Example #1
0
        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);
        }
Example #2
0
        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));
        }
Example #3
0
        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));
        }
Example #4
0
        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));
        }
Example #5
0
        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));
        }
Example #6
0
        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));
        }
Example #7
0
        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));
        }