erp/Web/EOrder/Order_Detail.aspx.cs

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)
        //{
        //}
    }


}