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