/// <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, "存盘失败"));
}
}