Example #1
0
        private List <RoadFlow.Data.Model.WorkFlowDelegation> DataReaderToList(MySqlDataReader dataReader)
        {
            List <RoadFlow.Data.Model.WorkFlowDelegation> list = new List <RoadFlow.Data.Model.WorkFlowDelegation>();

            RoadFlow.Data.Model.WorkFlowDelegation workFlowDelegation = null;
            while (((DbDataReader)dataReader).Read())
            {
                workFlowDelegation           = new RoadFlow.Data.Model.WorkFlowDelegation();
                workFlowDelegation.ID        = ((DbDataReader)dataReader).GetString(0).ToGuid();
                workFlowDelegation.UserID    = ((DbDataReader)dataReader).GetString(1).ToGuid();
                workFlowDelegation.StartTime = ((DbDataReader)dataReader).GetDateTime(2);
                workFlowDelegation.EndTime   = ((DbDataReader)dataReader).GetDateTime(3);
                if (!((DbDataReader)dataReader).IsDBNull(4))
                {
                    workFlowDelegation.FlowID = ((DbDataReader)dataReader).GetString(4).ToGuid();
                }
                workFlowDelegation.ToUserID  = ((DbDataReader)dataReader).GetString(5).ToGuid();
                workFlowDelegation.WriteTime = ((DbDataReader)dataReader).GetDateTime(6);
                if (!((DbDataReader)dataReader).IsDBNull(7))
                {
                    workFlowDelegation.Note = ((DbDataReader)dataReader).GetString(7);
                }
                list.Add(workFlowDelegation);
            }
            return(list);
        }
        public int Update(RoadFlow.Data.Model.WorkFlowDelegation model)
        {
            string sql = "UPDATE WorkFlowDelegation SET \r\n\t\t\t\tUserID=@UserID,StartTime=@StartTime,EndTime=@EndTime,FlowID=@FlowID,ToUserID=@ToUserID,WriteTime=@WriteTime,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";

            SqlParameter[] parameter = new SqlParameter[8]
            {
                new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.UserID
                },
                new SqlParameter("@StartTime", SqlDbType.DateTime, 8)
                {
                    Value = model.StartTime
                },
                new SqlParameter("@EndTime", SqlDbType.DateTime, 8)
                {
                    Value = model.EndTime
                },
                (!model.FlowID.HasValue) ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.FlowID
                },
                new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ToUserID
                },
                new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
                {
                    Value = model.WriteTime
                },
                (model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
                {
                    Value = model.Note
                },
                new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ID
                }
            };
            return(dbHelper.Execute(sql, parameter));
        }
        public int Add(RoadFlow.Data.Model.WorkFlowDelegation model)
        {
            string sql = "INSERT INTO WorkFlowDelegation\r\n\t\t\t\t(ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note) \r\n\t\t\t\tVALUES(@ID,@UserID,@StartTime,@EndTime,@FlowID,@ToUserID,@WriteTime,@Note)";

            SqlParameter[] parameter = new SqlParameter[8]
            {
                new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ID
                },
                new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.UserID
                },
                new SqlParameter("@StartTime", SqlDbType.DateTime, 8)
                {
                    Value = model.StartTime
                },
                new SqlParameter("@EndTime", SqlDbType.DateTime, 8)
                {
                    Value = model.EndTime
                },
                (!model.FlowID.HasValue) ? new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.FlowID
                },
                new SqlParameter("@ToUserID", SqlDbType.UniqueIdentifier, -1)
                {
                    Value = model.ToUserID
                },
                new SqlParameter("@WriteTime", SqlDbType.DateTime, 8)
                {
                    Value = model.WriteTime
                },
                (model.Note == null) ? new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
                {
                    Value = DBNull.Value
                } : new SqlParameter("@Note", SqlDbType.NVarChar, 8000)
                {
                    Value = model.Note
                }
            };
            return(dbHelper.Execute(sql, parameter));
        }
