本文整理汇总了C#中MxWeiXinPF类的典型用法代码示例。如果您正苦于以下问题:C# MxWeiXinPF类的具体用法?C# MxWeiXinPF怎么用?C# MxWeiXinPF使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
MxWeiXinPF类属于命名空间,在下文中一共展示了MxWeiXinPF类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_vote_result.cs
示例2: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_shop_catalog_attribute.cs
示例3: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_diancai_shop_setup.cs
示例4: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_sjb_users.cs
示例5: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_xt_user.cs
示例6: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_ucard_adver.cs
示例7: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_ucard_sys.cs
示例8: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_albums_sys.cs
示例9: Add
/// <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;
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:36,代码来源:wx_payment_type.cs
示例10: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_shop_catalog.cs
示例11: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:29,代码来源:wx_shop_productAttr_value.cs
示例12: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_dzpUsersTemp.cs
示例13: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_yy_result.cs
示例14: Add
/// <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;
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:30,代码来源:pre_common_district.cs
示例15: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_shop_sku.cs
示例16: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_xt_photo.cs
示例17: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_diancai_caipin_category.cs
示例18: Add
/// <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;
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:30,代码来源:wx_ucard_usercard.cs
示例19: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_ggkAwardItem.cs
示例20: Add
/// <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);
}
}
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_sq_heimd.cs
注:本文中的MxWeiXinPF类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论