using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Text; using System.Data; namespace Mtxfw.VipSite { public partial class Admin_Member_Products_Orders : Mtxfw.Utility.MemberBase { Mtxfw.DAL.user_Results daoResults = new Mtxfw.DAL.user_Results(); Mtxfw.DAL.user_Results_jl2 daojl2 = new Mtxfw.DAL.user_Results_jl2(); Mtxfw.DAL.order_product_info daoorderproduct = new Mtxfw.DAL.order_product_info(); Mtxfw.DAL.order_info daoorder = new Mtxfw.DAL.order_info(); Mtxfw.Model.order_info model = new Mtxfw.Model.order_info(); Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info(); public Mtxfw.DAL.P_Product daoProduct = new Mtxfw.DAL.P_Product(); public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config(""); public int gtype = 0, t=0; public string strTitle = "订单列表", strUserId=""; #region 判断页面是否刷新 private bool _refreshState; private bool _isRefresh; /// /// 判断页面是否刷新 /// public bool IsRefresh { get { return _isRefresh; } } protected override void LoadViewState(object savedState) { object[] allStates = (object[])savedState; base.LoadViewState(allStates[0]); _refreshState = (bool)allStates[1]; _isRefresh = _refreshState == (bool)Session["__ISREFRESH"]; } protected override object SaveViewState() { Session["__ISREFRESH"] = _refreshState; object[] allStates = new object[2]; allStates[0] = base.SaveViewState(); allStates[1] = !_refreshState; return allStates; } #endregion protected override void OnLoad(EventArgs e) { base.OnLoad(e); string hostname = Request.Url.Host; /*if (!String.IsNullOrEmpty(Request.QueryString["t"])) { t = Convert.ToInt32(Request.QueryString["t"].ToString()); } if (t == 1) { strTitle = "流量包订单列表"; } if (t == 2) { strTitle = "精选商品订单列表"; } if (t == 4) { strTitle = "服务中心订单列表"; } if (t == 5) { strTitle = "助农专区订单列表"; } if (t == 6) { strTitle = "枣享福区订单列表"; } if (t == 7) { strTitle = "其它订单列表"; } if (t == 8) { strTitle = "事业联盟订单列表"; } if (t == 9) { strTitle = "助农专区订单列表"; } if (t == 10) { strTitle = "推广员订单列表"; } if (t == 11) { strTitle = "爆品专区订单列表"; } if (t == 12) { strTitle = "补贴专区订单列表"; } if (t == 13) { strTitle = "体验区订单列表"; } if (t == 15) { strTitle = "镇街服务商订单列表"; } if (t == 16) { strTitle = "全部订单列表"; } if (t != 1) { seclect_Drop.Items.Add(new ListItem("批量发货", "1")); }*/ if (!IsPostBack) { // foreach (KeyValuePair kv in Mtxfw.Utility.Common.GetTems()) // { // Drop_Tem.Items.Add(new ListItem(kv.Value, kv.Key.ToString())); // } if (Session["IFPassword"] == null) { Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_Products_Orders.aspx"); } if (IFStores != 1) { Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx"); } if (MemberJS.IndexOf("订单列表") == -1) { Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx"); } Page.Title = "订单列表 - " + GetWebName; Data_Bind(); } MyPager.PageChanged += delegate(object s, EventArgs ex) { Data_Bind(); }; } protected String GetProvince() { StringBuilder sb = new StringBuilder(); Mtxfw.DAL.province daoPro = new Mtxfw.DAL.province(); System.Data.DataSet Ds = daoPro.GetCacheList("", "1=1 Order by Id Asc", "Province"); System.Data.DataTable Dt = (Ds != null && Ds.Tables[0] != null) ? Ds.Tables[0] : null; foreach (System.Data.DataRow Dr in Dt.Rows) { sb.Append("\r\n"); } return sb.ToString(); } protected void Data_Bind() { System.Text.StringBuilder sb = new System.Text.StringBuilder(); String UserId = HttpUtility.UrlDecode(Request.QueryString["UserId"]); String ZTMemberId = HttpUtility.UrlDecode(Request.QueryString["ZTMemberId"]); String o_payed = HttpUtility.UrlDecode(Request.QueryString["o_payed"]); String key = HttpUtility.UrlDecode(Request.QueryString["key"]); String state = HttpUtility.UrlDecode(Request.QueryString["state"]); String t0 = HttpUtility.UrlDecode(Request.QueryString["t0"]); String ttype = HttpUtility.UrlDecode(Request.QueryString["type"]); String paytype = HttpUtility.UrlDecode(Request.QueryString["paytype"]); String peitype = HttpUtility.UrlDecode(Request.QueryString["peitype"]); String tem = HttpUtility.UrlDecode(Request.QueryString["tem"]); if (!String.IsNullOrEmpty(ttype)) { sb.Append(" and ttype=" + ttype); Drop_ordertype.SelectedValue = ttype; } sb.Append(" and (Select Count(id) From User_info b where b.id=UserId)>0"); if (MemberuLevel29 > 0) { sb.Append(" And MemberId=" + MemberShippingID); } else { sb.Append(" and MemberId=0"); } if (!String.IsNullOrEmpty(ZTMemberId)) { sb.Append(" and ZTMemberId=" + ZTMemberId); } if (!String.IsNullOrEmpty(o_payed)) { sb.Append(" and o_payed=" + o_payed); } if (!String.IsNullOrEmpty(paytype)) { sb.Append(" and utype=" + paytype); Drop_paytype.Text = paytype; } if (!String.IsNullOrEmpty(peitype)) { sb.Append(" and peitype=" + peitype); Drop_peitype.Text = peitype; } if (!String.IsNullOrEmpty(state) && state != "-2") { sb.Append(" and O_Payed='" + state + "'"); Drop_State.SelectedValue = state; } if (!String.IsNullOrEmpty(t0)) { if (t0 == "1") { sb.Append(" and DateDiff(day,addtime,getdate())=0"); strTitle = "今日订单列表"; } else if (t0 == "2") { sb.Append(" and DateDiff(day,addtime,getdate())=1"); strTitle = "昨日订单列表"; } } if (!String.IsNullOrEmpty(UserId)) { sb.Append("and UserId=" + UserId); } if (!String.IsNullOrEmpty(tem)) { sb.Append(" and ptgroup=" + tem + ""); // Drop_Tem.SelectedValue = tem; } if (!String.IsNullOrEmpty(key)) { strUserId = key; if (!System.Text.RegularExpressions.Regex.IsMatch(key, @"^[1]+[1,2,3,4,5,6,7,8,9]+\d{9}$") && !System.Text.RegularExpressions.Regex.IsMatch(key, @"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$")) { sb.Append("and (orderid like '%" + key + "%' Or Contactname like '%" + key + "%' Or Contacttel like '%" + key + "%' Or yundanhao like '%" + key + "%' Or UserID in (select id from user_info b where b.IFStores=0 and (b.UserName like '%" + key + "%' or b.realname like '%" + key + "%')))"); } else { sb.Append("and (Contacttel like '%" + key + "%' Or UserID in (select id from user_info b where b.IFStores=0 and (b.UserName like '%" + key + "%')))"); } } string groupby = ""; string strOrder = " addtime desc"; int Start = 0; int Limit = 0; Int32 Recount = 0; MyPager.PageSize = 50; Start = MyPager.PageSize * (MyPager.CurrentPageIndex - 1); Limit = MyPager.PageSize; DataSet dss = daoorder.GetDataSet(groupby, strOrder, "ID,ttype,utype,orderid,ptype,peitype,O_SubmitDate,addtime,O_Payed,O_Payed_date,O_Shipped,O_Shipped_date,O_received,O_received_date,kdcompay,yundanhao,Guests,wlremarks,Contactname,Contacttel,Province,City,County,IFFill,Tradingarea,Address,Address0,Totalnum,pcount,ypznum,Totalprice,Totalprice0,Totalprice2,Totalprice10,refundstatus,refund_channel,user_received_account,success_time,ptgroup,O_Seef,O_ReturnReason,(select UserName from user_info c where c.ID=UserID) as UserName,(select RealName from user_info c where c.ID=UserID) as RealName", "", "gtype=" + gtype + " and IFDelete=0 and O_Payed>0" + sb.ToString(), Start, Limit, out Recount); Mtxfw.Utility.Tools.ToBind(Repeater1, dss.Tables[1]); MyPager.RecordCount = Recount; if (MyPager.RecordCount == 0) { MyPager.Visible = false; } string strfill = ",0 as Totalprice22"; if (t == 1) { strfill = ",sum(Totalprice0/Totalprice2) as Totalprice22"; } DataSet ds = daoorder.GetList1("sum(Totalnum) as Totalnum,sum(pcount) as pcount,sum(Totalprice) as Totalprice,sum(Totalprice0) as Totalprice0,sum(Totalprice2) as Totalprice2"+ strfill + ",sum(Totalprice10) as Totalprice10", "gtype=" + gtype + " and IFDelete=0 and O_Payed>0" + sb.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Totalnum"].ToString() != "") { Label_b0.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalnum"]).ToString(); } else { Label_b0.Text = "0"; } if (ds.Tables[0].Rows[0]["pcount"].ToString() != "") { Label_b1.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["pcount"]).ToString(); } else { Label_b1.Text = "0"; } if (ds.Tables[0].Rows[0]["Totalprice"].ToString() != "") { Label_b2.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice"]).ToString("f2"); } else { Label_b2.Text = "0.00"; } if (ds.Tables[0].Rows[0]["Totalprice0"].ToString() != "") { Label_b3.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice0"]).ToString("0.####"); } else { Label_b3.Text = "0"; } if (ds.Tables[0].Rows[0]["Totalprice10"].ToString() != "") { Label_b4.Text = (Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice0"])-Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice10"])).ToString("0.####"); } else { Label_b4.Text = "0"; } if (ds.Tables[0].Rows[0]["Totalprice2"].ToString() != "") { Label_b5.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice2"]).ToString("0.####"); } else { Label_b5.Text = "0"; } if (ds.Tables[0].Rows[0]["Totalprice22"].ToString() != "") { Label_b6.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalprice22"]).ToString("0.####"); } else { Label_b6.Text = "0"; } } else { Label_b1.Text = "0"; Label_b2.Text = "0.00"; Label_b3.Text = "0"; Label_b4.Text = "0"; Label_b5.Text = "0"; Label_b6.Text = "0"; } ds.Clear(); } protected void Run_Click(object s, System.EventArgs e) { if (IsRefresh == false) { CheckBox Check = new CheckBox(); string strs = seclect_Drop.SelectedItem.Value; foreach (RepeaterItem Item in Repeater1.Items) { //在行中查找到该单选框 Check = (CheckBox)Item.FindControl("checka"); int strID = int.Parse(Check.CssClass); if (Check.Checked == true) { if (strs == "2") { Mtxfw.Model.order_info ModelOrder = daoorder.GetModel(strID); if (ModelOrder != null) { DateTime dt = DateTime.Now; if (ModelOrder.IFDelete == 0) { daoorder.UpdateIFDelete(1, DateTime.Now.ToString(), strID); if (ModelOrder.O_Payed == "0" || ModelOrder.O_Payed == "1" || ModelOrder.O_Payed == "2" || ModelOrder.O_Payed == "3" || ModelOrder.O_Payed == "5") { System.Data.DataSet Ds_op = new Mtxfw.DAL.order_product_info().GetList1("Totalnum,guige,selcolor", "utype='0' And orderid=" + ModelOrder.Id + " And IFDelete=0 Order By SubmitTime asc"); if (Ds_op.Tables[0].Rows.Count > 0) { foreach (System.Data.DataRow drv2 in Ds_op.Tables[0].Rows) { string selcolor = drv2["selcolor"].ToString(); int prodNum = Convert.ToInt32(drv2["Totalnum"]); string guige = drv2["guige"].ToString(); if (guige != "") { Mtxfw.Model.P_Guige gmodel = new DAL.P_Guige().GetModel(Convert.ToInt32(guige)); if (gmodel != null) { int ZKC = 0; bool IFKC = true; string strcolors = gmodel.G_Color; string[] acolors = gmodel.G_Color.Split(','); for (int jj = 0; jj < acolors.Length; jj++) { if (acolors[jj] != "") { var ac = acolors[jj].Split('|'); if (ac.Length > 1) { if (ac[1] != "") { int intNum = Convert.ToInt32(ac[1]); if (ac[0] == selcolor) { intNum = (intNum + Convert.ToInt32(prodNum)); strcolors = strcolors.Replace(ac[0] + "|" + ac[1], ac[0] + "|" + intNum); } ZKC += intNum; IFKC = false; } } } } gmodel.G_Color = strcolors; if (IFKC) { gmodel.G_KC = gmodel.G_KC + Convert.ToInt32(prodNum); } else { gmodel.G_KC = ZKC; } new DAL.P_Guige().Update(gmodel); } } } } Ds_op.Clear(); } Mtxfw.Model.user_info umodel = new Mtxfw.DAL.user_info().GetModel(ModelOrder.UserID); if (umodel != null) { int ttype = ModelOrder.ttype; if (ttype == 1) { Double Totalprice0 = Convert.ToDouble(ModelOrder.Totalprice0.ToString("f2")); Double Totalprice1 = Convert.ToDouble(ModelOrder.Totalprice2.ToString("f2")); Double Totalprice2 = Convert.ToDouble(ModelOrder.Totalprice3.ToString("f2")); Double mrccmoney = Convert.ToDouble(Convert.ToDouble((Totalprice0 / Totalprice1).ToString("0.####")).ToString("f4")); if (mrccmoney > Convert.ToDouble(umodel.umoney26.ToString("f4"))) { mrccmoney = Convert.ToDouble(umodel.umoney26.ToString("f4")); } if (mrccmoney > 0.0000) { daoUser.UpdateMoney("umoney26", -mrccmoney, umodel.Id); } Double hyzmoney = Totalprice2; if (hyzmoney > Convert.ToDouble(umodel.umoney33.ToString("f2"))) { hyzmoney = Convert.ToDouble(umodel.umoney33.ToString("f2")); } if (hyzmoney > 0.00) { Model.user_Results_jl2 mjl2 = new Model.user_Results_jl2(); mjl2.MemberId = umodel.Id; mjl2.MemberId2 = 0; mjl2.Addmoney = -hyzmoney; mjl2.Cutmoney = 0; mjl2.Totalmoney = umodel.umoney33 - hyzmoney; mjl2.addtime = dt; mjl2.BZContent = "流量包完成"; mjl2.PayID = ""; mjl2.OrdersIDs = ""; mjl2.OrdersID = 0; mjl2.utype = 5; mjl2.utype2 = 0; mjl2.Seef = -1; mjl2.seeftime = dt; mjl2.gtype = gtype; daojl2.Add(mjl2); daoUser.UpdateMoney("umoney33", -hyzmoney, umodel.Id); daoUser.UpdateMoney("umoney19", -hyzmoney, umodel.Id); umodel.umoney33 -= hyzmoney; umodel.umoney19 -= hyzmoney; Mtxfw.DAL.MemberStatistics.UpdteuLevel0(gtype, config, umodel.Id, umodel.ContactIDS, umodel.uLevel, umodel.uLevel4, umodel.IFBecomeAgents, Convert.ToInt32(umodel.umoney33.ToString().Split('.')[0]), dt); string[] ASuperiorsIDS = (umodel.ContactIDS).Split(','); for (int ak = ASuperiorsIDS.Length - 2; ak > 0; ak--) { if (ASuperiorsIDS[ak] != "") { // DataSet ds0 = daoUser.GetList1("ID,ContactIDS,umoney33,uLevel,uLevel24,IFBecomeAgents", "gtype=" + gtype + " and UserState='正常' And IFStores=0 And uLevel17=0 And id=" + ASuperiorsIDS[ak]); if (ds0.Tables[0].Rows.Count > 0) { int dID = Convert.ToInt32(ds0.Tables[0].Rows[0]["ID"].ToString()); string dContactIDS = ds0.Tables[0].Rows[0]["ContactIDS"].ToString(); int dumoney33 = Convert.ToInt32(ds0.Tables[0].Rows[0]["umoney33"].ToString().Split('.')[0]); int duLevel = Convert.ToInt32(ds0.Tables[0].Rows[0]["uLevel"].ToString()); int duLevel24 = Convert.ToInt32(ds0.Tables[0].Rows[0]["uLevel24"].ToString()); int dIFBecomeAgents = Convert.ToInt32(ds0.Tables[0].Rows[0]["IFBecomeAgents"].ToString()); daoUser.UpdateMoney("umoney19", -hyzmoney, dID); if (ak == ASuperiorsIDS.Length - 2) { daoUser.UpdateMoney("umoney35", -hyzmoney, dID); } Mtxfw.DAL.MemberStatistics.UpdteuLevel0(gtype, config, dID, dContactIDS, duLevel, duLevel24, dIFBecomeAgents, dumoney33, dt); } ds0.Clear(); } } } } if (ttype == 11) { if (umodel.uLevel42 == 1) { int ordercunt = daoorder.GetCount("gtype=" + gtype + " and ttype=11 and IFDelete=0 and O_Payed>0 and MemberId=" + umodel.Id); if (ordercunt == 0) { umodel.uLevel42 = 0; daoUser.UpdateuLevel("uLevel42", 0, umodel.Id); } } } Mtxfw.Model.Article amodel = new Mtxfw.Model.Article(); amodel.senderid = 0; amodel.receiverid = umodel.Id; amodel.Title = "订单删除通知"; amodel.ParentID = 30; amodel.CategoryId = "0"; amodel.AddTime = DateTime.Now; amodel.Author = "../image/order-ico.png"; amodel.Content = "您的订单" + ModelOrder.orderid + "1小时内未付款，已被删除"; amodel.Paths = "orders.html"; amodel.Content2 = ""; amodel.Paths2 = ""; amodel.KeyWords = ""; amodel.media_id = ""; amodel.thumb_media_id = ""; amodel.wtype = 4; amodel.wtype2 = 0; amodel.LinkID = 1; amodel.Seef = 0; amodel.gtype = gtype; string dataid = new DAL.Article().Add(amodel).ToString(); if (umodel.registrationId != "") { List RegistrationIDList = new List(); RegistrationIDList.Add(umodel.registrationId); string title = amodel.Title; string strMsg = amodel.Content; bool is_production = true; string strLog = ""; new Jiguang.JPush.JPushV3().SendPushV2(RegistrationIDList, title, dataid, strMsg, is_production, out strLog); } Model.User_CZ_log logmodel = new Model.User_CZ_log(); logmodel.MemberId = Card; logmodel.AddTime = dt; logmodel.IP = Mtxfw.Utility.Common.GetIP; logmodel.Body = "删除" + Mtxfw.Utility.Common.GetOrderType(ModelOrder.ttype) + "，会员：" + umodel.UserName + "(" + umodel.RealName + ")，订单号：" + ModelOrder.orderid; logmodel.UType = 0; logmodel.gtype = gtype; new DAL.User_CZ_log().Add(logmodel); } } } } else if (strs == "1") { Mtxfw.Model.order_info ModelOrder = daoorder.GetModel(strID); if (ModelOrder != null) { TextBox Totalprice = (TextBox)Item.FindControl("txtTotalprice"); ModelOrder.Totalprice = Convert.ToDouble(Totalprice.Text); daoorder.UpdateTotalprice(ModelOrder.Totalprice, ModelOrder.Id); Model.User_CZ_log logmodel = new Model.User_CZ_log(); logmodel.MemberId = Card; logmodel.AddTime = DateTime.Now; logmodel.IP = Mtxfw.Utility.Common.GetIP; logmodel.Body = "修改订单金额，订单号" + model.orderid; logmodel.UType = 0; logmodel.gtype = gtype; new DAL.User_CZ_log().Add(logmodel); } } } } } Response.Redirect(Request.Url.AbsoluteUri); } protected void IsGo_Click(object s, CommandEventArgs ex) { Int32 ID = int.Parse(ex.CommandName); daoorder.UpdateqyState(1, "1", DateTime.Now, ID); Mtxfw.Utility.Tools.Message("处理成功!", Request.Url.AbsoluteUri); } protected string GetProducts(int O_Id) { string ShowConent = ""; System.Data.DataSet Ds_op = daoorderproduct.GetList("(Select utype from P_Product b where b.P_ID=a.pid) as cutype,(Select P_NAME from P_Product b where b.P_ID=a.pid) as prodName,(Select P_images from P_Product b where b.P_ID=a.pid) as prodimg,", "orderid=" + O_Id + " And IFDelete=0 Order By SubmitTime asc"); if (Ds_op.Tables[0].Rows.Count > 0) { for (int l = 0; l < Ds_op.Tables[0].Rows.Count; l++) { string pid2 = Ds_op.Tables[0].Rows[l]["id"].ToString(); string prodimg2 = Ds_op.Tables[0].Rows[l]["prodimg"].ToString(); string[] aprodimg = prodimg2.Split('|'); string prodid2 = Ds_op.Tables[0].Rows[l]["pid"].ToString(); string prodName2 = Ds_op.Tables[0].Rows[l]["prodName"].ToString(); string guige2 = Ds_op.Tables[0].Rows[l]["guige"].ToString(); string selcolor2 = Ds_op.Tables[0].Rows[l]["selcolor"].ToString(); string Totalnum2 = Ds_op.Tables[0].Rows[l]["Totalnum"].ToString(); string DJprice2 = Ds_op.Tables[0].Rows[l]["DJprice"].ToString(); string Totalprice2 = Ds_op.Tables[0].Rows[l]["Totalprice"].ToString(); string cutype = Ds_op.Tables[0].Rows[l]["cutype"].ToString(); string strimg = ""; string strUrl2 = "/shop/view-" + prodid2 + ".html"; if (guige2 != "") { Mtxfw.Model.P_Guige gmodel = new DAL.P_Guige().GetModel(Convert.ToInt32(guige2)); if (gmodel != null) { prodName2 += " " + gmodel.G_Name; } } if (selcolor2 != "") { foreach (string img in aprodimg) { if (img.IndexOf(selcolor2) != -1) { strimg = img.Split(',')[0]; } } if (strimg == "") { strimg = prodimg2.Split('|')[0].Split(',')[0]; } } else { strimg = prodimg2.Split('|')[0].Split(',')[0]; } ShowConent += "
" + prodName2 + "\n"; } } Ds_op.Clear(); return ShowConent; } } }