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