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