Example #4
0
 public string Delete()
 {
     RoadFlow.Platform.WorkFlowDelegation workFlowDelegation = new RoadFlow.Platform.WorkFlowDelegation();
     string[] array = base.Request.Form["ids"].Split(',');
     for (int i = 0; i < array.Length; i++)
     {
         Guid test;
         if (array[i].IsGuid(out test))
         {
             RoadFlow.Data.Model.WorkFlowDelegation workFlowDelegation2 = workFlowDelegation.Get(test);
             if (workFlowDelegation2 != null)
             {
                 workFlowDelegation.Delete(test);
                 RoadFlow.Platform.Log.Add("删除了流程意见", workFlowDelegation2.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
             }
         }
     }
     workFlowDelegation.RefreshCache();
     return("删除成功!");
 }
Example #5
0
        public int Add(RoadFlow.Data.Model.WorkFlowDelegation 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_0030: Expected O, but got Unknown
            //IL_0031: 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_0055: Expected O, but got Unknown
            //IL_0056: Expected O, but got Unknown
            //IL_0060: Unknown result type (might be due to invalid IL or missing references)
            //IL_0065: Unknown result type (might be due to invalid IL or missing references)
            //IL_0076: Expected O, but got Unknown
            //IL_0077: Expected O, but got Unknown
            //IL_0081: Unknown result type (might be due to invalid IL or missing references)
            //IL_0086: Unknown result type (might be due to invalid IL or missing references)
            //IL_0097: Expected O, but got Unknown
            //IL_0098: Expected O, but got Unknown
            //IL_00b6: Unknown result type (might be due to invalid IL or missing references)
            //IL_00bb: Unknown result type (might be due to invalid IL or missing references)
            //IL_00cc: Expected O, but got Unknown
            //IL_00da: Unknown result type (might be due to invalid IL or missing references)
            //IL_00df: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ea: Expected O, but got Unknown
            //IL_00eb: Expected O, but got Unknown
            //IL_00f9: Unknown result type (might be due to invalid IL or missing references)
            //IL_00fe: Unknown result type (might be due to invalid IL or missing references)
            //IL_010f: Expected O, but got Unknown
            //IL_0110: Expected O, but got Unknown
            //IL_011a: Unknown result type (might be due to invalid IL or missing references)
            //IL_011f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0130: Expected O, but got Unknown
            //IL_0131: Expected O, but got Unknown
            //IL_0146: Unknown result type (might be due to invalid IL or missing references)
            //IL_014b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0157: Expected O, but got Unknown
            //IL_0164: Unknown result type (might be due to invalid IL or missing references)
            //IL_0169: Unknown result type (might be due to invalid IL or missing references)
            //IL_0174: Expected O, but got Unknown
            //IL_0175: Expected O, but got Unknown
            string sql = "INSERT INTO workflowdelegation\r\n\t\t\t\t(ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note) \r\n\t\t\t\tVALUES(@ID,@UserID,@StartTime,@EndTime,@FlowID,@ToUserID,@WriteTime,@Note)";

            MySqlParameter[] obj = new MySqlParameter[8];
            MySqlParameter   val = new MySqlParameter("@ID", 253, 36);

            ((DbParameter)val).Value = model.ID;
            obj[0] = val;
            MySqlParameter val2 = new MySqlParameter("@UserID", 253, 36);

            ((DbParameter)val2).Value = model.UserID;
            obj[1] = val2;
            MySqlParameter val3 = new MySqlParameter("@StartTime", 12, -1);

            ((DbParameter)val3).Value = model.StartTime;
            obj[2] = val3;
            MySqlParameter val4 = new MySqlParameter("@EndTime", 12, -1);

            ((DbParameter)val4).Value = model.EndTime;
            obj[3] = val4;
            _003F val5;

            if (model.FlowID.HasValue)
            {
                val5 = new MySqlParameter("@FlowID", 253, 36);
                ((DbParameter)val5).Value = model.FlowID;
            }
            else
            {
                val5 = new MySqlParameter("@FlowID", 253, 36);
                ((DbParameter)val5).Value = DBNull.Value;
            }
            obj[4] = val5;
            MySqlParameter val6 = new MySqlParameter("@ToUserID", 253, 36);

            ((DbParameter)val6).Value = model.ToUserID;
            obj[5] = val6;
            MySqlParameter val7 = new MySqlParameter("@WriteTime", 12, -1);

            ((DbParameter)val7).Value = model.WriteTime;
            obj[6] = val7;
            _003F val8;

            if (model.Note != null)
            {
                val8 = new MySqlParameter("@Note", 752, -1);
                ((DbParameter)val8).Value = model.Note;
            }
            else
            {
                val8 = new MySqlParameter("@Note", 752, -1);
                ((DbParameter)val8).Value = DBNull.Value;
            }
            obj[7] = val8;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
Example #6
0
        public int Update(RoadFlow.Data.Model.WorkFlowDelegation 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_0030: Expected O, but got Unknown
            //IL_0031: Expected O, but got Unknown
            //IL_003b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0040: Unknown result type (might be due to invalid IL or missing references)
            //IL_0051: Expected O, but got Unknown
            //IL_0052: Expected O, but got Unknown
            //IL_005c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0061: Unknown result type (might be due to invalid IL or missing references)
            //IL_0072: Expected O, but got Unknown
            //IL_0073: Expected O, but got Unknown
            //IL_0091: Unknown result type (might be due to invalid IL or missing references)
            //IL_0096: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a7: Expected O, but got Unknown
            //IL_00b5: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ba: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c5: Expected O, but got Unknown
            //IL_00c6: Expected O, but got Unknown
            //IL_00d4: Unknown result type (might be due to invalid IL or missing references)
            //IL_00d9: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ea: Expected O, but got Unknown
            //IL_00eb: Expected O, but got Unknown
            //IL_00f5: Unknown result type (might be due to invalid IL or missing references)
            //IL_00fa: Unknown result type (might be due to invalid IL or missing references)
            //IL_010b: Expected O, but got Unknown
            //IL_010c: Expected O, but got Unknown
            //IL_0121: Unknown result type (might be due to invalid IL or missing references)
            //IL_0126: Unknown result type (might be due to invalid IL or missing references)
            //IL_0132: Expected O, but got Unknown
            //IL_013f: Unknown result type (might be due to invalid IL or missing references)
            //IL_0144: Unknown result type (might be due to invalid IL or missing references)
            //IL_014f: Expected O, but got Unknown
            //IL_0150: Expected O, but got Unknown
            //IL_015e: Unknown result type (might be due to invalid IL or missing references)
            //IL_0163: Unknown result type (might be due to invalid IL or missing references)
            //IL_0174: Expected O, but got Unknown
            //IL_0175: Expected O, but got Unknown
            string sql = "UPDATE workflowdelegation SET \r\n\t\t\t\tUserID=@UserID,StartTime=@StartTime,EndTime=@EndTime,FlowID=@FlowID,ToUserID=@ToUserID,WriteTime=@WriteTime,Note=@Note\r\n\t\t\t\tWHERE ID=@ID";

            MySqlParameter[] obj = new MySqlParameter[8];
            MySqlParameter   val = new MySqlParameter("@UserID", 253, 36);

            ((DbParameter)val).Value = model.UserID;
            obj[0] = val;
            MySqlParameter val2 = new MySqlParameter("@StartTime", 12, -1);

            ((DbParameter)val2).Value = model.StartTime;
            obj[1] = val2;
            MySqlParameter val3 = new MySqlParameter("@EndTime", 12, -1);

            ((DbParameter)val3).Value = model.EndTime;
            obj[2] = val3;
            _003F val4;

            if (model.FlowID.HasValue)
            {
                val4 = new MySqlParameter("@FlowID", 253, 36);
                ((DbParameter)val4).Value = model.FlowID;
            }
            else
            {
                val4 = new MySqlParameter("@FlowID", 253, 36);
                ((DbParameter)val4).Value = DBNull.Value;
            }
            obj[3] = val4;
            MySqlParameter val5 = new MySqlParameter("@ToUserID", 253, 36);

            ((DbParameter)val5).Value = model.ToUserID;
            obj[4] = val5;
            MySqlParameter val6 = new MySqlParameter("@WriteTime", 12, -1);

            ((DbParameter)val6).Value = model.WriteTime;
            obj[5] = val6;
            _003F val7;

            if (model.Note != null)
            {
                val7 = new MySqlParameter("@Note", 752, -1);
                ((DbParameter)val7).Value = model.Note;
            }
            else
            {
                val7 = new MySqlParameter("@Note", 752, -1);
                ((DbParameter)val7).Value = DBNull.Value;
            }
            obj[6] = val7;
            MySqlParameter val8 = new MySqlParameter("@ID", 253, 36);

            ((DbParameter)val8).Value = model.ID;
            obj[7] = val8;
            MySqlParameter[] parameter = (MySqlParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
Example #7
0
 public int Update(RoadFlow.Data.Model.WorkFlowDelegation model)
 {
     return(dataWorkFlowDelegation.Update(model));
 }
Example #8
0
 public int Add(RoadFlow.Data.Model.WorkFlowDelegation model)
 {
     return(dataWorkFlowDelegation.Add(model));
 }
Example #9
0
        public ActionResult Edit(FormCollection collection)
        {
            RoadFlow.Platform.WorkFlowDelegation   workFlowDelegation  = new RoadFlow.Platform.WorkFlowDelegation();
            RoadFlow.Data.Model.WorkFlowDelegation workFlowDelegation2 = null;
            string str    = base.Request.QueryString["id"];
            string empty  = string.Empty;
            string empty2 = string.Empty;
            string empty3 = string.Empty;
            string empty4 = string.Empty;
            string text   = string.Empty;
            string empty5 = string.Empty;
            bool   flag   = "1" == base.Request.QueryString["isoneself"];
            Guid   test;

            if (str.IsGuid(out test))
            {
                workFlowDelegation2 = workFlowDelegation.Get(test);
                if (workFlowDelegation2 != null)
                {
                    text = workFlowDelegation2.FlowID.ToString();
                }
            }
            string oldXML = workFlowDelegation2.Serialize();

            if (collection != null)
            {
                empty  = base.Request.Form["UserID"];
                empty2 = base.Request.Form["ToUserID"];
                empty3 = base.Request.Form["StartTime"];
                empty4 = base.Request.Form["EndTime"];
                text   = base.Request.Form["FlowID"];
                empty5 = base.Request.Form["Note"];
                bool num = !str.IsGuid();
                if (workFlowDelegation2 == null)
                {
                    workFlowDelegation2 = new RoadFlow.Data.Model.WorkFlowDelegation
                    {
                        ID = Guid.NewGuid()
                    };
                }
                workFlowDelegation2.UserID  = (flag ? RoadFlow.Platform.Users.CurrentUserID : RoadFlow.Platform.Users.RemovePrefix(empty).ToGuid());
                workFlowDelegation2.EndTime = empty4.ToDateTime();
                if (text.IsGuid())
                {
                    workFlowDelegation2.FlowID = text.ToGuid();
                }
                else
                {
                    workFlowDelegation2.FlowID = null;
                }
                workFlowDelegation2.Note      = (empty5.IsNullOrEmpty() ? null : empty5);
                workFlowDelegation2.StartTime = empty3.ToDateTime();
                workFlowDelegation2.ToUserID  = RoadFlow.Platform.Users.RemovePrefix(empty2).ToGuid();
                workFlowDelegation2.WriteTime = DateTimeNew.Now;
                if (num)
                {
                    workFlowDelegation.Add(workFlowDelegation2);
                    RoadFlow.Platform.Log.Add("添加了工作委托", workFlowDelegation2.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
                }
                else
                {
                    workFlowDelegation.Update(workFlowDelegation2);
                    RoadFlow.Platform.Log.Add("修改了工作委托", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowDelegation2.Serialize());
                }
                workFlowDelegation.RefreshCache();
                base.ViewBag.Script = "alert('保存成功!');new RoadUI.Window().getOpenerWindow().query();new RoadUI.Window().close();";
            }
            base.ViewBag.FlowOptions = new RoadFlow.Platform.WorkFlow().GetOptions(text);
            return(View((workFlowDelegation2 == null) ? new RoadFlow.Data.Model.WorkFlowDelegation
            {
                UserID = RoadFlow.Platform.Users.CurrentUserID
            } : workFlowDelegation2));
        }
        public int Add(RoadFlow.Data.Model.WorkFlowDelegation model)
        {
            //IL_0017: Unknown result type (might be due to invalid IL or missing references)
            //IL_001c: Unknown result type (might be due to invalid IL or missing references)
            //IL_002d: Expected O, but got Unknown
            //IL_002e: Expected O, but got Unknown
            //IL_0039: Unknown result type (might be due to invalid IL or missing references)
            //IL_003e: Unknown result type (might be due to invalid IL or missing references)
            //IL_004f: Expected O, but got Unknown
            //IL_0050: 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_007b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0080: Unknown result type (might be due to invalid IL or missing references)
            //IL_0091: Expected O, but got Unknown
            //IL_0092: Expected O, but got Unknown
            //IL_00ad: Unknown result type (might be due to invalid IL or missing references)
            //IL_00b2: Unknown result type (might be due to invalid IL or missing references)
            //IL_00c3: Expected O, but got Unknown
            //IL_00ce: Unknown result type (might be due to invalid IL or missing references)
            //IL_00d3: Unknown result type (might be due to invalid IL or missing references)
            //IL_00de: Expected O, but got Unknown
            //IL_00df: 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_0100: Expected O, but got Unknown
            //IL_0101: Expected O, but got Unknown
            //IL_010b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0110: Unknown result type (might be due to invalid IL or missing references)
            //IL_0121: Expected O, but got Unknown
            //IL_0122: Expected O, but got Unknown
            //IL_0138: Unknown result type (might be due to invalid IL or missing references)
            //IL_013d: Unknown result type (might be due to invalid IL or missing references)
            //IL_0149: Expected O, but got Unknown
            //IL_0157: Unknown result type (might be due to invalid IL or missing references)
            //IL_015c: Unknown result type (might be due to invalid IL or missing references)
            //IL_0167: Expected O, but got Unknown
            //IL_0168: Expected O, but got Unknown
            string sql = "INSERT INTO WorkFlowDelegation\r\n\t\t\t\t(ID,UserID,StartTime,EndTime,FlowID,ToUserID,WriteTime,Note) \r\n\t\t\t\tVALUES(:ID,:UserID,:StartTime,:EndTime,:FlowID,:ToUserID,:WriteTime,:Note)";

            OracleParameter[] obj = new OracleParameter[8];
            OracleParameter   val = new OracleParameter(":ID", 126, 40);

            ((DbParameter)val).Value = model.ID;
            obj[0] = val;
            OracleParameter val2 = new OracleParameter(":UserID", 126, 40);

            ((DbParameter)val2).Value = model.UserID;
            obj[1] = val2;
            OracleParameter val3 = new OracleParameter(":StartTime", 106, 8);

            ((DbParameter)val3).Value = model.StartTime;
            obj[2] = val3;
            OracleParameter val4 = new OracleParameter(":EndTime", 106, 8);

            ((DbParameter)val4).Value = model.EndTime;
            obj[3] = val4;
            _003F val5;

            if (model.FlowID.HasValue)
            {
                val5 = new OracleParameter(":FlowID", 126, 40);
                ((DbParameter)val5).Value = model.FlowID;
            }
            else
            {
                val5 = new OracleParameter(":FlowID", 126, 40);
                ((DbParameter)val5).Value = DBNull.Value;
            }
            obj[4] = val5;
            OracleParameter val6 = new OracleParameter(":ToUserID", 126, 40);

            ((DbParameter)val6).Value = model.ToUserID;
            obj[5] = val6;
            OracleParameter val7 = new OracleParameter(":WriteTime", 106, 8);

            ((DbParameter)val7).Value = model.WriteTime;
            obj[6] = val7;
            _003F val8;

            if (model.Note != null)
            {
                val8 = new OracleParameter(":Note", 119, 8000);
                ((DbParameter)val8).Value = model.Note;
            }
            else
            {
                val8 = new OracleParameter(":Note", 119, 8000);
                ((DbParameter)val8).Value = DBNull.Value;
            }
            obj[7] = val8;
            OracleParameter[] parameter = (OracleParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }
        public int Update(RoadFlow.Data.Model.WorkFlowDelegation model)
        {
            //IL_0017: Unknown result type (might be due to invalid IL or missing references)
            //IL_001c: Unknown result type (might be due to invalid IL or missing references)
            //IL_002d: Expected O, but got Unknown
            //IL_002e: 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_0059: Unknown result type (might be due to invalid IL or missing references)
            //IL_005e: 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_008b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0090: Unknown result type (might be due to invalid IL or missing references)
            //IL_00a1: Expected O, but got Unknown
            //IL_00ac: Unknown result type (might be due to invalid IL or missing references)
            //IL_00b1: Unknown result type (might be due to invalid IL or missing references)
            //IL_00bc: Expected O, but got Unknown
            //IL_00bd: Expected O, but got Unknown
            //IL_00c8: Unknown result type (might be due to invalid IL or missing references)
            //IL_00cd: Unknown result type (might be due to invalid IL or missing references)
            //IL_00de: Expected O, but got Unknown
            //IL_00df: Expected O, but got Unknown
            //IL_00e9: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ee: Unknown result type (might be due to invalid IL or missing references)
            //IL_00ff: Expected O, but got Unknown
            //IL_0100: Expected O, but got Unknown
            //IL_0116: Unknown result type (might be due to invalid IL or missing references)
            //IL_011b: Unknown result type (might be due to invalid IL or missing references)
            //IL_0127: Expected O, but got Unknown
            //IL_0135: Unknown result type (might be due to invalid IL or missing references)
            //IL_013a: Unknown result type (might be due to invalid IL or missing references)
            //IL_0145: Expected O, but got Unknown
            //IL_0146: Expected O, but got Unknown
            //IL_0151: Unknown result type (might be due to invalid IL or missing references)
            //IL_0156: Unknown result type (might be due to invalid IL or missing references)
            //IL_0167: Expected O, but got Unknown
            //IL_0168: Expected O, but got Unknown
            string sql = "UPDATE WorkFlowDelegation SET \r\n\t\t\t\tUserID=:UserID,StartTime=:StartTime,EndTime=:EndTime,FlowID=:FlowID,ToUserID=:ToUserID,WriteTime=:WriteTime,Note=:Note\r\n\t\t\t\tWHERE ID=:ID";

            OracleParameter[] obj = new OracleParameter[8];
            OracleParameter   val = new OracleParameter(":UserID", 126, 40);

            ((DbParameter)val).Value = model.UserID;
            obj[0] = val;
            OracleParameter val2 = new OracleParameter(":StartTime", 106, 8);

            ((DbParameter)val2).Value = model.StartTime;
            obj[1] = val2;
            OracleParameter val3 = new OracleParameter(":EndTime", 106, 8);

            ((DbParameter)val3).Value = model.EndTime;
            obj[2] = val3;
            _003F val4;

            if (model.FlowID.HasValue)
            {
                val4 = new OracleParameter(":FlowID", 126, 40);
                ((DbParameter)val4).Value = model.FlowID;
            }
            else
            {
                val4 = new OracleParameter(":FlowID", 126, 40);
                ((DbParameter)val4).Value = DBNull.Value;
            }
            obj[3] = val4;
            OracleParameter val5 = new OracleParameter(":ToUserID", 126, 40);

            ((DbParameter)val5).Value = model.ToUserID;
            obj[4] = val5;
            OracleParameter val6 = new OracleParameter(":WriteTime", 106, 8);

            ((DbParameter)val6).Value = model.WriteTime;
            obj[5] = val6;
            _003F val7;

            if (model.Note != null)
            {
                val7 = new OracleParameter(":Note", 119, 8000);
                ((DbParameter)val7).Value = model.Note;
            }
            else
            {
                val7 = new OracleParameter(":Note", 119, 8000);
                ((DbParameter)val7).Value = DBNull.Value;
            }
            obj[6] = val7;
            OracleParameter val8 = new OracleParameter(":ID", 126, 40);

            ((DbParameter)val8).Value = model.ID;
            obj[7] = val8;
            OracleParameter[] parameter = (OracleParameter[])obj;
            return(dbHelper.Execute(sql, parameter));
        }