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