public bool Add(EasyOne.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
{
string strSql = "INSERT INTO PE_CollectionFieldRules(FieldRuleId, ItemId, FieldName, FieldType, RuleType, BeginCode, EndCode, PrivateFilter, FilterRuleId, UsePaging, SpecialSetting, ExclosionID) VALUES (@FieldRuleId, @ItemId, @FieldName, @FieldType, @RuleType, @BeginCode, @EndCode, @PrivateFilter, @FilterRuleId, @UsePaging, @SpecialSetting, @ExclosionID)";
collectionFieldRuleInfo.FieldRuleId = GetMaxId() + 1;
return(DBHelper.ExecuteSql(strSql, GetParameters(collectionFieldRuleInfo)));
}
private static EasyOne.Model.Collection.CollectionFieldRuleInfo CollectionFieldRuleInfo(NullableDataReader rdr)
{
EasyOne.Model.Collection.CollectionFieldRuleInfo info = new EasyOne.Model.Collection.CollectionFieldRuleInfo();
info.FieldRuleId = rdr.GetInt32("FieldRuleId");
info.ItemId = rdr.GetInt32("ItemId");
info.FieldName = rdr.GetString("FieldName");
info.FieldType = rdr.GetString("FieldType");
info.RuleType = rdr.GetInt32("RuleType");
info.BeginCode = rdr.GetString("BeginCode");
info.EndCode = rdr.GetString("EndCode");
info.PrivateFilter = rdr.GetString("PrivateFilter");
info.FilterRuleId = rdr.GetString("FilterRuleId");
info.UsePaging = rdr.GetBoolean("UsePaging");
info.SpecialSetting = rdr.GetString("SpecialSetting");
info.ExclosionId = rdr.GetInt32("ExclosionID");
return(info);
}
private static Parameters GetParameters(EasyOne.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@FieldRuleId", DbType.Int32, collectionFieldRuleInfo.FieldRuleId);
parameters.AddInParameter("@ItemId", DbType.Int32, collectionFieldRuleInfo.ItemId);
parameters.AddInParameter("@FieldName", DbType.String, collectionFieldRuleInfo.FieldName);
parameters.AddInParameter("@FieldType", DbType.String, collectionFieldRuleInfo.FieldType);
parameters.AddInParameter("@RuleType", DbType.Int32, collectionFieldRuleInfo.RuleType);
parameters.AddInParameter("@BeginCode", DbType.String, collectionFieldRuleInfo.BeginCode);
parameters.AddInParameter("@EndCode", DbType.String, collectionFieldRuleInfo.EndCode);
parameters.AddInParameter("@PrivateFilter", DbType.String, collectionFieldRuleInfo.PrivateFilter);
parameters.AddInParameter("@FilterRuleId", DbType.String, collectionFieldRuleInfo.FilterRuleId);
parameters.AddInParameter("@UsePaging", DbType.Boolean, collectionFieldRuleInfo.UsePaging);
parameters.AddInParameter("@SpecialSetting", DbType.String, collectionFieldRuleInfo.SpecialSetting);
parameters.AddInParameter("@ExclosionID", DbType.Int32, collectionFieldRuleInfo.ExclosionId);
return(parameters);
}
public bool Update(EasyOne.Model.Collection.CollectionFieldRuleInfo collectionFieldRuleInfo)
{
string strSql = "UPDATE PE_CollectionFieldRules SET ItemId = @ItemId, FieldName = @FieldName, FieldType = @FieldType, RuleType = @RuleType, BeginCode = @BeginCode, EndCode = @EndCode, PrivateFilter = @PrivateFilter, FilterRuleId = @FilterRuleId, UsePaging = @UsePaging, SpecialSetting = @SpecialSetting, ExclosionID = @ExclosionID WHERE ItemId = @ItemId AND FieldName = @FieldName";
return(DBHelper.ExecuteSql(strSql, GetParameters(collectionFieldRuleInfo)));
}