public void MyBind(int orderType = 5)
        {
            DataTable dt          = new DataTable();
            int       getquicksou = 0;
            int       soutype     = DataConverter.CLng(Request.QueryString["souchtable"]);
            string    key         = HttpUtility.HtmlEncode(Request.QueryString["souchkey"]);
            string    menu        = Request.QueryString["menu"];

            this.souchtable.Text = soutype.ToString();
            switch (menu == "souch" && key != "")
            {
            case true:
                this.souchkey.Text = key;
                dt = bll.Getsouchinfo(soutype, key, orderType);
                break;

            case false:
                if (getquicksou > 0)
                {
                    dt = bll.GetOrderListtype(getquicksou, orderType);
                }
                else
                {
                    dt = bll.GetOrderListByOrderType(orderType);
                }
                break;

            default:
                dt = bll.GetOrderListByOrderType(orderType);
                break;
            }
            Order_RPT.DataSource = dt;
            Order_RPT.DataBind();
        }
Exemple #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Order_RPT.SPage = SelPage;
     if (!IsPostBack)
     {
         Order_RPT.DataBind();
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     ExHelper.CheckUserAuth("cash");
     Order_RPT.SPage = SelPage;
     if (!IsPostBack)
     {
         Order_RPT.DataBind();
     }
 }
Exemple #4
0
    public void MyBind()
    {
        M_UserInfo mu = buser.GetLogin();

        Order_RPT.DataSource = OrderDT.DefaultView.ToTable(true, "ID,OrderNo,AddUser,AddTime,StoreID".Split(','));
        Order_RPT.DataBind();
        Skey_T.Text = Skey;
        function.Script(this, "CheckOrderType('" + Filter + "')");
    }
Exemple #5
0
        protected void BatRecover_Btn_Click(object sender, EventArgs e)
        {
            string ids = Request.Form["idchk"];

            if (!string.IsNullOrEmpty(ids))
            {
                orderBll.ChangeStatus(ids, "recover");
                function.WriteSuccessMsg("订单恢复成功");
            }
            Order_RPT.DataBind();
        }
Exemple #6
0
        protected void BatDel_Btn_Click(object sender, EventArgs e)
        {
            string ids = Request.Form["idchk"];

            if (!string.IsNullOrEmpty(ids))
            {
                orderBll.DelByIDS(ids);
                function.WriteSuccessMsg("删除订单成功");
            }
            Order_RPT.DataBind();
        }
        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 + "')");
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            B_Admin.CheckIsLogged();
            if (!IsPostBack)
            {
                //内容,商品,会员

                //只显示有数据的第一级父节点
                DataTable condt = nodeBll.SelForShowAll(0);
                condt.DefaultView.RowFilter = "ItemCount>0 AND NodeBySite<1 AND NodeType>0";
                condt = condt.DefaultView.ToTable();
                condt = condt.DefaultView.ToTable(false, "ItemCount", "NodeName");
                data1 = JsonConvert.SerializeObject(condt);
                //商品
                //DataTable prodt = SqlHelper.JoinQuery("A.*,B.NodeName", "(SELECT COUNT(ID) AS ICount,NodeID FROM ZL_Commodities Group BY NodeID)", "ZL_Node", "A.NodeID=B.NodeID");
                //data2 = JsonConvert.SerializeObject(prodt);
                //商品,数量与销量
                string prosql = "SELECT Pro.*,Cart.SellCount FROM "
                                + " (SELECT A.*,B.NodeName FROM (SELECT COUNT(ID) AS ProCount,Nodeid FROM ZL_Commodities GROUP BY Nodeid) A LEFT JOIN ZL_Node B ON A.Nodeid=B.NodeID WHERE B.NodeName IS NOT NULL) Pro"
                                + " LEFT JOIN"
                                + " (SELECT COUNT(A.ID) AS SellCount,B.Nodeid FROM ZL_CartPro A LEFT JOIN ZL_Commodities B ON A.ProID=B.ID GROUP BY B.Nodeid) Cart"
                                + " ON Pro.Nodeid=Cart.Nodeid";
                DataTable prodt = SqlHelper.ExecuteTable(prosql);
                DataRow   dr    = prodt.NewRow();
                dr["NodeName"]  = "总计";
                dr["ProCount"]  = prodt.Compute("SUM(ProCount)", "");
                dr["SellCount"] = prodt.Compute("SUM(SellCount)", "");
                prodt.Rows.Add(dr);
                data2 = JsonConvert.SerializeObject(prodt);
                //内芯
                DataTable userdt1 = SqlHelper.ExecuteTable("SELECT COUNT(UserID) AS count1,(SELECT COUNT(UserID) FROM ZL_User Where ParentUserID>0) AS count2 FROM ZL_User");
                data3_1 = JsonConvert.SerializeObject(userdt1);
                DataTable userdt2 = SqlHelper.JoinQuery("A.*,B.GroupName", "(SELECT COUNT(UserID) AS ICount,GroupID FROM ZL_User Group BY GroupID)", "ZL_Group", "A.GroupID=B.GroupID");
                data3_2 = JsonConvert.SerializeObject(userdt2);
                this.litUserName.Text = B_Admin.GetLogin().AdminName;
                this.litDate.Text     = DateTime.Now.ToShortDateString() + " " + Resources.L.农历 + Season.GetLunarCalendar(DateTime.Now) + " " + Season.GetWeekCHA() + " " + Season.ChineseTwentyFourDay(DateTime.Now);
                this.Version.Text     = "当前版本:CMS2 X3.8 版,数据引擎:SQL Server 2005及更高版本";
                //支付明细
                DataTable paydt    = modelBll.SelectTableName("ZL_Payment", "PayPlatID>0 AND PaymentNum like 'DD%' ");
                var       payquery = (from pay in paydt.AsEnumerable() select pay).Take(5);
                payquery.Count();
                Pay_RPT.DataSource = payquery.Count() > 0 ? payquery.CopyToDataTable() : null;
                Pay_RPT.DataBind();
                //订单列表
                DataTable orderdt = orderBll.SearchByQuickAndSkey("0,4", "", "", 0, 0, "");
                var       query   = (from order in orderdt.AsEnumerable() select order).Take(5);
                Order_RPT.DataSource = query.Count() > 0 ? query.CopyToDataTable() : null;
                Order_RPT.DataBind();
                Sche_RPT.DataSource = new B_Content_ScheLog().Sel(5);
                Sche_RPT.DataBind();
            }
        }
