/// <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); }
/// <summary> /// 获取用户优惠券 /// </summary> /// <param name="entId">机构</param> /// <param name="userId">用户</param> /// <param name="pageIndex">当前页数</param> /// <param name="pageSize">每页条目</param> /// <param name="enable">是否使用</param> /// <param name="limit">是否过期</param> /// <param name="recordCount">总条目</param> /// <param name="pageCount">总页数</param> /// <returns></returns> public List <Coupon> UserCouponList(string entId, string userId, string source, int pageIndex, int pageSize, int enable, out int recordCount, out int pageCount) { recordCount = 0; pageCount = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "UserCouponList"), new SqlParameter("@entId", entId), new SqlParameter("@userId", userId), new SqlParameter("@enable", enable), new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var list = new List <Coupon>(); var set = sql.RunProDataSet("Proc_OperationCoupon", parameters); if (set.Tables.Count >= 3) { pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString()); recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString()); int code = 10006; switch (source) { case "苹果端": code = 10005; break; case "电脑端": code = 10000; break; case "安卓端": code = 10003; break; } list = FillList(set.Tables[1]).Where(a => a.TypeCoding == 10006 | a.TypeCoding == code).ToList(); } return(list); }
/// <summary> /// 个人中心角标 /// </summary> /// <param name="entId">企业</param> /// <param name="userId">用户</param> /// <returns></returns> public CornerMark CornerMark(string entId, string userId) { DataTable table = new DataTable(); SqlParameter[] sql = new SqlParameter[] { new SqlParameter("@type", "CornerMark"), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId) }; SqlRun sqlRun = new SqlRun(SqlRun.sqlstr); table = sqlRun.RunSqlDataTable("Proc_UserInfo", sql); CornerMark cornerMark = new CornerMark(); if (table.Rows.Count > 0) { cornerMark = CornerMarkFill(table.Rows[0]); } return(cornerMark); }
protected string UpdateDelRoleJson(string status, string strWhere) { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable ds = sql.RunProcedureDR("Proc_Admin_MembersQuery", new SqlParameter[] { new SqlParameter("@type", "PC_DelRole"), 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="entId"></param> /// <param name="userId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <GoodsArrival> GoodsArrivalQuery(string entId, string userId, int pageIndex, int pageSize, out int recordCount, out int pageCount) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Type", "GetGoodsArrival"), new SqlParameter("@entId", entId), new SqlParameter("@userId", userId), new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize), }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet("Proc_Goods_Statistical", param); DataTable dt = null; if (ds.Tables.Count >= 3) { dt = ds.Tables[1]; recordCount = int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString()); pageCount = int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString()); } else { dt = ds.Tables[0]; recordCount = dt.Rows.Count; pageCount = 1; } List <GoodsArrival> list = new List <GoodsArrival>(); if (dt.Rows.Count > 0) { list = SetGoodsArrivalInfo(dt); } return(list); } catch (Exception ex) { LogQueue.Write(LogType.Error, "StatisticalDal/GoodsArrivalQuery", ex.Message.ToString()); throw ex; } }
/// <summary> /// 查询商户充值订单 /// </summary> /// <param name="orderNo"></param> /// <returns></returns> public List <RechargeOrders> InquireRecharge(string orderNo) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "InquireRecharge"), new SqlParameter("@orderNo", orderNo) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls); List <RechargeOrders> rechargeOrders = new List <RechargeOrders>(); if (set.Tables[0].Rows.Count > 0) { rechargeOrders = FillRechargeOrders(set.Tables[0]); } else { rechargeOrders = null; } return(rechargeOrders); }
public JsonResult SaveHelpCategory(string proc, string type, string class_layer, string parent_id, string sort_id, string title, string content, string id) { try { if (id == "") { id = "0"; } SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RunProcedureDR(proc, new SqlParameter[] { new SqlParameter("type", type), new SqlParameter("class_layer", class_layer), new SqlParameter("parent_id", parent_id), new SqlParameter("sort_id", sort_id), new SqlParameter("title", title), new SqlParameter("channel_id", "11"), new SqlParameter("call_index", ""), new SqlParameter("seo_title", ""), new SqlParameter("content", content), new SqlParameter("id", id) }); if (dt.Rows.Count > 0 && (int.Parse(dt.Rows[0]["flag"].ToString())) > 0) { return(Json(new { flag = true, message = "添加成功" })); } else { return(Json(new { flag = false, message = "添加失败" })); } } catch (Exception ex) { Log.Error("错误:帮助资讯存盘", ex.Message); LogQueue.Write(LogType.Error, "Article/SaveArticle", ex.Message); return(Json(new { success = false, message = "帮助资讯存盘失败!" })); } }
/// <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="entId"></param> /// <param name="goodsId"></param> /// <returns></returns> public string IntegralGoods(string entId, string goodsId) { string json = string.Empty; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "jifenDetail"), new SqlParameter("@goodsid", goodsId), new SqlParameter("@entId", entId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet("Proc_Premiun_details", param); if (ds.Tables[0].Rows.Count > 0) { json = JsonHelper.GetDataJson(0, 0, 0, ds.Tables[0]); } else { json = JsonHelper.GetErrorJson(1, 0, "暂无数据"); } return(json); }
/// <summary> /// 获取商品分类/首页导航栏 /// </summary> /// <param name="Channel_Id"></param> /// <returns></returns> public List <Models.Category> GetCategory(string entid, int channelId) { DataTable dt = new DataTable(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,isnull(link_url,'') as link_url,isnull(img_url,'') as img_url,content,entid "); strSql.Append(" from dt_article_category where channel_id=@Channel_Id /*and entid=@EntId*/ "); strSql.Append(" order by sort_id asc,id desc "); SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Channel_Id", channelId), new SqlParameter("@EntId", entid) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); dt = sql.RunSqlDataTable(strSql.ToString(), param); List <Models.Category> CList = new List <Models.Category>(); if (dt.Rows.Count > 0) { CList = SetCategory(dt); } return(CList); }
/// <summary> /// 领取优惠券 /// </summary> /// <param name="userId"></param> /// <param name="entId"></param> /// <param name="couponCode"></param> /// <param name="flag"></param> /// <returns></returns> public string GetCoupon(string userId, string entId, int couponCode, out bool flag) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@type", "GetCoupon"), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId), new SqlParameter("@couponCode", couponCode) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable table = sql.RunProcedureDR("Proc_OperationCoupon", parameters); if (table.Rows.Count > 0) { flag = 0 == int.Parse(table.Rows[0]["flag"].ToString()) ? true : false; return(table.Rows[0]["msg"].ToString().Trim()); } else { flag = false; return("优惠券领取失败!"); } }
public string PicturesData(string userId, string entId, string sqlvalue, string type, string arguments, string imgUrl) { try { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", type), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId), new SqlParameter("@sqlvalue", sqlvalue), new SqlParameter("@arguments", arguments) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable data = sql.RunProcedureDR("Proc_QualityInspection", sqls); UplaodImg(sqlvalue, type, data, imgUrl, arguments); return(JsonHelper.GetDataJson(0, data.Rows.Count, data)); } catch (Exception ex) { LogQueue.Write(LogType.Error, "QualityInspectionReport/UplaodImg", ex.ToString()); return(JsonHelper.GetErrorJson(1, 0, ex.ToString())); } }
/// <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="ids"></param> /// <returns></returns> public bool BatchDelete(int[] ids) { if (ids.Length == 0) { return(false); } SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr); int flag = 0; for (int i = 0; i < ids.Length; i++) { SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@id", ids[i]) }; flag += sqlhelper.ExecuteNonQuery("Proc_DeleteCustomForm", sqlParams); } if (flag > 0) { return(true); } else { return(false); } }
/// <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> /// <returns></returns> public List <RechargeGoods> RechargeOptions(string entId, string userId) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "RechargeGoods"), new SqlParameter("@userId", userId), new SqlParameter("@entId", entId) }; List <RechargeGoods> rechargeGoods = new List <RechargeGoods>(); SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls); DataTable table = set.Tables[0]; if (table.Rows.Count > 0) { rechargeGoods = FillRechargeGoods(table); } else { rechargeGoods = null; } return(rechargeGoods); }
/// <summary> /// 获取用户资料 /// </summary> /// <param name="userId">用户Id</param> /// <param name="entId">机构Id</param> /// <returns></returns> public List <UserRegister> AcquireMaterial(string telphone, string entId) { SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@type", "AcquireMaterial"), new SqlParameter("@telphone", telphone), new SqlParameter("@entId", entId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); //DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls); DataSet set = sql.RunProDataSet("Proc_OperationUser", sqls); //LogQueue.Write(LogType.Debug, "表数目", set.Tables.Count.ToString()); List <UserRegister> infos = new List <UserRegister>(); if (set.Tables.Count > 0) { infos = FillList(set); } else { infos = null; } return(infos); }
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 IndexAdvert GetIndexAdvert(string entId) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "GetIndexAdvert"), new SqlParameter("@entId", entId) }; IndexAdvert lc = new IndexAdvert(); SqlRun sql = new SqlRun(SqlRun.sqlstr); var ds = sql.RunProcedureDR("Pc_Log", param); string web_url = BaseConfiguration.SercerIp; if (ds.Rows.Count > 0) { foreach (DataRow dr in ds.Rows) { lc = new IndexAdvert { linkurl = dr["linkurl"].ToString().Trim(), height = dr["height"].ToString().Trim(), width = dr["width"].ToString().Trim() }; if (dr["imgurl"].ToString().Trim() != "") { lc.imgurl = web_url + dr["imgurl"].ToString().Trim(); } else { lc.imgurl = ""; } } return(lc); } else { return(null); } }
public void ServerVariables(string entId, string userId, HttpRequest request) { //发出请求的远程主机的IP地址 var addr = request.ServerVariables["Remote_Addr"].ToString(); //发出请求的远程主机名称 var host = ""; //发出请求的远程主机端口 var port = request.ServerVariables["SERVER_PORT"].ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ServerVariables(UserID,EntID,Host,Addr,Port,RecordDate)values(@userId,@entId,@host,@addr,@port,@date)"); SqlParameter[] sqls = new SqlParameter[] { new SqlParameter("@userId", userId), new SqlParameter("@entId", entId), new SqlParameter("@host", host), new SqlParameter("@addr", addr), new SqlParameter("@port", port), new SqlParameter("@date", DateTime.Now) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); sql.RunSqlNumber(strSql.ToString(), sqls); }
/// <summary> /// 获取积分流水&&获取积分订单汇总 /// </summary> public string GetMsg(string type, string userid, string entId, int page, int size) { var msg = ""; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet("Proc_Premiun_user", new SqlParameter[] { new SqlParameter("@type", type), new SqlParameter("@userid", userid), new SqlParameter("@entId", entId), new SqlParameter("@pageIndex", page), new SqlParameter("@pageSize", size) } ); if (ds.Tables[1].Rows.Count > 0) { msg = JsonHelper.GetDataJson(0, int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString()), int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString()), ds.Tables[1]); } else { msg = JsonHelper.GetErrorJson(1, 0, "暂无数据"); } return(msg); }
public List <IndexFloor> GetIndexFloor(string userId, string entId) { ///获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = dal.GetUserInfo(userId, entId); string jgjb = "", KhType = ""; bool landing = false; bool staleDated = false; if (user.Count > 0) { entId = user[0].EntId; jgjb = user[0].Pricelevel; KhType = user[0].KhType; landing = true; staleDated = user[0].StaleDated; } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "floorImg"), new SqlParameter("@jgjb", jgjb), new SqlParameter("@khlb", KhType), new SqlParameter("@EntId", entId), new SqlParameter("@userId", userId), }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var ds = sql.RunProDataSet("Proc_GoodsList", param); List <IndexFloor> list = new List <IndexFloor>(); if (ds.Tables.Count > 0) { list = FillFloor(ds.Tables[0], ds.Tables[1], entId, landing, staleDated, jgjb, userId); } return(list); }
public List <IndexWebConfig> GetIndexConfig(string entId, string imgType) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "PC_GetWebConfig"), new SqlParameter("@entId", entId), new SqlParameter("@imgType", imgType) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var ds = sql.RunProcedureDR("Pc_Log", param); List <IndexWebConfig> list = new List <IndexWebConfig>(); string web_url = BaseConfiguration.SercerIp; if (ds.Rows.Count > 0) { foreach (DataRow dr in ds.Rows) { IndexWebConfig lc = new IndexWebConfig { ImgType = dr["ImgType"].ToString().Trim(), TypeName = dr["TypeName"].ToString().Trim(), WebValue = dr["WebValue"].ToString().Trim(), ImgOrText = int.Parse(dr["ImgOrText"].ToString()) }; if (dr["imgurl"].ToString().Trim() != "") { lc.imgurl = web_url + dr["imgurl"].ToString().Trim(); } else { lc.imgurl = ""; } list.Add(lc); } } return(list); }
/// <summary> /// 搜索页获取商品列表 /// </summary> /// <param name="ywyId">业务员Id</param> /// <param name="userId">客户Id</param> /// <param name="searchValue">搜索条件</param> /// <param name="letter">厂家首字母</param> /// <param name="tags">排序类型</param> /// <param name="isKc">是否有货</param> /// <param name="CategoryId">商品分类Id</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">没页行数</param> /// <returns></returns> public ValetOrderModel <GoodsInfo> GetGoodsList(string ywyId, string userId, string searchValue, string letter, string tags, string isKc, string CategoryId, int pageIndex, int pageSize, string entid) { ValetOrderModel <GoodsInfo> mode = new ValetOrderModel <GoodsInfo>(); mode.PageIndex = pageIndex; mode.PageSize = pageSize; ////加载用户信息 string jgjb = "", clientlimit = "", KhType = ""; try { //获取用户信息 UserInfoDal dal = new UserInfoDal(); List <UserInfo> user = new List <UserInfo>(); user = dal.GetUserInfo(userId, entid); if (user.Count <= 0) { mode.Success = "002"; mode.Message = "客户信息获取失败"; return(mode); } entid = user[0].EntId; jgjb = user[0].Pricelevel; clientlimit = user[0].ClientLimit; KhType = user[0].KhType; } catch (Exception ex) { LogQueue.Write(LogType.Error, "ValetOrder/GetGoodsList", ex.Message.ToString()); mode.Success = "002"; mode.Message = "客户信息获取失败," + ex.Message.ToString(); return(mode); } try { ///加载查询条件 StringBuilder StrWhere = new StringBuilder(); if (searchValue.IndexOf(" ") >= 0) { string goodsValue, factoryValue; string[] searchString = searchValue.Split(' '); goodsValue = searchString[0]; factoryValue = searchString[1]; StrWhere.Append(" and b.mnemonic_code like '%" + goodsValue + "%' and b.Origin_mnemonic_code like '%" + factoryValue + "%' "); } else { StrWhere.Append(" and(b.goodscode like '%" + searchValue + "%' or b.sub_title like '%" + searchValue + "%' or b.mnemonic_code like '%" + searchValue + "%'"); StrWhere.Append(" or b.drug_factory like '%" + searchValue + "%' or b.Origin_mnemonic_code like '%" + searchValue + "%') "); } //是否有货筛选 if (isKc == "Y") { StrWhere.Append(" and c.stock_quantity>0 "); } //商品价格大于0筛选 StrWhere.Append(" and d.price>0.0"); ///厂家首字母筛选 if (letter != "") { StrWhere.Append(" and left(b.Origin_mnemonic_code,1)='" + letter + "'"); } StringBuilder order = new StringBuilder(); order.Append(" "); //商品排序 switch (tags) { case "click_u": //点击量升序 order.Append(" order by a.click asc,b.goodscode asc"); break; case "click_d": //点击量降序 order.Append(" order by a.click desc,b.goodscode desc"); break; case "sales_u": //销量升序 order.Append(" order by a.sales asc,b.goodscode asc"); break; case "sales_d": //销量降序 order.Append(" order by a.sales desc,b.goodscode desc"); break; case "price_u": //价格升序 order.Append(" order by d.price asc,b.goodscode asc"); break; case "price_d": //价格降序 order.Append(" order by d.price desc,b.goodscode desc"); break; case "cxbs": //促销排序 order.Append(" order by fabh desc,b.goodscode asc"); break; case "cjpx": //厂家排序 order.Append(" order by drug_factory asc"); break; case "sppx": //商品排序 order.Append(" order by sub_title asc"); break; default: order.Append(" order by b.goodscode asc"); break; } //////统计客户搜索类容 if (searchValue != "") { bool flag = StatisticalDal.GoodsStatistical("GoodsSearch", searchValue, entid); } ///获取商品列表 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Type", "GetList"), new SqlParameter("@UserId", userId), new SqlParameter("@Entid", entid), new SqlParameter("@PageSize", pageSize), new SqlParameter("@PageIndex", pageIndex), new SqlParameter("@StrWhere", StrWhere.ToString()), new SqlParameter("@Order", order.ToString()), new SqlParameter("@CategoryId", CategoryId), new SqlParameter("@Login_Id", ywyId), new SqlParameter("@Jgjb", jgjb), new SqlParameter("@khlb", KhType) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet ds = sql.RunProDataSet("Proc_GoodsList", param); mode.Success = "001"; if (ds.Tables.Count > 0) { DataTable dt = new DataTable(); if (ds.Tables.Count >= 3) { dt = ds.Tables[1]; } else { dt = ds.Tables[0]; } if (dt.Rows.Count > 0) { mode.Data = SetGoodsList(dt); mode.Success = "000"; mode.Message = "商品加载成功"; } } return(mode); } catch (Exception ex) { mode.Success = "002"; mode.Message = "商品信息加载失败," + ex.Message.ToString(); return(mode); } }
public string TabularData(string json, string userId, string entId) { string JSON = "{\"status\":"; string message = "", status = "0"; DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataTable dt_fd = new DataTable(); SqlRun sqlRun = new SqlRun(SqlRun.sqlstr); try { ds = AcquireData(json, userId, entId); int ReCount = 0, pgCount = 0; message = "{\"fdname\":{"; if (ds.Tables.Count > 2) { dt = ds.Tables[1]; dt_fd = sqlRun.GetChinaName(dt); ReCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim()); pgCount = Convert.ToInt32(ds.Tables[2].Rows[0]["PageCount"].ToString().Trim()); } else { dt = ds.Tables[0]; dt_fd = sqlRun.GetChinaName(dt); ReCount = dt.Rows.Count; } if (dt_fd != null) { foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Contains("ROWSTAT")) { continue; } DataRow[] dr = dt_fd.Select("fdname = '" + dc.ColumnName + "'"); string chnname = dr.Length == 1 ? dr[0]["chnname"].ToString() : dc.ColumnName; message += "\"" + dc.ColumnName.Trim() + "\":\"" + chnname + "\","; } message = message.Substring(0, message.Length - 1); message += "},"; } else { throw new Exception("未获取字段"); } message += "\"ReCount\":" + ReCount + ",\"pgCount\":" + pgCount + ",\"Content\":"; if (dt.Rows.Count > 0) { message += "["; foreach (DataRow dr in dt.Rows) { message += "{"; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName.Contains("ROWSTAT")) { continue; } message += "\"" + dc.ColumnName.Trim() + "\":\"" + dr[dc.ColumnName].ToString().Trim() + "\","; } message = message.Substring(0, message.Length - 1); message += "},"; } message = message.Substring(0, message.Length - 1); message += "]"; } else { message += "\"无记录\""; } message += "}"; } catch (Exception e) { status = "2"; message = "\"" + e.Message.Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", "") + "\""; } JSON += "\"" + status + "\""; JSON += ",\"message\":" + message + "}"; return(JSON); }
public List <ImgInfo> GoodsParatope(List <ImgInfo> imgList, string entId, string webUrl, bool landing, bool staleDated, int len, string jgjb, string title, string userId) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "GoodsParatope"), new SqlParameter("@Jgjb", jgjb), new SqlParameter("@EntId", entId), new SqlParameter("@userId", userId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var dt = sql.RunProcedureDR("Proc_GoodsList", param); List <ImgInfo> source = new List <ImgInfo>(); List <ImgInfo> back = new List <ImgInfo>(); //LogQueue.Write(LogType.Debug, "商品count", $"{dt.Rows.Count}"); if (dt.Rows.Count > 0) { //补位数据 foreach (DataRow item in dt.Rows) { ImgInfo img = new ImgInfo { Entid = item["entid"].ToString().Trim(), Title = title, ArticleId = item["Article_Id"].ToString().Trim(), SortId = int.Parse(item["sort_Id"].ToString().Trim()), IsBrand = "N", BrandCode = "", LinkUrl = item["link_url"].ToString().Trim() }; if (item["img_url"].ToString().Trim() != "") { img.ImgUrl = webUrl + item["img_url"].ToString().Trim(); } else { img.ImgUrl = ""; } if (item["left_pic"].ToString().Trim() != "") { img.LeftPic = webUrl + item["left_pic"].ToString().Trim(); } if (item["brand_img_url"].ToString().Trim() != "") { img.BrandImgUrl = webUrl + item["brand_img_url"].ToString().Trim(); } else { img.BrandImgUrl = ""; } img.SubTitle = item["sub_title"].ToString().Trim(); img.DrugSpec = item["drug_spec"].ToString().Trim(); img.DrugFactory = item["drug_factory"].ToString().Trim(); if (landing && !staleDated) { img.Price = BasisConfig.ObjToDecimal(item["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString(); } else { img.Price = "会员可见"; } img.Cxbs = item["cxbs"].ToString().Trim(); img.Fabh = item["fabh"].ToString().Trim(); source.Add(img); } //加入现有商品 imgList.ForEach(t => back.Add(t)); //已存在的品牌 var exist = imgList.Select(t => t.ArticleId).Distinct().ToList(); //移除已存在的品牌 source.RemoveAll(t => exist.Contains(t.ArticleId)); if (source.Count > 0) { int length = source.Count > len ? len : source.Count; Random random = new Random(); int index = source.Count > len?random.Next(source.Count - len + 1) : 0; source = source.GetRange(index, length); source.ForEach(p => { back.Add(p); }); } } return(back); }
/// <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 string ActivityTheme(string promotionCode, string templateCode, string lx = "PC") { AppMsg <Object> jsonResult = new AppMsg <Object>(); string html = ""; try { SqlRun sql = new SqlRun(SqlRun.sqlstr); DataSet dt = sql.RunProDataSet("Pc_TemplateRelation", new SqlParameter[] { new SqlParameter("@type", "CX_GetTemplateRelation"), new SqlParameter("@PromotionCode", promotionCode), new SqlParameter("@TemplateCode", templateCode) }); if (dt.Tables.Count == 2 && dt.Tables[0].Rows.Count > 0 && dt.Tables[1].Rows.Count > 0) { html = dt.Tables[0].Rows[0]["TemplateText"].ToString(); DataRowCollection datalist = dt.Tables[1].Rows; string boxTop = GetRegValue(html, "<!--截取TopStatr-->", "<!--截取TopEnd-->"); string tboxTop = boxTop; if (boxTop != "") { string Topleft = GetRegValue(boxTop, "<!--leftTopStatr-->", "<!--leftTopEnd-->"); string tleft = Topleft; if (datalist.Count == 1) { tleft = tleft.Replace("@left@article_id", datalist[0]["article_id"].ToString()); tleft = tleft.Replace("@left@pdoduct", datalist[0]["sub_title"].ToString()); tleft = tleft.Replace("@left@old", datalist[0]["price"].ToString()); tleft = tleft.Replace("@left@new", datalist[0]["price"].ToString()); tleft = tleft.Replace("@left@image", datalist[0]["img_url"].ToString()); tleft = tleft.Replace("@left@gg", datalist[0]["drug_spec"].ToString()); tboxTop.Replace(Topleft, tleft); html.Replace(boxTop, tboxTop); datalist.Remove(datalist[0]); } else if (datalist.Count >= 2) { var leftobj = datalist[0]; var rightobj = datalist[1]; tleft = tleft.Replace("@left@article_id", leftobj["article_id"].ToString()); tleft = tleft.Replace("@left@pdoduct", leftobj["sub_title"].ToString()); tleft = tleft.Replace("@left@old", leftobj["price"].ToString()); tleft = tleft.Replace("@left@new", leftobj["price"].ToString()); tleft = tleft.Replace("@left@image", leftobj["img_url"].ToString()); tleft = tleft.Replace("@left@gg", leftobj["drug_spec"].ToString()); //分割线 第二块 tboxTop = tboxTop.Replace("@right@article_id", rightobj["article_id"].ToString()); tboxTop = tboxTop.Replace("@right@pdoduct", rightobj["sub_title"].ToString()); tboxTop = tboxTop.Replace("@right@old", rightobj["price"].ToString()); tboxTop = tboxTop.Replace("@right@new", rightobj["price"].ToString()); tboxTop = tboxTop.Replace("@right@image", rightobj["img_url"].ToString()); tboxTop = tboxTop.Replace("@right@gg", rightobj["drug_spec"].ToString()); tboxTop = tboxTop.Replace(Topleft, tleft); html = html.Replace(boxTop, tboxTop); datalist.Remove(leftobj); datalist.Remove(rightobj); } } string boxAll = GetRegValue(html, "<!--截取Statr-->", "<!--截取end-->"); string leftAll = GetRegValue(boxAll, "<!--leftStatr-->", "<!--leftEnd-->"); string left = leftAll; string box = boxAll; string texthtml = ""; if (datalist.Count == 1) { //left = left.Replace("@left@huodong", datalist[0]["fabh"].ToString()); left = left.Replace("@left@article_id", datalist[0]["article_id"].ToString()); left = left.Replace("@left@pdoduct", datalist[0]["sub_title"].ToString()); left = left.Replace("@left@old", datalist[0]["price"].ToString()); left = left.Replace("@left@new", datalist[0]["price"].ToString()); left = left.Replace("@left@image", datalist[0]["img_url"].ToString()); left = left.Replace("@left@gg", datalist[0]["drug_spec"].ToString()); texthtml += left; left = leftAll; } else if (datalist.Count % 2 != 0) { for (var i = 0; i < datalist.Count; i++) { //box = box.Replace("@left@huodong", datalist[i]["fabh"].ToString()); box = box.Replace("@left@article_id", datalist[i]["article_id"].ToString()); box = box.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString()); box = box.Replace("@left@old", datalist[i]["price"].ToString()); box = box.Replace("@left@new", datalist[i]["price"].ToString()); box = box.Replace("@left@image", datalist[i]["img_url"].ToString()); box = box.Replace("@left@gg", datalist[i]["drug_spec"].ToString()); i++; //box = box.Replace("@right@huodong", datalist[i]["fabh"].ToString()); box = box.Replace("@right@article_id", datalist[i]["article_id"].ToString()); box = box.Replace("@right@pdoduct", datalist[i]["sub_title"].ToString()); box = box.Replace("@right@old", datalist[i]["price"].ToString()); box = box.Replace("@right@new", datalist[i]["price"].ToString()); box = box.Replace("@right@image", datalist[i]["img_url"].ToString()); box = box.Replace("@right@gg", datalist[i]["drug_spec"].ToString()); texthtml += box; box = boxAll; if ((i + 1) == (datalist.Count - 1)) { i++; //left = left.Replace("@left@huodong", datalist[i]["fabh"].ToString()); left = left.Replace("@left@article_id", datalist[i]["article_id"].ToString()); left = left.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString()); left = left.Replace("@left@old", datalist[i]["price"].ToString()); left = left.Replace("@left@new", datalist[i]["price"].ToString()); left = left.Replace("@left@image", datalist[i]["img_url"].ToString()); left = left.Replace("@left@gg", datalist[i]["drug_spec"].ToString()); texthtml += left; left = leftAll; } } } else { for (var i = 0; i < datalist.Count; i++) { //box = box.Replace("@left@huodong", datalist[i]["fabh"].ToString()); box = box.Replace("@left@article_id", datalist[i]["article_id"].ToString()); box = box.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString()); box = box.Replace("@left@old", datalist[i]["price"].ToString()); box = box.Replace("@left@new", datalist[i]["price"].ToString()); box = box.Replace("@left@image", datalist[i]["img_url"].ToString()); box = box.Replace("@left@gg", datalist[i]["drug_spec"].ToString()); i++; //box = box.Replace("@right@huodong", datalist[i]["fabh"].ToString()); box = box.Replace("@right@article_id", datalist[i]["article_id"].ToString()); box = box.Replace("@right@pdoduct", datalist[i]["sub_title"].ToString()); box = box.Replace("@right@old", datalist[i]["price"].ToString()); box = box.Replace("@right@new", datalist[i]["price"].ToString()); box = box.Replace("@right@image", datalist[i]["img_url"].ToString()); box = box.Replace("@right@gg", datalist[i]["drug_spec"].ToString()); texthtml += box; box = boxAll; } } html = "<body>" + html.Replace(boxAll, texthtml) + "</body>"; } else { throw new Exception("没有主题页"); } } catch (Exception ex) { html = ex.Message; } return(html); }
public List <ImgInfo> BrandParatope(List <ImgInfo> imgList, string entId, string webUrl, bool landing, bool staleDated, int len, string userId) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@type", "BrandParatope"), new SqlParameter("@EntId", entId), new SqlParameter("@userId", userId) }; SqlRun sql = new SqlRun(SqlRun.sqlstr); var dt = sql.RunProcedureDR("Proc_GoodsList", param); List <ImgInfo> source = new List <ImgInfo>(); List <ImgInfo> back = new List <ImgInfo>(); if (dt.Rows.Count > 0) { //补位数据 foreach (DataRow item in dt.Rows) { ImgInfo img = new ImgInfo { Entid = item["entid"].ToString().Trim(), Title = item["FloorTitle"].ToString().Trim(), ArticleId = item["Article_Id"].ToString().Trim(), SortId = int.Parse(item["sort_Id"].ToString().Trim()), IsBrand = item["Is_Brand"].ToString().Trim(), BrandCode = item["BrandCode"].ToString().Trim(), LinkUrl = item["link_url"].ToString().Trim() }; if (item["img_url"].ToString().Trim() != "") { img.ImgUrl = webUrl + item["img_url"].ToString().Trim(); } else { img.ImgUrl = ""; } if (item["left_pic"].ToString().Trim() != "") { img.LeftPic = webUrl + item["left_pic"].ToString().Trim(); } if (item["brand_img_url"].ToString().Trim() != "") { img.BrandImgUrl = webUrl + item["brand_img_url"].ToString().Trim(); } else { img.BrandImgUrl = ""; } img.SubTitle = item["sub_title"].ToString().Trim(); img.DrugSpec = item["drug_spec"].ToString().Trim(); img.DrugFactory = item["drug_factory"].ToString().Trim(); if (landing && !staleDated) { img.Price = BasisConfig.ObjToDecimal(item["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString(); } else { img.Price = "会员可见"; } img.Cxbs = item["cxbs"].ToString().Trim(); img.Fabh = item["fabh"].ToString().Trim(); source.Add(img); } imgList.ForEach(t => back.Add(t)); //已存在的品牌 var exist = imgList.Select(t => t.ArticleId).Distinct().ToList(); //移除已存在的品牌 source.RemoveAll(t => exist.Contains(t.ArticleId)); if (source.Count > 0) { int length = source.Count > len ? len : source.Count; Random random = new Random(); int index = source.Count > len?random.Next(source.Count - len + 1) : 0; source = source.GetRange(index, length); source.ForEach(p => { back.Add(p); }); } if (source.Count < len) { var placehold = XmlOperation.ReadXml("Base", "RecommendPicture"); for (int i = 0; i < len - source.Count; i++) { ImgInfo imgInfo = new ImgInfo { Entid = entId, Title = "品牌推荐", ArticleId = "", SortId = 99, IsBrand = "Y", BrandCode = "", LinkUrl = "", ImgUrl = placehold, LeftPic = "", BrandImgUrl = placehold, DrugFactory = "", DrugSpec = "", SubTitle = "", Price = "", Cxbs = "", Fabh = "" }; back.Add(imgInfo); } } } return(back); }
/// <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); }