private DataTable SelPage(int pageSize, int pageIndex) { M_UserInfo mu = buser.GetLogin(); Filter_Order filter = new Filter_Order(); filter.cpage = pageIndex; filter.psize = pageSize; filter.orderType = OrderType; //filter.uids = ClientUid.ToString(); filter.storeType = mu.SiteID.ToString(); PageSetting setting = ExOrder.Order_Sel(filter); OrderDT = setting.dt; StoreDT = orderCom.SelStoreDT(OrderDT); //Skey_T.Text = Skey; DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID"); if (dt != null && dt.Rows.Count > 0) { TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2"); //function.Script(this, "CheckOrderType('" + Filter + "')"); Order_RPT.ItemCount = setting.itemCount; empty_div.Visible = false; } else { empty_div.Visible = true; TotalSum_Hid.Value = "0"; } return(dt); }
private DataTable SelPage(int pageSize, int pageIndex) { ZoomLa.BLL.B_CartPro.Filter_Order filter = new ZoomLa.BLL.B_CartPro.Filter_Order(); filter.cpage = pageIndex; filter.psize = pageSize; filter.storeType = StoreType_DP.SelectedValue; filter.orderType = OrderType; filter.addon = Filter; filter.proname = ProName_T.Text; filter.orderno = OrderNo_T.Text; filter.reuser = ReUser_T.Text; filter.mobile = Mobile_T.Text; filter.uids = UserID_T.Text; filter.stype = SkeyType_DP.SelectedValue; filter.skey = Skey_T.Text; filter.stime = STime_T.Text; filter.etime = ETime_T.Text; filter.expstime = ExpSTime_T.Text; filter.expetime = ExpETime_T.Text; //StoreType_DP.SelectedValue, OrderType, Filter, ProName_T.Text, OrderNo_T.Text, ReUser_T.Text, Mobile_T.Text, UserID_T.Text, SkeyType_DP.SelectedValue, Skey_T.Text, STime_T.Text, ETime_T.Text, ExpSTime_T.Text, ExpETime_T.Text PageSetting setting = cpBll.SelForOrderList(filter); OrderDT = setting.dt; StoreDT = orderCom.SelStoreDT(OrderDT); DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID"); Skey_T.Text = Skey; empty_div.Visible = dt.Rows.Count < 1; TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2"); //function.Script(this, "CheckOrderType('" + Filter + "')"); Order_RPT.ItemCount = setting.itemCount; return(dt); }
private void MyBind() { string fields = "ID,OrderNo,AddUser,AddTime,StoreID,PaymentStatus,OrderType,OrderStatus,OrderMessage,ExpressNum,ParentUserID,UserID,HoneyName,ExpSTime"; DataTable dt = OrderDT.DefaultView.ToTable(true, fields.Split(',')); Order_RPT.DataSource = dt; Order_RPT.DataBind(); Skey_T.Text = Skey; empty_div.Visible = dt.Rows.Count < 1; TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2"); //function.Script(this, "CheckOrderType('" + Filter + "')"); }
private DataTable SelPage(int pageSize, int pageIndex) { M_UserInfo mu = buser.GetLogin(); Filter_Order filter = new Filter_Order(); filter.cpage = pageIndex; filter.psize = pageSize; //filter.storeType = StoreType_DP.SelectedValue; filter.orderType = "-100"; //filter.addon = Filter; filter.uids = mu.UserID.ToString(); //filter.proname = ProName_T.Text; //filter.orderno = OrderNo_T.Text; //filter.reuser = ReUser_T.Text; //filter.mobile = Mobile_T.Text; //filter.uids = UserID_T.Text; //filter.stype = SkeyType_DP.SelectedValue; //filter.skey = Skey_T.Text; //filter.stime = STime_T.Text; //filter.etime = ETime_T.Text; //filter.expstime = ExpSTime_T.Text; //filter.expetime = ExpETime_T.Text; PageSetting setting = ExHelper.Order_Sel(filter); OrderDT = setting.dt; StoreDT = orderCom.SelStoreDT(OrderDT); //Skey_T.Text = Skey; DataTable dt = new DataTableHelper().DistinctByField(OrderDT, "ID"); if (dt != null && dt.Rows.Count > 0) { TotalSum_Hid.Value = DataConvert.CDouble(OrderDT.Compute("SUM(ordersamount)", "")).ToString("f2"); //function.Script(this, "CheckOrderType('" + Filter + "')"); Order_RPT.ItemCount = setting.itemCount; empty_div.Visible = false; } else { empty_div.Visible = true; TotalSum_Hid.Value = "0"; } return dt; }