/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_ucard_sys model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_ucard_sys set ");
strSql.Append("wid=@wid,");
strSql.Append("tradeTel=@tradeTel,");
strSql.Append("tradeContent=@tradeContent,");
strSql.Append("cardType=@cardType,");
strSql.Append("createDate=@createDate");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@tradeTel", SqlDbType.VarChar,50),
new SqlParameter("@tradeContent", SqlDbType.VarChar,1500),
new SqlParameter("@cardType", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.tradeTel;
parameters[2].Value = model.tradeContent;
parameters[3].Value = model.cardType;
parameters[4].Value = model.createDate;
parameters[5].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_albums_sys model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_albums_sys(");
strSql.Append("wid,bannerPic,code,typeId,typeName)");
strSql.Append(" values (");
strSql.Append("@wid,@bannerPic,@code,@typeId,@typeName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@bannerPic", SqlDbType.VarChar,1000),
new SqlParameter("@code", SqlDbType.VarChar,500),
new SqlParameter("@typeId", SqlDbType.Int,4),
new SqlParameter("@typeName", SqlDbType.VarChar,500)};
parameters[0].Value = model.wid;
parameters[1].Value = model.bannerPic;
parameters[2].Value = model.code;
parameters[3].Value = model.typeId;
parameters[4].Value = model.typeName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_shop_sku model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_shop_sku(");
strSql.Append("productId,sku,stock,price,attributeValue,attributeId)");
strSql.Append(" values (");
strSql.Append("@productId,@sku,@stock,@price,@attributeValue,@attributeId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@productId", SqlDbType.Int,4),
new SqlParameter("@sku", SqlDbType.VarChar,16),
new SqlParameter("@stock", SqlDbType.Int,4),
new SqlParameter("@price", SqlDbType.Float,8),
new SqlParameter("@attributeValue", SqlDbType.VarChar,500),
new SqlParameter("@attributeId", SqlDbType.Int,4)};
parameters[0].Value = model.productId;
parameters[1].Value = model.sku;
parameters[2].Value = model.stock;
parameters[3].Value = model.price;
parameters[4].Value = model.attributeValue;
parameters[5].Value = model.attributeId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_ucard_adver model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ucard_adver(");
strSql.Append("wid,adverName,picUrl,linkUrl,isShow,sort_id,createDate)");
strSql.Append(" values (");
strSql.Append("@wid,@adverName,@picUrl,@linkUrl,@isShow,@sort_id,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@adverName", SqlDbType.VarChar,50),
new SqlParameter("@picUrl", SqlDbType.VarChar,800),
new SqlParameter("@linkUrl", SqlDbType.VarChar,200),
new SqlParameter("@isShow", SqlDbType.Bit,1),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.wid;
parameters[1].Value = model.adverName;
parameters[2].Value = model.picUrl;
parameters[3].Value = model.linkUrl;
parameters[4].Value = model.isShow;
parameters[5].Value = model.sort_id;
parameters[6].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_dzpUsersTemp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_dzpUsersTemp set ");
strSql.Append("actId=@actId,");
strSql.Append("openid=@openid,");
strSql.Append("times=@times,");
strSql.Append("createDate=@createDate");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@actId", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@times", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.actId;
parameters[1].Value = model.openid;
parameters[2].Value = model.times;
parameters[3].Value = model.createDate;
parameters[4].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_sq_piclist model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_sq_piclist(");
strSql.Append("aid,openid,picUrl,createDate,hasShenghe)");
strSql.Append(" values (");
strSql.Append("@aid,@openid,@picUrl,@createDate,@hasShenghe)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@aid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@picUrl", SqlDbType.VarChar,800),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@hasShenghe", SqlDbType.Bit,1)};
parameters[0].Value = model.aid;
parameters[1].Value = model.openid;
parameters[2].Value = model.picUrl;
parameters[3].Value = model.createDate;
parameters[4].Value = model.hasShenghe;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WechatBuilder.Model.wx_ucard_usercard model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ucard_usercard(");
strSql.Append("id,uid,sid,addDate)");
strSql.Append(" values (");
strSql.Append("@id,@uid,@sid,@addDate)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@uid", SqlDbType.Int,4),
new SqlParameter("@sid", SqlDbType.Int,4),
new SqlParameter("@addDate", SqlDbType.DateTime)};
parameters[0].Value = model.id;
parameters[1].Value = model.uid;
parameters[2].Value = model.sid;
parameters[3].Value = model.addDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_diancai_shop_setup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_diancai_shop_setup set ");
strSql.Append("wid=@wid,");
strSql.Append("unionManage=@unionManage,");
strSql.Append("unionTel=@unionTel,");
strSql.Append("createDate=@createDate,");
strSql.Append("shopid=@shopid");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@unionManage", SqlDbType.VarChar,500),
new SqlParameter("@unionTel", SqlDbType.VarChar,100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@shopid", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.unionManage;
parameters[2].Value = model.unionTel;
parameters[3].Value = model.createDate;
parameters[4].Value = model.shopid;
parameters[5].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(WechatBuilder.Model.wx_payment_type model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_payment_type(");
strSql.Append("id,typeCode,typeName,remark,sort_id,img_url,api_path)");
strSql.Append(" values (");
strSql.Append("@id,@typeCode,@typeName,@remark,@sort_id,@img_url,@api_path)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@typeCode", SqlDbType.VarChar,30),
new SqlParameter("@typeName", SqlDbType.VarChar,100),
new SqlParameter("@remark", SqlDbType.VarChar,1500),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@img_url", SqlDbType.VarChar,800),
new SqlParameter("@api_path", SqlDbType.VarChar,100)};
parameters[0].Value = model.id;
parameters[1].Value = model.typeCode;
parameters[2].Value = model.typeName;
parameters[3].Value = model.remark;
parameters[4].Value = model.sort_id;
parameters[5].Value = model.img_url;
parameters[6].Value = model.api_path;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_wsite_setting model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_wsite_setting(");
strSql.Append("wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2)");
strSql.Append(" values (");
strSql.Append("@wId,@wName,@companyName,@bgMusic,@bgPic,@bgDongHuaId,@wCopyright,@wBrief,@remark,@phone,@addr,@addrUrl,@email,@seo_title,@seo_keywords,@seo_desc,@createDate,@extInt,@extStr,@extStr2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wId", SqlDbType.Int,4),
new SqlParameter("@wName", SqlDbType.VarChar,500),
new SqlParameter("@companyName", SqlDbType.VarChar,500),
new SqlParameter("@bgMusic", SqlDbType.VarChar,800),
new SqlParameter("@bgPic", SqlDbType.VarChar,800),
new SqlParameter("@bgDongHuaId", SqlDbType.Int,4),
new SqlParameter("@wCopyright", SqlDbType.VarChar,500),
new SqlParameter("@wBrief", SqlDbType.VarChar,500),
new SqlParameter("@remark", SqlDbType.VarChar,2000),
new SqlParameter("@phone", SqlDbType.VarChar,200),
new SqlParameter("@addr", SqlDbType.VarChar,1000),
new SqlParameter("@addrUrl", SqlDbType.VarChar,1000),
new SqlParameter("@email", SqlDbType.VarChar,200),
new SqlParameter("@seo_title", SqlDbType.VarChar,500),
new SqlParameter("@seo_keywords", SqlDbType.VarChar,500),
new SqlParameter("@seo_desc", SqlDbType.VarChar,1000),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@extInt", SqlDbType.Int,4),
new SqlParameter("@extStr", SqlDbType.VarChar,500),
new SqlParameter("@extStr2", SqlDbType.VarChar,800)};
parameters[0].Value = model.wId;
parameters[1].Value = model.wName;
parameters[2].Value = model.companyName;
parameters[3].Value = model.bgMusic;
parameters[4].Value = model.bgPic;
parameters[5].Value = model.bgDongHuaId;
parameters[6].Value = model.wCopyright;
parameters[7].Value = model.wBrief;
parameters[8].Value = model.remark;
parameters[9].Value = model.phone;
parameters[10].Value = model.addr;
parameters[11].Value = model.addrUrl;
parameters[12].Value = model.email;
parameters[13].Value = model.seo_title;
parameters[14].Value = model.seo_keywords;
parameters[15].Value = model.seo_desc;
parameters[16].Value = model.createDate;
parameters[17].Value = model.extInt;
parameters[18].Value = model.extStr;
parameters[19].Value = model.extStr2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_diancai_shop_setup model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_diancai_shop_setup(");
strSql.Append("wid,unionManage,unionTel,createDate,shopid)");
strSql.Append(" values (");
strSql.Append("@wid,@unionManage,@unionTel,@createDate,@shopid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@unionManage", SqlDbType.VarChar,500),
new SqlParameter("@unionTel", SqlDbType.VarChar,100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@shopid", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.unionManage;
parameters[2].Value = model.unionTel;
parameters[3].Value = model.createDate;
parameters[4].Value = model.shopid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_diancai_blacklist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_diancai_blacklist set ");
strSql.Append("openid=@openid,");
strSql.Append("blackName=@blackName,");
strSql.Append("blackDate=@blackDate,");
strSql.Append("createDate=@createDate,");
strSql.Append("shopid=@shopid");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@openid", SqlDbType.VarChar,300),
new SqlParameter("@blackName", SqlDbType.VarChar,100),
new SqlParameter("@blackDate", SqlDbType.DateTime),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@shopid", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.openid;
parameters[1].Value = model.blackName;
parameters[2].Value = model.blackDate;
parameters[3].Value = model.createDate;
parameters[4].Value = model.shopid;
parameters[5].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_diancai_blacklist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_diancai_blacklist(");
strSql.Append("openid,blackName,blackDate,createDate,shopid)");
strSql.Append(" values (");
strSql.Append("@openid,@blackName,@blackDate,@createDate,@shopid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@openid", SqlDbType.VarChar,300),
new SqlParameter("@blackName", SqlDbType.VarChar,100),
new SqlParameter("@blackDate", SqlDbType.DateTime),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@shopid", SqlDbType.Int,4)};
parameters[0].Value = model.openid;
parameters[1].Value = model.blackName;
parameters[2].Value = model.blackDate;
parameters[3].Value = model.createDate;
parameters[4].Value = model.shopid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_xt_user model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_xt_user(");
strSql.Append("bId,openid,uName,phone,pNum,createDate)");
strSql.Append(" values (");
strSql.Append("@bId,@openid,@uName,@phone,@pNum,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@bId", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,200),
new SqlParameter("@uName", SqlDbType.VarChar,100),
new SqlParameter("@phone", SqlDbType.VarChar,100),
new SqlParameter("@pNum", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.bId;
parameters[1].Value = model.openid;
parameters[2].Value = model.uName;
parameters[3].Value = model.phone;
parameters[4].Value = model.pNum;
parameters[5].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_vote_result model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_vote_result set ");
strSql.Append("baseid=@baseid,");
strSql.Append("itemid=@itemid,");
strSql.Append("openId=@openId,");
strSql.Append("createDate=@createDate");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@baseid", SqlDbType.Int,4),
new SqlParameter("@itemid", SqlDbType.Int,4),
new SqlParameter("@openId", SqlDbType.VarChar,200),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.baseid;
parameters[1].Value = model.itemid;
parameters[2].Value = model.openId;
parameters[3].Value = model.createDate;
parameters[4].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_diancai_caipin_category model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_diancai_caipin_category(");
strSql.Append("shopid,sortid,categoryName,miaoshu,isStart,createDate)");
strSql.Append(" values (");
strSql.Append("@shopid,@sortid,@categoryName,@miaoshu,@isStart,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@shopid", SqlDbType.Int,4),
new SqlParameter("@sortid", SqlDbType.Int,4),
new SqlParameter("@categoryName", SqlDbType.VarChar,100),
new SqlParameter("@miaoshu", SqlDbType.VarChar,100),
new SqlParameter("@isStart", SqlDbType.Bit,1),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.shopid;
parameters[1].Value = model.sortid;
parameters[2].Value = model.categoryName;
parameters[3].Value = model.miaoshu;
parameters[4].Value = model.isStart;
parameters[5].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_shop_catalog_attribute model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_shop_catalog_attribute(");
strSql.Append("wid,catalogId,aName,aType,aValue,createDate,sort_id)");
strSql.Append(" values (");
strSql.Append("@wid,@catalogId,@aName,@aType,@aValue,@createDate,@sort_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@catalogId", SqlDbType.Int,4),
new SqlParameter("@aName", SqlDbType.VarChar,100),
new SqlParameter("@aType", SqlDbType.Int,4),
new SqlParameter("@aValue", SqlDbType.VarChar,2000),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@sort_id", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.catalogId;
parameters[2].Value = model.aName;
parameters[3].Value = model.aType;
parameters[4].Value = model.aValue;
parameters[5].Value = model.createDate;
parameters[6].Value = model.sort_id;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_ucard_notice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ucard_notice(");
strSql.Append("wid,nName,nContent,userDegree,createDate,sId)");
strSql.Append(" values (");
strSql.Append("@wid,@nName,@nContent,@userDegree,@createDate,@sId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@nName", SqlDbType.VarChar,100),
new SqlParameter("@nContent", SqlDbType.VarChar,1500),
new SqlParameter("@userDegree", SqlDbType.VarChar,500),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@sId", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.nName;
parameters[2].Value = model.nContent;
parameters[3].Value = model.userDegree;
parameters[4].Value = model.createDate;
parameters[5].Value = model.sId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_sq_piclist model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_sq_piclist set ");
strSql.Append("aid=@aid,");
strSql.Append("openid=@openid,");
strSql.Append("picUrl=@picUrl,");
strSql.Append("createDate=@createDate,");
strSql.Append("hasShenghe=@hasShenghe");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@aid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@picUrl", SqlDbType.VarChar,800),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@hasShenghe", SqlDbType.Bit,1),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.aid;
parameters[1].Value = model.openid;
parameters[2].Value = model.picUrl;
parameters[3].Value = model.createDate;
parameters[4].Value = model.hasShenghe;
parameters[5].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_shop_productAttr_value model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_shop_productAttr_value(");
strSql.Append("attributeId,productId,paValue)");
strSql.Append(" values (");
strSql.Append("@attributeId,@productId,@paValue)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@attributeId", SqlDbType.Int,4),
new SqlParameter("@productId", SqlDbType.Int,4),
new SqlParameter("@paValue", SqlDbType.VarChar,4000)};
parameters[0].Value = model.attributeId;
parameters[1].Value = model.productId;
parameters[2].Value = model.paValue;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_ucard_usercard model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_ucard_usercard set ");
strSql.Append("uid=@uid,");
strSql.Append("sid=@sid,");
strSql.Append("addDate=@addDate");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@uid", SqlDbType.Int,4),
new SqlParameter("@sid", SqlDbType.Int,4),
new SqlParameter("@addDate", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.uid;
parameters[1].Value = model.sid;
parameters[2].Value = model.addDate;
parameters[3].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_shop_productAttr_value model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_shop_productAttr_value set ");
strSql.Append("attributeId=@attributeId,");
strSql.Append("productId=@productId,");
strSql.Append("paValue=@paValue");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@attributeId", SqlDbType.Int,4),
new SqlParameter("@productId", SqlDbType.Int,4),
new SqlParameter("@paValue", SqlDbType.VarChar,4000),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.attributeId;
parameters[1].Value = model.productId;
parameters[2].Value = model.paValue;
parameters[3].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_dzpUsersTemp model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_dzpUsersTemp(");
strSql.Append("actId,openid,times,createDate)");
strSql.Append(" values (");
strSql.Append("@actId,@openid,@times,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@actId", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@times", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.actId;
parameters[1].Value = model.openid;
parameters[2].Value = model.times;
parameters[3].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_pano_sys model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_pano_sys(");
strSql.Append("wid,backPic,seriesId,seriesName,createDate,seq)");
strSql.Append(" values (");
strSql.Append("@wid,@backPic,@seriesId,@seriesName,@createDate,@seq)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@backPic", SqlDbType.VarChar,1000),
new SqlParameter("@seriesId", SqlDbType.Int,4),
new SqlParameter("@seriesName", SqlDbType.VarChar,300),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@seq", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.backPic;
parameters[2].Value = model.seriesId;
parameters[3].Value = model.seriesName;
parameters[4].Value = model.createDate;
parameters[5].Value = model.seq;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_shop_category_catalog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_shop_category_catalog set ");
strSql.Append("categoryId=@categoryId,");
strSql.Append("catalogId=@catalogId");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@categoryId", SqlDbType.Int,4),
new SqlParameter("@catalogId", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.categoryId;
parameters[1].Value = model.catalogId;
parameters[2].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_diancai_shop_advertisement model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_diancai_shop_advertisement(");
strSql.Append("setupid,advertisementName,sortid,picUrl,websetUrl,isdisplay,createDate)");
strSql.Append(" values (");
strSql.Append("@setupid,@advertisementName,@sortid,@picUrl,@websetUrl,@isdisplay,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@setupid", SqlDbType.Int,4),
new SqlParameter("@advertisementName", SqlDbType.VarChar,300),
new SqlParameter("@sortid", SqlDbType.Int,4),
new SqlParameter("@picUrl", SqlDbType.VarChar,300),
new SqlParameter("@websetUrl", SqlDbType.VarChar,300),
new SqlParameter("@isdisplay", SqlDbType.Bit,1),
new SqlParameter("@createDate", SqlDbType.VarChar,4000)};
parameters[0].Value = model.setupid;
parameters[1].Value = model.advertisementName;
parameters[2].Value = model.sortid;
parameters[3].Value = model.picUrl;
parameters[4].Value = model.websetUrl;
parameters[5].Value = model.isdisplay;
parameters[6].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WechatBuilder.Model.wx_albums_sys model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_albums_sys set ");
strSql.Append("wid=@wid,");
strSql.Append("bannerPic=@bannerPic,");
strSql.Append("code=@code,");
strSql.Append("typeId=@typeId,");
strSql.Append("typeName=@typeName");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@bannerPic", SqlDbType.VarChar,1000),
new SqlParameter("@code", SqlDbType.VarChar,500),
new SqlParameter("@typeId", SqlDbType.Int,4),
new SqlParameter("@typeName", SqlDbType.VarChar,500),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.bannerPic;
parameters[2].Value = model.code;
parameters[3].Value = model.typeId;
parameters[4].Value = model.typeName;
parameters[5].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_vote_result model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_vote_result(");
strSql.Append("baseid,itemid,openId,createDate)");
strSql.Append(" values (");
strSql.Append("@baseid,@itemid,@openId,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@baseid", SqlDbType.Int,4),
new SqlParameter("@itemid", SqlDbType.Int,4),
new SqlParameter("@openId", SqlDbType.VarChar,200),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.baseid;
parameters[1].Value = model.itemid;
parameters[2].Value = model.openId;
parameters[3].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_diancai_shoppic model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_diancai_shoppic(");
strSql.Append("shopid,description,sortid,picUrl,pictzUrl,createDate)");
strSql.Append(" values (");
strSql.Append("@shopid,@description,@sortid,@picUrl,@pictzUrl,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@shopid", SqlDbType.Int,4),
new SqlParameter("@description", SqlDbType.VarChar,200),
new SqlParameter("@sortid", SqlDbType.Int,4),
new SqlParameter("@picUrl", SqlDbType.VarChar,300),
new SqlParameter("@pictzUrl", SqlDbType.VarChar,300),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.shopid;
parameters[1].Value = model.description;
parameters[2].Value = model.sortid;
parameters[3].Value = model.picUrl;
parameters[4].Value = model.pictzUrl;
parameters[5].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WechatBuilder.Model.wx_ucard_sys model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ucard_sys(");
strSql.Append("wid,tradeTel,tradeContent,cardType,createDate)");
strSql.Append(" values (");
strSql.Append("@wid,@tradeTel,@tradeContent,@cardType,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@tradeTel", SqlDbType.VarChar,50),
new SqlParameter("@tradeContent", SqlDbType.VarChar,1500),
new SqlParameter("@cardType", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.wid;
parameters[1].Value = model.tradeTel;
parameters[2].Value = model.tradeContent;
parameters[3].Value = model.cardType;
parameters[4].Value = model.createDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
