You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

50 lines
1.7 KiB
C#

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Xml;
using DSWeb.Models;
using DSWeb.EntityDA;
namespace DSWeb.FeeCodes
{
public partial class SubCompSeaeDefAdapter : System.Web.UI.Page
{
private string strPortName = "";
public string CORPID = "";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["CORPID"] != null)
{
CORPID = Request.QueryString["CORPID"].ToString();
}
//
if (CORPID != "" && CORPID != "null")
{
T_ALL_DA T_ALL_DA = new T_ALL_DA();
DataSet ds = T_ALL_DA.GetAllSQL("select * from subcomp_seae_def where CORPID=(select Gid from Company where codename='" + CORPID + "')");
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
strPortName = ds.Tables[0].Rows[0]["PORTLOAD"].ToString().Trim() + "&&" + ds.Tables[0].Rows[0]["BLFRT"].ToString().Trim() + "&&" + ds.Tables[0].Rows[0]["SERVICE"].ToString().Trim() + "&&" + ds.Tables[0].Rows[0]["KGS"].ToString() + "&&" + ds.Tables[0].Rows[0]["ISCGOL"].ToString() + "&&" + ds.Tables[0].Rows[0]["ISADVANCE"].ToString();
}
}
}
Response.Write(strPortName);
}
}
}