/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.webInfoTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into webInfoTb(");
strSql.Append("webName,logoURL,lastPub)");
strSql.Append(" values (");
strSql.Append("@webName,@logoURL,@lastPub)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@webName", SqlDbType.NVarChar,100),
new SqlParameter("@logoURL", SqlDbType.NVarChar,150),
new SqlParameter("@lastPub", SqlDbType.DateTime)};
parameters[0].Value = model.webName;
parameters[1].Value = model.logoURL;
parameters[2].Value = model.lastPub;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.reportTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into reportTb(");
strSql.Append("noveltyID,reporterID,reportTime,reportTypeID,state)");
strSql.Append(" values (");
strSql.Append("@noveltyID,@reporterID,@reportTime,@reportTypeID,@state)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@noveltyID", SqlDbType.Int,4),
new SqlParameter("@reporterID", SqlDbType.Int,4),
new SqlParameter("@reportTime", SqlDbType.DateTime),
new SqlParameter("@reportTypeID", SqlDbType.Int,4),
new SqlParameter("@state", SqlDbType.NVarChar,50)};
parameters[0].Value = model.noveltyID;
parameters[1].Value = model.reporterID;
parameters[2].Value = model.reportTime;
parameters[3].Value = model.reportTypeID;
parameters[4].Value = model.state;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.LTsectionTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into LTsectionTb(");
strSql.Append("sectionName,sectionImg,sectionIntro,adminID,state)");
strSql.Append(" values (");
strSql.Append("@sectionName,@sectionImg,@sectionIntro,@adminID,@state)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sectionName", SqlDbType.NVarChar,50),
new SqlParameter("@sectionImg", SqlDbType.VarChar,500),
new SqlParameter("@sectionIntro", SqlDbType.NVarChar,500),
new SqlParameter("@adminID", SqlDbType.Int,4),
new SqlParameter("@state", SqlDbType.NVarChar,50)};
parameters[0].Value = model.sectionName;
parameters[1].Value = model.sectionImg;
parameters[2].Value = model.sectionIntro;
parameters[3].Value = model.adminID;
parameters[4].Value = model.state;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.eventsTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into eventsTb(");
strSql.Append("operatorID,operateAction,operateContent,operateTime)");
strSql.Append(" values (");
strSql.Append("@operatorID,@operateAction,@operateContent,@operateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@operatorID", SqlDbType.Int,4),
new SqlParameter("@operateAction", SqlDbType.NVarChar,50),
new SqlParameter("@operateContent", SqlDbType.NVarChar,500),
new SqlParameter("@operateTime", SqlDbType.DateTime)};
parameters[0].Value = model.operatorID;
parameters[1].Value = model.operateAction;
parameters[2].Value = model.operateContent;
parameters[3].Value = model.operateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.fansTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into fansTb(");
strSql.Append("ownID,ownedID,ownedName,groupID)");
strSql.Append(" values (");
strSql.Append("@ownID,@ownedID,@ownedName,@groupID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ownID", SqlDbType.Int,4),
new SqlParameter("@ownedID", SqlDbType.Int,4),
new SqlParameter("@ownedName", SqlDbType.NVarChar,50),
new SqlParameter("@groupID", SqlDbType.Int,4)};
parameters[0].Value = model.ownID;
parameters[1].Value = model.ownedID;
parameters[2].Value = model.ownedName;
parameters[3].Value = model.groupID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.noveltyImagesTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into noveltyImagesTb(");
strSql.Append("noveltyID,imgUrl,smallImgUrl)");
strSql.Append(" values (");
strSql.Append("@noveltyID,@imgUrl,@smallImgUrl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@noveltyID", SqlDbType.Int,4),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,100),
new SqlParameter("@smallImgUrl", SqlDbType.NVarChar,50)};
parameters[0].Value = model.noveltyID;
parameters[1].Value = model.imgUrl;
parameters[2].Value = model.smallImgUrl;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.noticeTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into noticeTb(");
strSql.Append("adminID,title,contents,sentTime,state,receiveID)");
strSql.Append(" values (");
strSql.Append("@adminID,@title,@contents,@sentTime,@state,@receiveID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@adminID", SqlDbType.Int,4),
new SqlParameter("@title", SqlDbType.NVarChar,50),
new SqlParameter("@contents", SqlDbType.NVarChar,500),
new SqlParameter("@sentTime", SqlDbType.DateTime),
new SqlParameter("@state", SqlDbType.NVarChar,50),
new SqlParameter("@receiveID", SqlDbType.Int,4)};
parameters[0].Value = model.adminID;
parameters[1].Value = model.title;
parameters[2].Value = model.contents;
parameters[3].Value = model.sentTime;
parameters[4].Value = model.state;
parameters[5].Value = model.receiveID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.adminTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into adminTb(");
strSql.Append("adminName,adminPwd,adminEmail,adminLevel)");
strSql.Append(" values (");
strSql.Append("@adminName,@adminPwd,@adminEmail,@adminLevel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@adminName", SqlDbType.NVarChar,50),
new SqlParameter("@adminPwd", SqlDbType.VarChar,50),
new SqlParameter("@adminEmail", SqlDbType.NVarChar,50),
new SqlParameter("@adminLevel", SqlDbType.Int,4)};
parameters[0].Value = model.adminName;
parameters[1].Value = model.adminPwd;
parameters[2].Value = model.adminEmail;
parameters[3].Value = model.adminLevel;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(littleworld.Model.photoTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into photoTb(");
strSql.Append("photoID,ownID,description,imgUrl,photoGroupID,creatTime,littleImgUrl)");
strSql.Append(" values (");
strSql.Append("@photoID,@ownID,@description,@imgUrl,@photoGroupID,@creatTime,@littleImgUrl)");
SqlParameter[] parameters = {
new SqlParameter("@photoID", SqlDbType.Int,4),
new SqlParameter("@ownID", SqlDbType.Int,4),
new SqlParameter("@description", SqlDbType.NVarChar,50),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,50),
new SqlParameter("@photoGroupID", SqlDbType.Int,4),
new SqlParameter("@creatTime", SqlDbType.DateTime),
new SqlParameter("@littleImgUrl", SqlDbType.NVarChar,50)};
parameters[0].Value = model.photoID;
parameters[1].Value = model.ownID;
parameters[2].Value = model.description;
parameters[3].Value = model.imgUrl;
parameters[4].Value = model.photoGroupID;
parameters[5].Value = model.creatTime;
parameters[6].Value = model.littleImgUrl;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.userTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into userTb(");
strSql.Append("userName,userEmail,userPwd,headImgUrl,sex,addr,age,primarySchool,juniorSchool,highSchool,collegeSchool,interstID,state,groupID,reprotNum,skinID)");
strSql.Append(" values (");
strSql.Append("@userName,@userEmail,@userPwd,@headImgUrl,@sex,@addr,@age,@primarySchool,@juniorSchool,@highSchool,@collegeSchool,@interstID,@state,@groupID,@reprotNum,@skinID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@userName", SqlDbType.NVarChar,50),
new SqlParameter("@userEmail", SqlDbType.VarChar,50),
new SqlParameter("@userPwd", SqlDbType.VarChar,50),
new SqlParameter("@headImgUrl", SqlDbType.VarChar,500),
new SqlParameter("@sex", SqlDbType.NVarChar,50),
new SqlParameter("@addr", SqlDbType.NVarChar,50),
new SqlParameter("@age", SqlDbType.Int,4),
new SqlParameter("@primarySchool", SqlDbType.NVarChar,50),
new SqlParameter("@juniorSchool", SqlDbType.NVarChar,50),
new SqlParameter("@highSchool", SqlDbType.NVarChar,50),
new SqlParameter("@collegeSchool", SqlDbType.NVarChar,50),
new SqlParameter("@interstID", SqlDbType.Int,4),
new SqlParameter("@state", SqlDbType.NVarChar,50),
new SqlParameter("@groupID", SqlDbType.Int,4),
new SqlParameter("@reprotNum", SqlDbType.Int,4),
new SqlParameter("@skinID", SqlDbType.Int,4)};
parameters[0].Value = model.userName;
parameters[1].Value = model.userEmail;
parameters[2].Value = model.userPwd;
parameters[3].Value = model.headImgUrl;
parameters[4].Value = model.sex;
parameters[5].Value = model.addr;
parameters[6].Value = model.age;
parameters[7].Value = model.primarySchool;
parameters[8].Value = model.juniorSchool;
parameters[9].Value = model.highSchool;
parameters[10].Value = model.collegeSchool;
parameters[11].Value = model.interstID;
parameters[12].Value = model.state;
parameters[13].Value = model.groupID;
parameters[14].Value = model.reprotNum;
parameters[15].Value = model.skinID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.noveltyTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into noveltyTb(");
strSql.Append("senderID,contents,state,hasImgs,typeID,commentNum,supportNum,reportNum,transmitNum,publishtime)");
strSql.Append(" values (");
strSql.Append("@senderID,@contents,@state,@hasImgs,@typeID,@commentNum,@supportNum,@reportNum,@transmitNum,@publishtime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@senderID", SqlDbType.Int,4),
new SqlParameter("@contents", SqlDbType.NVarChar,500),
new SqlParameter("@state", SqlDbType.NVarChar,50),
new SqlParameter("@hasImgs", SqlDbType.Int,4),
new SqlParameter("@typeID", SqlDbType.Int,4),
new SqlParameter("@commentNum", SqlDbType.Int,4),
new SqlParameter("@supportNum", SqlDbType.Int,4),
new SqlParameter("@reportNum", SqlDbType.Int,4),
new SqlParameter("@transmitNum", SqlDbType.Int,4),
new SqlParameter("@publishtime", SqlDbType.DateTime)};
parameters[0].Value = model.senderID;
parameters[1].Value = model.contents;
parameters[2].Value = model.state;
parameters[3].Value = model.hasImgs;
parameters[4].Value = model.typeID;
parameters[5].Value = model.commentNum;
parameters[6].Value = model.supportNum;
parameters[7].Value = model.reportNum;
parameters[8].Value = model.transmitNum;
parameters[9].Value = model.publishtime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.LTnoteTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into LTnoteTb(");
strSql.Append("sectionID,senderID,NContent,NCommentNum,NSupportNum,NReportNum,NTransmitNum,NPublishtime,NState,parentNoteID)");
strSql.Append(" values (");
strSql.Append("@sectionID,@senderID,@NContent,@NCommentNum,@NSupportNum,@NReportNum,@NTransmitNum,@NPublishtime,@NState,@parentNoteID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@sectionID", SqlDbType.Int,4),
new SqlParameter("@senderID", SqlDbType.Int,4),
new SqlParameter("@NContent", SqlDbType.NVarChar,3000),
new SqlParameter("@NCommentNum", SqlDbType.Int,4),
new SqlParameter("@NSupportNum", SqlDbType.Int,4),
new SqlParameter("@NReportNum", SqlDbType.Int,4),
new SqlParameter("@NTransmitNum", SqlDbType.Int,4),
new SqlParameter("@NPublishtime", SqlDbType.DateTime),
new SqlParameter("@NState", SqlDbType.NVarChar,50),
new SqlParameter("@parentNoteID", SqlDbType.Int,4)};
parameters[0].Value = model.sectionID;
parameters[1].Value = model.senderID;
parameters[2].Value = model.NContent;
parameters[3].Value = model.NCommentNum;
parameters[4].Value = model.NSupportNum;
parameters[5].Value = model.NReportNum;
parameters[6].Value = model.NTransmitNum;
parameters[7].Value = model.NPublishtime;
parameters[8].Value = model.NState;
parameters[9].Value = model.parentNoteID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.LTreportTypeTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into LTreportTypeTb(");
strSql.Append("NreporterName)");
strSql.Append(" values (");
strSql.Append("@NreporterName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@NreporterName", SqlDbType.NVarChar,50)};
parameters[0].Value = model.NreporterName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.fansGroupTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into fansGroupTb(");
strSql.Append("groupName,createTime)");
strSql.Append(" values (");
strSql.Append("@groupName,@createTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@groupName", SqlDbType.NVarChar,50),
new SqlParameter("@createTime", SqlDbType.DateTime)};
parameters[0].Value = model.groupName;
parameters[1].Value = model.createTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.skinTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into skinTb(");
strSql.Append("skinName,imgUrl)");
strSql.Append(" values (");
strSql.Append("@skinName,@imgUrl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@skinName", SqlDbType.NVarChar,50),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,500)};
parameters[0].Value = model.skinName;
parameters[1].Value = model.imgUrl;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.reportTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update reportTb set ");
strSql.Append("noveltyID=@noveltyID,");
strSql.Append("reporterID=@reporterID,");
strSql.Append("reportTime=@reportTime,");
strSql.Append("reportTypeID=@reportTypeID,");
strSql.Append("state=@state");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@noveltyID", SqlDbType.Int,4),
new SqlParameter("@reporterID", SqlDbType.Int,4),
new SqlParameter("@reportTime", SqlDbType.DateTime),
new SqlParameter("@reportTypeID", SqlDbType.Int,4),
new SqlParameter("@state", SqlDbType.NVarChar,50),
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = model.noveltyID;
parameters[1].Value = model.reporterID;
parameters[2].Value = model.reportTime;
parameters[3].Value = model.reportTypeID;
parameters[4].Value = model.state;
parameters[5].Value = model.ID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.photoTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update photoTb set ");
strSql.Append("ownID=@ownID,");
strSql.Append("description=@description,");
strSql.Append("imgUrl=@imgUrl,");
strSql.Append("photoGroupID=@photoGroupID,");
strSql.Append("creatTime=@creatTime,");
strSql.Append("littleImgUrl=@littleImgUrl");
strSql.Append(" where photoID=@photoID ");
SqlParameter[] parameters = {
new SqlParameter("@ownID", SqlDbType.Int,4),
new SqlParameter("@description", SqlDbType.NVarChar,50),
new SqlParameter("@imgUrl", SqlDbType.NVarChar,50),
new SqlParameter("@photoGroupID", SqlDbType.Int,4),
new SqlParameter("@creatTime", SqlDbType.DateTime),
new SqlParameter("@littleImgUrl", SqlDbType.NVarChar,50),
new SqlParameter("@photoID", SqlDbType.Int,4)};
parameters[0].Value = model.ownID;
parameters[1].Value = model.description;
parameters[2].Value = model.imgUrl;
parameters[3].Value = model.photoGroupID;
parameters[4].Value = model.creatTime;
parameters[5].Value = model.littleImgUrl;
parameters[6].Value = model.photoID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.LTnoteTb model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.LTnoteTb model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.commentTb model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.commentTb model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.reportTypeTb model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.photoGroupTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update photoGroupTb set ");
strSql.Append("groupName=@groupName,");
strSql.Append("ownID=@ownID");
strSql.Append(" where photoGroupID=@photoGroupID");
SqlParameter[] parameters = {
new SqlParameter("@groupName", SqlDbType.NVarChar,50),
new SqlParameter("@ownID", SqlDbType.Int,4),
new SqlParameter("@photoGroupID", SqlDbType.Int,4)};
parameters[0].Value = model.groupName;
parameters[1].Value = model.ownID;
parameters[2].Value = model.photoGroupID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.noveltyImagesTb model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.LTnoteTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update LTnoteTb set ");
strSql.Append("sectionID=@sectionID,");
strSql.Append("senderID=@senderID,");
strSql.Append("NContent=@NContent,");
strSql.Append("NCommentNum=@NCommentNum,");
strSql.Append("NSupportNum=@NSupportNum,");
strSql.Append("NReportNum=@NReportNum,");
strSql.Append("NTransmitNum=@NTransmitNum,");
strSql.Append("NPublishtime=@NPublishtime,");
strSql.Append("NState=@NState,");
strSql.Append("parentNoteID=@parentNoteID");
strSql.Append(" where noteID=@noteID");
SqlParameter[] parameters = {
new SqlParameter("@sectionID", SqlDbType.Int,4),
new SqlParameter("@senderID", SqlDbType.Int,4),
new SqlParameter("@NContent", SqlDbType.NVarChar,3000),
new SqlParameter("@NCommentNum", SqlDbType.Int,4),
new SqlParameter("@NSupportNum", SqlDbType.Int,4),
new SqlParameter("@NReportNum", SqlDbType.Int,4),
new SqlParameter("@NTransmitNum", SqlDbType.Int,4),
new SqlParameter("@NPublishtime", SqlDbType.DateTime),
new SqlParameter("@NState", SqlDbType.NVarChar,50),
new SqlParameter("@parentNoteID", SqlDbType.Int,4),
new SqlParameter("@noteID", SqlDbType.Int,4)};
parameters[0].Value = model.sectionID;
parameters[1].Value = model.senderID;
parameters[2].Value = model.NContent;
parameters[3].Value = model.NCommentNum;
parameters[4].Value = model.NSupportNum;
parameters[5].Value = model.NReportNum;
parameters[6].Value = model.NTransmitNum;
parameters[7].Value = model.NPublishtime;
parameters[8].Value = model.NState;
parameters[9].Value = model.parentNoteID;
parameters[10].Value = model.noteID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.noveltyImagesTb model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.reportTypeTb model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.LTreportTypeTb model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update LTreportTypeTb set ");
strSql.Append("NreporterName=@NreporterName");
strSql.Append(" where NreporterID=@NreporterID");
SqlParameter[] parameters = {
new SqlParameter("@NreporterName", SqlDbType.NVarChar,50),
new SqlParameter("@NreporterID", SqlDbType.Int,4)};
parameters[0].Value = model.NreporterName;
parameters[1].Value = model.NreporterID;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(littleworld.Model.userTb model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(littleworld.Model.userTb model)
{
return dal.Add(model);
}
