public bool Add(EasyOne.Model.Accessories.WordReplaceInfo wordReplaceInfo)
{
string strSql = "INSERT INTO PE_WordReplaceItem(ItemID, SourceWord, TargetWord, ReplaceType, Priority, ReplaceTimes, OpenType, IsEnabled, Title) VALUES (@ItemID, @SourceWord, @TargetWord, @ReplaceType, @Priority, @ReplaceTimes, @OpenType, @IsEnabled, @Title)";
wordReplaceInfo.ItemId = this.GetMaxId() + 1;
return(DBHelper.ExecuteSql(strSql, GetParameters(wordReplaceInfo)));
}
private static EasyOne.Model.Accessories.WordReplaceInfo WordReplaceInfo(NullableDataReader rdr)
{
EasyOne.Model.Accessories.WordReplaceInfo info = new EasyOne.Model.Accessories.WordReplaceInfo();
info.ItemId = rdr.GetInt32("ItemId");
info.SourceWord = rdr.GetString("SourceWord");
info.TargetWord = rdr.GetString("TargetWord");
info.ReplaceType = rdr.GetInt32("ReplaceType");
info.Priority = rdr.GetInt32("Priority");
info.ReplaceTimes = rdr.GetInt32("ReplaceTimes");
info.OpenType = rdr.GetBoolean("OpenType");
info.IsEnabled = rdr.GetBoolean("IsEnabled");
info.Title = rdr.GetString("Title");
return(info);
}
private static Parameters GetParameters(EasyOne.Model.Accessories.WordReplaceInfo wordReplaceInfo)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@ItemID", DbType.Int32, wordReplaceInfo.ItemId);
parameters.AddInParameter("@SourceWord", DbType.String, wordReplaceInfo.SourceWord);
parameters.AddInParameter("@TargetWord", DbType.String, wordReplaceInfo.TargetWord);
parameters.AddInParameter("@ReplaceType", DbType.Int32, wordReplaceInfo.ReplaceType);
parameters.AddInParameter("@Priority", DbType.Int32, wordReplaceInfo.Priority);
parameters.AddInParameter("@ReplaceTimes", DbType.Int32, wordReplaceInfo.ReplaceTimes);
parameters.AddInParameter("@OpenType", DbType.Boolean, wordReplaceInfo.OpenType);
parameters.AddInParameter("@IsEnabled", DbType.Boolean, wordReplaceInfo.IsEnabled);
parameters.AddInParameter("@Title", DbType.String, wordReplaceInfo.Title);
return(parameters);
}
public bool Update(EasyOne.Model.Accessories.WordReplaceInfo wordReplaceInfo)
{
string strSql = "UPDATE PE_WordReplaceItem SET SourceWord = @SourceWord, TargetWord = @TargetWord, ReplaceType = @ReplaceType, Priority = @Priority, ReplaceTimes = @ReplaceTimes, OpenType = @OpenType, IsEnabled = @IsEnabled, Title = @Title WHERE ItemID = @ItemID";
return(DBHelper.ExecuteSql(strSql, GetParameters(wordReplaceInfo)));
}
