/// <summary> /// 获取新推送 /// <summary> private void seachnewmessage(object sender) { Stop(); //获取推送编号 SqlParameter[] parameter_xh = new SqlParameter[] { new SqlParameter("@type", "查询新单据"), }; DataTable dt_xh = db.RunProcedureDR("SK_App_GetNewPsd", parameter_xh); if (dt_xh.Rows.Count == 0) { Log.Debug("推送获取编号详情", "无推送信息!"); } else { foreach (DataRow dataRow in dt_xh.Rows) { string xh = dataRow["djbh"].ToString(); Log.Debug("推送获取编号详情", xh); SeachNewOrder(xh); } } Start(); }
/// <summary> /// 选择商品组加入购物车 /// </summary> /// <param name="entId">企业id</param> /// <param name="userId">用户id</param> /// <param name="quantity">数量</param> /// <param name="fabh">促销方案编号</param> /// <returns></returns> public string CartAddGroup(string entId, string userId, decimal quantity, string fabh, out int flag, string bs, string cartType) { flag = 0; string msg = ""; try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "CartAddGroup"), new SqlParameter("@entId", entId), new SqlParameter("@userId", userId), new SqlParameter("@quantity", quantity), new SqlParameter("@fabh", fabh), new SqlParameter("@bs", bs), new SqlParameter("@carttype", cartType) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_CartAdd", parameters); if (table.Rows.Count > 0) { flag = int.Parse(table.Rows[0]["flag"].ToString()); msg = table.Rows[0]["msg"].ToString(); } return(msg); } catch (Exception ex) { flag = 1; return(ex.Message.ToString()); } }
public funbool DelUserGroup(string usergroupid, string groupid) { sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR("PC_Group", new SqlParameter[] { new SqlParameter("@type", "DelUserGroup"), new SqlParameter("@UserGroupId", usergroupid), new SqlParameter("@GroupId", groupid) } ); if (dt.Rows.Count > 0) { if (dt.Rows[0]["flag"].ToString() == "1") { return(new funbool(true, dt.Rows[0]["msg"].ToString())); } else { return(new funbool(false, dt.Rows[0]["msg"].ToString())); } } else { return(new funbool(false, "数据库未查出成功提示!")); } }
/// <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_GetType": //资质角色 foreach (DataRow dr_c1 in dtc.Rows) { objList += "<option value='" + dr_c1["TypeId"] + "'>" + dr_c1["Name"] + "</option>"; } break; default: break; } } return("{\"flag\":\"0\",\"objList\":\"" + objList + "\"}"); } else { string error = "无数据"; return(JsonMethod.GetError(1, error)); } }
/// <summary> /// 验证客户资质 /// </summary> /// <returns></returns> protected string ReturnCheckKhZz(string json, string proc, string userId, string entid) { string r_json = ""; JObject list = (JObject)JsonConvert.DeserializeObject(json); string khId = list["khId"].ToString(); string ywyId = list["ywyId"].ToString(); string hzId = list["hzId"].ToString(); string sqlType = list["type"].ToString(); string xentId = list["xentId"].ToString(); SqlRun sql = new SqlRun(SqlRun.sqlstr); //验证客户资质 SqlParameter[] paramC = new SqlParameter[] { new SqlParameter("@type", "CheckKh"), new SqlParameter("@khId", khId), new SqlParameter("@xentId", xentId) }; DataTable dt = sql.RunProcedureDR("proc_Ywt_XsdInfo", paramC); bool flag = false; string msg = ""; if (dt.Rows.Count > 0) { //flag = int.Parse(dt.Rows[0]["flag"].ToString() ?? "1"); msg = dt.Rows[0]["msg"].ToString(); } else { msg = dt.Rows[0]["msg"].ToString(); } return(msg); }
/// <summary> /// 删除设备类型 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entid"></param> /// <returns></returns> protected string GetDelTypeReturnJson(string userId, string entId, string id) { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Coupon", new SqlParameter[] { new SqlParameter("@type", "PC_DelType"), new SqlParameter("@strWhere", id), new SqlParameter("@entId", entId) }); string r_json; if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "1") { r_json = JsonMethod.GetError(0, "删除成功"); } else if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "2") { string error = "无法删除,请清除所属优惠券"; r_json = JsonMethod.GetError(1, error); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <summary> /// 返回DataTable(商品分类) /// </summary> /// <returns></returns> protected string GetSelectCategory() { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] { new SqlParameter("@type", "PC_GetSelectCategory") }); if (ds.Rows.Count > 0) { ///加载商品分类 string category = ""; DataTable dtc = ds; if (dtc.Rows.Count > 0) { foreach (DataRow dr_c1 in dtc.Rows) { category += "<option value='" + dr_c1["id"] + "'>" + dr_c1["title"] + "</option>"; } } return("{\"flag\":\"0\",\"category\":\"" + category + "\"}"); } else { string error = "没有商品分类,请添加"; return(JsonMethod.GetError(1, error)); } }
/// <summary> /// 返回DataTable(商品组合) /// </summary> /// <returns></returns> protected string GetSelectTemPro() { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] { new SqlParameter("@type", "PC_GetSelectTemPro") }); if (ds.Rows.Count > 0) { ///加载商品组合 string prom = ""; DataTable dtc = ds; if (dtc.Rows.Count > 0) { foreach (DataRow dr_c1 in dtc.Rows) { prom += "<option value='" + dr_c1["Id"] + "'>" + dr_c1["name"] + "</option>"; } } return("{\"flag\":\"0\",\"prom\":\"" + prom + "\"}"); } else { string error = "没有主题商品组合,请添加"; return(JsonMethod.GetError(1, error)); } }
/// <summary> /// 再次购买 /// </summary> /// <param name="userId">下单人Id</param> /// <param name="entId">下单人机构</param> /// <param name="billNo">再次购买商品的单号</param> /// <param name="loginId">登陆人Id</param> /// <param name="fabh"></param> /// <param name="flag"></param> /// <returns></returns> public string OnceAgain(string userId, string entId, int billNo, string loginId, out bool flag, string jgjb, string khType, string cartType, string bs) { try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "OnceAgain"), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId), new SqlParameter("@billNo", billNo), new SqlParameter("@loginId", loginId), new SqlParameter("@cartType", cartType), new SqlParameter("@jgjb", jgjb), new SqlParameter("@khType", khType), new SqlParameter("@bs", bs) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR("Proc_OperationOrders", parameters); if (dt.Rows.Count > 0) { flag = 0 == int.Parse(dt.Rows[0]["flag"].ToString()) ? true : false; return(dt.Rows[0]["msg"].ToString()); } else { flag = false; return("订单存盘失败"); } } catch (Exception ex) { flag = false; return(ex.Message.ToString()); } }
/// <summary> /// 返回DataTable(活动模板) /// </summary> /// <returns></returns> protected string GetSelectTemplate() { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] { new SqlParameter("@type", "PC_GetSelectTemplate") }); if (ds.Rows.Count > 0) { ///加载商品分类 string templatestr = ""; DataTable dtc = ds; if (dtc.Rows.Count > 0) { foreach (DataRow dr_c1 in dtc.Rows) { templatestr += "<option value='" + dr_c1["TemplateCode"] + "'>" + dr_c1["TemplateName"] + "</option>"; } } return("{\"flag\":\"0\",\"templatestr\":\"" + templatestr + "\"}"); } else { string error = "没有活动模板,请添加->上架"; return(JsonMethod.GetError(1, error)); } }
/// <summary> ///获取单个组合信息 /// </summary> /// <param name="entId">机构</param> /// <param name="userId">用户</param> /// <param name="fabh">活动编号</param> /// <returns></returns> public DataTable GetGroupInfo(string entId, string userId, string fabh) { ///获取购物车商品列表 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Type", "GetGroupOne"), new SqlParameter("@UserId", userId), new SqlParameter("@Entid", entId), new SqlParameter("@fabh", fabh) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR("Proc_PromotionInfo", param); return(dt); }
/// <summary> /// 机构列表 /// </summary> /// <returns></returns> public List <Entdoc> EntdocList() { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "EntdocList") }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationEntdoc", parameters); List <Entdoc> list = new List <Entdoc>(); if (table.Rows.Count >= 0) { list = FillList(table); } return(list); }
/// <summary> /// 获取商品分类列表 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entId"></param> /// <returns></returns> protected string GetGoodsCategory(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) { r_json = JsonMethod.GoodsCategory(dt); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <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 GetTemplateDetail(string TemplateCode) { string r_json = ""; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] { new SqlParameter("@type", "PC_GetTemplateDetail"), new SqlParameter("@TemplateCode", TemplateCode) }); if (ds.Rows.Count > 0) { r_json = ds.Rows[0]["txt"].ToString(); } else { r_json = ""; } return(r_json); }
/// <summary> /// 客户类型 /// </summary> /// <returns></returns> public List <ClintType> ClientType() { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "ClientType") }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls); List <ClintType> types = new List <ClintType>(); if (table.Rows.Count > 0) { return(types = FillClientType(table)); } else { return(types = null); } }
/// <summary> /// 用户信贷 /// </summary> /// <param name="userId">用户</param> /// <param name="entId">机构</param> /// <returns></returns> public UserDebt DebtInfo(string userId, string entId) { //LogQueue.Write(LogType.Debug, "1", userId); SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "UserDebt"), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_UserInfo", sqls); UserDebt debt = new UserDebt(); if (table.Rows.Count > 0) { debt = FillDebt(table); } return(debt); }
/// <summary> /// 获取多个表返回Json /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entid"></param> /// <returns></returns> protected string ReturnDataTableJson(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); DataTable table = sql.RunProcedureDR(proc, param); if (table.Rows.Count > 0) { r_json = JsonMethod.DataTableToJson("0", table); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } return(r_json); }
/// <summary> /// 商品首营图片 /// </summary> /// <param name="goodsno">商品编号</param> /// <returns></returns> public List <ProductFirstCampPictures> ProductFirstCampPictures(string goodsno) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "ProductFirstCampPictures"), new SqlParameter("@sqlvalue", goodsno) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable data = sql.RunProcedureDR("Proc_QualityInspection", sqls); if (data.Rows.Count > 0) { return(ProductFirstCampPicturesFill(data)); } else { return(null); } }
/// <summary> /// APP个人中心数据 /// </summary> /// <param name="entid"></param> /// <returns></returns> public List <AppModule> PerModule(string entid, string userId, string model) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "PersonerModule"), new SqlParameter("@entid", entid), new SqlParameter("@userId", userId), new SqlParameter("@model", model) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var dt = sql.RunProcedureDR("Proc_UserInfo", parameters); List <AppModule> list = new List <AppModule>(); if (dt.Rows.Count > 0) { list = FillPerModule(dt); } return(list); }
/// <summary> /// 限时抢购 /// </summary> /// <param name="entId">机构</param> /// <param name="userId">用户</param> /// <param name="promType">活动类型</param> /// <param name="jgjb">价格级别</param> /// <param name="khType">客户类型</param> /// <param name="staleDated">证书是否过期</param> /// <param name="landing">是否登录</param> /// <returns></returns> public List <PromFlashSale> GetPromFlashSale(string entId, string userId, string promType, string jgjb, string khType, bool landing, bool staleDated) { ///获取单品促销信息 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Type", "GetFlashSale"), new SqlParameter("@UserId", userId), new SqlParameter("@Entid", entId), new SqlParameter("@Jgjb", jgjb), new SqlParameter("@promType", promType), new SqlParameter("@khlb", khType), }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR("Proc_PromotionInfo", param);//源数据 #region 重写 string now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //获取正在进行的商品组 DataRow[] begin = dt.Select(" startDate <= '" + now + "' and endDate > '" + now + "' "); //LogQueue.Write(LogType.Debug, "正在进行", $"{begin.Length},now:{now}"); DataTable dtBegin = dt.Clone(); foreach (DataRow item in begin) { dtBegin.ImportRow(item); } //还未开始的商品组 DataRow[] after = dt.Select(" startDate > '" + now + "'"); //LogQueue.Write(LogType.Debug, "还未开始", $"{after.Length},now:{now}"); DataTable dtAfter = dt.Clone(); foreach (DataRow item in after) { dtAfter.ImportRow(item); } List <PromFlashSale> list = new List <PromFlashSale>(); if (dt.Rows.Count > 0) { list = SetDate(dtBegin, dtAfter, landing, staleDated); } return(list); #endregion }
/// <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); }
/// <summary> /// 资料类型 /// </summary> /// <returns></returns> public List <UserMaterial> MaterialType(string customerType) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "MaterialType"), new SqlParameter("@customerType", customerType) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls); List <UserMaterial> types = new List <UserMaterial>(); if (table.Rows.Count > 0) { return(types = FillMaterial(table)); } else { return(types = null); } }
/// <summary> /// 购物车选中商品 /// </summary> /// <param name="entId"></param> /// <param name="userId"></param> /// <param name="goodsList"></param> /// <param name="jgjb"></param> /// <returns></returns> public List <CartGoods> CartList(string entId, string userId, string goodsList, string jgjb) { ///获取购物车商品列表 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Type", "GetCartList"), new SqlParameter("@UserId", userId), new SqlParameter("@Entid", entId), new SqlParameter("@Jgjb", jgjb), new SqlParameter("@List", goodsList) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_CartList", param); List <CartGoods> list = new List <CartGoods>(); if (table.Rows.Count > 0) { list = FillList(table); } return(list); }
/// <summary> /// 充值方式 /// </summary> /// <param name="entId">机构</param> /// <returns></returns> public List <Payment> PayTypes(string entId) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "PayTypes"), new SqlParameter("@entId", entId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationRecharge", sqls); List <Payment> payApis = new List <Payment>(); if (table.Rows.Count > 0) { return(payApis = FillPayApi(table)); } else { return(payApis = null); } }
/// <summary> /// 检测用户的角色权限 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="userId"></param> /// <param name="entId"></param> /// <returns></returns> protected string GetRoleJson(string json, string proc, 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); string r_json; if (ds.Rows.Count > 0) { int recordCount = 0; int pageCount = 0; r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds); } else { string error = "无数据"; r_json = JsonMethod.GetError(1, error); } 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> /// <returns></returns> public JsonResult GetTemplateList(string entId, string userId) { try { if (string.IsNullOrEmpty(userId)) { return(Json(new { success = false, message = "用户未登录,请先登录" })); } SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR("Pc_TemplateRelation", new SqlParameter[] { new SqlParameter("@type", "CX_GetTemplateList"), new SqlParameter("@entId", entId) }); return(Json(JsonMethod.DataTableToJson("1", dt))); } catch (Exception ex) { LogQueue.Write(LogType.Error, "Template/GetTemplateList", ex.Message.ToString()); return(Json(new { success = false, message = "商城主题加载失败" })); } }
/// <summary> /// 注册手机号验证 /// </summary> /// <param name="telphone">手机号</param> /// <returns></returns> public int PhoneVerify(string telphone, out string entId) { entId = ""; SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "PhoneVerify"), new SqlParameter("@telphone", telphone) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls); if (table.Rows.Count > 0) { entId = table.Rows[0]["entid"].ToString(); return(int.Parse(table.Rows[0]["status"].ToString())); } else { entId = ""; return(9999); } }
/// <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> /// 删除购物车商品 /// </summary> /// <param name="dltType">删除类型</param> /// <param name="entId">企业Id</param> /// <param name="userId">用户id</param> /// <param name="cartId">购物车Id</param> /// <returns></returns> public bool DeleteCart(string entId, string userId, string dltType, string cartId, string cartType, string ywyId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "CartDelete"), new SqlParameter("@userId", userId), new SqlParameter("@ywyId", ywyId), new SqlParameter("@entId", entId), new SqlParameter("@dltType", dltType), new SqlParameter("@cartId", cartId), new SqlParameter("@cartType", cartType) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = false; DataTable table = sql.RunProcedureDR("Proc_CartAdd", parameters); if (table.Rows.Count > 0) { flag = int.Parse(table.Rows[0]["flag"].ToString()) == 0 ? true : false; } return(flag); }