private List <RoadFlow.Data.Model.WorkFlow> DataReaderToList(MySqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlow> list = new List <RoadFlow.Data.Model.WorkFlow>(); RoadFlow.Data.Model.WorkFlow workFlow = null; while (((DbDataReader)dataReader).Read()) { workFlow = new RoadFlow.Data.Model.WorkFlow(); workFlow.ID = ((DbDataReader)dataReader).GetString(0).ToGuid(); workFlow.Name = ((DbDataReader)dataReader).GetString(1); workFlow.Type = ((DbDataReader)dataReader).GetString(2).ToGuid(); workFlow.Manager = ((DbDataReader)dataReader).GetString(3); workFlow.InstanceManager = ((DbDataReader)dataReader).GetString(4); workFlow.CreateDate = ((DbDataReader)dataReader).GetDateTime(5); workFlow.CreateUserID = ((DbDataReader)dataReader).GetString(6).ToGuid(); if (!((DbDataReader)dataReader).IsDBNull(7)) { workFlow.DesignJSON = ((DbDataReader)dataReader).GetString(7); } if (!((DbDataReader)dataReader).IsDBNull(8)) { workFlow.InstallDate = ((DbDataReader)dataReader).GetDateTime(8); } if (!((DbDataReader)dataReader).IsDBNull(9)) { workFlow.InstallUserID = ((DbDataReader)dataReader).GetString(9).ToGuid(); } if (!((DbDataReader)dataReader).IsDBNull(10)) { workFlow.RunJSON = ((DbDataReader)dataReader).GetString(10); } workFlow.Status = ((DbDataReader)dataReader).GetInt32(11); list.Add(workFlow); } return(list); }
public int Update(RoadFlow.Data.Model.WorkFlow model) { //IL_001a: Unknown result type (might be due to invalid IL or missing references) //IL_001f: Unknown result type (might be due to invalid IL or missing references) //IL_002b: Expected O, but got Unknown //IL_002c: Expected O, but got Unknown //IL_003a: Unknown result type (might be due to invalid IL or missing references) //IL_003f: 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_007d: Unknown result type (might be due to invalid IL or missing references) //IL_0082: Unknown result type (might be due to invalid IL or missing references) //IL_008e: Expected O, but got Unknown //IL_008f: Expected O, but got Unknown //IL_0099: Unknown result type (might be due to invalid IL or missing references) //IL_009e: 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_00be: Unknown result type (might be due to invalid IL or missing references) //IL_00c3: 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_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_0108: Unknown result type (might be due to invalid IL or missing references) //IL_010d: Unknown result type (might be due to invalid IL or missing references) //IL_0118: Expected O, but got Unknown //IL_0119: Expected O, but got Unknown //IL_0133: Unknown result type (might be due to invalid IL or missing references) //IL_0138: Unknown result type (might be due to invalid IL or missing references) //IL_0149: Expected O, but got Unknown //IL_0153: Unknown result type (might be due to invalid IL or missing references) //IL_0158: Unknown result type (might be due to invalid IL or missing references) //IL_0163: Expected O, but got Unknown //IL_0164: Expected O, but got Unknown //IL_0182: Unknown result type (might be due to invalid IL or missing references) //IL_0187: Unknown result type (might be due to invalid IL or missing references) //IL_0198: Expected O, but got Unknown //IL_01a6: Unknown result type (might be due to invalid IL or missing references) //IL_01ab: Unknown result type (might be due to invalid IL or missing references) //IL_01b6: Expected O, but got Unknown //IL_01b7: Expected O, but got Unknown //IL_01cd: Unknown result type (might be due to invalid IL or missing references) //IL_01d2: Unknown result type (might be due to invalid IL or missing references) //IL_01de: Expected O, but got Unknown //IL_01eb: Unknown result type (might be due to invalid IL or missing references) //IL_01f0: Unknown result type (might be due to invalid IL or missing references) //IL_01fb: Expected O, but got Unknown //IL_01fc: Expected O, but got Unknown //IL_0207: Unknown result type (might be due to invalid IL or missing references) //IL_020c: Unknown result type (might be due to invalid IL or missing references) //IL_021d: Expected O, but got Unknown //IL_021e: Expected O, but got Unknown //IL_022d: Unknown result type (might be due to invalid IL or missing references) //IL_0232: Unknown result type (might be due to invalid IL or missing references) //IL_0243: Expected O, but got Unknown //IL_0244: Expected O, but got Unknown string sql = "UPDATE workflow SET \r\n\t\t\t\tName=@Name,Type=@Type,Manager=@Manager,InstanceManager=@InstanceManager,CreateDate=@CreateDate,CreateUserID=@CreateUserID,DesignJSON=@DesignJSON,InstallDate=@InstallDate,InstallUserID=@InstallUserID,RunJSON=@RunJSON,Status=@Status\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] obj = new MySqlParameter[12]; MySqlParameter val = new MySqlParameter("@Name", 752, -1); ((DbParameter)val).Value = model.Name; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Type", 253, 36); ((DbParameter)val2).Value = model.Type; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Manager", 752, -1); ((DbParameter)val3).Value = model.Manager; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@InstanceManager", 752, -1); ((DbParameter)val4).Value = model.InstanceManager; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@CreateDate", 12, -1); ((DbParameter)val5).Value = model.CreateDate; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@CreateUserID", 253, 36); ((DbParameter)val6).Value = model.CreateUserID; obj[5] = val6; _003F val7; if (model.DesignJSON != null) { val7 = new MySqlParameter("@DesignJSON", 751, -1); ((DbParameter)val7).Value = model.DesignJSON; } else { val7 = new MySqlParameter("@DesignJSON", 751, -1); ((DbParameter)val7).Value = DBNull.Value; } obj[6] = val7; _003F val8; if (model.InstallDate.HasValue) { val8 = new MySqlParameter("@InstallDate", 12, -1); ((DbParameter)val8).Value = model.InstallDate; } else { val8 = new MySqlParameter("@InstallDate", 12, -1); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; _003F val9; if (model.InstallUserID.HasValue) { val9 = new MySqlParameter("@InstallUserID", 253, 36); ((DbParameter)val9).Value = model.InstallUserID; } else { val9 = new MySqlParameter("@InstallUserID", 253, 36); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.RunJSON != null) { val10 = new MySqlParameter("@RunJSON", 751, -1); ((DbParameter)val10).Value = model.RunJSON; } else { val10 = new MySqlParameter("@RunJSON", 751, -1); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; MySqlParameter val11 = new MySqlParameter("@Status", 3, 11); ((DbParameter)val11).Value = model.Status; obj[10] = val11; MySqlParameter val12 = new MySqlParameter("@ID", 253, 36); ((DbParameter)val12).Value = model.ID; obj[11] = val12; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlow 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_005f: Unknown result type (might be due to invalid IL or missing references) //IL_0064: 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_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_00b3: Expected O, but got Unknown //IL_00b4: Expected O, but got Unknown //IL_00be: Unknown result type (might be due to invalid IL or missing references) //IL_00c3: 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_00e3: Unknown result type (might be due to invalid IL or missing references) //IL_00e8: Unknown result type (might be due to invalid IL or missing references) //IL_00f9: Expected O, but got Unknown //IL_00fa: Expected O, but got Unknown //IL_010f: Unknown result type (might be due to invalid IL or missing references) //IL_0114: Unknown result type (might be due to invalid IL or missing references) //IL_0120: Expected O, but got Unknown //IL_012d: Unknown result type (might be due to invalid IL or missing references) //IL_0132: Unknown result type (might be due to invalid IL or missing references) //IL_013d: Expected O, but got Unknown //IL_013e: Expected O, but got Unknown //IL_0158: Unknown result type (might be due to invalid IL or missing references) //IL_015d: Unknown result type (might be due to invalid IL or missing references) //IL_016e: 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_0188: Expected O, but got Unknown //IL_0189: Expected O, but got Unknown //IL_01a8: Unknown result type (might be due to invalid IL or missing references) //IL_01ad: Unknown result type (might be due to invalid IL or missing references) //IL_01be: Expected O, but got Unknown //IL_01cc: Unknown result type (might be due to invalid IL or missing references) //IL_01d1: Unknown result type (might be due to invalid IL or missing references) //IL_01dc: Expected O, but got Unknown //IL_01dd: 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_0204: Expected O, but got Unknown //IL_0211: Unknown result type (might be due to invalid IL or missing references) //IL_0216: Unknown result type (might be due to invalid IL or missing references) //IL_0221: Expected O, but got Unknown //IL_0222: Expected O, but got Unknown //IL_022d: Unknown result type (might be due to invalid IL or missing references) //IL_0232: Unknown result type (might be due to invalid IL or missing references) //IL_0243: Expected O, but got Unknown //IL_0244: Expected O, but got Unknown string sql = "INSERT INTO workflow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)"; MySqlParameter[] obj = new MySqlParameter[12]; MySqlParameter val = new MySqlParameter("@ID", 253, 36); ((DbParameter)val).Value = model.ID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Name", 752, -1); ((DbParameter)val2).Value = model.Name; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Type", 253, 36); ((DbParameter)val3).Value = model.Type; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Manager", 752, -1); ((DbParameter)val4).Value = model.Manager; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@InstanceManager", 752, -1); ((DbParameter)val5).Value = model.InstanceManager; obj[4] = val5; MySqlParameter val6 = new MySqlParameter("@CreateDate", 12, -1); ((DbParameter)val6).Value = model.CreateDate; obj[5] = val6; MySqlParameter val7 = new MySqlParameter("@CreateUserID", 253, 36); ((DbParameter)val7).Value = model.CreateUserID; obj[6] = val7; _003F val8; if (model.DesignJSON != null) { val8 = new MySqlParameter("@DesignJSON", 751, -1); ((DbParameter)val8).Value = model.DesignJSON; } else { val8 = new MySqlParameter("@DesignJSON", 751, -1); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; _003F val9; if (model.InstallDate.HasValue) { val9 = new MySqlParameter("@InstallDate", 12, -1); ((DbParameter)val9).Value = model.InstallDate; } else { val9 = new MySqlParameter("@InstallDate", 12, -1); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.InstallUserID.HasValue) { val10 = new MySqlParameter("@InstallUserID", 253, 36); ((DbParameter)val10).Value = model.InstallUserID; } else { val10 = new MySqlParameter("@InstallUserID", 253, 36); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.RunJSON != null) { val11 = new MySqlParameter("@RunJSON", 751, -1); ((DbParameter)val11).Value = model.RunJSON; } else { val11 = new MySqlParameter("@RunJSON", 751, -1); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; MySqlParameter val12 = new MySqlParameter("@Status", 3, 11); ((DbParameter)val12).Value = model.Status; obj[11] = val12; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkFlow 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_002c: Expected O, but got Unknown //IL_002d: Expected O, but got Unknown //IL_0038: Unknown result type (might be due to invalid IL or missing references) //IL_003d: Unknown result type (might be due to invalid IL or missing references) //IL_004e: Expected O, but got Unknown //IL_004f: Expected O, but got Unknown //IL_005d: Unknown result type (might be due to invalid IL or missing references) //IL_0062: Unknown result type (might be due to invalid IL or missing references) //IL_006e: Expected O, but got Unknown //IL_006f: Expected O, but got Unknown //IL_007d: Unknown result type (might be due to invalid IL or missing references) //IL_0082: Unknown result type (might be due to invalid IL or missing references) //IL_008e: Expected O, but got Unknown //IL_008f: Expected O, but got Unknown //IL_0099: Unknown result type (might be due to invalid IL or missing references) //IL_009e: 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_00bb: Unknown result type (might be due to invalid IL or missing references) //IL_00c0: Unknown result type (might be due to invalid IL or missing references) //IL_00d1: Expected O, but got Unknown //IL_00d2: Expected O, but got Unknown //IL_00e3: Unknown result type (might be due to invalid IL or missing references) //IL_00e8: Unknown result type (might be due to invalid IL or missing references) //IL_00f4: Expected O, but got Unknown //IL_00fd: Unknown result type (might be due to invalid IL or missing references) //IL_0102: Unknown result type (might be due to invalid IL or missing references) //IL_010d: Expected O, but got Unknown //IL_010e: Expected O, but got Unknown //IL_0128: Unknown result type (might be due to invalid IL or missing references) //IL_012d: Unknown result type (might be due to invalid IL or missing references) //IL_013e: Expected O, but got Unknown //IL_0148: Unknown result type (might be due to invalid IL or missing references) //IL_014d: Unknown result type (might be due to invalid IL or missing references) //IL_0158: Expected O, but got Unknown //IL_0159: Expected O, but got Unknown //IL_0174: Unknown result type (might be due to invalid IL or missing references) //IL_0179: Unknown result type (might be due to invalid IL or missing references) //IL_018a: Expected O, but got Unknown //IL_0195: Unknown result type (might be due to invalid IL or missing references) //IL_019a: Unknown result type (might be due to invalid IL or missing references) //IL_01a5: Expected O, but got Unknown //IL_01a6: Expected O, but got Unknown //IL_01b8: Unknown result type (might be due to invalid IL or missing references) //IL_01bd: Unknown result type (might be due to invalid IL or missing references) //IL_01c9: Expected O, but got Unknown //IL_01d2: Unknown result type (might be due to invalid IL or missing references) //IL_01d7: Unknown result type (might be due to invalid IL or missing references) //IL_01e2: Expected O, but got Unknown //IL_01e3: Expected O, but got Unknown //IL_01ed: Unknown result type (might be due to invalid IL or missing references) //IL_01f2: Unknown result type (might be due to invalid IL or missing references) //IL_0203: Expected O, but got Unknown //IL_0204: Expected O, but got Unknown //IL_0210: Unknown result type (might be due to invalid IL or missing references) //IL_0215: Unknown result type (might be due to invalid IL or missing references) //IL_0226: Expected O, but got Unknown //IL_0227: Expected O, but got Unknown string sql = "UPDATE WorkFlow SET \r\n\t\t\t\tName=:Name,Type=:Type,Manager=:Manager,InstanceManager=:InstanceManager,CreateDate=:CreateDate,CreateUserID=:CreateUserID,DesignJSON=:DesignJSON,InstallDate=:InstallDate,InstallUserID=:InstallUserID,RunJSON=:RunJSON,Status=:Status\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] obj = new OracleParameter[12]; OracleParameter val = new OracleParameter(":Name", 119, 1000); ((DbParameter)val).Value = model.Name; obj[0] = val; OracleParameter val2 = new OracleParameter(":Type", 126, 40); ((DbParameter)val2).Value = model.Type; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Manager", 126, 5000); ((DbParameter)val3).Value = model.Manager; obj[2] = val3; OracleParameter val4 = new OracleParameter(":InstanceManager", 126, 5000); ((DbParameter)val4).Value = model.InstanceManager; obj[3] = val4; OracleParameter val5 = new OracleParameter(":CreateDate", 106, 8); ((DbParameter)val5).Value = model.CreateDate; obj[4] = val5; OracleParameter val6 = new OracleParameter(":CreateUserID", 126, 40); ((DbParameter)val6).Value = model.CreateUserID; obj[5] = val6; _003F val7; if (model.DesignJSON != null) { val7 = new OracleParameter(":DesignJSON", 105); ((DbParameter)val7).Value = model.DesignJSON; } else { val7 = new OracleParameter(":DesignJSON", 105); ((DbParameter)val7).Value = DBNull.Value; } obj[6] = val7; _003F val8; if (model.InstallDate.HasValue) { val8 = new OracleParameter(":InstallDate", 106, 8); ((DbParameter)val8).Value = model.InstallDate; } else { val8 = new OracleParameter(":InstallDate", 106, 8); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; _003F val9; if (model.InstallUserID.HasValue) { val9 = new OracleParameter(":InstallUserID", 126, 40); ((DbParameter)val9).Value = model.InstallUserID; } else { val9 = new OracleParameter(":InstallUserID", 126, 40); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.RunJSON != null) { val10 = new OracleParameter(":RunJSON", 105); ((DbParameter)val10).Value = model.RunJSON; } else { val10 = new OracleParameter(":RunJSON", 105); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; OracleParameter val11 = new OracleParameter(":Status", 112); ((DbParameter)val11).Value = model.Status; obj[10] = val11; OracleParameter val12 = new OracleParameter(":ID", 126, 40); ((DbParameter)val12).Value = model.ID; obj[11] = val12; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlow model) { //IL_0018: Unknown result type (might be due to invalid IL or missing references) //IL_001d: Unknown result type (might be due to invalid IL or missing references) //IL_002e: Expected O, but got Unknown //IL_002f: Expected O, but got Unknown //IL_003d: Unknown result type (might be due to invalid IL or missing references) //IL_0042: Unknown result type (might be due to invalid IL or missing references) //IL_004e: Expected O, but got Unknown //IL_004f: Expected O, but got Unknown //IL_005a: Unknown result type (might be due to invalid IL or missing references) //IL_005f: Unknown result type (might be due to invalid IL or missing references) //IL_0070: Expected O, but got Unknown //IL_0071: Expected O, but got Unknown //IL_007f: Unknown result type (might be due to invalid IL or missing references) //IL_0084: Unknown result type (might be due to invalid IL or missing references) //IL_0090: Expected O, but got Unknown //IL_0091: Expected O, but got Unknown //IL_009f: Unknown result type (might be due to invalid IL or missing references) //IL_00a4: Unknown result type (might be due to invalid IL or missing references) //IL_00b0: Expected O, but got Unknown //IL_00b1: Expected O, but got Unknown //IL_00bb: Unknown result type (might be due to invalid IL or missing references) //IL_00c0: Unknown result type (might be due to invalid IL or missing references) //IL_00d1: Expected O, but got Unknown //IL_00d2: Expected O, but got Unknown //IL_00dd: Unknown result type (might be due to invalid IL or missing references) //IL_00e2: Unknown result type (might be due to invalid IL or missing references) //IL_00f3: Expected O, but got Unknown //IL_00f4: Expected O, but got Unknown //IL_0105: Unknown result type (might be due to invalid IL or missing references) //IL_010a: Unknown result type (might be due to invalid IL or missing references) //IL_0116: Expected O, but got Unknown //IL_011f: Unknown result type (might be due to invalid IL or missing references) //IL_0124: Unknown result type (might be due to invalid IL or missing references) //IL_012f: Expected O, but got Unknown //IL_0130: Expected O, but got Unknown //IL_014a: Unknown result type (might be due to invalid IL or missing references) //IL_014f: Unknown result type (might be due to invalid IL or missing references) //IL_0160: Expected O, but got Unknown //IL_016a: Unknown result type (might be due to invalid IL or missing references) //IL_016f: Unknown result type (might be due to invalid IL or missing references) //IL_017a: Expected O, but got Unknown //IL_017b: Expected O, but got Unknown //IL_0197: Unknown result type (might be due to invalid IL or missing references) //IL_019c: Unknown result type (might be due to invalid IL or missing references) //IL_01ad: Expected O, but got Unknown //IL_01b8: Unknown result type (might be due to invalid IL or missing references) //IL_01bd: Unknown result type (might be due to invalid IL or missing references) //IL_01c8: Expected O, but got Unknown //IL_01c9: Expected O, but got Unknown //IL_01db: Unknown result type (might be due to invalid IL or missing references) //IL_01e0: Unknown result type (might be due to invalid IL or missing references) //IL_01ec: Expected O, but got Unknown //IL_01f5: Unknown result type (might be due to invalid IL or missing references) //IL_01fa: Unknown result type (might be due to invalid IL or missing references) //IL_0205: Expected O, but got Unknown //IL_0206: Expected O, but got Unknown //IL_0210: Unknown result type (might be due to invalid IL or missing references) //IL_0215: Unknown result type (might be due to invalid IL or missing references) //IL_0226: Expected O, but got Unknown //IL_0227: Expected O, but got Unknown string sql = "INSERT INTO WorkFlow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(:ID,:Name,:Type,:Manager,:InstanceManager,:CreateDate,:CreateUserID,:DesignJSON,:InstallDate,:InstallUserID,:RunJSON,:Status)"; OracleParameter[] obj = new OracleParameter[12]; OracleParameter val = new OracleParameter(":ID", 126, 40); ((DbParameter)val).Value = model.ID; obj[0] = val; OracleParameter val2 = new OracleParameter(":Name", 119, 1000); ((DbParameter)val2).Value = model.Name; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Type", 126, 40); ((DbParameter)val3).Value = model.Type; obj[2] = val3; OracleParameter val4 = new OracleParameter(":Manager", 126, 5000); ((DbParameter)val4).Value = model.Manager; obj[3] = val4; OracleParameter val5 = new OracleParameter(":InstanceManager", 126, 5000); ((DbParameter)val5).Value = model.InstanceManager; obj[4] = val5; OracleParameter val6 = new OracleParameter(":CreateDate", 106, 8); ((DbParameter)val6).Value = model.CreateDate; obj[5] = val6; OracleParameter val7 = new OracleParameter(":CreateUserID", 126, 40); ((DbParameter)val7).Value = model.CreateUserID; obj[6] = val7; _003F val8; if (model.DesignJSON != null) { val8 = new OracleParameter(":DesignJSON", 105); ((DbParameter)val8).Value = model.DesignJSON; } else { val8 = new OracleParameter(":DesignJSON", 105); ((DbParameter)val8).Value = DBNull.Value; } obj[7] = val8; _003F val9; if (model.InstallDate.HasValue) { val9 = new OracleParameter(":InstallDate", 106, 8); ((DbParameter)val9).Value = model.InstallDate; } else { val9 = new OracleParameter(":InstallDate", 106, 8); ((DbParameter)val9).Value = DBNull.Value; } obj[8] = val9; _003F val10; if (model.InstallUserID.HasValue) { val10 = new OracleParameter(":InstallUserID", 126, 40); ((DbParameter)val10).Value = model.InstallUserID; } else { val10 = new OracleParameter(":InstallUserID", 126, 40); ((DbParameter)val10).Value = DBNull.Value; } obj[9] = val10; _003F val11; if (model.RunJSON != null) { val11 = new OracleParameter(":RunJSON", 105); ((DbParameter)val11).Value = model.RunJSON; } else { val11 = new OracleParameter(":RunJSON", 105); ((DbParameter)val11).Value = DBNull.Value; } obj[10] = val11; OracleParameter val12 = new OracleParameter(":Status", 112); ((DbParameter)val12).Value = model.Status; obj[11] = val12; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkFlow model) { string sql = "UPDATE WorkFlow SET \r\n\t\t\t\tName=@Name,Type=@Type,Manager=@Manager,InstanceManager=@InstanceManager,CreateDate=@CreateDate,CreateUserID=@CreateUserID,DesignJSON=@DesignJSON,InstallDate=@InstallDate,InstallUserID=@InstallUserID,RunJSON=@RunJSON,Status=@Status\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] parameter = new SqlParameter[12] { new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@Manager", SqlDbType.VarChar, 5000) { Value = model.Manager }, new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000) { Value = model.InstanceManager }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, (model.DesignJSON == null) ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = model.DesignJSON }, (!model.InstallDate.HasValue) ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = model.InstallDate }, (!model.InstallUserID.HasValue) ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.InstallUserID }, (model.RunJSON == null) ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = model.RunJSON }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlow model) { string sql = "INSERT INTO WorkFlow\r\n\t\t\t\t(ID,Name,Type,Manager,InstanceManager,CreateDate,CreateUserID,DesignJSON,InstallDate,InstallUserID,RunJSON,Status) \r\n\t\t\t\tVALUES(@ID,@Name,@Type,@Manager,@InstanceManager,@CreateDate,@CreateUserID,@DesignJSON,@InstallDate,@InstallUserID,@RunJSON,@Status)"; SqlParameter[] parameter = new SqlParameter[12] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Type", SqlDbType.UniqueIdentifier, -1) { Value = model.Type }, new SqlParameter("@Manager", SqlDbType.VarChar, 5000) { Value = model.Manager }, new SqlParameter("@InstanceManager", SqlDbType.VarChar, 5000) { Value = model.InstanceManager }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, (model.DesignJSON == null) ? new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@DesignJSON", SqlDbType.VarChar, -1) { Value = model.DesignJSON }, (!model.InstallDate.HasValue) ? new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = DBNull.Value } : new SqlParameter("@InstallDate", SqlDbType.DateTime, 8) { Value = model.InstallDate }, (!model.InstallUserID.HasValue) ? new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = DBNull.Value } : new SqlParameter("@InstallUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.InstallUserID }, (model.RunJSON == null) ? new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@RunJSON", SqlDbType.VarChar, -1) { Value = model.RunJSON }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status } }; return(dbHelper.Execute(sql, parameter)); }