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