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