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