/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.userAddress model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into userAddress(");
strSql.Append("userId,contacts,tel,addressNo,addressInfo,isDefault)");
strSql.Append(" values (");
strSql.Append("@userId,@contacts,@tel,@addressNo,@addressInfo,@isDefault)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@userId", SqlDbType.Int,4),
new SqlParameter("@contacts", SqlDbType.VarChar,200),
new SqlParameter("@tel", SqlDbType.VarChar,200),
new SqlParameter("@addressNo", SqlDbType.NChar,10),
new SqlParameter("@addressInfo", SqlDbType.NChar,10),
new SqlParameter("@isDefault", SqlDbType.Int,4)};
parameters[0].Value = model.userId;
parameters[1].Value = model.contacts;
parameters[2].Value = model.tel;
parameters[3].Value = model.addressNo;
parameters[4].Value = model.addressInfo;
parameters[5].Value = model.isDefault;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.t_distinct model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into t_distinct(");
strSql.Append("code,name,cityCode)");
strSql.Append(" values (");
strSql.Append("@code,@name,@cityCode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@code", SqlDbType.Char,6),
new SqlParameter("@name", SqlDbType.VarChar,40),
new SqlParameter("@cityCode", SqlDbType.Char,6)};
parameters[0].Value = model.code;
parameters[1].Value = model.name;
parameters[2].Value = model.cityCode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.menu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into menu(");
strSql.Append("parentId,menuName,level,orders,url)");
strSql.Append(" values (");
strSql.Append("@parentId,@menuName,@level,@orders,@url)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@parentId", SqlDbType.Int,4),
new SqlParameter("@menuName", SqlDbType.VarChar,100),
new SqlParameter("@level", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@url", SqlDbType.VarChar,100)};
parameters[0].Value = model.parentId;
parameters[1].Value = model.menuName;
parameters[2].Value = model.level;
parameters[3].Value = model.orders;
parameters[4].Value = model.url;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.dept model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into dept(");
strSql.Append("parentId,deptName,userId,manager)");
strSql.Append(" values (");
strSql.Append("@parentId,@deptName,@userId,@manager)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@parentId", SqlDbType.Int,4),
new SqlParameter("@deptName", SqlDbType.VarChar,100),
new SqlParameter("@userId", SqlDbType.Int,4),
new SqlParameter("@manager", SqlDbType.VarChar,100)};
parameters[0].Value = model.parentId;
parameters[1].Value = model.deptName;
parameters[2].Value = model.userId;
parameters[3].Value = model.manager;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.newsCat model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into newsCat(");
strSql.Append("parentId,catName,type,orders,backCol)");
strSql.Append(" values (");
strSql.Append("@parentId,@catName,@type,@orders,@backCol)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@parentId", SqlDbType.Int,4),
new SqlParameter("@catName", SqlDbType.VarChar,100),
new SqlParameter("@type", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@backCol", SqlDbType.VarChar,100)};
parameters[0].Value = model.parentId;
parameters[1].Value = model.catName;
parameters[2].Value = model.type;
parameters[3].Value = model.orders;
parameters[4].Value = model.backCol;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.advPos model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into advPos(");
strSql.Append("name,width,height,summary,template,addTime,status)");
strSql.Append(" values (");
strSql.Append("@name,@width,@height,@summary,@template,@addTime,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,200),
new SqlParameter("@width", SqlDbType.VarChar,200),
new SqlParameter("@height", SqlDbType.VarChar,200),
new SqlParameter("@summary", SqlDbType.VarChar,500),
new SqlParameter("@template", SqlDbType.Text),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int,4)};
parameters[0].Value = model.name;
parameters[1].Value = model.width;
parameters[2].Value = model.height;
parameters[3].Value = model.summary;
parameters[4].Value = model.template;
parameters[5].Value = model.addTime;
parameters[6].Value = model.status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(hm.Model.userExtension model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into userExtension(");
strSql.Append("userId,ext1,ext2,ext3,ext4,ext5,ext6,ext7,ext8,ext9,ext10,ext11,ext12,ext13,ext14,ext15)");
strSql.Append(" values (");
strSql.Append("@userId,@ext1,@ext2,@ext3,@ext4,@ext5,@ext6,@ext7,@ext8,@ext9,@ext10,@ext11,@ext12,@ext13,@ext14,@ext15)");
SqlParameter[] parameters = {
new SqlParameter("@userId", SqlDbType.Int,4),
new SqlParameter("@ext1", SqlDbType.VarChar,500),
new SqlParameter("@ext2", SqlDbType.VarChar,500),
new SqlParameter("@ext3", SqlDbType.VarChar,500),
new SqlParameter("@ext4", SqlDbType.VarChar,500),
new SqlParameter("@ext5", SqlDbType.VarChar,500),
new SqlParameter("@ext6", SqlDbType.VarChar,500),
new SqlParameter("@ext7", SqlDbType.VarChar,500),
new SqlParameter("@ext8", SqlDbType.VarChar,500),
new SqlParameter("@ext9", SqlDbType.VarChar,500),
new SqlParameter("@ext10", SqlDbType.VarChar,500),
new SqlParameter("@ext11", SqlDbType.VarChar,500),
new SqlParameter("@ext12", SqlDbType.VarChar,500),
new SqlParameter("@ext13", SqlDbType.VarChar,500),
new SqlParameter("@ext14", SqlDbType.VarChar,500),
new SqlParameter("@ext15", SqlDbType.VarChar,500)};
parameters[0].Value = model.userId;
parameters[1].Value = model.ext1;
parameters[2].Value = model.ext2;
parameters[3].Value = model.ext3;
parameters[4].Value = model.ext4;
parameters[5].Value = model.ext5;
parameters[6].Value = model.ext6;
parameters[7].Value = model.ext7;
parameters[8].Value = model.ext8;
parameters[9].Value = model.ext9;
parameters[10].Value = model.ext10;
parameters[11].Value = model.ext11;
parameters[12].Value = model.ext12;
parameters[13].Value = model.ext13;
parameters[14].Value = model.ext14;
parameters[15].Value = model.ext15;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.siteConfig model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into siteConfig(");
strSql.Append("name,logo,seoTitle,seoKeywords,seoDescription,copyright,contact,email,qq,phone,fax,address,icp,url,updateTime)");
strSql.Append(" values (");
strSql.Append("@name,@logo,@seoTitle,@seoKeywords,@seoDescription,@copyright,@contact,@email,@qq,@phone,@fax,@address,@icp,@url,@updateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,200),
new SqlParameter("@logo", SqlDbType.VarChar,200),
new SqlParameter("@seoTitle", SqlDbType.VarChar,200),
new SqlParameter("@seoKeywords", SqlDbType.VarChar,200),
new SqlParameter("@seoDescription", SqlDbType.VarChar,500),
new SqlParameter("@copyright", SqlDbType.VarChar),
new SqlParameter("@contact", SqlDbType.VarChar,200),
new SqlParameter("@email", SqlDbType.VarChar,200),
new SqlParameter("@qq", SqlDbType.VarChar,200),
new SqlParameter("@phone", SqlDbType.VarChar,200),
new SqlParameter("@fax", SqlDbType.VarChar,200),
new SqlParameter("@address", SqlDbType.VarChar,200),
new SqlParameter("@icp", SqlDbType.VarChar,200),
new SqlParameter("@url", SqlDbType.VarChar,200),
new SqlParameter("@updateTime", SqlDbType.DateTime)};
parameters[0].Value = model.name;
parameters[1].Value = model.logo;
parameters[2].Value = model.seoTitle;
parameters[3].Value = model.seoKeywords;
parameters[4].Value = model.seoDescription;
parameters[5].Value = model.copyright;
parameters[6].Value = model.contact;
parameters[7].Value = model.email;
parameters[8].Value = model.qq;
parameters[9].Value = model.phone;
parameters[10].Value = model.fax;
parameters[11].Value = model.address;
parameters[12].Value = model.icp;
parameters[13].Value = model.url;
parameters[14].Value = model.updateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.shoppingPayment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into shoppingPayment(");
strSql.Append("name,code,summary,returnUrl,notifyUrl,ico,gateUrl,filePath,parm1,parm2,parm3,parm4,parm5,status)");
strSql.Append(" values (");
strSql.Append("@name,@code,@summary,@returnUrl,@notifyUrl,@ico,@gateUrl,@filePath,@parm1,@parm2,@parm3,@parm4,@parm5,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,200),
new SqlParameter("@code", SqlDbType.VarChar,200),
new SqlParameter("@summary", SqlDbType.VarChar,500),
new SqlParameter("@returnUrl", SqlDbType.VarChar,500),
new SqlParameter("@notifyUrl", SqlDbType.VarChar,500),
new SqlParameter("@ico", SqlDbType.VarChar,200),
new SqlParameter("@gateUrl", SqlDbType.VarChar,500),
new SqlParameter("@filePath", SqlDbType.VarChar,500),
new SqlParameter("@parm1", SqlDbType.VarChar,500),
new SqlParameter("@parm2", SqlDbType.VarChar,500),
new SqlParameter("@parm3", SqlDbType.VarChar,500),
new SqlParameter("@parm4", SqlDbType.VarChar,500),
new SqlParameter("@parm5", SqlDbType.VarChar,500),
new SqlParameter("@status", SqlDbType.Int,4)};
parameters[0].Value = model.name;
parameters[1].Value = model.code;
parameters[2].Value = model.summary;
parameters[3].Value = model.returnUrl;
parameters[4].Value = model.notifyUrl;
parameters[5].Value = model.ico;
parameters[6].Value = model.gateUrl;
parameters[7].Value = model.filePath;
parameters[8].Value = model.parm1;
parameters[9].Value = model.parm2;
parameters[10].Value = model.parm3;
parameters[11].Value = model.parm4;
parameters[12].Value = model.parm5;
parameters[13].Value = model.status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.shoppingCart model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into shoppingCart(");
strSql.Append("orderId,userId,userName,storeId,storeName,goodsId,goodsName,goodsNum,goodsPrice,goodsPic,addTime,status)");
strSql.Append(" values (");
strSql.Append("@orderId,@userId,@userName,@storeId,@storeName,@goodsId,@goodsName,@goodsNum,@goodsPrice,@goodsPic,@addTime,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@orderId", SqlDbType.Int,4),
new SqlParameter("@userId", SqlDbType.Int,4),
new SqlParameter("@userName", SqlDbType.VarChar,200),
new SqlParameter("@storeId", SqlDbType.Int,4),
new SqlParameter("@storeName", SqlDbType.VarChar,200),
new SqlParameter("@goodsId", SqlDbType.Int,4),
new SqlParameter("@goodsName", SqlDbType.VarChar,200),
new SqlParameter("@goodsNum", SqlDbType.Int,4),
new SqlParameter("@goodsPrice", SqlDbType.Decimal,9),
new SqlParameter("@goodsPic", SqlDbType.VarChar,200),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int,4)};
parameters[0].Value = model.orderId;
parameters[1].Value = model.userId;
parameters[2].Value = model.userName;
parameters[3].Value = model.storeId;
parameters[4].Value = model.storeName;
parameters[5].Value = model.goodsId;
parameters[6].Value = model.goodsName;
parameters[7].Value = model.goodsNum;
parameters[8].Value = model.goodsPrice;
parameters[9].Value = model.goodsPic;
parameters[10].Value = model.addTime;
parameters[11].Value = model.status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.adv model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into adv(");
strSql.Append("title,apId,url,pic,remark,startDate,endDate,price,clickCount,orders,addTime,status)");
strSql.Append(" values (");
strSql.Append("@title,@apId,@url,@pic,@remark,@startDate,@endDate,@price,@clickCount,@orders,@addTime,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@title", SqlDbType.VarChar,200),
new SqlParameter("@apId", SqlDbType.Int,4),
new SqlParameter("@url", SqlDbType.VarChar,200),
new SqlParameter("@pic", SqlDbType.VarChar,200),
new SqlParameter("@remark", SqlDbType.VarChar),
new SqlParameter("@startDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@price", SqlDbType.Decimal,9),
new SqlParameter("@clickCount", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int,4)};
parameters[0].Value = model.title;
parameters[1].Value = model.apId;
parameters[2].Value = model.url;
parameters[3].Value = model.pic;
parameters[4].Value = model.remark;
parameters[5].Value = model.startDate;
parameters[6].Value = model.endDate;
parameters[7].Value = model.price;
parameters[8].Value = model.clickCount;
parameters[9].Value = model.orders;
parameters[10].Value = model.addTime;
parameters[11].Value = model.status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.role model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into role(");
strSql.Append("roleName)");
strSql.Append(" values (");
strSql.Append("@roleName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@roleName", SqlDbType.VarChar,100)};
parameters[0].Value = model.roleName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.goodsPic model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into goodsPic(");
strSql.Append("goodsId,goodsName,picSmall,picNormal,picBig,orders,isDefault,isShow,addTime)");
strSql.Append(" values (");
strSql.Append("@goodsId,@goodsName,@picSmall,@picNormal,@picBig,@orders,@isDefault,@isShow,@addTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@goodsId", SqlDbType.Int,4),
new SqlParameter("@goodsName", SqlDbType.VarChar,200),
new SqlParameter("@picSmall", SqlDbType.VarChar,200),
new SqlParameter("@picNormal", SqlDbType.VarChar,200),
new SqlParameter("@picBig", SqlDbType.VarChar,200),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@isDefault", SqlDbType.Int,4),
new SqlParameter("@isShow", SqlDbType.Int,4),
new SqlParameter("@addTime", SqlDbType.DateTime)};
parameters[0].Value = model.goodsId;
parameters[1].Value = model.goodsName;
parameters[2].Value = model.picSmall;
parameters[3].Value = model.picNormal;
parameters[4].Value = model.picBig;
parameters[5].Value = model.orders;
parameters[6].Value = model.isDefault;
parameters[7].Value = model.isShow;
parameters[8].Value = model.addTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.goodsStandPrice model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into goodsStandPrice(");
strSql.Append("goodsId,standId,standSecondId,standThirdId,marketPrice,storePrice,buyScore,stock,orders)");
strSql.Append(" values (");
strSql.Append("@goodsId,@standId,@standSecondId,@standThirdId,@marketPrice,@storePrice,@buyScore,@stock,@orders)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@goodsId", SqlDbType.Int,4),
new SqlParameter("@standId", SqlDbType.Int,4),
new SqlParameter("@standSecondId", SqlDbType.Int,4),
new SqlParameter("@standThirdId", SqlDbType.Int,4),
new SqlParameter("@marketPrice", SqlDbType.Decimal,9),
new SqlParameter("@storePrice", SqlDbType.Decimal,9),
new SqlParameter("@buyScore", SqlDbType.Int,4),
new SqlParameter("@stock", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4)};
parameters[0].Value = model.goodsId;
parameters[1].Value = model.standId;
parameters[2].Value = model.standSecondId;
parameters[3].Value = model.standThirdId;
parameters[4].Value = model.marketPrice;
parameters[5].Value = model.storePrice;
parameters[6].Value = model.buyScore;
parameters[7].Value = model.stock;
parameters[8].Value = model.orders;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.message model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into message(");
strSql.Append("receiverId,receiverName,senderId,senderName,title,remark,type,addTime,status)");
strSql.Append(" values (");
strSql.Append("@receiverId,@receiverName,@senderId,@senderName,@title,@remark,@type,@addTime,@status)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@receiverId", SqlDbType.Int,4),
new SqlParameter("@receiverName", SqlDbType.VarChar,200),
new SqlParameter("@senderId", SqlDbType.Int,4),
new SqlParameter("@senderName", SqlDbType.VarChar,200),
new SqlParameter("@title", SqlDbType.VarChar,200),
new SqlParameter("@remark", SqlDbType.VarChar),
new SqlParameter("@type", SqlDbType.Int,4),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int,4)};
parameters[0].Value = model.receiverId;
parameters[1].Value = model.receiverName;
parameters[2].Value = model.senderId;
parameters[3].Value = model.senderName;
parameters[4].Value = model.title;
parameters[5].Value = model.remark;
parameters[6].Value = model.type;
parameters[7].Value = model.addTime;
parameters[8].Value = model.status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.sysItem model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sysItem(");
strSql.Append("sicId,itemName,itemPath,back1,back2,back3,back4,orders)");
strSql.Append(" values (");
strSql.Append("@sicId,@itemName,@itemPath,@back1,@back2,@back3,@back4,@orders)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sicId", SqlDbType.Int,4),
new SqlParameter("@itemName", SqlDbType.VarChar,100),
new SqlParameter("@itemPath", SqlDbType.VarChar,200),
new SqlParameter("@back1", SqlDbType.VarChar,200),
new SqlParameter("@back2", SqlDbType.VarChar,200),
new SqlParameter("@back3", SqlDbType.VarChar,200),
new SqlParameter("@back4", SqlDbType.VarChar,200),
new SqlParameter("@orders", SqlDbType.Int,4)};
parameters[0].Value = model.sicId;
parameters[1].Value = model.itemName;
parameters[2].Value = model.itemPath;
parameters[3].Value = model.back1;
parameters[4].Value = model.back2;
parameters[5].Value = model.back3;
parameters[6].Value = model.back4;
parameters[7].Value = model.orders;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.goodsStand model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into goodsStand(");
strSql.Append("catId,name,parentId,isShow,orders,path,pic,summary)");
strSql.Append(" values (");
strSql.Append("@catId,@name,@parentId,@isShow,@orders,@path,@pic,@summary)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@catId", SqlDbType.Int,4),
new SqlParameter("@name", SqlDbType.VarChar,200),
new SqlParameter("@parentId", SqlDbType.Int,4),
new SqlParameter("@isShow", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@path", SqlDbType.VarChar,200),
new SqlParameter("@pic", SqlDbType.VarChar,200),
new SqlParameter("@summary", SqlDbType.VarChar,500)};
parameters[0].Value = model.catId;
parameters[1].Value = model.name;
parameters[2].Value = model.parentId;
parameters[3].Value = model.isShow;
parameters[4].Value = model.orders;
parameters[5].Value = model.path;
parameters[6].Value = model.pic;
parameters[7].Value = model.summary;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.roleMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into roleMenu(");
strSql.Append("roleId,menuId)");
strSql.Append(" values (");
strSql.Append("@roleId,@menuId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@roleId", SqlDbType.Int,4),
new SqlParameter("@menuId", SqlDbType.Int,4)};
parameters[0].Value = model.roleId;
parameters[1].Value = model.menuId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.sysItemCategory model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sysItemCategory(");
strSql.Append("innerName,catName)");
strSql.Append(" values (");
strSql.Append("@innerName,@catName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@innerName", SqlDbType.VarChar,100),
new SqlParameter("@catName", SqlDbType.VarChar,100)};
parameters[0].Value = model.innerName;
parameters[1].Value = model.catName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.roleMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update roleMenu set ");
strSql.Append("roleId=@roleId,");
strSql.Append("menuId=@menuId");
strSql.Append(" where rmId=@rmId");
SqlParameter[] parameters = {
new SqlParameter("@roleId", SqlDbType.Int,4),
new SqlParameter("@menuId", SqlDbType.Int,4),
new SqlParameter("@rmId", SqlDbType.Int,4)};
parameters[0].Value = model.roleId;
parameters[1].Value = model.menuId;
parameters[2].Value = model.rmId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.menu model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.menu model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.t_province model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.t_province model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.t_distinct model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.t_distinct model)
{
return dal.Add(model);
}
public ChannelSpellDescriptor(hm instance) : base(instance)
{
_internal = instance;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.adv model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update adv set ");
strSql.Append("title=@title,");
strSql.Append("apId=@apId,");
strSql.Append("url=@url,");
strSql.Append("pic=@pic,");
strSql.Append("remark=@remark,");
strSql.Append("startDate=@startDate,");
strSql.Append("endDate=@endDate,");
strSql.Append("price=@price,");
strSql.Append("clickCount=@clickCount,");
strSql.Append("orders=@orders,");
strSql.Append("addTime=@addTime,");
strSql.Append("status=@status");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@title", SqlDbType.VarChar,200),
new SqlParameter("@apId", SqlDbType.Int,4),
new SqlParameter("@url", SqlDbType.VarChar,200),
new SqlParameter("@pic", SqlDbType.VarChar,200),
new SqlParameter("@remark", SqlDbType.VarChar),
new SqlParameter("@startDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@price", SqlDbType.Decimal,9),
new SqlParameter("@clickCount", SqlDbType.Int,4),
new SqlParameter("@orders", SqlDbType.Int,4),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.title;
parameters[1].Value = model.apId;
parameters[2].Value = model.url;
parameters[3].Value = model.pic;
parameters[4].Value = model.remark;
parameters[5].Value = model.startDate;
parameters[6].Value = model.endDate;
parameters[7].Value = model.price;
parameters[8].Value = model.clickCount;
parameters[9].Value = model.orders;
parameters[10].Value = model.addTime;
parameters[11].Value = model.status;
parameters[12].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.users model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(hm.Model.users model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(hm.Model.news model)
{
return dal.Add(model);
}
