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);
        }
Example #2
0
        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}&nbsp;&nbsp;&nbsp;生产公司:{mm.drug_factory}&nbsp;&nbsp;&nbsp;规格:{mm.drug_spec}&nbsp;&nbsp;&nbsp;中包装:{mm.min_package}&nbsp;&nbsp;&nbsp;价格:{mm.price}&nbsp;&nbsp;&nbsp;库存:{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);
        }
Example #4
0
        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);
        }