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)); }
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("删除成功!"); }
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)); }
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)); }
public int Update(RoadFlow.Data.Model.WorkFlowDelegation model) { return(dataWorkFlowDelegation.Update(model)); }
public int Add(RoadFlow.Data.Model.WorkFlowDelegation model) { return(dataWorkFlowDelegation.Add(model)); }
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)); }