erp/Web/EOrder/OldDataList.aspx.cs

using SiteCore;
using SQLData;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Utils.Serialization;

public partial class EOrder_OldDataList : BasePage
{
    protected override void OnPreInit(EventArgs e)
    {
        _repTitle = "老系统数据";
        PmTag = "olddatalist";
        //_selfCheckPermission = true;
        _filterItem = "all";
        _keyFilterVisible = false;
        _addVisible = false;
    }

    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 ce_erpBill where tid={0};",0);
            //sql.AppendFormat("select * from ce_ErpReturnCash where tid={0};",0);
            //sql.AppendFormat("select * from ce_erptradorder where tid={0};",0);
            //sql.AppendFormat("select * from ce_erptradeLog where AfterSaleState>=0 and ctid={0};",0);
            //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]) + ";");
            //selType.DataSource = dt;
            //selType.DataValueField = "ID";
            //selType.DataTextField = "Name";
            //selType.DataBind();

                //string sData = GetString("sData");
                //if (sData != "") AppendScript("openPageData=" + sData + ";");

                //AppendScript("viewUrl='" + webConfig.ltFileSiteUrl + "/d/fx';uploadUrl ='" + webConfig.ltSimUploadUrl + "?ut=fx';");
                //StringBuilder sql = new StringBuilder();
                //sql.AppendFormat("select * from s_runinfotype");
                //DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString());
                //DataTable dt = ds.Tables[0];
                //AppendScript("tData=" + JsonString.DataTable2Json(dt) + ";");

                //selType.DataSource = dt;
                //selType.DataValueField = "ID";
                //selType.DataTextField = "Name";
                //selType.DataBind();
            
        }

        //foreach (DataRow dr in dt.Rows)
        //{
        //}
    }
}