/// <summary> /// 返回模板绑定 /// </summary> /// <param name="templateName"></param> /// <param name="isDel"></param> /// <param name="status"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> protected string GetTemplateRelationDetail(string TemplateCode) { string r_json = ""; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_TemplateRelation", new SqlParameter[] { new SqlParameter("@type", "PC_GetTemplateRelationDetail"), new SqlParameter("@TemplateRelationCode", TemplateCode) }); if (ds.Rows.Count > 0) { r_json = JsonMethod.GetDataTable(0, ds.Rows.Count, 1, ds); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string returnJson = ""; try { string type = context.Request.QueryString["type"].Trim();//请求类型 if (type == "UploadImage") { returnJson = UploadImage(context); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(4, msg);; } context.Response.Write(returnJson); }
/// <summary> /// 更新数据目录 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <returns></returns> protected string GetReturnJsonInt(string json, string proc, string userId, string entid) { SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entid)).ToArray();//动态解析json参数 SqlRun sql = new SqlRun(SqlRun.sqlstr); int n = sql.ExecuteNonQuery(proc, param); string r_json; string msg; if (n > 0) { msg = "更新成功"; r_json = JsonMethod.GetError(0, msg); } else { msg = "更新失败!"; r_json = JsonMethod.GetError(1, msg); } return(r_json); }
/// <summary> /// 更新数据库的数据,返回一个表 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <returns></returns> protected string GetReturnDs(string json, string proc, string UserId, string entid) { SqlParameter[] param = (JsonMethod.ListParameter(json, UserId, entid)).ToArray();//动态解析json参数 SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR(proc, param); string r_json; if (dt.Rows.Count > 0) { int flag = int.Parse(dt.Rows[0]["flag"].ToString() ?? "1"); string msg = dt.Rows[0]["msg"].ToString(); r_json = JsonMethod.GetError(flag, msg); } else { string msg = dt.Rows[0]["msg"].ToString(); r_json = JsonMethod.GetError(1, msg); } return(r_json); }
/// <summary> /// 活动绑定上架 /// </summary> /// <param name="templateCode"></param> /// <param name="status"></param> /// <returns></returns> protected string SetTemplateRelationStatu(string templateRelationCode, string status) { string r_json = ""; SqlRun sql = new SqlRun(SqlRun.sqlstr); int num = sql.ExecuteNonQuery("Pc_TemplateRelation", new SqlParameter[] { new SqlParameter("@type", "PC_UpTemplateRelationStatus"), new SqlParameter("@TemplateRelationCode", templateRelationCode), new SqlParameter("@Status", status) }); if (num > 0) { r_json = JsonMethod.GetError(0, "成功"); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <summary> /// 返回DataTable(规则详情) /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entid"></param> /// <returns></returns> protected string GeTypeDetailReturnJson(string userId, string entId, string id) { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Coupon", new SqlParameter[] { new SqlParameter("@type", "PC_GetTypeDetail"), new SqlParameter("@strWhere", id), new SqlParameter("@entId", entId) }); string r_json; if (ds.Rows.Count > 0) { r_json = JsonMethod.GetDataTable(0, ds.Rows.Count, 1, ds); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <summary> /// 返回DataTable(权限访问) /// </summary> /// <param name="userId">用户主键</param> /// <param name="entId"></param> /// <param name="ConfigType">权限等级</param> /// <returns></returns> protected string GettIndexUrlJson(string entid, string username) { SqlRun sql = new SqlRun(SqlRun.sqlstr); List <Dt_Method> list = new List <Dt_Method>(); if (entid == "superintendent") { list = DateTableTool.DataTableToList <Dt_Method>(sql.RtDataTable($"select * from Dt_Method m join [Dt_RoleMethod] rm on rm.MethodId=m.Id join dt_users us on rm.RoleId=us.role_id and us.entid='superintendent'")); } else { list = DateTableTool.DataTableToList <Dt_Method>(sql.RtDataTable($"select m.* from Dt_Method m join [Dt_RoleMethod] rm on rm.MethodId=m.Id join dt_users us on rm.RoleId=us.role_id where m.status=1 and us.entid='" + entid + "' and us.username='******' and m.Source in('B2B','ALL')")); } if (list.Count() > 0) { ///加载Html string urlList = ""; foreach (Dt_Method meth in list.Where(a => a.FatherId == null)) { urlList += "<dl id='menu-" + meth.Id + "'>"; urlList += " <dt ><i class='Hui-iconfont ztbj' style='font-size: 20px'>" + meth.IcoAddress + "</i> " + meth.Title + "<i class='Hui-iconfont menu_dropdown-arrow'></i></dt>"; urlList += " <dd>"; urlList += " <ul>"; foreach (Dt_Method son in list.Where(a => a.FatherId == meth.Id).ToList()) { urlList += "<li><a data-href='" + son.Power + "' data-title='" + son.Title + "' href='javascript:void(0)'><i class='Hui-iconfont'>" + son.IcoAddress + "</i> " + son.Title + "</a></li>"; } urlList += " </ul>"; urlList += " </dd>"; urlList += "</dl>"; } return("{\"flag\":\"0\",\"urlList\":\"" + urlList + "\"}"); } else { string error = "无数据"; return(JsonMethod.GetError(1, error)); } }
/// <summary> /// 用户审核 /// </summary> public string AuditUser(string json) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_users set status=@status where userId=@userId"); SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@status", obj["status"].ToString()), new SqlParameter("@userId", obj["userId"].ToString()), }; SqlRun sql = new SqlRun(SqlRun.sqlstr); int n = sql.ExecuteSql(strSql.ToString(), pram); if (n > 0) { return(JsonMethod.GetError(0, "操作成功")); } else { return(JsonMethod.GetError(1, "操作失败")); } }
/// <summary> /// 获取数据返回数据列表 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entId"></param> /// <returns></returns> protected string GetReturnJson(string json, string proc, string userId, string entId) { string r_json; SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数 SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet(proc, param); if (ds.Tables.Count >= 3) { if (ds.Tables[1].Rows.Count > 0) { int recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim()); int pageCount = Convert.ToInt32(ds.Tables[2].Rows[0]["pageCount"].ToString().Trim()); DataTable table = sql.GetChinaName(ds.Tables[1]); r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, table, ds.Tables[1]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } else { if (ds.Tables[0].Rows.Count > 0) { int recordCount = 0; int pageCount = 0; r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[0]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } return(r_json); }
protected string UpdateDelMethodJson(string status, string strWhere) { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Proc_Admin_MembersQuery", new SqlParameter[] { new SqlParameter("@type", "PC_DelMethodUrl"), new SqlParameter("@strWhere", strWhere) }); string r_json; if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "1") { r_json = JsonMethod.GetError(0, "删除成功"); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="json"></param> /// <returns></returns> protected string UpdateUserInfo(string json, string password) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); string pwd = ""; if (obj["pwd"].ToString().Trim() == password) { pwd = obj["pwd"].ToString().Trim(); } else { pwd = Encryption.GetMD5_16(obj["pwd"].ToString().Trim()); } string name = obj["name"].ToString(); string sex = obj["sex"].ToString(); string telphone = obj["telphone"].ToString(); string birthday = obj["birthday"].ToString(); string point = obj["point"].ToString(); string status = obj["status"].ToString(); string userIds = obj["userId"].ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append($"update dt_users set name='{name}',sex='{sex}',telphone='{telphone}',birthday='{birthday}',point='{point}',status='{obj["status"].ToString()}',"); strSql.Append($"password='******' where userId='{userIds}'"); //entId = @entId, SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); if (flag) { return(JsonMethod.GetError(0, "存盘成功")); } else { return(JsonMethod.GetError(1, "操作失败")); } }
/// <summary> /// 保存模板绑定 /// </summary> /// <param name="title"></param> /// <param name="newsType"></param> /// <param name="sortId"></param> /// <param name="dates"></param> /// <param name="content"></param> /// <returns></returns> protected string SaveTemplateRelation(string promotioncode, string templatecode, string categorycode, int txtType, string templateimg, int sort_id, string id) { SqlRun sql = new SqlRun(SqlRun.sqlstr); int num = sql.ExecuteNonQuery("Pc_TemplateRelation", new SqlParameter[] { new SqlParameter("@type", "PC_AddTemplateRelation"), new SqlParameter("@PromotionCode", promotioncode), new SqlParameter("@TemplateCode", templatecode), new SqlParameter("@CategoryCode", categorycode), new SqlParameter("@TypeCode", txtType), new SqlParameter("@TemplateImg", templateimg), new SqlParameter("@Sort_id", sort_id), new SqlParameter("@strWhere", id), }); if (num > 0) { return(JsonMethod.GetError(0, "操作成功")); } else { return(JsonMethod.GetError(1, "操作失败")); } }
/// <summary> /// 客户审核 /// </summary> /// <param name="json"></param> /// <returns></returns> public string AuditCustomer(string json) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_businessdoc set beactive=@status where businessid=@businessId and entid=@entId"); SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@status", obj["status"].ToString()), new SqlParameter("@businessId", obj["businessId"].ToString()), new SqlParameter("@entId", obj["entId"].ToString()), }; SqlRun sql = new SqlRun(SqlRun.sqlstr); int n = sql.ExecuteSql(strSql.ToString(), pram); if (n > 0) { return(JsonMethod.GetError(0, "操作成功")); } else { return(JsonMethod.GetError(1, "操作失败")); } }
/// <summary> /// 修改推荐商品 /// </summary> /// <param name="json"></param> /// <returns></returns> private string UpdateGoodsRecommend(string json) { dynamic obj = JsonConvert.DeserializeObject <dynamic>(json); int articleid = Convert.ToInt32(obj.articleid); int old_articleid = Convert.ToInt32(obj.old_articleid); int type = Convert.ToInt32(obj.code); int old_type = Convert.ToInt32(obj.old_type); int status = Convert.ToInt32(obj.status); int sort = Convert.ToInt32(obj.sort); DAL.GoodsInfoDal goodsInfoDal = new DAL.GoodsInfoDal(); if (articleid != old_articleid) { bool isExist = goodsInfoDal.ExistGoodsRecommend(articleid, type); if (isExist) { return(JsonMethod.GetError(3, "此推荐商品已存在")); } } bool result = goodsInfoDal.UpdateGoodsRecommend(articleid, old_articleid, type, old_type, status, sort); return(result ? JsonMethod.GetError(1, "修改成功") : JsonMethod.GetError(0, "修改失败,请稍后重试")); }
public string SaveCustomer(string json) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_businessdoc set businesscode=@businesscode,businessname=@businessname,entid=@entid,clienttype=@clienttype,"); strSql.Append("beactive=@beactive,shortname=@shortname,businesscont=@businesscont,address=@address,wtr=@wtr,wtsyxq=@wtsyxq,"); strSql.Append("xkzyxq=@xkzyxq,yyzzyxq=@yyzzyxq,gspzsyxq=@gspzsyxq where entid=@oldentid and businessid=@businessid "); SqlParameter[] pram = new SqlParameter[] { new SqlParameter("@businesscode", obj["businesscode"].ToString()), new SqlParameter("@businessname", obj["businessname"].ToString()), new SqlParameter("@entid", obj["entid"].ToString()), new SqlParameter("@clienttype", obj["clienttype"].ToString()), new SqlParameter("@beactive", obj["beactive"].ToString()), new SqlParameter("@shortname", obj["shortname"].ToString()), new SqlParameter("@businesscont", obj["businesscont"].ToString()), new SqlParameter("@address", obj["address"].ToString()), new SqlParameter("@wtr", obj["wtr"].ToString()), new SqlParameter("@wtsyxq", obj["wtsyxq"].ToString()), new SqlParameter("@xkzyxq", obj["xkzyxq"].ToString()), new SqlParameter("@yyzzyxq", obj["yyzzyxq"].ToString()), new SqlParameter("@gspzsyxq", obj["gspzsyxq"].ToString()), new SqlParameter("@oldentid", obj["oldentid"].ToString()), new SqlParameter("@businessid", obj["businessid"].ToString()) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); int n = sql.ExecuteSql(strSql.ToString(), pram); if (n > 0) { return(JsonMethod.GetError(0, "存盘成功")); } else { return(JsonMethod.GetError(1, "存盘失败")); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string type = context.Request.QueryString["type"].Trim(); //请求类型 string json = context.Request.QueryString["json"].Trim(); //请求参数(json类型) string proc = context.Request.QueryString["proc"].Trim(); //存储过程名称 string returnJson = ""; switch (type) { case "login": returnJson = UserLogin(json, proc, context); break; case "loginOut": returnJson = loginOut(context); break; case "UrlAddress": Dt_User user = RoleFuns.IsLoginAdmin(context.Session["user"]); if (user == null) { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } else { returnJson = GettIndexUrlJson(user.entId, user.username); } break; default: returnJson = JsonMethod.GetError(4, "参数错误!"); break; } context.Response.Write(returnJson); }
/// <summary> /// 获取数据返回数据列表 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entid"></param> /// <returns></returns> protected string GetReturnJson(string json, string proc, string userId, string entid) { List <SqlParameter> listPrmt = new List <SqlParameter>(); JObject o = JObject.Parse(json); IEnumerable <JProperty> properties = o.Properties(); bool flag = true; foreach (JProperty item in properties) { if (item.Name.Trim() != "") { if (item.Name.ToString() == "Entid") { flag = false; } if (item.Name.ToString() == "PassWord")//密码md5加密 { listPrmt.Add(new SqlParameter("@" + item.Name, Encryption.GetMD5_16(item.Value.ToString()))); } else if (item.Name.ToString() == "XPassWord")//密码md5加密 { listPrmt.Add(new SqlParameter("@" + item.Name, Encryption.GetMD5_16(item.Value.ToString()))); } else { listPrmt.Add(new SqlParameter("@" + item.Name, item.Value.ToString().Trim() ?? "")); } } } if (userId != "") { listPrmt.Add(new SqlParameter("@UserId", userId)); } if (entid != "" && flag == true) { listPrmt.Add(new SqlParameter("@entId", entid)); } SqlParameter[] param = listPrmt.ToArray();//动态解析json参数 JObject obj = (JObject)JsonConvert.DeserializeObject(json); string familyid = ""; if (obj["type"].ToString() == "GetAdminList") { familyid = Familylist(userId, entid); Log.Info("家族主键", familyid); } if (familyid != "" && flag == true) { listPrmt.Add(new SqlParameter("@familyid", familyid)); } //获取顶级以及最底层所有会员的状态 SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet(proc, param); string r_json; if (ds.Tables.Count >= 3) { if (ds.Tables[1].Rows.Count > 0) { int recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim()); int pageCount = Convert.ToInt32(ds.Tables[2].Rows[0]["pageCount"].ToString().Trim()); r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[1]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } else { if (ds.Tables[0].Rows.Count > 0) { int recordCount = 0; int pageCount = 0; r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[0]); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } } return(r_json); }
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.Params["json"].Trim(); //请求参数(json类型) string type = context.Request.Params["type"].Trim(); //请求类型 string proc = context.Request.Params["proc"].Trim(); //存储过程名称 JObject obj = (JObject)JsonConvert.DeserializeObject(json); if (obj["type"] != null) { List <string> rolestr = context.Session["role"] != null? (List <string>)context.Session["role"]:null; RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr); //if (/*rolestr == null || RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr) == 0*/false) //{ // returnJson = JsonMethod.GetError(4, "抱歉您没有权限进入!"); //} //else { //执行查询返回列表 switch (type) { case "ReturnList": returnJson = GetReturnJson(json, proc, user.userId, user.entId); break; case "ReturnNumber": returnJson = GetReturnJsonInt(json, proc, user.userId, user.entId); break; case "LoadCheckBox": returnJson = LoadCheckBox(json, proc, user.userId, user.entId, context); break; case "ReturnDataSet": returnJson = ReturnDataSetJson(json, proc, user.userId, user.entId); break; //case "UpdateGoodsInfo": // returnJson = UpdateGoodsInfo(json, proc, user.userId, user.entId); // break; case "GoodsCategory": returnJson = GetGoodsCategory(json, proc, user.userId, user.entId); break; case "GoodsRecommendList": returnJson = GetGoodRecommendList(json); break; case "GoodsRecommendType": returnJson = GetGoodsRecommendType(); break; case "AddGoodsRecommend": returnJson = AddGoodsRecommend(json); break; case "SingleGoodsRecommend": returnJson = SingleGoodsRecommend(json); break; case "StatusGoodsRecommend": returnJson = StatusGoodsRecommend(json); break; case "DeleteGoodsRecommend": returnJson = DeleteGoodsRecommend(json); break; case "UpdateGoodsRecommend": returnJson = UpdateGoodsRecommend(json); break; default: returnJson = JsonMethod.GetError(4, "参数错误!"); 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); }
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 type = context.Request.QueryString["type"].Trim(); //请求类型 string json = context.Request.QueryString["json"].Trim(); //请求参数(json类型) string proc = context.Request.QueryString["proc"].Trim(); //存储过程名称 string password = user.password; JObject obj = (JObject)JsonConvert.DeserializeObject(json); if (obj["type"] != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr); //if (/*rolestr == null || RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr) == 0*/false) //{ // returnJson = JsonMethod.GetError(4, "抱歉您没有权限进入!"); //} //else { switch (type) { case "ReturnList": returnJson = GetReturnJson(json, proc, user.userId, user.entId); break; case "ReturnDataSet": returnJson = ReturnDataSetJson(json, proc, user.userId, user.entId); break; case "UpdateUserInfo": returnJson = UpdateUserInfo(json, password); break; case "AuditUser": returnJson = AuditUser(json); break; case "AuditCustomer": returnJson = AuditCustomer(json); break; case "SaveCustomer": returnJson = SaveCustomer(json); break; default: returnJson = JsonMethod.GetError(1, "参数错误!"); 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); }
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); }
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(); //存储过程名称 JObject obj = (JObject)JsonConvert.DeserializeObject(json); if (obj["type"] != null) { List <string> rolestr = context.Session["role"] != null ? (List <string>)context.Session["role"] : null; RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr); //if (/*rolestr == null || RoleFuns.SetAdminLog(user.username, obj["type"].ToString(), rolestr) == 0*/false) //{ // returnJson = JsonMethod.GetError(4, "抱歉您没有权限进入!"); //} //else { switch (type) { case "ReturnList": returnJson = GetReturnJson(json, proc, user.userId, user.entId); break; case "ReturnDataSet": returnJson = ReturnDataSetJson(json, proc, user.userId, user.entId); break; case "ReturnNumber": returnJson = GetReturnJsonInt(json, proc, user.userId, user.entId); break; case "ReturnListNumber": returnJson = GetReturnDs(json, proc, user.userId, user.entId); break; case "SaveBase": returnJson = SaveBase(json, proc, user.userId, user.entId); break; case "GetWebSiteBase": returnJson = GetWebSiteBase(json, proc, user.userId, user.entId); break; case "GetConfig": //returnJson = GetWebConfig(json, proc, user.userId, user.entId); break; case "jiancerole": returnJson = GetRoleJson(json, proc, user.userId, user.entId); break; case "Jy": returnJson = UpdateUpJson(context.Request.QueryString["status"].Trim(), context.Request.QueryString["strWhere"].Trim()); break; case "Qy": returnJson = UpdateUpJson(context.Request.QueryString["status"].Trim(), context.Request.QueryString["strWhere"].Trim()); break; case "delUser": returnJson = DelAdminUserJson(context.Request.QueryString["strWhere"].Trim()); break; case "delMethod": returnJson = UpdateDelMethodJson(context.Request.QueryString["status"].Trim(), context.Request.QueryString["strWhere"].Trim()); break; case "delRole": returnJson = UpdateDelRoleJson(context.Request.QueryString["status"].Trim(), context.Request.QueryString["strWhere"].Trim()); break; default: returnJson = JsonMethod.GetError(4, "参数错误!"); 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); }
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.Params["type"].Trim(); //请求类型 string strWhere; int pageIndex; string status; int txtType; switch (type) { case "TemplateLIst": strWhere = context.Request.Params["strWhere"]; pageIndex = int.Parse(context.Request.Params["pageIndex"]); status = context.Request.Params["Status"]; returnJson = GetTemplateReturnJson(strWhere, status, pageIndex); break; case "TemplateRelationLIst": strWhere = context.Request.Params["strWhere"]; pageIndex = int.Parse(context.Request.Params["pageIndex"]); status = context.Request.Params["Status"]; txtType = int.Parse(context.Request.Params["txtType"]); returnJson = GetTemplateRelationReturnJson(strWhere, status, txtType, pageIndex); break; case "SaveTemplate": string title = context.Request.Params["title"]; string content = context.Request.Params["content"]; strWhere = context.Request.Params["strWhere"]; returnJson = SaveTemplate(title, content, strWhere); break; case "SaveTemplateRelation": var sltTemplateRelation = context.Request.Params["sltTemplateRelation"]; txtType = int.Parse(context.Request.Params["txtType"]); int txtSortId = int.Parse(context.Request.Params["txtSortId"]); var sltcategory = context.Request.Params["sltcategory"]; var sltprom = context.Request.Params["sltprom"]; var templateimg = context.Request.Params["txtImgUrl"]; strWhere = context.Request.Params["strWhere"]; returnJson = SaveTemplateRelation(sltprom, sltTemplateRelation, sltcategory, txtType, templateimg, txtSortId, strWhere); break; case "AuditTemplate": strWhere = context.Request.Params["id"]; status = context.Request.Params["status"]; returnJson = SetTemplateStatu(strWhere, status); break; case "AuditTemplateRelation": strWhere = context.Request.Params["id"]; status = context.Request.Params["status"]; returnJson = SetTemplateRelationStatu(strWhere, status); break; case "TemDel": strWhere = context.Request.Params["strWhere"]; returnJson = SetTemplateIsDel(strWhere); break; case "TemRelationDel": strWhere = context.Request.Params["strWhere"]; returnJson = SetTemplateRelationIsDel(strWhere); break; case "TemplateDetail": strWhere = context.Request.Params["strWhere"]; returnJson = GetTemplateDetail(strWhere); break; case "TemplateRelationDetail": strWhere = context.Request.Params["strWhere"]; returnJson = GetTemplateRelationDetail(strWhere); break; case "selectTemplate": returnJson = GetSelectTemplate(); break; case "selectCategory": returnJson = GetSelectCategory(); break; case "selectTemPro": returnJson = GetSelectTemPro(); break; default: returnJson = JsonMethod.GetError(4, "参数错误!"); break; } } else { returnJson = JsonMethod.GetError(2, "登陆超时,请重新登陆!"); } } catch (Exception e) { string msg = e.Message.ToString().Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", ""); returnJson = JsonMethod.GetError(3, msg); } context.Response.Write(returnJson); }
/// <summary> /// 返回DataTable(渠道分类) /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entid"></param> /// <returns></returns> protected string GetReturnJsonBox(string json, string proc, string typename, string userId, string entid) { SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entid)).ToArray();//动态解析json参数 SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR(proc, param); if (ds.Rows.Count > 0) { ///加载节点 string objList = ""; DataTable dtc = ds; if (dtc.Rows.Count > 0) { switch (typename) { case "Pc_GetClassType": //设备类型//应用范围 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["Code"] + "'>" + dr_c1["Name"] + "</option>"; } break; case "Pc_GetCouponType": //领取类型 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["typeCoding"] + "'>" + dr_c1["typeName"] + "</option>"; } break; case "Pc_GetBrandType": //品牌类型 var num = 0; foreach (DataRow dr_c1 in dtc.Rows) { //; objList += "<input type='checkbox' id='chkPpBox" + num + "' value='" + dr_c1["billno"] + "' title='" + dr_c1["name"] + "' /> <label for='chkPpBox" + num + "''>" + dr_c1["name"] + "</label>  "; num++; } break; case "Pc_GoodsGroup": //商品分组 var n = 0; foreach (DataRow dr_c1 in dtc.Rows) { //; objList += "<input type='checkbox' id='chkPpBox" + n + "' value='" + dr_c1["billno"] + "' title='" + dr_c1["name"] + "' /> <label for='chkPpBox" + n + "''>" + dr_c1["name"] + "</label>  "; n++; } break; case "Pc_GetHelperType": case "Pc_GetCateGoryType": //分类类型 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["title"] + "</option>"; } break; case "Pc_GetShengType": //省 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>"; } break; case "Pc_GetShiType": //市 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>"; } break; case "Pc_GetQuType": //区 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>"; } break; default: break; } } return("{\"flag\":\"0\",\"objList\":\"" + objList + "\"}"); } else { string error = "无数据"; return(JsonMethod.GetError(1, error)); } }
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); }
/// <summary> /// 用户退出登陆 /// </summary> /// <param name="context"></param> /// <returns></returns> protected string loginOut(HttpContext context) { context.Session["user"] = null; context.Session["role"] = null; return(JsonMethod.GetError(0, "退出成功")); }