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