public int UpdateAduitStatus(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE SolderPasteDifferRecord SET AduitStatus = '" + Convert.ToBase64String(UTF8Encoding.Unicode.GetBytes("已确认")) + "' WHERE Id = '" + id + "'"); return(DbHelperSql.ExecuteSql(strSql.ToString())); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(big_data.Model.UnifiedAddressLibraryUserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UnifiedAddressLibraryUserInfo set "); strSql.Append("UnifiedAddressLibraryID=@UnifiedAddressLibraryID,"); strSql.Append("UserIDList=@UserIDList,"); strSql.Append("AddTime=@AddTime"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UnifiedAddressLibraryID", SqlDbType.Int, 4), new SqlParameter("@UserIDList", SqlDbType.NVarChar, -1), new SqlParameter("@AddTime", SqlDbType.DateTime2, 8), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UnifiedAddressLibraryID; parameters[1].Value = model.UserIDList; parameters[2].Value = model.AddTime; parameters[3].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.PublicityType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PublicityType set "); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("Name=@Name,"); strSql.Append("IsDeleted=@IsDeleted"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8), new SqlParameter("@Name", SqlDbType.VarChar, 255), new SqlParameter("@IsDeleted", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@PublicityTypeUUID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.CreateTime; parameters[1].Value = model.Name; parameters[2].Value = model.IsDeleted; parameters[3].Value = model.ID; parameters[4].Value = model.PublicityTypeUUID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Haikan.LabSystemCore.Model.CreditCardBehavior model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CreditCardBehavior set "); strSql.Append("CardNo=@CardNo,"); strSql.Append("DeviceID=@DeviceID,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("ProjectID=@ProjectID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CardNo", SqlDbType.VarChar, 255), new SqlParameter("@DeviceID", SqlDbType.VarChar, 255), new SqlParameter("@AddTime", SqlDbType.VarChar, 255), new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CardNo; parameters[1].Value = model.DeviceID; parameters[2].Value = model.AddTime; parameters[3].Value = model.ProjectID; parameters[4].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.searchl model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update searchl set "); strSql.Append("text=@text,"); strSql.Append("url=@url"); strSql.Append(" where guid=@guid "); SqlParameter[] parameters = { new SqlParameter("@text", SqlDbType.VarChar, 255), new SqlParameter("@url", SqlDbType.VarChar, 255), new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.text; parameters[1].Value = model.url; parameters[2].Value = model.guid; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.SystemUserRoleMapping model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SystemUserRoleMapping set "); strSql.Append("AddTime=@AddTime,"); strSql.Append("AddPeople=@AddPeople"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@AddTime", SqlDbType.NVarChar, 255), new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255), new SqlParameter("@SystemUserUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@SystemRoleUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.AddTime; parameters[1].Value = model.AddPeople; parameters[2].Value = model.SystemUserUUID; parameters[3].Value = model.SystemRoleUUID; parameters[4].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(big_data.Model.RegionInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RegionInfo set "); strSql.Append("RegionID=@RegionID,"); strSql.Append("RegionX=@RegionX,"); strSql.Append("RegionY=@RegionY,"); strSql.Append("AddTime=@AddTime"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@RegionID", SqlDbType.Int, 4), new SqlParameter("@RegionX", SqlDbType.VarChar, 255), new SqlParameter("@RegionY", SqlDbType.VarChar, 255), new SqlParameter("@AddTime", SqlDbType.DateTime2, 8), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.RegionID; parameters[1].Value = model.RegionX; parameters[2].Value = model.RegionY; parameters[3].Value = model.AddTime; parameters[4].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HeqiaoDaoshiCore.Model.searchl model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into searchl("); strSql.Append("guid,text,url)"); strSql.Append(" values ("); strSql.Append("@guid,@text,@url)"); SqlParameter[] parameters = { new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@text", SqlDbType.VarChar, 255), new SqlParameter("@url", SqlDbType.VarChar, 255) }; parameters[0].Value = Guid.NewGuid(); parameters[1].Value = model.text; parameters[2].Value = model.url; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool Update(int programButtonID, int programID, string buttonID, string Url) { var strSql = new StringBuilder(); strSql.Append("UPDATE tbLOG_Program_Button SET "); strSql.Append(" Program_ID = @Program_ID ,Button_ID = @Button_ID , Url = @Url "); strSql.Append("FROM tbLOG_Program_Button LPB "); strSql.Append("LEFT JOIN ( "); strSql.Append("SELECT * FROM ( SELECT Program_ID ,Button_ID ,ROW_NUMBER() OVER ( PARTITION BY Program_ID,Button_ID ORDER BY Program_Button_ID ASC ) RN FROM tbLOG_Program_Button WHERE Program_ID=@Program_ID AND Button_ID=@Button_ID ) AS T WHERE T.RN > 1 "); strSql.Append(" ) TPB "); strSql.Append("ON LPB.Program_ID = TPB.Program_ID AND LPB.Button_ID = TPB.Button_ID "); strSql.Append("WHERE LPB.Program_ID=@Program_ID AND LPB.Button_ID=@Button_ID AND TPB.Program_ID IS NULL "); SqlParameter[] parameters = { new SqlParameter("@Program_Button_ID", SqlDbType.VarChar, 50), new SqlParameter("@Program_ID", SqlDbType.VarChar, 50), new SqlParameter("@Button_ID", SqlDbType.VarChar, 200), new SqlParameter("@Url", SqlDbType.VarChar, 100) }; parameters[0].Value = programButtonID; parameters[1].Value = programID; parameters[2].Value = buttonID; parameters[3].Value = Url; var resultCount = DbHelperSql.ExecuteSql(DbHelperSql.DefaultUpdateConn, strSql.ToString(), parameters); if (resultCount == 0) { return(false); } return(true); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Guid HotelRoomUuid, int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from HotelRoom "); strSql.Append(" where HotelRoomUuid=@HotelRoomUuid and ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@HotelRoomUuid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = HotelRoomUuid; parameters[1].Value = ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(Guid SystemIconUUID, int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SystemIcon "); strSql.Append(" where SystemIconUUID=@SystemIconUUID and ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@SystemIconUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = SystemIconUUID; parameters[1].Value = ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 创建一个只有一个Id主键的空表 /// </summary> /// <param name="tablename"></param> /// <param name="defaultColumns"></param> /// <returns></returns> public bool CreateTable(string tablename, params string[] defaultColumns) { if (_providerConfig.DbProvider == DbProvider.MySql) { var sqlClause = string.Format(@" CREATE TABLE IF NOT EXISTS `{0}` (`Id` int(11) NOT NULL AUTO_INCREMENT,PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;", tablename); DbHelperMySql.ExecuteSql(_providerConfig.DbConnectionString, sqlClause); } else { var sqlClause = string.Format(@"IF NOT EXISTS(SELECT * FROM sysobjects where id=OBJECT_ID('{0}') and xtype='U') BEGIN CREATE TABLE {0} ( [Id] INT NOT NULL IDENTITY, PRIMARY KEY CLUSTERED ([Id] ASC)); END", tablename); DbHelperSql.ExecuteSql(_providerConfig.DbConnectionString, sqlClause); } foreach (var column in defaultColumns) { if (!string.IsNullOrEmpty(column) && !ColumHasExists(tablename, column)) { AddColumn(tablename, column, TemplateColumnDataType.TemplateString, 255); } } return(true); }
public void UpdateMatIDByPartNo(string partNo, string matId) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE ResponseInfo SET MatID = '" + matId + "' WHERE PartNo = '" + partNo + "'"); DbHelperSql.ExecuteSql(strSql.ToString()); }
/// <summary> /// 批量删除章节 /// </summary> /// <param name="ids">章节编号集合</param> /// <returns></returns> public static int BatchDelete(string ids) { ids = ids.Trim().Replace(" ", "").Replace(",", "','"); string strSql = string.Format(@"DELETE FROM dbo.Chapters WHERE (Id IN ('{0}'));", ids); return(DbHelperSql.ExecuteSql(strSql)); }
/// <summary> /// 修改状态 /// </summary> /// <param name="id"></param> /// <param name="state"></param> /// <returns></returns> public bool UpdateState(int id, int state) { var sql = " update CoAgent set [State] = " + state + " where id='" + id + "'"; var rows = DbHelperSql.ExecuteSql(sql); return(rows > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ClassLibrary1.Model.TcqType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TcqType set "); strSql.Append("Tcqid=@Tcqid,"); strSql.Append("TcqName=@TcqName"); strSql.Append(" where Tcqguid=@Tcqguid "); SqlParameter[] parameters = { new SqlParameter("@Tcqid", SqlDbType.Int, 4), new SqlParameter("@TcqName", SqlDbType.VarChar, 255), new SqlParameter("@Tcqguid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.Tcqid; parameters[1].Value = model.TcqName; parameters[2].Value = model.Tcqguid; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool UpdatePwd(int id, string password) { var sql = " update CoAgent set Password = '******' where Id='" + id + "'"; var rows = DbHelperSql.ExecuteSql(sql); return(rows > 0); }
public bool UpdateState(string id, int state) { var sql = " update CoAgent set [State] = " + state + " where Id in (" + id + ")"; var rows = DbHelperSql.ExecuteSql(sql); return(rows > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.Treasurerecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Treasurerecord set "); strSql.Append("UserUUID=@UserUUID,"); strSql.Append("Content=@Content,"); strSql.Append("Createtime=@Createtime"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Content", SqlDbType.NVarChar, 255), new SqlParameter("@Createtime", SqlDbType.NVarChar, 255), new SqlParameter("@TreasurerecordUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserUUID; parameters[1].Value = model.Content; parameters[2].Value = model.Createtime; parameters[3].Value = model.TreasurerecordUUID; parameters[4].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <param name="id"></param> /// <param name="objUpdate"></param> /// <returns></returns> public static bool UpdateById <T>(object id, object objUpdate) where T : class { var t = typeof(T); var sql = t.GeneratePartialUpdateSqlById <T>(id, objUpdate); var i = DbHelperSql.ExecuteSql(sql, AdoUtil.GetParameters(objUpdate).AppendParameters <T>(id)); return(i > 0); }
public void UpdateMatIDToResponseDicByPartNo(string productPartNo, string lineNo, string MaterialsPartNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE ResponseDic SET MaterialsPartNo = '" + MaterialsPartNo + "' WHERE LineName = '" + lineNo + "' and ProductPartNo='" + productPartNo + "'"); int c = DbHelperSql.ExecuteSql(strSql.ToString()); }
public virtual bool Delete(int id) { var type = typeof(T); var sql = type.GenerateDeleteSqlString(id); var rows = DbHelperSql.ExecuteSql(sql); return(rows > 0); }
public bool Update(T entity) { var type = typeof(T); var sql = type.GenerateUpdateSqlString(); var rows = DbHelperSql.ExecuteSql(sql, AdoUtil.GetParameters(entity)); return(rows > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.Gtoilet model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Gtoilet set "); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("GtoiletName=@GtoiletName,"); strSql.Append("GtoiletAddress=@GtoiletAddress,"); strSql.Append("Lon=@Lon,"); strSql.Append("Lat=@Lat,"); strSql.Append("GtoiletStaues=@GtoiletStaues,"); strSql.Append("KongqiZhil=@KongqiZhil,"); strSql.Append("WaterYujin=@WaterYujin,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("AddPeople=@AddPeople,"); strSql.Append("Picture=@Picture"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@IsDeleted", SqlDbType.Int, 4), new SqlParameter("@GtoiletName", SqlDbType.NVarChar, 255), new SqlParameter("@GtoiletAddress", SqlDbType.NVarChar, 255), new SqlParameter("@Lon", SqlDbType.NVarChar, 255), new SqlParameter("@Lat", SqlDbType.NVarChar, 255), new SqlParameter("@GtoiletStaues", SqlDbType.NVarChar, 255), new SqlParameter("@KongqiZhil", SqlDbType.NVarChar, 255), new SqlParameter("@WaterYujin", SqlDbType.NVarChar, 255), new SqlParameter("@AddTime", SqlDbType.NVarChar, 255), new SqlParameter("@AddPeople", SqlDbType.NVarChar, 255), new SqlParameter("@Picture", SqlDbType.NVarChar, -1), new SqlParameter("@GtoiletUuid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.GtoiletName; parameters[2].Value = model.GtoiletAddress; parameters[3].Value = model.Lon; parameters[4].Value = model.Lat; parameters[5].Value = model.GtoiletStaues; parameters[6].Value = model.KongqiZhil; parameters[7].Value = model.WaterYujin; parameters[8].Value = model.AddTime; parameters[9].Value = model.AddPeople; parameters[10].Value = model.Picture; parameters[11].Value = model.GtoiletUuid; parameters[12].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.ArticlesManagement model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ArticlesManagement set "); strSql.Append("ArticleTitle=@ArticleTitle,"); strSql.Append("ArticleTypeUUID=@ArticleTypeUUID,"); strSql.Append("ReleaseTime=@ReleaseTime,"); strSql.Append("IsDelete=@IsDelete,"); strSql.Append("IsRelease=@IsRelease,"); strSql.Append("CoverPhoto=@CoverPhoto,"); strSql.Append("ArticleName=@ArticleName,"); strSql.Append("AddPeople=@AddPeople,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("Count=@Count,"); strSql.Append("IsRecommend=@IsRecommend"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ArticleTitle", SqlDbType.VarChar, 255), new SqlParameter("@ArticleTypeUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReleaseTime", SqlDbType.VarChar, 255), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@IsRelease", SqlDbType.Int, 4), new SqlParameter("@CoverPhoto", SqlDbType.VarChar, -1), new SqlParameter("@ArticleName", SqlDbType.VarChar, -1), new SqlParameter("@AddPeople", SqlDbType.VarChar, 255), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@Count", SqlDbType.Int, 4), new SqlParameter("@IsRecommend", SqlDbType.Bit, 1), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@ArticleUUID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.ArticleTitle; parameters[1].Value = model.ArticleTypeUUID; parameters[2].Value = model.ReleaseTime; parameters[3].Value = model.IsDelete; parameters[4].Value = model.IsRelease; parameters[5].Value = model.CoverPhoto; parameters[6].Value = model.ArticleName; parameters[7].Value = model.AddPeople; parameters[8].Value = model.AddTime; parameters[9].Value = model.Count; parameters[10].Value = model.IsRecommend; parameters[11].Value = model.ID; parameters[12].Value = model.ArticleUUID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//SELECT TOP (200) Id, NovelId, ChapterUrl, NextUrl, Chapter, ChapterIdx, ChapterName, HeadWord, Content, WordCount, UpdateTime //FROM Chapters #region 编辑章节数据 /// <summary> /// 编辑章节数据 /// </summary> /// <param name="model">章节实体</param> /// <returns></returns> public static int Edit(Chapters model) { string strSql = string.Format (@"UPDATE Chapters SET Chapter='{1}', Content='{2}', WordCount='{3}', ValidChapter = '{4}' WHERE (Id = '{0}');" , model.Id, model.Chapter, model.Content, model.Content.Length, model.ValidChapter); return(DbHelperSql.ExecuteSql(strSql)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Haikan.LabSystemCore.Model.EntranceGuard model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update EntranceGuard set "); strSql.Append("GNameListID=@GNameListID,"); strSql.Append("Entcardnumber=@Entcardnumber,"); strSql.Append("ip=@ip,"); strSql.Append("USB=@USB,"); strSql.Append("stime=@stime,"); strSql.Append("etime=@etime,"); strSql.Append("GNameListName=@GNameListName,"); strSql.Append("StudenListID=@StudenListID,"); strSql.Append("StudentListName=@StudentListName,"); strSql.Append("EntcardType=@EntcardType,"); strSql.Append("Port=@Port"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@GNameListID", SqlDbType.NVarChar, -1), new SqlParameter("@Entcardnumber", SqlDbType.NVarChar, -1), new SqlParameter("@ip", SqlDbType.NVarChar, 50), new SqlParameter("@USB", SqlDbType.Int, 4), new SqlParameter("@stime", SqlDbType.DateTime), new SqlParameter("@etime", SqlDbType.DateTime), new SqlParameter("@GNameListName", SqlDbType.NVarChar, -1), new SqlParameter("@StudenListID", SqlDbType.NVarChar, -1), new SqlParameter("@StudentListName", SqlDbType.NVarChar, -1), new SqlParameter("@EntcardType", SqlDbType.VarChar, 255), new SqlParameter("@Port", SqlDbType.VarChar, 255), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.GNameListID; parameters[1].Value = model.Entcardnumber; parameters[2].Value = model.ip; parameters[3].Value = model.USB; parameters[4].Value = model.stime; parameters[5].Value = model.etime; parameters[6].Value = model.GNameListName; parameters[7].Value = model.StudenListID; parameters[8].Value = model.StudentListName; parameters[9].Value = model.EntcardType; parameters[10].Value = model.Port; parameters[11].Value = model.id; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 编辑站点数据 /// </summary> /// <param name="model">站点实体</param> /// <returns></returns> public static int Edit(WebSites model) { string strSql = string.Format (@"UPDATE WebSites SET Name='{1}', WebUrl='{2}', ContentName='{3}', HeaderName='{4}', NextName='{5}' , NextTitle='{6}', Valid='{7}', UrlCombine='{8}', Encoding='{9}' WHERE (Id = '{0}');" , model.Id, model.Name, model.WebUrl, model.ContentName, model.HeaderName, model.NextName , model.NextTitle, model.Valid, model.UrlCombine, model.Encoding); return(DbHelperSql.ExecuteSql(strSql)); }
//SELECT TOP (200) Id, WebId, Title, NovelUrl, StartUrl, LatestChapter, Author // , TypeId, Status, RecentUpdate, ChapterCount, CreateTime, ChapterChar, StartChapterIdx, ChapterType //FROM Novels #region 编辑小说数据 /// <summary> /// 编辑小说数据 /// </summary> /// <param name="model">小说实体</param> /// <returns></returns> public static int Edit(Model.Novels model) { string strSql = string.Format (@"UPDATE Novels SET WebId='{1}', Title='{2}', NovelUrl='{3}', StartUrl='{4}', LatestChapter='{5}', Author='{6}' , TypeId='{7}', Status='{8}', StartChapterIdx='{9}', ChapterChar='{10}', ChapterType='{11}' WHERE (Id = '{0}');" , model.Id, model.WebId, model.Title, model.NovelUrl, model.StartUrl, model.LatestChapter, model.Author , model.TypeId, model.Status, model.StartChapterIdx, model.ChapterChar, model.ChapterType); return(DbHelperSql.ExecuteSql(strSql)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.Information model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Information set "); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("Title=@Title,"); strSql.Append("InformationTypeUUID=@InformationTypeUUID,"); strSql.Append("Introduce=@Introduce,"); strSql.Append("Address=@Address,"); strSql.Append("StartTime=@StartTime,"); strSql.Append("Picture=@Picture,"); strSql.Append("State=@State,"); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("Photo=@Photo"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8), new SqlParameter("@Title", SqlDbType.VarChar, 255), new SqlParameter("@InformationTypeUUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Introduce", SqlDbType.VarChar, -1), new SqlParameter("@Address", SqlDbType.VarChar, 255), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@Picture", SqlDbType.VarChar, -1), new SqlParameter("@State", SqlDbType.Bit, 1), new SqlParameter("@IsDeleted", SqlDbType.Int, 4), new SqlParameter("@Photo", SqlDbType.VarChar, -1), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@InformationUUID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.CreateTime; parameters[1].Value = model.Title; parameters[2].Value = model.InformationTypeUUID; parameters[3].Value = model.Introduce; parameters[4].Value = model.Address; parameters[5].Value = model.StartTime; parameters[6].Value = model.Picture; parameters[7].Value = model.State; parameters[8].Value = model.IsDeleted; parameters[9].Value = model.Photo; parameters[10].Value = model.ID; parameters[11].Value = model.InformationUUID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }