/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.Product_ProperValue model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Product_ProperValue("); strSql.Append("productId,properValueId,properValueText,properId,parentId)"); strSql.Append(" values ("); strSql.Append("@productId,@properValueId,@properValueText,@properId,@parentId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@properValueId", SqlDbType.Int, 4), new SqlParameter("@properValueText", SqlDbType.VarChar, 2000), new SqlParameter("@properId", SqlDbType.Int, 4), new SqlParameter("@parentId", SqlDbType.Int, 4) }; parameters[0].Value = model.productId; parameters[1].Value = model.properValueId; parameters[2].Value = model.properValueText; parameters[3].Value = model.properId; parameters[4].Value = model.parentId; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.NewsType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NewsType("); strSql.Append("name,parentId,status,remark,typedesc,pagename)"); strSql.Append(" values ("); strSql.Append("@name,@parentId,@status,@remark,@typedesc,@pagename)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@parentId", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@typedesc", SqlDbType.NText), new SqlParameter("@pagename",SqlDbType.VarChar, 1000) }; parameters[0].Value = model.name; parameters[1].Value = model.parentId; parameters[2].Value = model.status; parameters[3].Value = model.remark; parameters[4].Value = model.typedesc; parameters[5].Value = model.pagename; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.CartTemp model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CartTemp("); strSql.Append("productId,productCount,addUser,status,remark,sel)"); strSql.Append(" values ("); strSql.Append("@productId,@productCount,@addUser,@status,@remark," + model.sel + ")"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@productCount", SqlDbType.Int, 4), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 50) }; parameters[0].Value = model.productId; parameters[1].Value = model.productCount; parameters[2].Value = model.addUser; parameters[3].Value = model.status; parameters[4].Value = model.remark; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into News("); strSql.Append("title,pageName,newsType,newImg,newsContent,keyword,newsDesc,linkurl,is_tj,is_hot,ordernum,addTime,add_userid,res_views,areaid,sid,releaseTime,author)"); strSql.Append(" values ("); strSql.Append("@title,@pageName,@newsType,@newImg,@newsContent,@keyword,@newsDesc,@linkurl,@is_tj,@is_hot,@ordernum,@addTime,@add_userid,@res_views,@areaid,@sid,@releaseTime,@author)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar, 200), new SqlParameter("@pageName", SqlDbType.NText), new SqlParameter("@newsType", SqlDbType.Int, 4), new SqlParameter("@newImg", SqlDbType.VarChar, 500), new SqlParameter("@newsContent", SqlDbType.NText), new SqlParameter("@keyword", SqlDbType.VarChar, 250), new SqlParameter("@newsDesc", SqlDbType.NText), new SqlParameter("@linkurl", SqlDbType.VarChar, 250), new SqlParameter("@is_tj", SqlDbType.Int, 1), new SqlParameter("@is_hot", SqlDbType.Int, 4), new SqlParameter("@ordernum", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@add_userid", SqlDbType.Int, 4), new SqlParameter("@res_views", SqlDbType.Int, 4), new SqlParameter("@areaid", SqlDbType.Int, 4), new SqlParameter("@sid", SqlDbType.VarChar, 500), new SqlParameter("@releaseTime", SqlDbType.DateTime), new SqlParameter("@author", SqlDbType.VarChar, 50) }; parameters[0].Value = model.title; parameters[1].Value = model.pageName; parameters[2].Value = model.newsType; parameters[3].Value = model.newImg; parameters[4].Value = model.newsContent; parameters[5].Value = model.keyword; parameters[6].Value = model.newsDesc; parameters[7].Value = model.linkurl; parameters[8].Value = model.is_tj; parameters[9].Value = model.is_hot; parameters[10].Value = model.ordernum; parameters[11].Value = model.addTime; parameters[12].Value = model.add_userid; parameters[13].Value = model.res_views; parameters[14].Value = model.areaid; parameters[15].Value = model.sid; parameters[16].Value = model.releaseTime; parameters[17].Value = model.author; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(SysPrivileges model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SysPrivileges("); strSql.Append("roleId,departmentId,levelNo,parentLevelNo)"); strSql.Append(" values ("); strSql.Append("@roleId,@departmentId,@levelNo,@parentLevelNo)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@roleId", SqlDbType.Int, 4), new SqlParameter("@departmentId", SqlDbType.Int, 4), new SqlParameter("@levelNo", SqlDbType.Int, 4), new SqlParameter("@parentLevelNo", SqlDbType.Int, 4) }; parameters[0].Value = model.roleId; parameters[1].Value = model.departmentId; parameters[2].Value = model.levelNo; parameters[3].Value = model.parentLevelNo; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取子权限信息总Quantity /// </summary> /// <param name="levelNo"></param> /// <returns></returns> public static int GetSonCount(int roleId, int departId) { string sql = "select count(levelNo) from SysPrivileges where roleId = " + roleId + " and departmentId = " + departId + " and parentLevelNo <> 0"; object obj = DBHelperSQL.GetSingle(sql); return(Convert.ToInt32(obj)); }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.OrderInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OrderInfo("); strSql.Append("orderNo,orderName,proTotal,sendTotal,orderTotal,orderDesc,remark,recieveUser,pid,PName,cid,CName,regionId,ReginName,address,mobile,tel,status,addTime,infoType,addUser)"); strSql.Append(" values ("); strSql.Append("@orderNo,@orderName,@proTotal,@sendTotal,@orderTotal,@orderDesc,@remark,@recieveUser,@pid,@PName,@cid,@CName,@regionId,@ReginName,@address,@mobile,@tel,@status,@addTime,@infoType,@addUser)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@orderNo", SqlDbType.VarChar,50), new SqlParameter("@orderName", SqlDbType.VarChar,100), new SqlParameter("@proTotal", SqlDbType.Money,8), new SqlParameter("@sendTotal", SqlDbType.Money,8), new SqlParameter("@orderTotal", SqlDbType.Money,8), new SqlParameter("@orderDesc", SqlDbType.VarChar,150), new SqlParameter("@remark", SqlDbType.VarChar,150), new SqlParameter("@recieveUser", SqlDbType.VarChar,50), new SqlParameter("@pid", SqlDbType.Int,4), new SqlParameter("@PName", SqlDbType.VarChar,50), new SqlParameter("@cid", SqlDbType.Int,4), new SqlParameter("@CName", SqlDbType.VarChar,50), new SqlParameter("@regionId", SqlDbType.Int,4), new SqlParameter("@ReginName", SqlDbType.VarChar,50), new SqlParameter("@address", SqlDbType.VarChar,150), new SqlParameter("@mobile", SqlDbType.VarChar,20), new SqlParameter("@tel", SqlDbType.VarChar,20), new SqlParameter("@status", SqlDbType.Int,4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@infoType", SqlDbType.Int,4),new SqlParameter("@addUser",SqlDbType.Int,4)}; parameters[0].Value = model.orderNo; parameters[1].Value = model.orderName; parameters[2].Value = model.proTotal; parameters[3].Value = model.sendTotal; parameters[4].Value = model.orderTotal; parameters[5].Value = model.orderDesc; parameters[6].Value = model.remark; parameters[7].Value = model.recieveUser; parameters[8].Value = model.pid; parameters[9].Value = model.PName; parameters[10].Value = model.cid; parameters[11].Value = model.CName; parameters[12].Value = model.regionId; parameters[13].Value = model.ReginName; parameters[14].Value = model.address; parameters[15].Value = model.mobile; parameters[16].Value = model.tel; parameters[17].Value = model.status; parameters[18].Value = model.addTime; parameters[19].Value = model.infoType; parameters[20].Value = model.addUser; object obj = DBHelperSQL.GetSingle(strSql.ToString(),parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.EmailCode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into EmailCode("); strSql.Append("email,emailCode,status,remark,infoType)"); strSql.Append(" values ("); strSql.Append("@email,@emailCode,@status,@remark,@infoType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@emailCode", SqlDbType.VarChar, 50), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.email; parameters[1].Value = model.emailCode; parameters[2].Value = model.status; parameters[3].Value = model.remark; parameters[4].Value = model.infoType; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.KeyWordInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into KeyWordInfo("); strSql.Append("pageName,title,keyword,description,pageNameValue)"); strSql.Append(" values ("); strSql.Append("@pageName,@title,@keyword,@description,@pageNameValue)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@pageName", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 50), new SqlParameter("@keyword", SqlDbType.VarChar, 150), new SqlParameter("@description", SqlDbType.VarChar, 350), new SqlParameter("@pageNameValue", SqlDbType.VarChar, 50) }; parameters[0].Value = model.pageName; parameters[1].Value = model.title; parameters[2].Value = model.keyword; parameters[3].Value = model.description; parameters[4].Value = model.pageNameValue; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.Links model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Links("); strSql.Append("linkname,linktitle,linkurl,addtime,isTj)"); strSql.Append(" values ("); strSql.Append("@linkname,@linktitle,@linkurl,@addtime,@isTj)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@linkname", SqlDbType.NVarChar, 50), new SqlParameter("@linktitle", SqlDbType.VarChar, 100), new SqlParameter("@linkurl", SqlDbType.NVarChar, 500), new SqlParameter("@addtime", SqlDbType.DateTime), new SqlParameter("@isTj",SqlDbType.Int, 4) }; parameters[0].Value = model.linkname; parameters[1].Value = model.linktitle; parameters[2].Value = model.linkurl; parameters[3].Value = model.addtime; parameters[4].Value = model.istj; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.UserMemberInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserMemberInfo("); strSql.Append("userId,memCount,isHaveAccountUser,manageMemCount,taskUserWorkYears,busiUserName,tel,address,zipCode,email,fax,instituteDesc,status,remark,addTime,addUser,infoType)"); strSql.Append(" values ("); strSql.Append("@userId,@memCount,@isHaveAccountUser,@manageMemCount,@taskUserWorkYears,@busiUserName,@tel,@address,@zipCode,@email,@fax,@instituteDesc,@status,@remark,@addTime,@addUser,@infoType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@memCount", SqlDbType.Int, 4), new SqlParameter("@isHaveAccountUser", SqlDbType.Int, 4), new SqlParameter("@manageMemCount", SqlDbType.Int, 4), new SqlParameter("@taskUserWorkYears", SqlDbType.Int, 4), new SqlParameter("@busiUserName", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@zipCode", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@fax", SqlDbType.VarChar, 50), new SqlParameter("@instituteDesc", SqlDbType.NText), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.userId; parameters[1].Value = model.memCount; parameters[2].Value = model.isHaveAccountUser; parameters[3].Value = model.manageMemCount; parameters[4].Value = model.taskUserWorkYears; parameters[5].Value = model.busiUserName; parameters[6].Value = model.tel; parameters[7].Value = model.address; parameters[8].Value = model.zipCode; parameters[9].Value = model.email; parameters[10].Value = model.fax; parameters[11].Value = model.instituteDesc; parameters[12].Value = model.status; parameters[13].Value = model.remark; parameters[14].Value = model.addTime; parameters[15].Value = model.addUser; parameters[16].Value = model.infoType; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.Comment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Comment("); strSql.Append("orderId,orderNo,productId,commentType,dataType,fromId,commentInfo,commentDesc,img1Url,img2Url,img3Url,img4Url,status,remark,addTime,addUser,infoType)"); strSql.Append(" values ("); strSql.Append("@orderId,@orderNo,@productId,@commentType,@dataType,@fromId,@commentInfo,@commentDesc,@img1Url,@img2Url,@img3Url,@img4Url,@status,@remark,@addTime,@addUser,@infoType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@orderNo", SqlDbType.VarChar, 50), new SqlParameter("@productId", SqlDbType.Int, 4), new SqlParameter("@commentType", SqlDbType.Int, 4), new SqlParameter("@dataType", SqlDbType.Int, 4), new SqlParameter("@fromId", SqlDbType.Int, 4), new SqlParameter("@commentInfo", SqlDbType.VarChar, 1500), new SqlParameter("@commentDesc", SqlDbType.VarChar, 150), new SqlParameter("@img1Url", SqlDbType.VarChar, 150), new SqlParameter("@img2Url", SqlDbType.VarChar, 150), new SqlParameter("@img3Url", SqlDbType.VarChar, 150), new SqlParameter("@img4Url", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.orderId; parameters[1].Value = model.orderNo; parameters[2].Value = model.productId; parameters[3].Value = model.commentType; parameters[4].Value = model.dataType; parameters[5].Value = model.fromId; parameters[6].Value = model.commentInfo; parameters[7].Value = model.commentDesc; parameters[8].Value = model.img1Url; parameters[9].Value = model.img2Url; parameters[10].Value = model.img3Url; parameters[11].Value = model.img4Url; parameters[12].Value = model.status; parameters[13].Value = model.remark; parameters[14].Value = model.addTime; parameters[15].Value = model.addUser; parameters[16].Value = model.infoType; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.UserAddress model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserAddress("); strSql.Append("relName,mobile,tel,qq,weixin,zipcode,pid,cid,regionId,address,addressDetail,status,remark,addTime,addUser,infoType)"); strSql.Append(" values ("); strSql.Append("@relName,@mobile,@tel,@qq,@weixin,@zipcode,@pid,@cid,@regionId,@address,@addressDetail,@status,@remark,@addTime,@addUser,@infoType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@relName", SqlDbType.VarChar, 50), new SqlParameter("@mobile", SqlDbType.VarChar, 50), new SqlParameter("@tel", SqlDbType.VarChar, 50), new SqlParameter("@qq", SqlDbType.VarChar, 50), new SqlParameter("@weixin", SqlDbType.VarChar, 50), new SqlParameter("@zipcode", SqlDbType.VarChar, 50), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@addressDetail", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.relName; parameters[1].Value = model.mobile; parameters[2].Value = model.tel; parameters[3].Value = model.qq; parameters[4].Value = model.weixin; parameters[5].Value = model.zipcode; parameters[6].Value = model.pid; parameters[7].Value = model.cid; parameters[8].Value = model.regionId; parameters[9].Value = model.address; parameters[10].Value = model.addressDetail; parameters[11].Value = model.status; parameters[12].Value = model.remark; parameters[13].Value = model.addTime; parameters[14].Value = model.addUser; parameters[15].Value = model.infoType; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.Common_OnlineMessage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Common_OnlineMessage("); strSql.Append("typeId,objId,name,mobile,tel,qq,email,address,title,mesContent,imgURL,remark,ip,status,addTime,infoType)"); strSql.Append(" values ("); strSql.Append("@typeId,@objId,@name,@mobile,@tel,@qq,@email,@address,@title,@mesContent,@imgURL,@remark,@ip,@status,@addTime,@infoType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@typeId", SqlDbType.Int, 4), new SqlParameter("@objId", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 20), new SqlParameter("@mobile", SqlDbType.VarChar, 20), new SqlParameter("@tel", SqlDbType.VarChar, 20), new SqlParameter("@qq", SqlDbType.VarChar, 20), new SqlParameter("@email", SqlDbType.VarChar, 20), new SqlParameter("@address", SqlDbType.VarChar, 100), new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@mesContent", SqlDbType.NText), new SqlParameter("@imgURL", SqlDbType.VarChar, 50), new SqlParameter("@remark", SqlDbType.VarChar, 500), new SqlParameter("@ip", SqlDbType.VarChar, 20), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@infoType", SqlDbType.Int, 4) }; parameters[0].Value = model.typeId; parameters[1].Value = model.objId; parameters[2].Value = model.name; parameters[3].Value = model.mobile; parameters[4].Value = model.tel; parameters[5].Value = model.qq; parameters[6].Value = model.email; parameters[7].Value = model.address; parameters[8].Value = model.title; parameters[9].Value = model.mesContent; parameters[10].Value = model.imgURL; parameters[11].Value = model.remark; parameters[12].Value = model.ip; parameters[13].Value = model.status; parameters[14].Value = model.addTime; parameters[15].Value = model.infoType; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 月订单Quantity /// </summary> /// <param name="userId"></param> /// <returns></returns> public static int GetMonthCount(int userId) { string sql = "select count(id) from OrderInfo where addUser = "******" and addTime >= '" + DateTime.Now.AddDays(-30) +"'"; object obj = DBHelperSQL.GetSingle(sql); if(obj != null) { return Convert.ToInt32(obj); } return 0; }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.UserBussState model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserBussState("); strSql.Append("businessArea,isHaveSeperate,serverPid,serverCid,serverRegionId,serverAddress,status,remark,addTime,addUser,infoType,serverPName,serverCName,serverRName)"); strSql.Append(" values ("); strSql.Append("@businessArea,@isHaveSeperate,@serverPid,@serverCid,@serverRegionId,@serverAddress,@status,@remark,@addTime,@addUser,@infoType,@serverPName,@serverCName,@serverRName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@businessArea", SqlDbType.VarChar, 1500), new SqlParameter("@isHaveSeperate", SqlDbType.VarChar, 1504), new SqlParameter("@serverPid", SqlDbType.VarChar, 1504), new SqlParameter("@serverCid", SqlDbType.Int, 4), new SqlParameter("@serverRegionId", SqlDbType.Int, 4), new SqlParameter("@serverAddress", SqlDbType.NText), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@remark", SqlDbType.VarChar, 1500), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@addUser", SqlDbType.Int, 4), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@serverPName", SqlDbType.VarChar, 1500), new SqlParameter("@serverCName", SqlDbType.VarChar, 1500), new SqlParameter("@serverRName", SqlDbType.NText) }; parameters[0].Value = model.businessArea; parameters[1].Value = model.isHaveSeperate; parameters[2].Value = model.serverPid; parameters[3].Value = model.serverCid; parameters[4].Value = model.serverRegionId; parameters[5].Value = model.serverAddress; parameters[6].Value = model.status; parameters[7].Value = model.remark; parameters[8].Value = model.addTime; parameters[9].Value = model.addUser; parameters[10].Value = model.infoType; parameters[11].Value = model.serverPName; parameters[12].Value = model.serverCName; parameters[13].Value = model.serverRName; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取Username /// </summary> /// <param name="userId"></param> /// <returns></returns> public static string GetUserName(int userId) { string sql = "select username from UserInfo where id = " + userId; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(obj.ToString()); } return(""); }
/// <summary> /// 发布该产品的经销商总数 /// </summary> /// <param name="p1"></param> /// <returns></returns> public static int GetCount_Product(Product p1) { string sql = "select count(id) from UserInfo where id in(select addUser from Product where productType = " + p1.productType + " and proType = " + p1.proType + " and rankingType = " + p1.rankingType + " and proGradeName = '" + p1.proGradeName + "')"; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 获取浏览次数 /// </summary> /// <param name="comId"></param> /// <returns></returns> public static int GetViews(int comId) { string sql = "select viewsCount from UserInfo where id = " + comId; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 获取信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetById(int id) { string sql = "select proValue from AboutMenu where id = " + id; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(obj.ToString()); } return(""); }
/// <summary> /// 根据图片路径获取URL /// </summary> /// <param name="src"></param> /// <returns></returns> public static string GetUrl(string src) { string sql = "select linkurl from FriendsInfo where img1path = '" + src + "'"; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(obj.ToString()); } return(""); }
/// <summary> /// 查询订单产品Quantity /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int GetProductCount(int orderId) { string sql = "select sum(productCount) from OrderDetail where orderId = " + orderId; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 查询一级权限的最大权限ID /// </summary> /// <returns></returns> public static int GetMaxLevelNo(int parentLevelNo) { string sql = "select top 1 levelNo from OALevel where parentLevelNo = " + parentLevelNo + " order by id desc"; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj) + 1); } return(Convert.ToInt32(parentLevelNo.ToString() + "01")); }
/// <summary> /// 根据问题查询回答问题的Quantity /// </summary> /// <param name="questionId"></param> /// <returns></returns> public static int GetAnswerCount(int questionId) { string sql = "select count(*) from AnswerInfo where questionId = " + questionId; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="productId"></param> /// <param name="id"></param> /// <returns></returns> public static bool Exists(object productId, object id) { string sql = "select top 1 * from Comment where productId = " + productId + " and orderId = " + id; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(true); } return(false); }
/// <summary> /// 根据医生Id回答记录Quantity /// </summary> /// <param name="userid"></param> /// <returns></returns> public static int GetAnswerCountByAddUser(int userid) { string sql = "select count(id) from AnswerInfo where addUser = " + userid; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 查询未读信息Quantity /// </summary> /// <param name="shoperId"></param> /// <returns></returns> public static int GetMesCount(int shoperId) { string sql = "select count(*) from Message where shopId = " + shoperId + " and status = 0"; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(Convert.ToInt32(obj)); } return(0); }
/// <summary> /// 获取I am aItem Name /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetById(int id) { string sql = "select typeName from TypeInfo where id = " + id; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(obj.ToString()); } return(""); }
/// <summary> /// 获取地区Item Name /// </summary> /// <param name="id"></param> /// <returns></returns> public static string GetName(int id) { string sql = "select areaName from AreaInfo where id = " + id; object obj = DBHelperSQL.GetSingle(sql); if (obj != null) { return(obj.ToString()); } return(""); }
/// <summary> /// 首页套餐I am a排名图片 /// </summary> /// <param name="orderNum"></param> /// <returns></returns> public static string GetImg(int orderNum) { string sql = "select remark from BaseConfig where parentId = " + orderNum; object obj = DBHelperSQL.GetSingle(sql); if (obj != DBNull.Value && obj != null) { return(obj.ToString()); } return("in_pbg4.png"); }