using BizCom; using Castle.ActiveRecord; using SQLData; using System; using System.Collections.Generic; using System.Data; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using Utils; using SiteCore; using Utils.Serialization; public partial class EOrder_Order_Detail: BasePage { protected override void OnPreInit(EventArgs e) { _selfCheckPermission = true; } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ctid = GetString("ctid"); string tid = GetString("tid"); StringBuilder sql = new StringBuilder(); sql.AppendFormat("select * from view_erptradecell where ctid='{0}';",ctid); sql.AppendFormat("select * from view_erpBill where tid='{0}';", tid); sql.AppendFormat("select * from view_ErpReturnCash where tid='{0}';", tid); sql.AppendFormat("select * from ce_erptradeorder where tid='{0}';", tid); sql.AppendFormat("select * from view_erptradeLog where AfterSaleState>0 and tid='{0}';", ctid); if (ctid.IndexOf("S") != -1) { string backmainctid = ctid.Replace("S_", ""); sql.AppendFormat("select * from view_erptradecell where ctid='{0}';", backmainctid); } DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString()); AppendScript("tradeData=" + JsonString.DataTable2AjaxJson(ds.Tables[0]) + ";"); AppendScript("billData=" + JsonString.DataTable2AjaxJson(ds.Tables[1]) + ";"); AppendScript("cashData=" + JsonString.DataTable2AjaxJson(ds.Tables[2]) + ";"); AppendScript("orderData=" + JsonString.DataTable2AjaxJson(ds.Tables[3]) + ";"); AppendScript("logData=" + JsonString.DataTable2AjaxJson(ds.Tables[4]) + ";"); if (ctid.IndexOf("S") != -1) { AppendScript("afterMainData=" + JsonString.DataTable2AjaxJson(ds.Tables[5]) + ";"); } //selType.DataSource = dt; //selType.DataValueField = "ID"; //selType.DataTextField = "Name"; //selType.DataBind(); AppendScript("downUrl='" + webConfig.ltSimDownLoadUrl + "';"); AppendScript("userPostCode='" + CurrentUser.UserPost.Post.Code + "';"); } //foreach (DataRow dr in dt.Rows) //{ //} } }