/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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(MxWeiXinPF.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(MxWeiXinPF.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 int Add(MxWeiXinPF.Model.wx_sjb_users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_sjb_users(");
strSql.Append("wid,openid,uName,tel,succTimes,failTimes)");
strSql.Append(" values (");
strSql.Append("@wid,@openid,@uName,@tel,@succTimes,@failTimes)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,300),
new SqlParameter("@uName", SqlDbType.VarChar,100),
new SqlParameter("@tel", SqlDbType.VarChar,30),
new SqlParameter("@succTimes", SqlDbType.Int,4),
new SqlParameter("@failTimes", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.openid;
parameters[2].Value = model.uName;
parameters[3].Value = model.tel;
parameters[4].Value = model.succTimes;
parameters[5].Value = model.failTimes;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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 int Add(MxWeiXinPF.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 int Add(MxWeiXinPF.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);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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 bool Add(MxWeiXinPF.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(MxWeiXinPF.Model.wx_shop_catalog model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_shop_catalog(");
strSql.Append("wid,cTitle,remark,sort_id,createDate)");
strSql.Append(" values (");
strSql.Append("@wid,@cTitle,@remark,@sort_id,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@cTitle", SqlDbType.VarChar,4000),
new SqlParameter("@remark", SqlDbType.VarChar,2000),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.wid;
parameters[1].Value = model.cTitle;
parameters[2].Value = model.remark;
parameters[3].Value = model.sort_id;
parameters[4].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(MxWeiXinPF.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 int Add(MxWeiXinPF.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(MxWeiXinPF.Model.wx_yy_result model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_yy_result(");
strSql.Append("formId,openid,cName,cId,userResult,createDate)");
strSql.Append(" values (");
strSql.Append("@formId,@openid,@cName,@cId,@userResult,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@formId", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@cName", SqlDbType.VarChar,100),
new SqlParameter("@cId", SqlDbType.Int,4),
new SqlParameter("@userResult", SqlDbType.VarChar,2000),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.formId;
parameters[1].Value = model.openid;
parameters[2].Value = model.cName;
parameters[3].Value = model.cId;
parameters[4].Value = model.userResult;
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 Add(MxWeiXinPF.Model.pre_common_district model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into pre_common_district(");
strSql.Append("id,name,level,upid)");
strSql.Append(" values (");
strSql.Append("@id,@name,@level,@upid)");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4),
new SqlParameter("@name", SqlDbType.NVarChar,255),
new SqlParameter("@level", SqlDbType.Int,4),
new SqlParameter("@upid", SqlDbType.Int,4)};
parameters[0].Value = model.id;
parameters[1].Value = model.name;
parameters[2].Value = model.level;
parameters[3].Value = model.upid;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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(MxWeiXinPF.Model.wx_xt_photo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_xt_photo(");
strSql.Append("bId,pName,pUrl,remark,seq)");
strSql.Append(" values (");
strSql.Append("@bId,@pName,@pUrl,@remark,@seq)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@bId", SqlDbType.Int,4),
new SqlParameter("@pName", SqlDbType.VarChar,200),
new SqlParameter("@pUrl", SqlDbType.VarChar,1000),
new SqlParameter("@remark", SqlDbType.VarChar,1000),
new SqlParameter("@seq", SqlDbType.Int,4)};
parameters[0].Value = model.bId;
parameters[1].Value = model.pName;
parameters[2].Value = model.pUrl;
parameters[3].Value = model.remark;
parameters[4].Value = model.seq;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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 bool Add(MxWeiXinPF.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 int Add(MxWeiXinPF.Model.wx_ggkAwardItem model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ggkAwardItem(");
strSql.Append("actId,jxName,jpName,jpNum,jpRealNum,sort_id,createDate)");
strSql.Append(" values (");
strSql.Append("@actId,@jxName,@jpName,@jpNum,@jpRealNum,@sort_id,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@actId", SqlDbType.Int,4),
new SqlParameter("@jxName", SqlDbType.VarChar,50),
new SqlParameter("@jpName", SqlDbType.VarChar,200),
new SqlParameter("@jpNum", SqlDbType.Int,4),
new SqlParameter("@jpRealNum", SqlDbType.Int,4),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.actId;
parameters[1].Value = model.jxName;
parameters[2].Value = model.jpName;
parameters[3].Value = model.jpNum;
parameters[4].Value = model.jpRealNum;
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 int Add(MxWeiXinPF.Model.wx_sq_heimd model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_sq_heimd(");
strSql.Append("aid,openid,createDate,remark)");
strSql.Append(" values (");
strSql.Append("@aid,@openid,@createDate,@remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@aid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@remark", SqlDbType.VarChar,500)};
parameters[0].Value = model.aid;
parameters[1].Value = model.openid;
parameters[2].Value = model.createDate;
parameters[3].Value = model.remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_lbs_setting model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_lbs_setting(");
strSql.Append("wid,searchRadius,bannerPicUrl)");
strSql.Append(" values (");
strSql.Append("@wid,@searchRadius,@bannerPicUrl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@searchRadius", SqlDbType.Float,8),
new SqlParameter("@bannerPicUrl", SqlDbType.VarChar,1000)};
parameters[0].Value = model.wid;
parameters[1].Value = model.searchRadius;
parameters[2].Value = model.bannerPicUrl;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_sjb_jcDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_sjb_jcDetail(");
strSql.Append("uid,rcId,bsId,jcRetType,retIsRight,createDate)");
strSql.Append(" values (");
strSql.Append("@uid,@rcId,@bsId,@jcRetType,@retIsRight,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@uid", SqlDbType.Int,4),
new SqlParameter("@rcId", SqlDbType.Int,4),
new SqlParameter("@bsId", SqlDbType.Int,4),
new SqlParameter("@jcRetType", SqlDbType.Int,4),
new SqlParameter("@retIsRight", SqlDbType.Bit,1),
new SqlParameter("@createDate", SqlDbType.DateTime)};
parameters[0].Value = model.uid;
parameters[1].Value = model.rcId;
parameters[2].Value = model.bsId;
parameters[3].Value = model.jcRetType;
parameters[4].Value = model.retIsRight;
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(MxWeiXinPF.Model.wx_message_setting model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_message_setting(");
strSql.Append("wid,title,adminOpenid,picUrl,needSH)");
strSql.Append(" values (");
strSql.Append("@wid,@title,@adminOpenid,@picUrl,@needSH)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@title", SqlDbType.VarChar,200),
new SqlParameter("@adminOpenid", SqlDbType.VarChar,100),
new SqlParameter("@picUrl", SqlDbType.VarChar,800),
new SqlParameter("@needSH", SqlDbType.Bit,1)};
parameters[0].Value = model.wid;
parameters[1].Value = model.title;
parameters[2].Value = model.adminOpenid;
parameters[3].Value = model.picUrl;
parameters[4].Value = model.needSH;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_shop_albums model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_shop_albums(");
strSql.Append("productId,thumb_path,original_path,remark,add_time,wid)");
strSql.Append(" values (");
strSql.Append("@productId,@thumb_path,@original_path,@remark,@add_time,@wid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@productId", SqlDbType.Int,4),
new SqlParameter("@thumb_path", SqlDbType.VarChar,800),
new SqlParameter("@original_path", SqlDbType.VarChar,800),
new SqlParameter("@remark", SqlDbType.VarChar,500),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@wid", SqlDbType.Int,4)};
parameters[0].Value = model.productId;
parameters[1].Value = model.thumb_path;
parameters[2].Value = model.original_path;
parameters[3].Value = model.remark;
parameters[4].Value = model.add_time;
parameters[5].Value = model.wid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_ucard_udegree model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_ucard_udegree(");
strSql.Append("wid,degreeNum,callName,score_min,score_max,createDate,sId)");
strSql.Append(" values (");
strSql.Append("@wid,@degreeNum,@callName,@score_min,@score_max,@createDate,@sId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@degreeNum", SqlDbType.Int,4),
new SqlParameter("@callName", SqlDbType.VarChar,30),
new SqlParameter("@score_min", SqlDbType.Int,4),
new SqlParameter("@score_max", SqlDbType.Int,4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@sId", SqlDbType.Int,4)};
parameters[0].Value = model.wid;
parameters[1].Value = model.degreeNum;
parameters[2].Value = model.callName;
parameters[3].Value = model.score_min;
parameters[4].Value = model.score_max;
parameters[5].Value = model.createDate;
parameters[6].Value = model.sId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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(MxWeiXinPF.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 int Add(MxWeiXinPF.Model.wx_message_blacklist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_message_blacklist(");
strSql.Append("wid,openid,blacktime)");
strSql.Append(" values (");
strSql.Append("@wid,@openid,@blacktime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@wid", SqlDbType.Int,4),
new SqlParameter("@openid", SqlDbType.VarChar,500),
new SqlParameter("@blacktime", SqlDbType.DateTime)};
parameters[0].Value = model.wid;
parameters[1].Value = model.openid;
parameters[2].Value = model.blacktime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.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 int Add(MxWeiXinPF.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);
}
}
