public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string returnJson = ""; try { Dt_User user = RoleFuns.IsLoginAdmin(context.Session["user"]); if (user != null)//登录检测,权限检测 context.Session["user"] { //string type = context.Request.QueryString["type"].Trim();//请求类型 string json = context.Request.QueryString["json"].Trim();//请求参数(json类型) //string proc = context.Request.QueryString["proc"].Trim();//存储过程名称 var obj = JsonConvert.DeserializeObject <PromData>(json); var type = obj.type; if (type != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, "促销管理", rolestr); if (type == "SaveProm") { var db = new SqlSugarDb(); var fabh = ""; if (string.IsNullOrWhiteSpace(obj.ruleCode)) { db.Db.Ado.UseTran(() => { var maxbh = db.Db.Queryable <dt_Maxbh>().First(d => d.BiaoShi == "FAR")?.maxbh ?? "0"; var nowBh = (int.Parse(maxbh) + 1).ToString(); db.Db.Updateable <dt_Maxbh>().SetColumns(d => new dt_Maxbh { maxbh = nowBh }).Where(d => d.BiaoShi == "FAR").ExecuteCommand(); fabh = "FAR" + nowBh.PadLeft(11, '0'); }); } else { fabh = obj.ruleCode; db.Db.Deleteable <SC_T_PromRuleCondition>().Where(d => d.entid == user.entId && d.ruleCode == fabh).ExecuteCommand(); db.Db.Deleteable <SC_T_PromRuleReplenish>().Where(d => d.entid == user.entId && d.ruleCode == fabh).ExecuteCommand(); } var prom = new SC_T_PromRule(); prom.ruleCode = fabh; prom.entid = user.entId; prom.faType = obj.faType; prom.PromScenario = "3"; prom.limitAmount = obj.xgAmount; prom.Amount = obj.Quantity; prom.contentType = "0"; prom.customerType = obj.customerType; prom.describe = obj.describe; prom.moreBuy = "0"; prom.ruleTitle = obj.faname; var group = JsonConvert.DeserializeObject <List <PromGroupModel> >(obj.lsid); var groupList = new List <SC_T_PromRuleCondition>(); var repList = new List <SC_T_PromRuleReplenish>(); var groupSn = 1; var b = prom.faType == "GZH";//判断是否是组合 foreach (var item in group) { groupList.Add(new SC_T_PromRuleCondition() { rule_sn = groupSn, PromScenario = prom.PromScenario, entid = user.entId, faType = prom.faType, giftPrice = decimal.Parse(item.Price), giftQuantity = b ? decimal.Parse(item.shl) : 0, meetCount = b ? 0 : decimal.Parse(item.MeetCount), ruleCode = fabh }); repList.Add(new SC_T_PromRuleReplenish() { rule_sn = groupSn, entid = user.entId, faType = prom.faType, ScnarioID = item.GoodsId, maxQuantity = b ? obj.Quantity * decimal.Parse(item.shl) : decimal.Parse(item.Total), limitQuantity = b ? obj.xgAmount * decimal.Parse(item.shl) : decimal.Parse(item.Limit), ruleCode = fabh }); groupSn++; } db.Db.Insertable(groupList).ExecuteCommand(); db.Db.Insertable(repList).ExecuteCommand(); if (string.IsNullOrWhiteSpace(obj.ruleCode)) { db.Db.Insertable(prom).ExecuteCommand(); } else { db.Db.Updateable(prom).Where(d => d.entid == user.entId && d.ruleCode == obj.ruleCode).ExecuteCommand(); } returnJson = JsonMethod.GetError(0, "操作成功"); } if (type == "QuerySingleProm") { var db = new SqlSugarDb(); var model = db.Db.Queryable <SC_T_PromRule>().First(d => d.entid == obj.entid && d.ruleCode == obj.ruleCode); var condition = db.Db.Queryable <SC_T_PromRuleCondition, SC_T_PromRuleReplenish>((d, e) => new object[] { JoinType.Left, d.entid == e.entid && d.ruleCode == e.ruleCode && d.rule_sn == e.rule_sn }) .Where(d => d.entid == obj.entid && d.ruleCode == obj.ruleCode).Select((d, e) => new GroupReplenishes { entid = d.entid, rule_sn = d.rule_sn, faType = d.faType, giftPrice = d.giftPrice, giftQuantity = d.giftQuantity, meetCount = d.meetCount, ruleCode = d.ruleCode, maxQuantity = e.maxQuantity, limitQuantity = e.limitQuantity, giftGoodsID = e.ScnarioID }).ToList(); var scenarios = condition.Select(d => d.giftGoodsID).ToList(); var dic = db.Db.Queryable <dt_article_attribute, dt_article_inventory>((d, e) => new object[] { JoinType.Left, d.article_id == e.article_id }).Where((d, e) => d.entid == obj.entid && scenarios.Contains(SqlFunc.ToString(d.article_id))).Select((d, e) => new { d.sub_title, d.article_id, d.goodscode, d.drug_factory, d.drug_spec, d.min_package, d.price, e.stock_quantity }).ToList(); condition.ForEach(d => { var goods = dic.First(m => d.giftGoodsID == m.article_id.ToString()); d.stock_quantity = goods.stock_quantity.ToString(); d.sub_title = goods.sub_title; d.price = goods.price.ToString(); d.min_package = goods.min_package.ToString(); d.goodscode = goods.goodscode; d.drug_spec = goods.drug_spec; d.drug_factory = goods.drug_factory; }); returnJson = JsonConvert.SerializeObject(new PromGroupUpdate() { flag = 0, promRule = model, conditions = condition }); } } } else { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(4, msg);; } context.Response.Write(returnJson); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string returnJson = ""; try { Dt_User user = RoleFuns.IsLoginAdmin(context.Session["user"]); if (user != null)//登录检测,权限检测 context.Session["user"] { //string type = context.Request.QueryString["type"].Trim();//请求类型 string json = context.Request.QueryString["json"].Trim();//请求参数(json类型) //string proc = context.Request.QueryString["proc"].Trim();//存储过程名称 var obj = JsonConvert.DeserializeObject <PromData>(json); var type = obj.type; if (type != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, "促销管理", rolestr); //if (/*rolestr == null || RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr) == 0*/false) //{ // returnJson = JsonMethod.GetError(4, "抱歉您没有权限进入!"); //} //else { //执行查询返回列表 if (type == "SaveProm") { var db = new SqlSugarDb(); var fabh = ""; if (string.IsNullOrWhiteSpace(obj.ruleCode)) { db.Db.Ado.UseTran(() => { var maxbh = db.Db.Queryable <dt_Maxbh>().First(d => d.BiaoShi == "FAR")?.maxbh ?? "0"; var nowBh = (int.Parse(maxbh) + 1).ToString(); db.Db.Updateable <dt_Maxbh>().SetColumns(d => new dt_Maxbh { maxbh = nowBh }).Where(d => d.BiaoShi == "FAR").ExecuteCommand(); fabh = "FAR" + nowBh.PadLeft(11, '0'); }); } else { fabh = obj.ruleCode; db.Db.Deleteable <SC_T_PromRuleCondition>().Where(d => d.entid == user.entId && d.ruleCode == fabh).ExecuteCommand(); db.Db.Deleteable <SC_T_PromRuleReplenish>().Where(d => d.entid == user.entId && d.ruleCode == fabh).ExecuteCommand(); } var prom = new SC_T_PromRule(); prom.ruleCode = fabh; prom.entid = user.entId; prom.faType = obj.faType; prom.PromScenario = obj.PromScenario; prom.limitAmount = obj.xgAmount; prom.Amount = obj.Quantity; prom.contentType = obj.contentType; prom.customerType = obj.customerType; prom.describe = obj.describe; prom.moreBuy = obj.JieTi; prom.ruleTitle = obj.faname; var limit = JsonConvert.DeserializeObject <List <PromLimit> >(obj.lsid); var limitList = new List <SC_T_PromRuleCondition>(); var limitSn = 1; foreach (var item in limit) { limitList.Add(new SC_T_PromRuleCondition() { rule_sn = limitSn, PromScenario = prom.PromScenario, discount = decimal.Parse(item.zk), entid = user.entId, faType = prom.faType, giftGoodsID = item.zpid, giftPrice = decimal.Parse(item.jg), giftQuantity = decimal.Parse(item.shl), meetCount = decimal.Parse(item.mztj), ruleCode = fabh }); limitSn++; } db.Db.Insertable(limitList).ExecuteCommand(); var scenarioId = obj.ScenarioId; var scenario = (EPromScenario)Enum.Parse(typeof(EPromScenario), prom.PromScenario); var repList = new List <SC_T_PromRuleReplenish>(); var replenishSn = 1; switch (scenario) { case EPromScenario.全部商品: break; case EPromScenario.独立商品: case EPromScenario.分类商品: foreach (var item in scenarioId.Split('|')) { if (string.IsNullOrEmpty(item)) { continue; } var data = item.Split('_'); repList.Add(new SC_T_PromRuleReplenish() { entid = user.entId, faType = prom.faType, rule_sn = replenishSn, ruleCode = fabh, limitQuantity = decimal.Parse(data[2]), maxQuantity = decimal.Parse(data[1]), ScnarioID = data[0] }); replenishSn++; } break; case EPromScenario.品牌商品: case EPromScenario.商品分组: foreach (var item in scenarioId.Split('|')) { if (string.IsNullOrEmpty(item)) { continue; } repList.Add(new SC_T_PromRuleReplenish() { entid = user.entId, faType = prom.faType, rule_sn = replenishSn, ruleCode = fabh, ScnarioID = item }); replenishSn++; } break; default: break; } if (repList.Count > 0) { db.Db.Insertable(repList).ExecuteCommand(); } if (string.IsNullOrWhiteSpace(obj.ruleCode)) { db.Db.Insertable(prom).ExecuteCommand(); } else { db.Db.Updateable(prom).Where(d => d.entid == user.entId && d.ruleCode == obj.ruleCode).ExecuteCommand(); } returnJson = JsonMethod.GetError(0, "操作成功"); } if (type == "QuerySingleProm") { var db = new SqlSugarDb(); var model = db.Db.Queryable <SC_T_PromRule>().First(d => d.entid == obj.entid && d.ruleCode == obj.ruleCode); var condition = db.Db.Queryable <SC_T_PromRuleCondition>().Where(d => d.entid == obj.entid && d.ruleCode == obj.ruleCode).ToList(); var giftIds = condition.Select(d => d.giftGoodsID).ToList(); var conditionData = condition.Select(d => new PromCondition() { PromScenario = d.PromScenario, discount = d.discount, entid = d.entid, rule_sn = d.rule_sn, faType = d.faType, giftGoodsID = d.giftGoodsID, giftPrice = d.giftPrice, giftQuantity = d.giftQuantity, meetCount = d.meetCount, ruleCode = d.ruleCode }).ToList(); if (model.faType == "DHG") { var dic = db.Db.Queryable <dt_article_attribute>().Where(d => d.entid == obj.entid && giftIds.Contains(SqlFunc.ToString(d.article_id))).Select(d => new { d.sub_title, d.article_id }).ToList().ToDictionary(d => d.article_id.ToString(), d => d.sub_title); conditionData.ForEach(d => d.giftName = dic[d.giftGoodsID]); } if (model.faType == "DMZ") { var dic = db.Db.Queryable <dt_giftdoc>().Where(d => d.entid == obj.entid && giftIds.Contains(d.goodsid)).Select(d => new { d.goodsname, d.goodsid }).ToList().ToDictionary(d => d.goodsid, d => d.goodsname); conditionData.ForEach(d => d.giftName = dic[d.giftGoodsID]); } var replenish = db.Db.Queryable <SC_T_PromRuleReplenish>().Where(d => d.entid == obj.entid && d.ruleCode == obj.ruleCode).ToList(); var scenario = (EPromScenario)Enum.Parse(typeof(EPromScenario), model.PromScenario); var scenarios = replenish.Select(d => d.ScnarioID).ToList(); var replenishData = replenish.Select(d => new PromRuleReplenish() { ScnarioID = d.ScnarioID, entid = d.entid, faType = d.faType, InfoContent = d.InfoContent, rule_sn = d.rule_sn, limitQuantity = d.limitQuantity, maxQuantity = d.maxQuantity, ruleCode = d.ruleCode }).ToList(); if (scenario == EPromScenario.分类商品) { var dic = db.Db.Queryable <dt_article_category>().Where(d => d.channel_id == 7 && scenarios.Contains(SqlFunc.ToString(d.id))).Select(d => new { d.title, d.id }).ToList(); replenishData.ForEach(d => { var mm = dic.First(m => d.ScnarioID == m.id.ToString()); d.SecnarioName = mm.title; d.SecnarioCode = mm.id.ToString(); }); } if (scenario == EPromScenario.独立商品) { var dic = db.Db.Queryable <dt_article_attribute, dt_article_inventory>((d, e) => new object[] { JoinType.Left, d.article_id == e.article_id }).Where((d, e) => d.entid == obj.entid && scenarios.Contains(SqlFunc.ToString(d.article_id))).Select((d, e) => new { d.sub_title, d.article_id, d.goodscode, d.drug_factory, d.drug_spec, d.min_package, d.price, e.stock_quantity }).ToList(); replenishData.ForEach(d => { var mm = dic.First(m => d.ScnarioID == m.article_id.ToString()); d.SecnarioName = $"商品:{mm.sub_title} 生产公司:{mm.drug_factory} 规格:{mm.drug_spec} 中包装:{mm.min_package} 价格:{mm.price} 库存:{mm.stock_quantity}"; d.SecnarioCode = mm.goodscode; }); } returnJson = JsonConvert.SerializeObject(new PromUpdate() { flag = 0, promRule = model, conditions = conditionData, replenishes = replenishData }); } //} } } else { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(4, msg);; } context.Response.Write(returnJson); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string returnJson = ""; try { Dt_User user = RoleFuns.IsLoginAdmin(context.Session["user"]); if (user != null)//登录检测,权限检测 context.Session["user"] { //string type = context.Request.QueryString["type"].Trim();//请求类型 string json = context.Request.QueryString["json"].Trim();//请求参数(json类型) //string proc = context.Request.QueryString["proc"].Trim();//存储过程名称 var obj = JsonConvert.DeserializeObject <PromData>(json); var type = obj.type; if (type != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, "促销管理", rolestr); //if (/*rolestr == null || RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr) == 0*/false) //{ // returnJson = JsonMethod.GetError(4, "抱歉您没有权限进入!"); //} //else { //执行查询返回列表 if (type == "SaveProm") { var db = new SqlSugarDb(); var fabh = ""; if (string.IsNullOrWhiteSpace(obj.salesCode)) { db.Db.Ado.UseTran(() => { var maxbh = db.Db.Queryable <dt_Maxbh>().First(d => d.BiaoShi == "FAH")?.maxbh ?? "0"; var nowBh = (int.Parse(maxbh) + 1).ToString(); db.Db.Updateable <dt_Maxbh>().SetColumns(d => new dt_Maxbh { maxbh = nowBh }).Where(d => d.BiaoShi == "FAH").ExecuteCommand(); fabh = "FAH" + nowBh.PadLeft(11, '0'); }); } else { fabh = obj.salesCode; } var prom = new SC_T_PromSales(); prom.salesCode = fabh; prom.entid = user.entId; prom.faType = obj.faType; prom.salesName = obj.faname; prom.ruleCode = obj.ruleCode; prom.startDate = obj.startDates; prom.endDate = obj.endDates; if (string.IsNullOrWhiteSpace(obj.salesCode)) { db.Db.Insertable(prom).ExecuteCommand(); } else { db.Db.Updateable(prom).Where(d => d.entid == user.entId && d.salesCode == obj.salesCode).ExecuteCommand(); } returnJson = JsonMethod.GetError(0, "操作成功"); } if (type == "QuerySingleProm") { var db = new SqlSugarDb(); var model = db.Db.Queryable <SC_T_PromSales>().First(d => d.entid == obj.entid && d.salesCode == obj.salesCode); returnJson = JsonConvert.SerializeObject(new PromSalesUpdate() { promSales = model, flag = 0, message = "成功" }); } //} } } else { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(4, msg);; } context.Response.Write(returnJson); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string returnJson = ""; try { Dt_User user = RoleFuns.IsLoginAdmin(context.Session["user"]); if (user != null) //登录检测,权限检测 context.Session["user"] { string json = context.Request.QueryString["json"].Trim(); //请求参数(json类型) var obj = JsonConvert.DeserializeObject <PromRuleListModel>(json); var type = obj.type; if (type != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, "促销管理", rolestr); switch (type) { case "QueryList": { var db = new SqlSugarDb(); var total = 0; var strWhere = obj.strWhere; var status = obj.status; var faType = obj.faType; System.Linq.Expressions.Expression <Func <SC_T_PromSales, SC_T_PromRule, dt_PromType, bool> > lab; if (string.IsNullOrEmpty(status)) { lab = (d, f, e) => (d.salesName.Contains(strWhere) || f.describe.Contains(strWhere)) && d.faType.Contains(faType); } else { lab = (d, f, e) => (d.salesName.Contains(strWhere) || f.describe.Contains(strWhere)) && d.faType.Contains(faType) && SqlFunc.IsNull(d.isShow, "1") == status; } var data = db.Db.Queryable <SC_T_PromSales, SC_T_PromRule, dt_PromType>((d, f, e) => new object[] { JoinType.Left, d.ruleCode == f.ruleCode && d.faType == f.faType, JoinType.Left, d.faType == e.faType }) .Where(lab) .Select((d, f, e) => new { d.entid, d.salesName, d.salesCode, d.isShow, e.faName, f.ruleTitle, d.faType }) .ToDataTablePage(obj.PageIndex, obj.PageSize, ref total); var totalPage = total % obj.PageSize == 0 ? total / obj.PageSize : total / obj.PageSize + 1; returnJson = JsonMethod.GetDataTable(0, total, totalPage, data); } break; case "UpdateSalesDown": { var updateStatus = 1; var db = new SqlSugarDb(); db.Db.Ado.UseTran(() => { db.Db.Updateable <SC_T_PromSales>().SetColumns(d => new SC_T_PromSales() { isShow = updateStatus.ToString() }).Where(d => d.salesCode == obj.ruleCode && d.entid == obj.entid).ExecuteCommand(); db.Db.Ado.UseStoredProcedure().ExecuteCommand("Proc_Admin_PromSales", new SugarParameter("@type", "UpdateSalesDown"), new SugarParameter("@entid", obj.entid), new SugarParameter("@salesCode", obj.ruleCode)); }); returnJson = JsonMethod.GetError(0, "操作成功"); } break; case "UpdateSalesShow": { var updateStatus = 2; var db = new SqlSugarDb(); db.Db.Ado.UseTran(() => { db.Db.Updateable <SC_T_PromSales>().SetColumns(d => new SC_T_PromSales() { isShow = updateStatus.ToString() }).Where(d => d.salesCode == obj.ruleCode && d.entid == obj.entid).ExecuteCommand(); db.Db.Ado.UseStoredProcedure().ExecuteCommand("Proc_Admin_PromSales", new SugarParameter("@type", "UpdateSalesShow"), new SugarParameter("@entid", obj.entid), new SugarParameter("@salesCode", obj.ruleCode)); }); returnJson = JsonMethod.GetError(0, "操作成功"); } break; case "DeleteSales": { var updateStatus = 0; var db = new SqlSugarDb(); db.Db.Updateable <SC_T_PromSales>().SetColumns(d => new SC_T_PromSales() { isShow = updateStatus.ToString() }).Where(d => d.salesCode == obj.ruleCode && d.entid == obj.entid).ExecuteCommand(); returnJson = JsonMethod.GetError(0, "操作成功"); } break; } } } else { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(4, msg);; } context.Response.Write(returnJson); }