public bool Add(EasyOne.Model.Collection.CollectionExclosionInfo collectionExclosionInfo)
{
string str = "";
string str2 = "";
switch (collectionExclosionInfo.ExclosionType)
{
case 1:
str = "ExclosionStringType, ExclosionString";
str2 = "@ExclosionStringType, @ExclosionString";
break;
case 2:
str = "IsExclosionDesignatedDateTime, IsExclosionMaxDateTime, IsExclosionMinDateTime, ExclosionDesignatedDateTime, ExclosionMaxDateTime, ExclosionMinDateTime";
str2 = "@IsExclosionDesignatedDateTime, @IsExclosionMaxDateTime, @IsExclosionMinDateTime, @ExclosionDesignatedDateTime, @ExclosionMaxDateTime, @ExclosionMinDateTime";
break;
case 3:
str = "IsExclosionDesignatedNumber, IsExclosionMaxNumber, IsExclosionMinNumber, ExclosionDesignatedNumber, ExclosionMaxNumber, ExclosionMinNumber";
str2 = "@IsExclosionDesignatedNumber, @IsExclosionMaxNumber, @IsExclosionMinNumber, @ExclosionDesignatedNumber, @ExclosionMaxNumber, @ExclosionMinNumber";
break;
}
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO PE_CollectionExclosion(ExclosionID, ExclosionName, ExclosionType," + str);
builder.Append(") VALUES (@ExclosionID, @ExclosionName, @ExclosionType," + str2 + ")");
collectionExclosionInfo.ExclosionId = GetMaxId() + 1;
return(DBHelper.ExecuteSql(builder.ToString(), GetParameters(collectionExclosionInfo)));
}
private static EasyOne.Model.Collection.CollectionExclosionInfo CollectionExclosionInfo(NullableDataReader rdr)
{
EasyOne.Model.Collection.CollectionExclosionInfo info = new EasyOne.Model.Collection.CollectionExclosionInfo();
info.ExclosionId = rdr.GetInt32("ExclosionID");
info.ExclosionName = rdr.GetString("ExclosionName");
info.ExclosionType = rdr.GetInt32("ExclosionType");
info.ExclosionStringType = rdr.GetInt32("ExclosionStringType");
info.ExclosionString = rdr.GetString("ExclosionString");
info.ExclosionDesignatedNumber = rdr.GetInt32("ExclosionDesignatedNumber");
info.ExclosionMaxNumber = rdr.GetInt32("ExclosionMaxNumber");
info.ExclosionMinNumber = rdr.GetInt32("ExclosionMinNumber");
info.ExclosionDesignatedDateTime = new DateTime?(rdr.GetDateTime("ExclosionDesignatedDateTime"));
info.ExclosionMaxDateTime = new DateTime?(rdr.GetDateTime("ExclosionMaxDateTime"));
info.ExclosionMinDateTime = new DateTime?(rdr.GetDateTime("ExclosionMinDateTime"));
info.IsExclosionDesignatedNumber = rdr.GetBoolean("IsExclosionDesignatedNumber");
info.IsExclosionMaxNumber = rdr.GetBoolean("IsExclosionMaxNumber");
info.IsExclosionMinNumber = rdr.GetBoolean("IsExclosionMinNumber");
info.IsExclosionDesignatedDateTime = rdr.GetBoolean("IsExclosionDesignatedDateTime");
info.IsExclosionMaxDateTime = rdr.GetBoolean("IsExclosionMaxDateTime");
info.IsExclosionMinDateTime = rdr.GetBoolean("IsExclosionMinDateTime");
return(info);
}
private static Parameters GetParameters(EasyOne.Model.Collection.CollectionExclosionInfo collectionExclosionInfo)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@ExclosionID", DbType.Int32, collectionExclosionInfo.ExclosionId);
parameters.AddInParameter("@ExclosionName", DbType.String, collectionExclosionInfo.ExclosionName);
parameters.AddInParameter("@ExclosionType", DbType.Int32, collectionExclosionInfo.ExclosionType);
parameters.AddInParameter("@ExclosionStringType", DbType.Int32, collectionExclosionInfo.ExclosionStringType);
parameters.AddInParameter("@ExclosionString", DbType.String, collectionExclosionInfo.ExclosionString);
parameters.AddInParameter("@ExclosionDesignatedNumber", DbType.Int32, collectionExclosionInfo.ExclosionDesignatedNumber);
parameters.AddInParameter("@ExclosionMaxNumber", DbType.Int32, collectionExclosionInfo.ExclosionMaxNumber);
parameters.AddInParameter("@ExclosionMinNumber", DbType.Int32, collectionExclosionInfo.ExclosionMinNumber);
parameters.AddInParameter("@ExclosionDesignatedDateTime", DbType.DateTime, collectionExclosionInfo.ExclosionDesignatedDateTime);
parameters.AddInParameter("@ExclosionMaxDateTime", DbType.DateTime, collectionExclosionInfo.ExclosionMaxDateTime);
parameters.AddInParameter("@ExclosionMinDateTime", DbType.DateTime, collectionExclosionInfo.ExclosionMinDateTime);
parameters.AddInParameter("@IsExclosionDesignatedNumber", DbType.Boolean, collectionExclosionInfo.IsExclosionDesignatedNumber);
parameters.AddInParameter("@IsExclosionMaxNumber", DbType.Boolean, collectionExclosionInfo.IsExclosionMaxNumber);
parameters.AddInParameter("@IsExclosionMinNumber", DbType.Boolean, collectionExclosionInfo.IsExclosionMinNumber);
parameters.AddInParameter("@IsExclosionDesignatedDateTime", DbType.Boolean, collectionExclosionInfo.IsExclosionDesignatedDateTime);
parameters.AddInParameter("@IsExclosionMaxDateTime", DbType.Boolean, collectionExclosionInfo.IsExclosionMaxDateTime);
parameters.AddInParameter("@IsExclosionMinDateTime", DbType.Boolean, collectionExclosionInfo.IsExclosionMinDateTime);
return(parameters);
}
public bool Update(EasyOne.Model.Collection.CollectionExclosionInfo collectionExclosionInfo)
{
string str = "";
switch (collectionExclosionInfo.ExclosionType)
{
case 1:
str = "ExclosionStringType = @ExclosionStringType, ExclosionString = @ExclosionString";
break;
case 2:
str = "IsExclosionDesignatedDateTime = @IsExclosionDesignatedDateTime, IsExclosionMaxDateTime = @IsExclosionMaxDateTime, IsExclosionMinDateTime = @IsExclosionMinDateTime, ExclosionDesignatedDateTime = @ExclosionDesignatedDateTime, ExclosionMaxDateTime = @ExclosionMaxDateTime, ExclosionMinDateTime = @ExclosionMinDateTime";
break;
case 3:
str = "IsExclosionDesignatedNumber = @IsExclosionDesignatedNumber, IsExclosionMaxNumber = @IsExclosionMaxNumber, IsExclosionMinNumber = @IsExclosionMinNumber, ExclosionDesignatedNumber = @ExclosionDesignatedNumber, ExclosionMaxNumber = @ExclosionMaxNumber, ExclosionMinNumber = @ExclosionMinNumber";
break;
}
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE PE_CollectionExclosion SET ExclosionName = @ExclosionName, ExclosionType = @ExclosionType," + str);
builder.Append(" WHERE ExclosionID = @ExclosionID");
return(DBHelper.ExecuteSql(builder.ToString(), GetParameters(collectionExclosionInfo)));
}