public int Add(RoadFlow.Data.Model.ProgramBuilderQuerys model)
{
string sql = "INSERT INTO ProgramBuilderQuerys\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Operators,ControlName,InputType,Width,Sort,DataSource,DataSourceString,DataLinkID,IsQueryUsers,Value) \r\n\t\t\t\tVALUES(:ID,:ProgramID,:Field,:ShowTitle,:Operators,:ControlName,:InputType,:Width,:Sort,:DataSource,:DataSourceString,:DataLinkID,:IsQueryUsers,:Value)";
OracleParameter[] oracleParameterArray = new OracleParameter[14];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":ProgramID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.ProgramID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Field", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.Field;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":ShowTitle", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.ShowTitle;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":Operators", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.Operators;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6 = new OracleParameter(":ControlName", OracleDbType.Varchar2);
oracleParameter6.Value = (object)model.ControlName;
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter7 = new OracleParameter(":InputType", OracleDbType.Int32);
oracleParameter7.Value = (object)model.InputType;
oracleParameterArray[index7] = oracleParameter7;
int index8 = 7;
OracleParameter oracleParameter8;
if (model.Width != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":Width", OracleDbType.Varchar2);
oracleParameter9.Value = (object)model.Width;
oracleParameter8 = oracleParameter9;
}
else
{
oracleParameter8 = new OracleParameter(":Width", OracleDbType.Varchar2);
oracleParameter8.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter8;
int index9 = 8;
OracleParameter oracleParameter10 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter10.Value = (object)model.Sort;
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
int? nullable = model.DataSource;
OracleParameter oracleParameter11;
if (nullable.HasValue)
{
OracleParameter oracleParameter9 = new OracleParameter(":DataSource", OracleDbType.Int32);
oracleParameter9.Value = (object)model.DataSource;
oracleParameter11 = oracleParameter9;
}
else
{
oracleParameter11 = new OracleParameter(":DataSource", OracleDbType.Int32);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12;
if (model.DataSourceString != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":DataSourceString", OracleDbType.Varchar2);
oracleParameter9.Value = (object)model.DataSourceString;
oracleParameter12 = oracleParameter9;
}
else
{
oracleParameter12 = new OracleParameter(":DataSourceString", OracleDbType.Varchar2);
oracleParameter12.Value = (object)DBNull.Value;
}
oracleParameterArray[index11] = oracleParameter12;
int index12 = 11;
OracleParameter oracleParameter13;
if (model.DataLinkID != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":DataLinkID", OracleDbType.Varchar2);
oracleParameter9.Value = (object)model.DataLinkID;
oracleParameter13 = oracleParameter9;
}
else
{
oracleParameter13 = new OracleParameter(":DataLinkID", OracleDbType.Varchar2);
oracleParameter13.Value = (object)DBNull.Value;
}
oracleParameterArray[index12] = oracleParameter13;
int index13 = 12;
nullable = model.IsQueryUsers;
OracleParameter oracleParameter14;
if (nullable.HasValue)
{
OracleParameter oracleParameter9 = new OracleParameter(":IsQueryUsers", OracleDbType.Int32);
oracleParameter9.Value = (object)model.IsQueryUsers;
oracleParameter14 = oracleParameter9;
}
else
{
oracleParameter14 = new OracleParameter(":IsQueryUsers", OracleDbType.Int32);
oracleParameter14.Value = (object)DBNull.Value;
}
oracleParameterArray[index13] = oracleParameter14;
int index14 = 13;
OracleParameter oracleParameter15;
if (model.Value != null)
{
OracleParameter oracleParameter9 = new OracleParameter(":Value", OracleDbType.Varchar2);
oracleParameter9.Value = (object)model.Value;
oracleParameter15 = oracleParameter9;
}
else
{
oracleParameter15 = new OracleParameter(":Value", OracleDbType.Varchar2);
oracleParameter15.Value = (object)DBNull.Value;
}
oracleParameterArray[index14] = oracleParameter15;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
