/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(Articel_Words model) { #region SQL语句 const string sql = @" INSERT INTO [dbo].[Articel_Words] ( [WordPattern] ,[IsForbid] ,[IsMod] ,[ReplaceWord] ) VALUES ( @WordPattern ,@IsForbid ,@IsMod ,@ReplaceWord );select @@IDENTITY"; #endregion var res = SqlHelper.ExecuteScalar(sql, new SqlParameter("@WordPattern", model.WordPattern), new SqlParameter("@IsForbid", model.IsForbid), new SqlParameter("@IsMod", model.IsMod), new SqlParameter("@ReplaceWord", model.ReplaceWord) ); return(res == null ? 0 : Convert.ToInt32(res)); }
public int Add(Articel_Words model) { string sql = "insert into Articel_Words(WordPattern, IsForbid, IsMod, ReplaceWord)values( @WordPattern, @IsForbid, @IsMod, @ReplaceWord)"; SqlParameter[] pars = { new SqlParameter("@WordPattern", model.WordPattern), new SqlParameter("@IsForbid", model.IsForbid), new SqlParameter("@IsMod", model.IsMod), new SqlParameter("@ReplaceWord", model.ReplaceWord) }; return(DbHelperSQL.ExecuteSql(sql, pars)); }
/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(Articel_Words model) { #region SQL语句 const string sql = @" UPDATE [dbo].[Articel_Words] SET [WordPattern] = @WordPattern ,[IsForbid] = @IsForbid ,[IsMod] = @IsMod ,[ReplaceWord] = @ReplaceWord WHERE [Id] = @Id"; #endregion return(SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@Id", model.Id), new SqlParameter("@WordPattern", model.WordPattern), new SqlParameter("@IsForbid", model.IsForbid), new SqlParameter("@IsMod", model.IsMod), new SqlParameter("@ReplaceWord", model.ReplaceWord) )); }
/// <summary> /// 获取所有的替换词 /// </summary> /// <returns></returns> public List <Model.Articel_Words> GetReplace() { string sql = "select WordPattern,ReplaceWord from Articel_Words where IsForbid=0 and IsMod=0"; List <Model.Articel_Words> list = null; using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql)) { if (reader.HasRows) { list = new List <Articel_Words>(); while (reader.Read()) { Model.Articel_Words model = new Articel_Words(); model.WordPattern = reader.GetString(0); model.ReplaceWord = reader.GetString(1); list.Add(model); } } return(list); } }
/// <summary> /// 获取替换词 /// </summary> /// <returns></returns> public List <Articel_Words> GetReplace() { string sql = "select WordPattern,ReplaceWord from Articel_Words where IsMod=0 and IsForbid=0"; List <Articel_Words> list = new List <Articel_Words>(); using (SqlDataReader read = DbHelperSQL.ExecuteReader(sql)) { if (read.HasRows) { while (read.Read()) { Articel_Words articel_Words = new Articel_Words() { WordPattern = read.GetString(0), ReplaceWord = read.GetString(1) }; list.Add(articel_Words); } } } return(list); }