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