Exemple #9
0
 protected void Order_RPT_ItemCommand(object source, RepeaterCommandEventArgs e)
 {
     int id = Convert.ToInt32(e.CommandArgument);
     switch (e.CommandName)
     {
         case "del2":
             {
                 orderBll.ChangeStatus(id.ToString(), "recycle");
             }
             break;
     }
     Order_RPT.DataBind();
 }
Exemple #10
0
 //--------------------------------
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!B_ARoleAuth.Check(ZLEnum.Auth.shop, "OrderList"))
     {
         function.WriteErrMsg("没有权限进行此项操作");
     }
     Order_RPT.SPage = SelPage;
     if (!IsPostBack)
     {
         if (!string.IsNullOrEmpty(Request["UserID"]))
         {
             UserID_T.Text = Request["UserID"];
         }
         if (!string.IsNullOrEmpty(Request["storeType"]))
         {
             StoreType_DP.SelectedValue = Request["storeType"];
         }
         DataRow countdr = cpBll.SelOrderCount(StoreType_DP.SelectedValue, OrderType).Rows[0];
         order_all_l.Text      += "(" + countdr["all"] + ")";
         order_unpaid_l.Text   += "(" + countdr["unpaid"] + ")";
         order_paid_l.Text     += "(" + countdr["paid"] + ")";
         order_unexp_l.Text    += "(" + countdr["unexp"] + ")";
         order_exped_l.Text    += "(" + countdr["exped"] + ")";
         order_finished_l.Text += "(" + countdr["finished"] + ")";
         order_unrefund_l.Text += "(" + countdr["unrefund"] + ")";
         order_refunded_l.Text += "(" + countdr["refunded"] + ")";
         order_recycle_l.Text  += "(" + countdr["recycle"] + ")";
         Order_RPT.DataBind();
         if (Filter.Equals("recycle"))
         {
             op_recycle.Visible = true;
         }
         else
         {
             op_normal.Visible = true;
         }
     }
 }
Exemple #11
0
 //--------------------------------      
 protected void Page_Load(object sender, EventArgs e)
 {
     Order_RPT.SPage = SelPage;
     if (!IsPostBack)
     {
         //if (!string.IsNullOrEmpty(Request["UserID"])) { UserID_T.Text = Request["UserID"]; }
         //if (!string.IsNullOrEmpty(Request["storeType"])) { StoreType_DP.SelectedValue = Request["storeType"]; }
         //DataRow countdr = cpBll.SelOrderCount(StoreType_DP.SelectedValue, OrderType).Rows[0];
         //order_all_l.Text += "(" + countdr["all"] + ")";
         //order_unpaid_l.Text += "(" + countdr["unpaid"] + ")";
         //order_prepay_l.Text += "(" + countdr["prepay"] + ")";
         //order_paid_l.Text += "(" + countdr["paid"] + ")";
         //order_unexp_l.Text += "(" + countdr["unexp"] + ")";
         //order_exped_l.Text += "(" + countdr["exped"] + ")";
         //order_finished_l.Text += "(" + countdr["finished"] + ")";
         //order_unrefund_l.Text += "(" + countdr["unrefund"] + ")";
         //order_refunded_l.Text += "(" + countdr["refunded"] + ")";
         //order_recycle_l.Text += "(" + countdr["recycle"] + ")";
         Order_RPT.DataBind();
         //if (Filter.Equals("recycle")) { op_recycle.Visible = true; }
         //else { op_normal.Visible = true; }
     }
 }
Exemple #12
0
 protected void Skey_Btn_Click(object sender, EventArgs e)
 {
     Order_RPT.CPage = 1;
     Order_RPT.DataBind();
 }