/// <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));
}
