private List <RoadFlow.Data.Model.ProgramBuilderQuerys> DataReaderToList(MySqlDataReader dataReader) { List <RoadFlow.Data.Model.ProgramBuilderQuerys> list = new List <RoadFlow.Data.Model.ProgramBuilderQuerys>(); RoadFlow.Data.Model.ProgramBuilderQuerys programBuilderQuerys = null; while (((DbDataReader)dataReader).Read()) { programBuilderQuerys = new RoadFlow.Data.Model.ProgramBuilderQuerys(); programBuilderQuerys.ID = ((DbDataReader)dataReader).GetString(0).ToGuid(); programBuilderQuerys.ProgramID = ((DbDataReader)dataReader).GetString(1).ToGuid(); programBuilderQuerys.Field = ((DbDataReader)dataReader).GetString(2); programBuilderQuerys.ShowTitle = ((DbDataReader)dataReader).GetString(3); programBuilderQuerys.Operators = ((DbDataReader)dataReader).GetString(4); programBuilderQuerys.ControlName = ((DbDataReader)dataReader).GetString(5); programBuilderQuerys.InputType = ((DbDataReader)dataReader).GetInt32(6); if (!((DbDataReader)dataReader).IsDBNull(7)) { programBuilderQuerys.Width = ((DbDataReader)dataReader).GetString(7); } programBuilderQuerys.Sort = ((DbDataReader)dataReader).GetInt32(8); if (!((DbDataReader)dataReader).IsDBNull(9)) { programBuilderQuerys.DataSource = ((DbDataReader)dataReader).GetInt32(9); } if (!((DbDataReader)dataReader).IsDBNull(10)) { programBuilderQuerys.DataSourceString = ((DbDataReader)dataReader).GetString(10); } if (!((DbDataReader)dataReader).IsDBNull(11)) { programBuilderQuerys.DataLinkID = ((DbDataReader)dataReader).GetString(11); } if (!((DbDataReader)dataReader).IsDBNull(12)) { programBuilderQuerys.IsQueryUsers = ((DbDataReader)dataReader).GetInt32(12); } if (!((DbDataReader)dataReader).IsDBNull(13)) { programBuilderQuerys.Value = ((DbDataReader)dataReader).GetString(13); } list.Add(programBuilderQuerys); } return(list); }
public int Update(RoadFlow.Data.Model.ProgramBuilderQuerys model) { //IL_001b: Unknown result type (might be due to invalid IL or missing references) //IL_0020: Unknown result type (might be due to invalid IL or missing references) //IL_0031: Expected O, but got Unknown //IL_0032: Expected O, but got Unknown //IL_003f: Unknown result type (might be due to invalid IL or missing references) //IL_0044: Unknown result type (might be due to invalid IL or missing references) //IL_0050: Expected O, but got Unknown //IL_0051: Expected O, but got Unknown //IL_005e: Unknown result type (might be due to invalid IL or missing references) //IL_0063: Unknown result type (might be due to invalid IL or missing references) //IL_006f: Expected O, but got Unknown //IL_0070: Expected O, but got Unknown //IL_007e: Unknown result type (might be due to invalid IL or missing references) //IL_0083: Unknown result type (might be due to invalid IL or missing references) //IL_008f: Expected O, but got Unknown //IL_0090: Expected O, but got Unknown //IL_009e: Unknown result type (might be due to invalid IL or missing references) //IL_00a3: Unknown result type (might be due to invalid IL or missing references) //IL_00af: Expected O, but got Unknown //IL_00b0: Expected O, but got Unknown //IL_00ba: Unknown result type (might be due to invalid IL or missing references) //IL_00bf: Unknown result type (might be due to invalid IL or missing references) //IL_00d0: Expected O, but got Unknown //IL_00d1: Expected O, but got Unknown //IL_00e7: Unknown result type (might be due to invalid IL or missing references) //IL_00ec: Unknown result type (might be due to invalid IL or missing references) //IL_00f8: Expected O, but got Unknown //IL_0106: Unknown result type (might be due to invalid IL or missing references) //IL_010b: Unknown result type (might be due to invalid IL or missing references) //IL_0116: Expected O, but got Unknown //IL_0117: Expected O, but got Unknown //IL_0121: Unknown result type (might be due to invalid IL or missing references) //IL_0126: Unknown result type (might be due to invalid IL or missing references) //IL_0137: Expected O, but got Unknown //IL_0138: Expected O, but got Unknown //IL_0152: Unknown result type (might be due to invalid IL or missing references) //IL_0157: Unknown result type (might be due to invalid IL or missing references) //IL_0168: Expected O, but got Unknown //IL_0172: Unknown result type (might be due to invalid IL or missing references) //IL_0177: Unknown result type (might be due to invalid IL or missing references) //IL_0182: Expected O, but got Unknown //IL_0183: Expected O, but got Unknown //IL_0199: Unknown result type (might be due to invalid IL or missing references) //IL_019e: Unknown result type (might be due to invalid IL or missing references) //IL_01aa: Expected O, but got Unknown //IL_01b7: Unknown result type (might be due to invalid IL or missing references) //IL_01bc: Unknown result type (might be due to invalid IL or missing references) //IL_01c7: Expected O, but got Unknown //IL_01c8: Expected O, but got Unknown //IL_01df: Unknown result type (might be due to invalid IL or missing references) //IL_01e4: Unknown result type (might be due to invalid IL or missing references) //IL_01f0: Expected O, but got Unknown //IL_01fe: Unknown result type (might be due to invalid IL or missing references) //IL_0203: Unknown result type (might be due to invalid IL or missing references) //IL_020e: Expected O, but got Unknown //IL_020f: Expected O, but got Unknown //IL_022a: Unknown result type (might be due to invalid IL or missing references) //IL_022f: Unknown result type (might be due to invalid IL or missing references) //IL_0240: Expected O, but got Unknown //IL_024a: Unknown result type (might be due to invalid IL or missing references) //IL_024f: Unknown result type (might be due to invalid IL or missing references) //IL_025a: Expected O, but got Unknown //IL_025b: Expected O, but got Unknown //IL_0272: Unknown result type (might be due to invalid IL or missing references) //IL_0277: Unknown result type (might be due to invalid IL or missing references) //IL_0283: Expected O, but got Unknown //IL_0291: Unknown result type (might be due to invalid IL or missing references) //IL_0296: Unknown result type (might be due to invalid IL or missing references) //IL_02a1: Expected O, but got Unknown //IL_02a2: Expected O, but got Unknown //IL_02b1: Unknown result type (might be due to invalid IL or missing references) //IL_02b6: Unknown result type (might be due to invalid IL or missing references) //IL_02c7: Expected O, but got Unknown //IL_02c8: Expected O, but got Unknown string sql = "UPDATE programbuilderquerys SET \r\n\t\t\t\tProgramID=@ProgramID,Field=@Field,ShowTitle=@ShowTitle,Operators=@Operators,ControlName=@ControlName,InputType=@InputType,Width=@Width,Sort=@Sort,DataSource=@DataSource,DataSourceString=@DataSourceString,DataLinkID=@DataLinkID,IsQueryUsers=@IsQueryUsers,Value=@Value\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] obj = new MySqlParameter[14]; MySqlParameter val = new MySqlParameter("@ProgramID", 253, 36); ((DbParameter)val).Value = model.ProgramID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Field", 752, -1); ((DbParameter)val2).Value = model.Field; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@ShowTitle", 752, -1); ((DbParameter)val3).Value = model.ShowTitle; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Operators", 253, 50); ((DbParameter)val4).Value = model.Operators; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@ControlName", 253, 50); ((DbParameter)val5).Value = model.ControlName; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@InputType", 3, 11); ((DbParameter)val6).Value = model.InputType; obj[5] = val6; _003F val7; if (model.Width != null) { val7 = new MySqlParameter("@Width", 253, 50); ((DbParameter)val7).Value = model.Width; } else { val7 = new MySqlParameter("@Width", 253, 50); ((DbParameter)val7).Value = DBNull.Value; } obj[6] = val7; MySqlParameter val8 = new MySqlParameter("@Sort", 3, 11); ((DbParameter)val8).Value = model.Sort; obj[7] = val8; _003F val9; if (model.DataSource.HasValue) { val9 = new MySqlParameter("@DataSource", 3, 11); ((DbParameter)val9).Value = model.DataSource; } else { val9 = new MySqlParameter("@DataSource", 3, 11); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.DataSourceString != null) { val10 = new MySqlParameter("@DataSourceString", 751, -1); ((DbParameter)val10).Value = model.DataSourceString; } else { val10 = new MySqlParameter("@DataSourceString", 751, -1); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.DataLinkID != null) { val11 = new MySqlParameter("@DataLinkID", 253, 50); ((DbParameter)val11).Value = model.DataLinkID; } else { val11 = new MySqlParameter("@DataLinkID", 253, 50); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.IsQueryUsers.HasValue) { val12 = new MySqlParameter("@IsQueryUsers", 3, 11); ((DbParameter)val12).Value = model.IsQueryUsers; } else { val12 = new MySqlParameter("@IsQueryUsers", 3, 11); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.Value != null) { val13 = new MySqlParameter("@Value", 253, 50); ((DbParameter)val13).Value = model.Value; } else { val13 = new MySqlParameter("@Value", 253, 50); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; MySqlParameter val14 = new MySqlParameter("@ID", 253, 36); ((DbParameter)val14).Value = model.ID; obj[13] = val14; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.ProgramBuilderQuerys model) { return(dataProgramBuilderQuerys.Update(model)); }
public int Add(RoadFlow.Data.Model.ProgramBuilderQuerys model) { //IL_001b: Unknown result type (might be due to invalid IL or missing references) //IL_0020: Unknown result type (might be due to invalid IL or missing references) //IL_0031: Expected O, but got Unknown //IL_0032: Expected O, but got Unknown //IL_0040: Unknown result type (might be due to invalid IL or missing references) //IL_0045: Unknown result type (might be due to invalid IL or missing references) //IL_0056: Expected O, but got Unknown //IL_0057: Expected O, but got Unknown //IL_0064: Unknown result type (might be due to invalid IL or missing references) //IL_0069: Unknown result type (might be due to invalid IL or missing references) //IL_0075: Expected O, but got Unknown //IL_0076: Expected O, but got Unknown //IL_0083: Unknown result type (might be due to invalid IL or missing references) //IL_0088: Unknown result type (might be due to invalid IL or missing references) //IL_0094: Expected O, but got Unknown //IL_0095: Expected O, but got Unknown //IL_00a3: Unknown result type (might be due to invalid IL or missing references) //IL_00a8: Unknown result type (might be due to invalid IL or missing references) //IL_00b4: Expected O, but got Unknown //IL_00b5: Expected O, but got Unknown //IL_00c3: Unknown result type (might be due to invalid IL or missing references) //IL_00c8: Unknown result type (might be due to invalid IL or missing references) //IL_00d4: Expected O, but got Unknown //IL_00d5: Expected O, but got Unknown //IL_00df: Unknown result type (might be due to invalid IL or missing references) //IL_00e4: Unknown result type (might be due to invalid IL or missing references) //IL_00f5: Expected O, but got Unknown //IL_00f6: Expected O, but got Unknown //IL_010c: Unknown result type (might be due to invalid IL or missing references) //IL_0111: Unknown result type (might be due to invalid IL or missing references) //IL_011d: Expected O, but got Unknown //IL_012b: Unknown result type (might be due to invalid IL or missing references) //IL_0130: Unknown result type (might be due to invalid IL or missing references) //IL_013b: Expected O, but got Unknown //IL_013c: Expected O, but got Unknown //IL_0146: Unknown result type (might be due to invalid IL or missing references) //IL_014b: Unknown result type (might be due to invalid IL or missing references) //IL_015c: Expected O, but got Unknown //IL_015d: Expected O, but got Unknown //IL_0178: Unknown result type (might be due to invalid IL or missing references) //IL_017d: Unknown result type (might be due to invalid IL or missing references) //IL_018e: Expected O, but got Unknown //IL_0198: Unknown result type (might be due to invalid IL or missing references) //IL_019d: Unknown result type (might be due to invalid IL or missing references) //IL_01a8: Expected O, but got Unknown //IL_01a9: Expected O, but got Unknown //IL_01bf: Unknown result type (might be due to invalid IL or missing references) //IL_01c4: Unknown result type (might be due to invalid IL or missing references) //IL_01d0: Expected O, but got Unknown //IL_01dd: Unknown result type (might be due to invalid IL or missing references) //IL_01e2: Unknown result type (might be due to invalid IL or missing references) //IL_01ed: Expected O, but got Unknown //IL_01ee: Expected O, but got Unknown //IL_0205: Unknown result type (might be due to invalid IL or missing references) //IL_020a: Unknown result type (might be due to invalid IL or missing references) //IL_0216: Expected O, but got Unknown //IL_0224: Unknown result type (might be due to invalid IL or missing references) //IL_0229: Unknown result type (might be due to invalid IL or missing references) //IL_0234: Expected O, but got Unknown //IL_0235: Expected O, but got Unknown //IL_0250: Unknown result type (might be due to invalid IL or missing references) //IL_0255: Unknown result type (might be due to invalid IL or missing references) //IL_0266: Expected O, but got Unknown //IL_0270: Unknown result type (might be due to invalid IL or missing references) //IL_0275: Unknown result type (might be due to invalid IL or missing references) //IL_0280: Expected O, but got Unknown //IL_0281: Expected O, but got Unknown //IL_0298: Unknown result type (might be due to invalid IL or missing references) //IL_029d: Unknown result type (might be due to invalid IL or missing references) //IL_02a9: Expected O, but got Unknown //IL_02b7: Unknown result type (might be due to invalid IL or missing references) //IL_02bc: Unknown result type (might be due to invalid IL or missing references) //IL_02c7: Expected O, but got Unknown //IL_02c8: Expected O, but got Unknown 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)"; MySqlParameter[] obj = new MySqlParameter[14]; MySqlParameter val = new MySqlParameter("@ID", 253, 36); ((DbParameter)val).Value = model.ID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@ProgramID", 253, 36); ((DbParameter)val2).Value = model.ProgramID; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Field", 752, -1); ((DbParameter)val3).Value = model.Field; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@ShowTitle", 752, -1); ((DbParameter)val4).Value = model.ShowTitle; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@Operators", 253, 50); ((DbParameter)val5).Value = model.Operators; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@ControlName", 253, 50); ((DbParameter)val6).Value = model.ControlName; obj[5] = val6; MySqlParameter val7 = new MySqlParameter("@InputType", 3, 11); ((DbParameter)val7).Value = model.InputType; obj[6] = val7; _003F val8; if (model.Width != null) { val8 = new MySqlParameter("@Width", 253, 50); ((DbParameter)val8).Value = model.Width; } else { val8 = new MySqlParameter("@Width", 253, 50); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; MySqlParameter val9 = new MySqlParameter("@Sort", 3, 11); ((DbParameter)val9).Value = model.Sort; obj[8] = val9; _003F val10; if (model.DataSource.HasValue) { val10 = new MySqlParameter("@DataSource", 3, 11); ((DbParameter)val10).Value = model.DataSource; } else { val10 = new MySqlParameter("@DataSource", 3, 11); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.DataSourceString != null) { val11 = new MySqlParameter("@DataSourceString", 751, -1); ((DbParameter)val11).Value = model.DataSourceString; } else { val11 = new MySqlParameter("@DataSourceString", 751, -1); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.DataLinkID != null) { val12 = new MySqlParameter("@DataLinkID", 253, 50); ((DbParameter)val12).Value = model.DataLinkID; } else { val12 = new MySqlParameter("@DataLinkID", 253, 50); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.IsQueryUsers.HasValue) { val13 = new MySqlParameter("@IsQueryUsers", 3, 11); ((DbParameter)val13).Value = model.IsQueryUsers; } else { val13 = new MySqlParameter("@IsQueryUsers", 3, 11); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; _003F val14; if (model.Value != null) { val14 = new MySqlParameter("@Value", 253, 50); ((DbParameter)val14).Value = model.Value; } else { val14 = new MySqlParameter("@Value", 253, 50); ((DbParameter)val14).Value = DBNull.Value; } obj[13] = val14; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.ProgramBuilderQuerys model) { return(dataProgramBuilderQuerys.Add(model)); }
public int Update(RoadFlow.Data.Model.ProgramBuilderQuerys model) { string sql = "UPDATE ProgramBuilderQuerys SET \r\n\t\t\t\tProgramID=@ProgramID,Field=@Field,ShowTitle=@ShowTitle,Operators=@Operators,ControlName=@ControlName,InputType=@InputType,Width=@Width,Sort=@Sort,DataSource=@DataSource,DataSourceString=@DataSourceString,DataLinkID=@DataLinkID,IsQueryUsers=@IsQueryUsers,Value=@Value\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] parameter = new SqlParameter[14] { new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1) { Value = model.ProgramID }, new SqlParameter("@Field", SqlDbType.VarChar, 500) { Value = model.Field }, new SqlParameter("@ShowTitle", SqlDbType.NVarChar, 1000) { Value = model.ShowTitle }, new SqlParameter("@Operators", SqlDbType.VarChar, 50) { Value = model.Operators }, new SqlParameter("@ControlName", SqlDbType.VarChar, 50) { Value = model.ControlName }, new SqlParameter("@InputType", SqlDbType.Int, -1) { Value = model.InputType }, (model.Width == null) ? new SqlParameter("@Width", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Width", SqlDbType.VarChar, 50) { Value = model.Width }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, (!model.DataSource.HasValue) ? new SqlParameter("@DataSource", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@DataSource", SqlDbType.Int, -1) { Value = model.DataSource }, (model.DataSourceString == null) ? new SqlParameter("@DataSourceString", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DataSourceString", SqlDbType.VarChar, -1) { Value = model.DataSourceString }, (model.DataLinkID == null) ? new SqlParameter("@DataLinkID", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@DataLinkID", SqlDbType.VarChar, 50) { Value = model.DataLinkID }, (!model.IsQueryUsers.HasValue) ? new SqlParameter("@IsQueryUsers", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@IsQueryUsers", SqlDbType.Int, -1) { Value = model.IsQueryUsers }, (model.Value == null) ? new SqlParameter("@Value", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Value", SqlDbType.VarChar, 50) { Value = model.Value }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameter)); }
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)"; SqlParameter[] parameter = new SqlParameter[14] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1) { Value = model.ProgramID }, new SqlParameter("@Field", SqlDbType.VarChar, 500) { Value = model.Field }, new SqlParameter("@ShowTitle", SqlDbType.NVarChar, 1000) { Value = model.ShowTitle }, new SqlParameter("@Operators", SqlDbType.VarChar, 50) { Value = model.Operators }, new SqlParameter("@ControlName", SqlDbType.VarChar, 50) { Value = model.ControlName }, new SqlParameter("@InputType", SqlDbType.Int, -1) { Value = model.InputType }, (model.Width == null) ? new SqlParameter("@Width", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Width", SqlDbType.VarChar, 50) { Value = model.Width }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, (!model.DataSource.HasValue) ? new SqlParameter("@DataSource", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@DataSource", SqlDbType.Int, -1) { Value = model.DataSource }, (model.DataSourceString == null) ? new SqlParameter("@DataSourceString", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DataSourceString", SqlDbType.VarChar, -1) { Value = model.DataSourceString }, (model.DataLinkID == null) ? new SqlParameter("@DataLinkID", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@DataLinkID", SqlDbType.VarChar, 50) { Value = model.DataLinkID }, (!model.IsQueryUsers.HasValue) ? new SqlParameter("@IsQueryUsers", SqlDbType.Int, -1) { Value = DBNull.Value } : new SqlParameter("@IsQueryUsers", SqlDbType.Int, -1) { Value = model.IsQueryUsers }, (model.Value == null) ? new SqlParameter("@Value", SqlDbType.VarChar, 50) { Value = DBNull.Value } : new SqlParameter("@Value", SqlDbType.VarChar, 50) { Value = model.Value } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.ProgramBuilderQuerys model) { //IL_0016: Unknown result type (might be due to invalid IL or missing references) //IL_001b: Unknown result type (might be due to invalid IL or missing references) //IL_002c: Expected O, but got Unknown //IL_002d: Expected O, but got Unknown //IL_0036: Unknown result type (might be due to invalid IL or missing references) //IL_003b: Unknown result type (might be due to invalid IL or missing references) //IL_0047: Expected O, but got Unknown //IL_0048: Expected O, but got Unknown //IL_0051: Unknown result type (might be due to invalid IL or missing references) //IL_0056: Unknown result type (might be due to invalid IL or missing references) //IL_0062: Expected O, but got Unknown //IL_0063: Expected O, but got Unknown //IL_006c: Unknown result type (might be due to invalid IL or missing references) //IL_0071: Unknown result type (might be due to invalid IL or missing references) //IL_007d: Expected O, but got Unknown //IL_007e: Expected O, but got Unknown //IL_0087: Unknown result type (might be due to invalid IL or missing references) //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_0098: Expected O, but got Unknown //IL_0099: Expected O, but got Unknown //IL_00a2: Unknown result type (might be due to invalid IL or missing references) //IL_00a7: Unknown result type (might be due to invalid IL or missing references) //IL_00b8: Expected O, but got Unknown //IL_00b9: Expected O, but got Unknown //IL_00ca: Unknown result type (might be due to invalid IL or missing references) //IL_00cf: Unknown result type (might be due to invalid IL or missing references) //IL_00db: Expected O, but got Unknown //IL_00e4: Unknown result type (might be due to invalid IL or missing references) //IL_00e9: Unknown result type (might be due to invalid IL or missing references) //IL_00f4: Expected O, but got Unknown //IL_00f5: Expected O, but got Unknown //IL_00ff: Unknown result type (might be due to invalid IL or missing references) //IL_0104: Unknown result type (might be due to invalid IL or missing references) //IL_0115: Expected O, but got Unknown //IL_0116: Expected O, but got Unknown //IL_012f: Unknown result type (might be due to invalid IL or missing references) //IL_0134: Unknown result type (might be due to invalid IL or missing references) //IL_0145: Expected O, but got Unknown //IL_014e: Unknown result type (might be due to invalid IL or missing references) //IL_0153: Unknown result type (might be due to invalid IL or missing references) //IL_015e: Expected O, but got Unknown //IL_015f: Expected O, but got Unknown //IL_0171: Unknown result type (might be due to invalid IL or missing references) //IL_0176: Unknown result type (might be due to invalid IL or missing references) //IL_0182: Expected O, but got Unknown //IL_018b: Unknown result type (might be due to invalid IL or missing references) //IL_0190: Unknown result type (might be due to invalid IL or missing references) //IL_019b: Expected O, but got Unknown //IL_019c: Expected O, but got Unknown //IL_01ae: Unknown result type (might be due to invalid IL or missing references) //IL_01b3: Unknown result type (might be due to invalid IL or missing references) //IL_01bf: Expected O, but got Unknown //IL_01c8: Unknown result type (might be due to invalid IL or missing references) //IL_01cd: Unknown result type (might be due to invalid IL or missing references) //IL_01d8: Expected O, but got Unknown //IL_01d9: Expected O, but got Unknown //IL_01f3: Unknown result type (might be due to invalid IL or missing references) //IL_01f8: Unknown result type (might be due to invalid IL or missing references) //IL_0209: Expected O, but got Unknown //IL_0212: Unknown result type (might be due to invalid IL or missing references) //IL_0217: Unknown result type (might be due to invalid IL or missing references) //IL_0222: Expected O, but got Unknown //IL_0223: Expected O, but got Unknown //IL_0235: Unknown result type (might be due to invalid IL or missing references) //IL_023a: Unknown result type (might be due to invalid IL or missing references) //IL_0246: Expected O, but got Unknown //IL_024f: Unknown result type (might be due to invalid IL or missing references) //IL_0254: Unknown result type (might be due to invalid IL or missing references) //IL_025f: Expected O, but got Unknown //IL_0260: Expected O, but got Unknown //IL_026a: Unknown result type (might be due to invalid IL or missing references) //IL_026f: Unknown result type (might be due to invalid IL or missing references) //IL_0280: Expected O, but got Unknown //IL_0281: Expected O, but got Unknown string sql = "UPDATE ProgramBuilderQuerys SET \r\n\t\t\t\tProgramID=:ProgramID,Field=:Field,ShowTitle=:ShowTitle,Operators=:Operators,ControlName=:ControlName,InputType=:InputType,Width=:Width,Sort=:Sort,DataSource=:DataSource,DataSourceString=:DataSourceString,DataLinkID=:DataLinkID,IsQueryUsers=:IsQueryUsers,Value=:Value\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] obj = new OracleParameter[14]; OracleParameter val = new OracleParameter(":ProgramID", 126); ((DbParameter)val).Value = model.ProgramID; obj[0] = val; OracleParameter val2 = new OracleParameter(":Field", 126); ((DbParameter)val2).Value = model.Field; obj[1] = val2; OracleParameter val3 = new OracleParameter(":ShowTitle", 126); ((DbParameter)val3).Value = model.ShowTitle; obj[2] = val3; OracleParameter val4 = new OracleParameter(":Operators", 126); ((DbParameter)val4).Value = model.Operators; obj[3] = val4; OracleParameter val5 = new OracleParameter(":ControlName", 126); ((DbParameter)val5).Value = model.ControlName; obj[4] = val5; OracleParameter val6 = new OracleParameter(":InputType", 112); ((DbParameter)val6).Value = model.InputType; obj[5] = val6; _003F val7; if (model.Width != null) { val7 = new OracleParameter(":Width", 126); ((DbParameter)val7).Value = model.Width; } else { val7 = new OracleParameter(":Width", 126); ((DbParameter)val7).Value = DBNull.Value; } obj[6] = val7; OracleParameter val8 = new OracleParameter(":Sort", 112, -1); ((DbParameter)val8).Value = model.Sort; obj[7] = val8; _003F val9; if (model.DataSource.HasValue) { val9 = new OracleParameter(":DataSource", 112); ((DbParameter)val9).Value = model.DataSource; } else { val9 = new OracleParameter(":DataSource", 112); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.DataSourceString != null) { val10 = new OracleParameter(":DataSourceString", 126); ((DbParameter)val10).Value = model.DataSourceString; } else { val10 = new OracleParameter(":DataSourceString", 126); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.DataLinkID != null) { val11 = new OracleParameter(":DataLinkID", 126); ((DbParameter)val11).Value = model.DataLinkID; } else { val11 = new OracleParameter(":DataLinkID", 126); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.IsQueryUsers.HasValue) { val12 = new OracleParameter(":IsQueryUsers", 112); ((DbParameter)val12).Value = model.IsQueryUsers; } else { val12 = new OracleParameter(":IsQueryUsers", 112); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.Value != null) { val13 = new OracleParameter(":Value", 126); ((DbParameter)val13).Value = model.Value; } else { val13 = new OracleParameter(":Value", 126); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; OracleParameter val14 = new OracleParameter(":ID", 126); ((DbParameter)val14).Value = model.ID; obj[13] = val14; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.ProgramBuilderQuerys model) { //IL_0016: Unknown result type (might be due to invalid IL or missing references) //IL_001b: Unknown result type (might be due to invalid IL or missing references) //IL_002c: Expected O, but got Unknown //IL_002d: Expected O, but got Unknown //IL_0036: Unknown result type (might be due to invalid IL or missing references) //IL_003b: Unknown result type (might be due to invalid IL or missing references) //IL_004c: Expected O, but got Unknown //IL_004d: Expected O, but got Unknown //IL_0056: Unknown result type (might be due to invalid IL or missing references) //IL_005b: Unknown result type (might be due to invalid IL or missing references) //IL_0067: Expected O, but got Unknown //IL_0068: Expected O, but got Unknown //IL_0071: Unknown result type (might be due to invalid IL or missing references) //IL_0076: Unknown result type (might be due to invalid IL or missing references) //IL_0082: Expected O, but got Unknown //IL_0083: Expected O, but got Unknown //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_0091: Unknown result type (might be due to invalid IL or missing references) //IL_009d: Expected O, but got Unknown //IL_009e: Expected O, but got Unknown //IL_00a7: Unknown result type (might be due to invalid IL or missing references) //IL_00ac: Unknown result type (might be due to invalid IL or missing references) //IL_00b8: Expected O, but got Unknown //IL_00b9: Expected O, but got Unknown //IL_00c2: Unknown result type (might be due to invalid IL or missing references) //IL_00c7: Unknown result type (might be due to invalid IL or missing references) //IL_00d8: Expected O, but got Unknown //IL_00d9: Expected O, but got Unknown //IL_00ea: Unknown result type (might be due to invalid IL or missing references) //IL_00ef: Unknown result type (might be due to invalid IL or missing references) //IL_00fb: Expected O, but got Unknown //IL_0104: Unknown result type (might be due to invalid IL or missing references) //IL_0109: Unknown result type (might be due to invalid IL or missing references) //IL_0114: Expected O, but got Unknown //IL_0115: Expected O, but got Unknown //IL_011e: Unknown result type (might be due to invalid IL or missing references) //IL_0123: Unknown result type (might be due to invalid IL or missing references) //IL_0134: Expected O, but got Unknown //IL_0135: Expected O, but got Unknown //IL_014f: Unknown result type (might be due to invalid IL or missing references) //IL_0154: Unknown result type (might be due to invalid IL or missing references) //IL_0165: Expected O, but got Unknown //IL_016e: Unknown result type (might be due to invalid IL or missing references) //IL_0173: Unknown result type (might be due to invalid IL or missing references) //IL_017e: Expected O, but got Unknown //IL_017f: Expected O, but got Unknown //IL_0191: Unknown result type (might be due to invalid IL or missing references) //IL_0196: Unknown result type (might be due to invalid IL or missing references) //IL_01a2: Expected O, but got Unknown //IL_01ab: Unknown result type (might be due to invalid IL or missing references) //IL_01b0: Unknown result type (might be due to invalid IL or missing references) //IL_01bb: Expected O, but got Unknown //IL_01bc: Expected O, but got Unknown //IL_01ce: Unknown result type (might be due to invalid IL or missing references) //IL_01d3: Unknown result type (might be due to invalid IL or missing references) //IL_01df: Expected O, but got Unknown //IL_01e8: Unknown result type (might be due to invalid IL or missing references) //IL_01ed: Unknown result type (might be due to invalid IL or missing references) //IL_01f8: Expected O, but got Unknown //IL_01f9: Expected O, but got Unknown //IL_0213: Unknown result type (might be due to invalid IL or missing references) //IL_0218: Unknown result type (might be due to invalid IL or missing references) //IL_0229: Expected O, but got Unknown //IL_0232: Unknown result type (might be due to invalid IL or missing references) //IL_0237: Unknown result type (might be due to invalid IL or missing references) //IL_0242: Expected O, but got Unknown //IL_0243: Expected O, but got Unknown //IL_0255: Unknown result type (might be due to invalid IL or missing references) //IL_025a: Unknown result type (might be due to invalid IL or missing references) //IL_0266: Expected O, but got Unknown //IL_026f: Unknown result type (might be due to invalid IL or missing references) //IL_0274: Unknown result type (might be due to invalid IL or missing references) //IL_027f: Expected O, but got Unknown //IL_0280: Expected O, but got Unknown 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[] obj = new OracleParameter[14]; OracleParameter val = new OracleParameter(":ID", 126); ((DbParameter)val).Value = model.ID; obj[0] = val; OracleParameter val2 = new OracleParameter(":ProgramID", 126); ((DbParameter)val2).Value = model.ProgramID; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Field", 126); ((DbParameter)val3).Value = model.Field; obj[2] = val3; OracleParameter val4 = new OracleParameter(":ShowTitle", 126); ((DbParameter)val4).Value = model.ShowTitle; obj[3] = val4; OracleParameter val5 = new OracleParameter(":Operators", 126); ((DbParameter)val5).Value = model.Operators; obj[4] = val5; OracleParameter val6 = new OracleParameter(":ControlName", 126); ((DbParameter)val6).Value = model.ControlName; obj[5] = val6; OracleParameter val7 = new OracleParameter(":InputType", 112); ((DbParameter)val7).Value = model.InputType; obj[6] = val7; _003F val8; if (model.Width != null) { val8 = new OracleParameter(":Width", 126); ((DbParameter)val8).Value = model.Width; } else { val8 = new OracleParameter(":Width", 126); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; OracleParameter val9 = new OracleParameter(":Sort", 112); ((DbParameter)val9).Value = model.Sort; obj[8] = val9; _003F val10; if (model.DataSource.HasValue) { val10 = new OracleParameter(":DataSource", 112); ((DbParameter)val10).Value = model.DataSource; } else { val10 = new OracleParameter(":DataSource", 112); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.DataSourceString != null) { val11 = new OracleParameter(":DataSourceString", 126); ((DbParameter)val11).Value = model.DataSourceString; } else { val11 = new OracleParameter(":DataSourceString", 126); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; _003F val12; if (model.DataLinkID != null) { val12 = new OracleParameter(":DataLinkID", 126); ((DbParameter)val12).Value = model.DataLinkID; } else { val12 = new OracleParameter(":DataLinkID", 126); ((DbParameter)val12).Value = DBNull.Value; } obj[11] = val12; _003F val13; if (model.IsQueryUsers.HasValue) { val13 = new OracleParameter(":IsQueryUsers", 112); ((DbParameter)val13).Value = model.IsQueryUsers; } else { val13 = new OracleParameter(":IsQueryUsers", 112); ((DbParameter)val13).Value = DBNull.Value; } obj[12] = val13; _003F val14; if (model.Value != null) { val14 = new OracleParameter(":Value", 126); ((DbParameter)val14).Value = model.Value; } else { val14 = new OracleParameter(":Value", 126); ((DbParameter)val14).Value = DBNull.Value; } obj[13] = val14; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }