private List <RoadFlow.Data.Model.ProgramBuilderExport> DataReaderToList(OracleDataReader dataReader)
{
List <RoadFlow.Data.Model.ProgramBuilderExport> programBuilderExportList = new List <RoadFlow.Data.Model.ProgramBuilderExport>();
while (dataReader.Read())
{
RoadFlow.Data.Model.ProgramBuilderExport programBuilderExport = new RoadFlow.Data.Model.ProgramBuilderExport();
programBuilderExport.ID = dataReader.GetString(0).ToGuid();
programBuilderExport.ProgramID = dataReader.GetString(1).ToGuid();
programBuilderExport.Field = dataReader.GetString(2);
if (!dataReader.IsDBNull(3))
{
programBuilderExport.ShowTitle = dataReader.GetString(3);
}
programBuilderExport.Align = dataReader.GetInt32(4);
if (!dataReader.IsDBNull(5))
{
programBuilderExport.Width = new int?(dataReader.GetInt32(5));
}
if (!dataReader.IsDBNull(6))
{
programBuilderExport.ShowType = new int?(dataReader.GetInt32(6));
}
if (!dataReader.IsDBNull(7))
{
programBuilderExport.DataType = new int?(dataReader.GetInt32(7));
}
if (!dataReader.IsDBNull(8))
{
programBuilderExport.ShowFormat = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
programBuilderExport.CustomString = dataReader.GetString(9);
}
programBuilderExport.Sort = dataReader.GetInt32(10);
programBuilderExportList.Add(programBuilderExport);
}
return(programBuilderExportList);
}
public int Add(RoadFlow.Data.Model.ProgramBuilderExport model)
{
string sql = "INSERT INTO programbuilderexport\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,DataType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(:ID,:ProgramID,:Field,:ShowTitle,:Align,:Width,:ShowType,:DataType,:ShowFormat,:CustomString,:Sort)";
OracleParameter[] oracleParameterArray = new OracleParameter[11];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2, 36);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":ProgramID", OracleDbType.Varchar2, 36);
oracleParameter2.Value = (object)model.ProgramID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Field", OracleDbType.Blob, -1);
oracleParameter3.Value = (object)model.Field;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4;
if (model.ShowTitle != null)
{
OracleParameter oracleParameter5 = new OracleParameter(":ShowTitle", OracleDbType.Blob, -1);
oracleParameter5.Value = (object)model.ShowTitle;
oracleParameter4 = oracleParameter5;
}
else
{
oracleParameter4 = new OracleParameter(":ShowTitle", OracleDbType.Blob, -1);
oracleParameter4.Value = (object)DBNull.Value;
}
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter6 = new OracleParameter(":Align", OracleDbType.Int32, 11);
oracleParameter6.Value = (object)model.Align;
oracleParameterArray[index5] = oracleParameter6;
int index6 = 5;
int? nullable = model.Width;
OracleParameter oracleParameter7;
if (nullable.HasValue)
{
OracleParameter oracleParameter5 = new OracleParameter(":Width", OracleDbType.Int32, 11);
oracleParameter5.Value = (object)model.Width;
oracleParameter7 = oracleParameter5;
}
else
{
oracleParameter7 = new OracleParameter(":Width", OracleDbType.Int32, 11);
oracleParameter7.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter7;
int index7 = 6;
nullable = model.ShowType;
OracleParameter oracleParameter8;
if (nullable.HasValue)
{
OracleParameter oracleParameter5 = new OracleParameter(":ShowType", OracleDbType.Int32, 11);
oracleParameter5.Value = (object)model.ShowType;
oracleParameter8 = oracleParameter5;
}
else
{
oracleParameter8 = new OracleParameter(":ShowType", OracleDbType.Int32, 11);
oracleParameter8.Value = (object)DBNull.Value;
}
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
nullable = model.DataType;
OracleParameter oracleParameter9;
if (nullable.HasValue)
{
OracleParameter oracleParameter5 = new OracleParameter(":DataType", OracleDbType.Int32, 11);
oracleParameter5.Value = (object)model.DataType;
oracleParameter9 = oracleParameter5;
}
else
{
oracleParameter9 = new OracleParameter(":DataType", OracleDbType.Int32, 11);
oracleParameter9.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter9;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.ShowFormat != null)
{
OracleParameter oracleParameter5 = new OracleParameter(":ShowFormat", OracleDbType.Varchar2, 50);
oracleParameter5.Value = (object)model.ShowFormat;
oracleParameter10 = oracleParameter5;
}
else
{
oracleParameter10 = new OracleParameter(":ShowFormat", OracleDbType.Varchar2, 50);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11;
if (model.CustomString != null)
{
OracleParameter oracleParameter5 = new OracleParameter(":CustomString", OracleDbType.Blob, -1);
oracleParameter5.Value = (object)model.CustomString;
oracleParameter11 = oracleParameter5;
}
else
{
oracleParameter11 = new OracleParameter(":CustomString", OracleDbType.Blob, -1);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12 = new OracleParameter(":Sort", OracleDbType.Int32, 11);
oracleParameter12.Value = (object)model.Sort;
oracleParameterArray[index11] = oracleParameter12;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderExport model)
{
string sql = "INSERT INTO ProgramBuilderExport\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,DataType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@Field,@ShowTitle,@Align,@Width,@ShowType,@DataType,@ShowFormat,@CustomString,@Sort)";
SqlParameter[] sqlParameterArray = new SqlParameter[11];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.ID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.ProgramID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Field", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.Field;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4;
if (model.ShowTitle != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@ShowTitle", SqlDbType.NVarChar, 1000);
sqlParameter5.Value = (object)model.ShowTitle;
sqlParameter4 = sqlParameter5;
}
else
{
sqlParameter4 = new SqlParameter("@ShowTitle", SqlDbType.NVarChar, 1000);
sqlParameter4.Value = (object)DBNull.Value;
}
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter6 = new SqlParameter("@Align", SqlDbType.Int, -1);
sqlParameter6.Value = (object)model.Align;
sqlParameterArray[index5] = sqlParameter6;
int index6 = 5;
int? nullable = model.Width;
SqlParameter sqlParameter7;
if (nullable.HasValue)
{
SqlParameter sqlParameter5 = new SqlParameter("@Width", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.Width;
sqlParameter7 = sqlParameter5;
}
else
{
sqlParameter7 = new SqlParameter("@Width", SqlDbType.Int, -1);
sqlParameter7.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter7;
int index7 = 6;
nullable = model.ShowType;
SqlParameter sqlParameter8;
if (nullable.HasValue)
{
SqlParameter sqlParameter5 = new SqlParameter("@ShowType", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.ShowType;
sqlParameter8 = sqlParameter5;
}
else
{
sqlParameter8 = new SqlParameter("@ShowType", SqlDbType.Int, -1);
sqlParameter8.Value = (object)DBNull.Value;
}
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
nullable = model.DataType;
SqlParameter sqlParameter9;
if (nullable.HasValue)
{
SqlParameter sqlParameter5 = new SqlParameter("@DataType", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.DataType;
sqlParameter9 = sqlParameter5;
}
else
{
sqlParameter9 = new SqlParameter("@DataType", SqlDbType.Int, -1);
sqlParameter9.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter9;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.ShowFormat != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@ShowFormat", SqlDbType.VarChar, 50);
sqlParameter5.Value = (object)model.ShowFormat;
sqlParameter10 = sqlParameter5;
}
else
{
sqlParameter10 = new SqlParameter("@ShowFormat", SqlDbType.VarChar, 50);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11;
if (model.CustomString != null)
{
SqlParameter sqlParameter5 = new SqlParameter("@CustomString", SqlDbType.VarChar, 5000);
sqlParameter5.Value = (object)model.CustomString;
sqlParameter11 = sqlParameter5;
}
else
{
sqlParameter11 = new SqlParameter("@CustomString", SqlDbType.VarChar, 5000);
sqlParameter11.Value = (object)DBNull.Value;
}
sqlParameterArray[index10] = sqlParameter11;
int index11 = 10;
SqlParameter sqlParameter12 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter12.Value = (object)model.Sort;
sqlParameterArray[index11] = sqlParameter12;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.ProgramBuilderExport model)
{
return(this.dataProgramBuilderExport.Update(model));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderExport model)
{
string sql = "INSERT INTO programbuilderexport\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,DataType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@Field,@ShowTitle,@Align,@Width,@ShowType,@DataType,@ShowFormat,@CustomString,@Sort)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[11];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@ProgramID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.ProgramID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Field", MySqlDbType.Text, -1);
mySqlParameter3.Value = (object)model.Field;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4;
if (model.ShowTitle != null)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@ShowTitle", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.ShowTitle;
mySqlParameter4 = mySqlParameter5;
}
else
{
mySqlParameter4 = new MySqlParameter("@ShowTitle", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)DBNull.Value;
}
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Align", MySqlDbType.Int32, 11);
mySqlParameter6.Value = (object)model.Align;
mySqlParameterArray[index5] = mySqlParameter6;
int index6 = 5;
int? nullable = model.Width;
MySqlParameter mySqlParameter7;
if (nullable.HasValue)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@Width", MySqlDbType.Int32, 11);
mySqlParameter5.Value = (object)model.Width;
mySqlParameter7 = mySqlParameter5;
}
else
{
mySqlParameter7 = new MySqlParameter("@Width", MySqlDbType.Int32, 11);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[index6] = mySqlParameter7;
int index7 = 6;
nullable = model.ShowType;
MySqlParameter mySqlParameter8;
if (nullable.HasValue)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@ShowType", MySqlDbType.Int32, 11);
mySqlParameter5.Value = (object)model.ShowType;
mySqlParameter8 = mySqlParameter5;
}
else
{
mySqlParameter8 = new MySqlParameter("@ShowType", MySqlDbType.Int32, 11);
mySqlParameter8.Value = (object)DBNull.Value;
}
mySqlParameterArray[index7] = mySqlParameter8;
int index8 = 7;
nullable = model.DataType;
MySqlParameter mySqlParameter9;
if (nullable.HasValue)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@DataType", MySqlDbType.Int32, 11);
mySqlParameter5.Value = (object)model.DataType;
mySqlParameter9 = mySqlParameter5;
}
else
{
mySqlParameter9 = new MySqlParameter("@DataType", MySqlDbType.Int32, 11);
mySqlParameter9.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter9;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.ShowFormat != null)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@ShowFormat", MySqlDbType.VarChar, 50);
mySqlParameter5.Value = (object)model.ShowFormat;
mySqlParameter10 = mySqlParameter5;
}
else
{
mySqlParameter10 = new MySqlParameter("@ShowFormat", MySqlDbType.VarChar, 50);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11;
if (model.CustomString != null)
{
MySqlParameter mySqlParameter5 = new MySqlParameter("@CustomString", MySqlDbType.Text, -1);
mySqlParameter5.Value = (object)model.CustomString;
mySqlParameter11 = mySqlParameter5;
}
else
{
mySqlParameter11 = new MySqlParameter("@CustomString", MySqlDbType.Text, -1);
mySqlParameter11.Value = (object)DBNull.Value;
}
mySqlParameterArray[index10] = mySqlParameter11;
int index11 = 10;
MySqlParameter mySqlParameter12 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter12.Value = (object)model.Sort;
mySqlParameterArray[index11] = mySqlParameter12;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
