/// <summary> /// Delete一条数据 /// </summary> public static bool Delete(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CartTemp "); strSql.Append(" where id = " + id); int rows = DBHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 批量Delete数据 /// </summary> public bool DeleteList(string idlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from GuangGao "); strSql.Append(" where id in (" + idlist + ") "); int rows = DBHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// Delete用户条数据 /// </summary> public static bool DeleteByUserId(int userId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CartTemp "); strSql.Append(" where addUser = "******" and sel = 1"); int rows = DBHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ProductPK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ProductPK set "); strSql.Append("productId=@productId,"); strSql.Append("quantiyCount=@quantiyCount,"); strSql.Append("brandCount=@brandCount,"); strSql.Append("priceCount=@priceCount,"); strSql.Append("configCount=@configCount,"); strSql.Append("appearanceCount=@appearanceCount,"); strSql.Append("otherCount=@otherCount"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@quantiyCount", SqlDbType.Int, 4), new SqlParameter("@brandCount", SqlDbType.Int, 4), new SqlParameter("@priceCount", SqlDbType.Int, 4), new SqlParameter("@configCount", SqlDbType.Int, 4), new SqlParameter("@appearanceCount", SqlDbType.Int, 4), new SqlParameter("@otherCount", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.productId; parameters[1].Value = model.quantiyCount; parameters[2].Value = model.brandCount; parameters[3].Value = model.priceCount; parameters[4].Value = model.configCount; parameters[5].Value = model.appearanceCount; parameters[6].Value = model.otherCount; parameters[7].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ProductProperty model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ProductProperty set "); strSql.Append("productId=@productId,"); strSql.Append("properType=@properType,"); strSql.Append("properTypeName=@properTypeName,"); strSql.Append("properValue=@properValue,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@properType", SqlDbType.Int, 4), new SqlParameter("@properTypeName", SqlDbType.VarChar, 150), new SqlParameter("@properValue", SqlDbType.VarChar, 250), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.productId; parameters[1].Value = model.properType; parameters[2].Value = model.properTypeName; parameters[3].Value = model.properValue; parameters[4].Value = model.status; parameters[5].Value = model.remark; parameters[6].Value = model.infoType; parameters[7].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.ProductImg model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ProductImg set "); strSql.Append("productId=@productId,"); strSql.Append("imgURL=@imgURL,"); strSql.Append("title=@title,"); strSql.Append("alt=@alt,"); strSql.Append("linkurl=@linkurl,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@imgURL", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 150), new SqlParameter("@alt", SqlDbType.VarChar, 150), new SqlParameter("@linkurl", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.productId; parameters[1].Value = model.imgURL; parameters[2].Value = model.title; parameters[3].Value = model.alt; parameters[4].Value = model.linkurl; parameters[5].Value = model.status; parameters[6].Value = model.remark; parameters[7].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Materia model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Materia set "); strSql.Append("materiaName=@materiaName,"); strSql.Append("materiaValue=@materiaValue,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark,"); strSql.Append("addTime=@addTime,"); strSql.Append("addUser=@addUser,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@materiaName", SqlDbType.VarChar, 150), new SqlParameter("@materiaValue", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.materiaName; parameters[1].Value = model.materiaValue; parameters[2].Value = model.status; parameters[3].Value = model.remark; parameters[4].Value = model.addTime; parameters[5].Value = model.addUser; parameters[6].Value = model.infoType; parameters[7].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.BindInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BindInfo set "); strSql.Append("dataType=@dataType,"); strSql.Append("dataPara=@dataPara,"); strSql.Append("userId=@userId,"); strSql.Append("dataValue=@dataValue,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@dataType", SqlDbType.Int, 4), new SqlParameter("@dataPara", SqlDbType.VarChar, 50), new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@dataValue", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 50), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.dataType; parameters[1].Value = model.dataPara; parameters[2].Value = model.userId; parameters[3].Value = model.dataValue; parameters[4].Value = model.status; parameters[5].Value = model.remark; parameters[6].Value = model.infoType; parameters[7].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.ShoperInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ShoperInfo("); strSql.Append("shoperName,imgUrl,tel,mobile,price,pid,cid,regionId,address,remark,status,addTime,addUser,infoType)"); strSql.Append(" values ("); strSql.Append("@shoperName,@imgUrl,@tel,@mobile,@price,@pid,@cid,@regionId,@address,@remark,@status,@addTime,@addUser,@infoType)"); SqlParameter[] parameters = { new SqlParameter("@shoperName", SqlDbType.VarChar, 50), new SqlParameter("@imgUrl", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@mobile", SqlDbType.VarChar, 50), new SqlParameter("@price", SqlDbType.Money, 8), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.shoperName; parameters[1].Value = model.imgUrl; parameters[2].Value = model.tel; parameters[3].Value = model.mobile; parameters[4].Value = model.price; parameters[5].Value = model.pid; parameters[6].Value = model.cid; parameters[7].Value = model.regionId; parameters[8].Value = model.address; parameters[9].Value = model.remark; parameters[10].Value = model.status; parameters[11].Value = model.addTime; parameters[12].Value = model.addUser; parameters[13].Value = model.infoType; return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public static int Update(Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update News set "); strSql.Append("title=@title,"); strSql.Append("newsType=@newsType,"); strSql.Append("newImg=@newImg,"); strSql.Append("newsContent=@newsContent,"); strSql.Append("keyword=@keyword,"); strSql.Append("newsDesc=@newsDesc,"); strSql.Append("pageName=@pageName,"); strSql.Append("sid=@sid,author=@author"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@newsType", SqlDbType.Int, 4), new SqlParameter("@newImg", SqlDbType.VarChar, 500), new SqlParameter("@newsContent", SqlDbType.NText), new SqlParameter("@keyword", SqlDbType.VarChar, 250), new SqlParameter("@newsDesc", SqlDbType.NText), new SqlParameter("@pageName", SqlDbType.NText), new SqlParameter("@sid", SqlDbType.VarChar, 250),new SqlParameter("@author",SqlDbType.VarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.title; parameters[2].Value = model.newsType; parameters[3].Value = model.newImg; parameters[4].Value = model.newsContent; parameters[5].Value = model.keyword; parameters[6].Value = model.newsDesc; parameters[7].Value = model.pageName; parameters[8].Value = model.sid; parameters[9].Value = model.author; return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public static int UpdateModel(NewsType item) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NewsType set "); strSql.Append("name=@name,remark=@remark,typedesc=@typedesc,pagename=@pagename,parentId=" + item.parentId + ",status = " + item.status); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 50),new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@typedesc", SqlDbType.NText), new SqlParameter("@pagename", SqlDbType.VarChar, 1000) }; parameters[0].Value = item.id; parameters[1].Value = item.name; parameters[2].Value = item.remark; parameters[3].Value = item.typedesc; parameters[4].Value = item.pagename; return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.AreaInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AreaInfo set "); strSql.Append("areaName=@areaName,"); strSql.Append("parentId=@parentId,"); strSql.Append("charIndex=@charIndex,"); strSql.Append("remark=@remark,"); strSql.Append("status=@status,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@areaName", SqlDbType.VarChar, 50), new SqlParameter("@parentId", SqlDbType.Int, 4), new SqlParameter("@charIndex", SqlDbType.VarChar, 20), new SqlParameter("@remark", SqlDbType.VarChar, 50), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.areaName; parameters[1].Value = model.parentId; parameters[2].Value = model.charIndex; parameters[3].Value = model.remark; parameters[4].Value = model.status; parameters[5].Value = model.infoType; parameters[6].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.Invite model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Invite set "); strSql.Append("inviteName=@inviteName,"); strSql.Append("inviteInfo=@inviteInfo,"); strSql.Append("inviteDesc=@inviteDesc,"); strSql.Append("infoRemark=@infoRemark,"); strSql.Append("descremark=@descremark,"); strSql.Append("inviteType=@inviteType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@inviteName", SqlDbType.VarChar, 50), new SqlParameter("@inviteInfo", SqlDbType.NText), new SqlParameter("@inviteDesc", SqlDbType.NText), new SqlParameter("@inviteType", SqlDbType.Int, 4), new SqlParameter("@infoRemark", SqlDbType.VarChar, 1500),new SqlParameter("@descremark", SqlDbType.VarChar, 1500), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.inviteName; parameters[1].Value = model.inviteInfo; parameters[2].Value = model.inviteDesc; parameters[3].Value = model.inviteType; parameters[4].Value = model.inforemark; parameters[5].Value = model.descremark; parameters[6].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// Delete一条数据 /// </summary> public bool Delete(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("delete from OrderInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; int rows=DBHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public static int Update(Model.TopNews model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TopNews set "); strSql.Append("imgURL=@imgURL,"); strSql.Append("baseInfo=@baseInfo,"); strSql.Append("remark=@remark"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@imgURL", SqlDbType.VarChar, 50), new SqlParameter("@baseInfo", SqlDbType.VarChar, 1500),new SqlParameter("@remark", SqlDbType.VarChar, 500), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.imgURL; parameters[1].Value = model.baseInfo; parameters[2].Value = model.remark; parameters[3].Value = model.id; return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
public static bool AddDepartment(Department d) { string sql = "insert into Department(name,remarks,created,status) values(@name,@remarks,@created,@status)"; List <SqlParameter> par = new List <SqlParameter>(); par.Add(new SqlParameter("name", d.Name)); par.Add(new SqlParameter("remarks", d.Remarks)); par.Add(new SqlParameter("created", d.Created)); par.Add(new SqlParameter("status", d.Status)); int res = DBHelperSQL.ExecuteSql(sql, par.ToArray()); if (res > 0) { return(true); } else { return(false); } }
public static bool ModifyDepartment(Department d) { string sql = "Update Department set name=@name,remarks=@remarks,created=@created,status=@status where id=" + d.Id; List <SqlParameter> par = new List <SqlParameter>(); par.Add(new SqlParameter("name", d.Name)); par.Add(new SqlParameter("remarks", d.Remarks)); par.Add(new SqlParameter("created", d.Created)); par.Add(new SqlParameter("status", d.Status)); int res = DBHelperSQL.ExecuteSql(sql, par.ToArray()); if (res > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Product_ProperValue model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Product_ProperValue set "); strSql.Append("productId=@productId,"); strSql.Append("properValueId=@properValueId,"); strSql.Append("properValueText=@properValueText,"); strSql.Append("properId=@properId,"); strSql.Append("parentId=@parentId"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@properValueId", SqlDbType.Int, 4), new SqlParameter("@properValueText", SqlDbType.VarChar, 2000), new SqlParameter("@properId", SqlDbType.Int, 4), new SqlParameter("@parentId", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.productId; parameters[1].Value = model.properValueId; parameters[2].Value = model.properValueText; parameters[3].Value = model.properId; parameters[4].Value = model.parentId; parameters[5].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.EmailCode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update EmailCode set "); strSql.Append("email=@email,"); strSql.Append("emailCode=@emailCode,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@emailCode", SqlDbType.VarChar, 50), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.email; parameters[1].Value = model.emailCode; parameters[2].Value = model.status; parameters[3].Value = model.remark; parameters[4].Value = model.infoType; parameters[5].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// Delete一条数据 /// </summary> public static bool Delete(int userId, int shoperId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from UserFavoriteInfo "); strSql.Append(" where objId=@objId and addUser = "******"@objId", SqlDbType.Int, 4) }; parameters[0].Value = shoperId; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// Delete一条数据 /// </summary> public static bool Delete(int productId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Product_ProperValue "); strSql.Append(" where productId=@productId"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4) }; parameters[0].Value = productId; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// Delete一条数据 /// </summary> public static bool Delete(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Common_OnlineMessage "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Shoper model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Shoper set "); strSql.Append("shoperName=@shoperName,"); strSql.Append("pid=@pid,"); strSql.Append("cid=@cid,"); strSql.Append("regionId=@regionId,"); strSql.Append("address=@address,"); strSql.Append("mapInfo=@mapInfo,"); strSql.Append("shopingTime=@shopingTime,"); strSql.Append("tel=@tel,"); strSql.Append("moible=@moible,"); strSql.Append("email=@email,"); strSql.Append("qq=@qq,"); strSql.Append("qqisBind=@qqisBind,"); strSql.Append("mainBrand=@mainBrand,"); strSql.Append("goodCount=@goodCount,"); strSql.Append("assessCount=@assessCount,"); strSql.Append("shareCount=@shareCount,"); strSql.Append("status=@status,"); strSql.Append("remark=@remark,"); strSql.Append("addTime=@addTime,"); strSql.Append("addUser=@addUser,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@shoperName", SqlDbType.VarChar, 150), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@mapInfo", SqlDbType.NText), new SqlParameter("@shopingTime", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@moible", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@qq", SqlDbType.VarChar, 20), new SqlParameter("@qqisBind", SqlDbType.NChar, 10), new SqlParameter("@mainBrand", SqlDbType.VarChar, 150), new SqlParameter("@goodCount", SqlDbType.Int, 4), new SqlParameter("@assessCount", SqlDbType.Int, 4), new SqlParameter("@shareCount", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.shoperName; parameters[1].Value = model.pid; parameters[2].Value = model.cid; parameters[3].Value = model.regionId; parameters[4].Value = model.address; parameters[5].Value = model.mapInfo; parameters[6].Value = model.shopingTime; parameters[7].Value = model.tel; parameters[8].Value = model.moible; parameters[9].Value = model.email; parameters[10].Value = model.qq; parameters[11].Value = model.qqisBind; parameters[12].Value = model.mainBrand; parameters[13].Value = model.goodCount; parameters[14].Value = model.assessCount; parameters[15].Value = model.shareCount; parameters[16].Value = model.status; parameters[17].Value = model.remark; parameters[18].Value = model.addTime; parameters[19].Value = model.addUser; parameters[20].Value = model.infoType; parameters[21].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新顺序号 /// </summary> /// <param name="id"></param> /// <param name="infoType"></param> /// <returns></returns> public static int Update(int id, int infoType) { string sql = "update IndexUser set infoType = " + infoType + " where id = " + id; return(DBHelperSQL.ExecuteSql(sql)); }
/// <summary> /// Delete二维码 /// </summary> /// <param name="user"></param> /// <returns></returns> public static int DelErWeiCode(UserInfo user) { string sql = "update UserInfo set badCount = 0,imgUrl = '' where id = " + user.id; return(DBHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("username=@username,"); strSql.Append("mobile=@mobile,"); strSql.Append("isBindMobile=@isBindMobile,"); strSql.Append("email=@email,"); strSql.Append("isBindEmail=@isBindEmail,"); strSql.Append("password=@password,"); strSql.Append("md5Pass=@md5Pass,"); strSql.Append("relName=@relName,"); strSql.Append("bodyCode=@bodyCode,"); strSql.Append("comName=@comName,"); strSql.Append("pid=@pid,"); strSql.Append("cid=@cid,"); strSql.Append("regionId=@regionId,"); strSql.Append("address=@address,"); strSql.Append("zipCode=@zipCode,"); strSql.Append("qq=@qq,"); strSql.Append("weixin=@weixin,"); strSql.Append("isBindWeiXin=@isBindWeiXin,"); strSql.Append("weibo=@weibo,"); strSql.Append("isBindWeiBo=@isBindWeiBo,"); strSql.Append("shopType=@shopType,"); strSql.Append("shopTypeName=@shopTypeName,"); strSql.Append("imgUrl=@imgUrl,"); strSql.Append("comInfo=@comInfo,"); strSql.Append("remark=@remark,"); strSql.Append("status=@status,"); strSql.Append("addTime=@addTime,"); strSql.Append("mobileCode=@mobileCode,"); strSql.Append("activeCode=@activeCode,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 150), new SqlParameter("@mobile", SqlDbType.VarChar, 150), new SqlParameter("@isBindMobile", SqlDbType.Int, 4), new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@isBindEmail", SqlDbType.Int, 4), new SqlParameter("@password", SqlDbType.VarChar, 150), new SqlParameter("@md5Pass", SqlDbType.VarChar, 150), new SqlParameter("@relName", SqlDbType.VarChar, 150), new SqlParameter("@bodyCode", SqlDbType.VarChar, 150), new SqlParameter("@comName", SqlDbType.VarChar, 150), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@zipCode", SqlDbType.VarChar, 150), new SqlParameter("@qq", SqlDbType.VarChar, 150), new SqlParameter("@weixin", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiXin", SqlDbType.Int, 4), new SqlParameter("@weibo", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiBo", SqlDbType.Int, 4), new SqlParameter("@shopType", SqlDbType.Int, 4), new SqlParameter("@shopTypeName", SqlDbType.VarChar, 150), new SqlParameter("@imgUrl", SqlDbType.VarChar, 150), new SqlParameter("@comInfo", SqlDbType.NText), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@mobileCode", SqlDbType.VarChar, 150), new SqlParameter("@activeCode", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.username; parameters[1].Value = model.mobile; parameters[2].Value = model.isBindMobile; parameters[3].Value = model.email; parameters[4].Value = model.isBindEmail; parameters[5].Value = model.password; parameters[6].Value = model.md5Pass; parameters[7].Value = model.relName; parameters[8].Value = model.bodyCode; parameters[9].Value = model.comName; parameters[10].Value = model.pid; parameters[11].Value = model.cid; parameters[12].Value = model.regionId; parameters[13].Value = model.address; parameters[14].Value = model.zipCode; parameters[15].Value = model.qq; parameters[16].Value = model.weixin; parameters[17].Value = model.isBindWeiXin; parameters[18].Value = model.weibo; parameters[19].Value = model.isBindWeiBo; parameters[20].Value = model.shopType; parameters[21].Value = model.shopTypeName; parameters[22].Value = model.imgUrl; parameters[23].Value = model.comInfo; parameters[24].Value = model.remark; parameters[25].Value = model.status; parameters[26].Value = model.addTime; parameters[27].Value = model.mobileCode; parameters[28].Value = model.activeCode; parameters[29].Value = model.infoType; parameters[30].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 绑定邮箱 /// </summary> /// <param name="userId"></param> /// <param name="email"></param> /// <returns></returns> public static int BindEmail(object userId, object email) { string sql = "update UserInfo set isBindEmail = 1,email = '" + email + "' where id = " + userId; return(DBHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 更新支付Password /// </summary> /// <param name="user"></param> /// <returns></returns> public static int UpdatePayPass(UserInfo user) { string sql = "update UserInfo set telephone = '" + user.telephone + "' where id = " + user.id; return(DBHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 更新个人基本信息 /// </summary> /// <param name="item"></param> /// <returns></returns> public static int UpdateInfo(UserInfo item) { string sql = "update UserInfo set address = '" + item.address + "',imgUrl='" + item.imgUrl + "',mobileCode = '" + item.mobileCode + "',activeCode = '" + item.activeCode + "',shopingtime = '" + item.shopingtime + "',sharecount = " + item.sharecount + ",relName = '" + item.relName + "',username = '******',mainBrand ='" + item.mainbrand + "' where id = " + item.id; return(DBHelperSQL.ExecuteSql(sql)); }
/// <summary> /// 更新个人基本信息 /// </summary> /// <param name="item"></param> /// <returns></returns> public static int UpdateInfoShop(UserInfo item) { string sql = "update UserInfo set weibo = '" + item.weibo + "',remark='" + item.remark + "',email='" + item.email + "',imgUrl='" + item.imgUrl + "',mobileCode = '" + item.mobileCode + "',activeCode = '" + item.activeCode + "',comName = '" + item.comName + "',shopType = " + item.shopType + ",relName = '" + item.relName + "',username = '******',mainBrand ='" + item.mainbrand + "' where id = " + item.id; return(DBHelperSQL.ExecuteSql(sql)); }