Example #1
0
    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);
    }
Example #2
0
        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 + "')");
        }
Example #4
0
    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;

    }