erp/Web/EOrder/Order_Log.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_Log: BasePage
{
    protected override void OnPreInit(EventArgs e)
    {
        _selfCheckPermission = true;
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string ctid = GetString("ctid");

            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("select * from view_erptradelog where tid='{0}' order by id;", ctid);
            DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString());
            AppendScript("logData=" + JsonString.DataTable2AjaxJson(ds.Tables[0]) + ";");

            //string tid = ctid;
            //if (tid.IndexOf("C") != -1)
            //{
            //    int idxC = tid.IndexOf("C");
            //    tid = tid.Substring(idxC + 3, tid.Length - idxC - 3);

            //    StringBuilder sql2 = new StringBuilder();
            //    sql2.AppendFormat("select * from view_erptradelog where tid like '%{0}' order by id;", tid);
            //    DataSet ds2 = DbHelper.DbConn.ExecuteDataset(sql2.ToString());
            //    AppendScript("logDataTotal=" + JsonString.DataTable2AjaxJson(ds2.Tables[0]) + ";");
            //}
            

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


}