/// <summary> /// 删除商品收藏 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DltGoodsCollection(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_article_collection where id=" + id); SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); return(flag); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="entId"></param> /// <param name="userId"></param> /// <param name="telPhone"></param> /// <param name="imgUrl"></param> /// <returns></returns> public static bool UpdateUserInfo(string entId, string userId, string telPhone, string imgUrl, string email = "", string qq = "", string sex = "", string birthday = "") { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_users set telphone='" + telPhone + "',img_url='" + imgUrl + "',sex='" + sex + "',email='" + email + "',birthday='" + birthday + "' where userid='" + userId + "' and entid='" + entId + "'"); SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); return(flag); }
/// <summary> /// 删除商品到货提醒 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DltGoodsArrival(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Zzsk_ArrivalReminder where Id=" + id); SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); return(flag); }
/// <summary> /// 修改到货提醒阅读状态 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool ReadGoodsArrival(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update Zzsk_ArrivalReminder Set ReadStatus=1 where Id=" + id); SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); return(flag); }
public JsonResult UpdateProduct(string category_id, string sub_title, string img_url, string left_pic, string content, string brand_img_url, string sort_id, string article_id, string generic, string drug_factory, string approval_number, string drug_spec, string big_package, string package_unit, string min_package, string mnemonic_code, string Storage_conditions, string BrandCode, string rate, string min_package_astrict, string price, string category, string dosage_form, string recommendList, string isZbz, string isDbz, string zhaiyao) { Dt_User user = RoleFuns.IsLoginAdmin(HttpContext.Session["user"]); if (user != null)//登录检测,权限检测 context.Session["user"] { try { StringBuilder strSql = new StringBuilder(); //修改商品主表 strSql.Append("update dt_article set category_id='" + category_id + "',title='" + sub_title + "',img_url='" + img_url + "',"); strSql.Append("left_pic='" + left_pic + "',content='" + content + "',brand_img_url='" + brand_img_url + "',sort_id='" + sort_id + "' "); strSql.Append(" ,zhaiyao='" + zhaiyao + "' where id='" + article_id + "' and entid='" + user.entId + "' ;"); //修改属性表 strSql.Append("update dt_article_attribute set sub_title='" + sub_title.ToString().Trim() + "',generic='" + generic + "',drug_factory='" + drug_factory + "',"); strSql.Append("approval_number='" + approval_number + "',drug_spec='" + drug_spec + "',big_package='" + big_package + "',min_package='" + min_package + "',"); strSql.Append("package_unit='" + package_unit + "',Storage_conditions='" + Storage_conditions + "',category='" + category + "',mnemonic_code='" + mnemonic_code + "',"); strSql.Append("dosage_form='" + dosage_form + "',rate='" + rate + "',brandId='" + BrandCode + "',price='" + price + "',min_package_astrict='" + min_package_astrict + "'"); strSql.Append(",scattered='" + isZbz + "',packControl='" + isDbz + "' where article_id='" + article_id + "' and entid='" + user.entId + "'"); //status = " + obj["status"].ToString().Trim() + " SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); if (flag) { SqlParameter[] prmt = new SqlParameter[] { new SqlParameter("@type", "GoodsRecommend"), new SqlParameter("@recommendList", recommendList), new SqlParameter("@article_id", article_id), new SqlParameter("@BrandCode", BrandCode), new SqlParameter("@entId", user.entId), }; int n = sql.ExecuteNonQuery("Proc_Admin_GoodsList", prmt); return(Json(JsonMethod.GetError(0, "操作成功"))); } else { return(Json(JsonMethod.GetError(1, "操作失败"))); } } catch (Exception ex) { Log.Error("错误:商品编辑失败", ex.Message); LogQueue.Write(LogType.Error, "Goods/UpdateProduct", ex.Message); return(Json(JsonMethod.GetError(1, "操作失败"))); } } else { return(Json(JsonMethod.GetError(2, "登录超时"))); } }
/// <summary> /// 网站设置修改 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="UserId"></param> /// <param name="entId"></param> /// <returns></returns> protected string SaveBase(string json, string proc, string UserId, string entId) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); ///修改webconfig节点 BasisConfig.UpdateAppSetting("SercerIp", obj["ip"].ToString()); StringBuilder strSql = new StringBuilder(); //修改商品主表 strSql.Append("select entid from dt_system_base(nolock) where entid='" + entId + "'"); SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RtDataTable(strSql.ToString()); //清空StringBuilder strSql.Length = 0; if (dt.Rows.Count > 0) { strSql.Append("update dt_system_base set web_name=@web_name,web_ip=@web_ip,company=@company,complaints=@complaints,xxjyz=@xxjyz,xxfwz=@xxfwz,icp=@icp,beizhu=@beizhu,img_app=@img_app,img_logo=@img_logo,img_left=@img_left,img_right=@img_right,img_service=@img_service,link_service=@link_service where entid=@entid"); } else { strSql.Append("insert into dt_system_base(entId,web_name,web_ip,company,complaints,xxjyz,xxfwz,icp,beizhu,img_app,img_logo,img_left,img_right,img_service,link_service) "); strSql.Append(" values(@entId,@web_name,@web_ip,@company,@complaints,@xxjyz,@xxfwz,@icp,@beizhu,@img_app,@img_logo,@img_left,@img_right,@img_service,@link_service);"); } SqlParameter[] prmt = new SqlParameter[] { new SqlParameter("@entid", entId), new SqlParameter("@web_name", obj["title"].ToString()), new SqlParameter("@web_ip", obj["ip"].ToString()), new SqlParameter("@company", obj["company"].ToString()), new SqlParameter("@complaints", obj["complaints"].ToString()), new SqlParameter("@xxjyz", obj["xxjyz"].ToString()), new SqlParameter("@xxfwz", obj["xxfwz"].ToString()), new SqlParameter("@icp", obj["ICP"].ToString()), new SqlParameter("@beizhu", obj["beizhu"].ToString()), new SqlParameter("@img_app", obj["app_url"].ToString()), new SqlParameter("@img_logo", obj["logo_url"].ToString()), new SqlParameter("@img_left", obj["left_url"].ToString()), new SqlParameter("@img_right", obj["right_url"].ToString()), new SqlParameter("@img_service", obj["kf_url"].ToString()), new SqlParameter("@link_service", obj["kf_link"].ToString()) }; int n = sql.ExecuteSql(strSql.ToString(), prmt); if (n > 0) { return(JsonMethod.GetError(0, "提交成功")); } else { return(JsonMethod.GetError(1, "提交失败")); } }
/// <summary> /// 修改自定义表单 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateCustomForm(Models.CustomForm model) { SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr); string sql = "update dt_custom_form set [Name]=@name,[Fields]=@fields,[SQL]=@sql,ModuleID=@moduleid where [ID]=@id"; SqlParameter[] sqlparams = new SqlParameter[] { new SqlParameter("@name", model.Name), new SqlParameter("@fields", model.Fields), new SqlParameter("@sql", model.SQL), new SqlParameter("@moduleid", model.ModuleID), new SqlParameter("@id", model.ID) }; int result = sqlhelper.ExecuteSql(sql, sqlparams); return(result); }
/// <summary> /// 修改已经过期的资质 /// </summary> /// <param name="entId"></param> /// <param name="userId"></param> /// <param name="imgurl"></param> /// <param name="materialId"></param> /// <returns></returns> public static bool UpdateUsersMaterial(string entId, string userId, string imgurl, string materialId, string materialname, string customertypeid) { StringBuilder strSql = new StringBuilder(); if (int.Parse(materialId) != 0) { strSql.Append("update dt_users_material Set materialUrl='" + imgurl + "' where id=" + materialId + ""); } else { //strSql.Append("INSERT INTO [dbo].[dt_users_material] VALUES('"+userId+"','" + entId + "',"+ customertypeid + ",'"+ materialname + "','"+ imgurl + "','','"+DateTime.Now+"')"); strSql.Append("insert into [dbo].[dt_users_material](userId,entId,CustomerTypeId,materialName,materialUrl,remark,lastmodifytime) select top 1 userid,entid," + customertypeid + ",'" + materialname + "','" + imgurl + "','','" + DateTime.Now.ToString() + "' from dt_register where dtuserid='" + userId + "' and entid='" + entId + "'"); } SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); return(flag); }
protected string UpdateGoodsInfo(string json, string proc, string userId, string entId) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); StringBuilder strSql = new StringBuilder(); //修改商品主表 strSql.Append("update dt_article set category_id='" + obj["category_id"].ToString().Trim() + "',"); strSql.Append("title='" + obj["sub_title"].ToString().Trim() + "',img_url='" + obj["img_url"].ToString().Trim() + "',"); strSql.Append("left_pic='" + obj["left_pic"].ToString().Trim() + "',content='" + obj["content"].ToString().Trim() + "',"); strSql.Append("brand_img_url='" + obj["brand_img_url"].ToString().Trim() + "',sort_id='" + obj["sort_id"].ToString().Trim() + "' "); strSql.Append(" where id='" + obj["article_id"].ToString().Trim() + "' and entid='" + entId + "' ;"); //修改属性表 strSql.Append("update dt_article_attribute set sub_title='" + obj["sub_title"].ToString().Trim() + "',"); strSql.Append("generic='" + obj["generic"].ToString().Trim() + "',drug_factory='" + obj["drug_factory"].ToString().Trim() + "',"); strSql.Append("approval_number='" + obj["approval_number"].ToString().Trim() + "',drug_spec='" + obj["drug_spec"].ToString().Trim() + "',"); strSql.Append("big_package='" + obj["big_package"].ToString().Trim() + "',min_package='" + obj["min_package"].ToString().Trim() + "',"); strSql.Append("package_unit='" + obj["package_unit"].ToString().Trim() + "',Storage_conditions='" + obj["Storage_conditions"].ToString().Trim() + "',"); strSql.Append("category='" + obj["category"].ToString().Trim() + "',mnemonic_code='" + obj["mnemonic_code"].ToString().Trim() + "',"); strSql.Append("dosage_form='" + obj["dosage_form"].ToString().Trim() + "',rate='" + obj["rate"].ToString().Trim() + "',brandId='" + obj["BrandCode"].ToString().Trim() + "',"); strSql.Append("price='" + obj["price"].ToString().Trim() + "',min_package_astrict='" + obj["min_package_astrict"].ToString().Trim() + "'"); strSql.Append(" where article_id='" + obj["article_id"] + "' and entid='" + entId + "'"); //status = " + obj["status"].ToString().Trim() + " SqlRun sql = new SqlRun(SqlRun.sqlstr); bool flag = sql.ExecuteSql(strSql.ToString()); if (flag) { SqlParameter[] prmt = new SqlParameter[] { new SqlParameter("@type", "GoodsRecommend"), new SqlParameter("@recommendList", obj["recommendList"].ToString()), new SqlParameter("@article_id", obj["article_id"].ToString()), new SqlParameter("@BrandCode", obj["BrandCode"].ToString()), new SqlParameter("@entId", entId), }; int n = sql.ExecuteNonQuery("Proc_Admin_GoodsList", prmt); return(JsonMethod.GetError(0, "操作成功")); } else { return(JsonMethod.GetError(1, "操作失败")); } }
/// <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> /// <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="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, "操作失败")); } }
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, "存盘失败")); } }