public int Update(RoadFlow.Data.Model.WorkFlowComment model) { string sql = "UPDATE WorkFlowComment SET \r\n\t\t\t\tMemberID=@MemberID,Comment=@Comment,Type=@Type,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; SqlParameter[] parameter = new SqlParameter[5] { new SqlParameter("@MemberID", SqlDbType.VarChar, -1) { Value = model.MemberID }, new SqlParameter("@Comment", SqlDbType.NVarChar, 1000) { Value = model.Comment }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlowComment model) { string sql = "INSERT INTO WorkFlowComment\r\n\t\t\t\t(ID,MemberID,Comment,Type,Sort) \r\n\t\t\t\tVALUES(@ID,@MemberID,@Comment,@Type,@Sort)"; SqlParameter[] parameter = new SqlParameter[5] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@MemberID", SqlDbType.VarChar, -1) { Value = model.MemberID }, new SqlParameter("@Comment", SqlDbType.NVarChar, 1000) { Value = model.Comment }, new SqlParameter("@Type", SqlDbType.Int, -1) { Value = model.Type }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkFlowComment model) { //IL_001d: Unknown result type (might be due to invalid IL or missing references) //IL_0022: Unknown result type (might be due to invalid IL or missing references) //IL_002e: Expected O, but got Unknown //IL_0037: Unknown result type (might be due to invalid IL or missing references) //IL_003c: Unknown result type (might be due to invalid IL or missing references) //IL_0047: Expected O, but got Unknown //IL_0048: Expected O, but got Unknown //IL_0051: Unknown result type (might be due to invalid IL or missing references) //IL_0056: Unknown result type (might be due to invalid IL or missing references) //IL_0062: Expected O, but got Unknown //IL_0063: Expected O, but got Unknown //IL_006c: Unknown result type (might be due to invalid IL or missing references) //IL_0071: Unknown result type (might be due to invalid IL or missing references) //IL_0082: Expected O, but got Unknown //IL_0083: Expected O, but got Unknown //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_0091: Unknown result type (might be due to invalid IL or missing references) //IL_00a2: Expected O, but got Unknown //IL_00a3: 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_00c2: Expected O, but got Unknown //IL_00c3: Expected O, but got Unknown string sql = "UPDATE WorkFlowComment SET \r\n\t\t\t\tMemberID=:MemberID,Comment1=:Comment1,Type=:Type,Sort=:Sort\r\n\t\t\t\tWHERE ID=:ID"; OracleParameter[] obj = new OracleParameter[5]; _003F val; if (model.MemberID != null) { val = new OracleParameter(":MemberID", 105); ((DbParameter)val).Value = model.MemberID; } else { val = new OracleParameter(":MemberID", 105); ((DbParameter)val).Value = DBNull.Value; } obj[0] = val; OracleParameter val2 = new OracleParameter(":Comment1", 119); ((DbParameter)val2).Value = model.Comment; obj[1] = val2; OracleParameter val3 = new OracleParameter(":Type", 112); ((DbParameter)val3).Value = model.Type; obj[2] = val3; OracleParameter val4 = new OracleParameter(":Sort", 112); ((DbParameter)val4).Value = model.Sort; obj[3] = val4; OracleParameter val5 = new OracleParameter(":ID", 126); ((DbParameter)val5).Value = model.ID; obj[4] = val5; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlowComment model) { //IL_0015: Unknown result type (might be due to invalid IL or missing references) //IL_001a: 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_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_0057: Unknown result type (might be due to invalid IL or missing references) //IL_005c: Unknown result type (might be due to invalid IL or missing references) //IL_0067: Expected O, but got Unknown //IL_0068: Expected O, but got Unknown //IL_0071: Unknown result type (might be due to invalid IL or missing references) //IL_0076: Unknown result type (might be due to invalid IL or missing references) //IL_0082: Expected O, but got Unknown //IL_0083: Expected O, but got Unknown //IL_008c: Unknown result type (might be due to invalid IL or missing references) //IL_0091: Unknown result type (might be due to invalid IL or missing references) //IL_00a2: Expected O, but got Unknown //IL_00a3: 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_00c2: Expected O, but got Unknown //IL_00c3: Expected O, but got Unknown string sql = "INSERT INTO WorkFlowComment\r\n\t\t\t\t(ID,MemberID,Comment1,Type,Sort) \r\n\t\t\t\tVALUES(:ID,:MemberID,:Comment1,:Type,:Sort)"; OracleParameter[] obj = new OracleParameter[5]; OracleParameter val = new OracleParameter(":ID", 126); ((DbParameter)val).Value = model.ID; obj[0] = val; _003F val2; if (model.MemberID != null) { val2 = new OracleParameter(":MemberID", 105); ((DbParameter)val2).Value = model.MemberID; } else { val2 = new OracleParameter(":MemberID", 105); ((DbParameter)val2).Value = DBNull.Value; } obj[1] = val2; OracleParameter val3 = new OracleParameter(":Comment1", 119); ((DbParameter)val3).Value = model.Comment; obj[2] = val3; OracleParameter val4 = new OracleParameter(":Type", 112); ((DbParameter)val4).Value = model.Type; obj[3] = val4; OracleParameter val5 = new OracleParameter(":Sort", 112); ((DbParameter)val5).Value = model.Sort; obj[4] = val5; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public ActionResult Edit(FormCollection collection) { RoadFlow.Platform.WorkFlowComment workFlowComment = new RoadFlow.Platform.WorkFlowComment(); RoadFlow.Data.Model.WorkFlowComment workFlowComment2 = null; string str = base.Request.QueryString["id"]; string empty = string.Empty; string empty2 = string.Empty; string empty3 = string.Empty; bool flag = "1" == base.Request.QueryString["isoneself"]; Guid test; if (str.IsGuid(out test)) { workFlowComment2 = workFlowComment.Get(test); empty = workFlowComment2.MemberID; empty2 = workFlowComment2.Comment; empty3 = workFlowComment2.Sort.ToString(); } string oldXML = workFlowComment2.Serialize(); if (collection != null) { empty = (flag ? ("u_" + RoadFlow.Platform.Users.CurrentUserID.ToString()) : base.Request.Form["Member"]); empty2 = base.Request.Form["Comment"]; empty3 = base.Request.Form["Sort"]; bool num = !str.IsGuid(); if (workFlowComment2 == null) { workFlowComment2 = new RoadFlow.Data.Model.WorkFlowComment { ID = Guid.NewGuid(), Type = (flag ? 1 : 0) }; } workFlowComment2.MemberID = (empty.IsNullOrEmpty() ? "" : empty.Trim()); workFlowComment2.Comment = (empty2.IsNullOrEmpty() ? "" : empty2.Trim()); workFlowComment2.Sort = (empty3.IsInt() ? empty3.ToInt() : workFlowComment.GetManagerMaxSort()); if (num) { workFlowComment.Add(workFlowComment2); RoadFlow.Platform.Log.Add("添加了流程意见", workFlowComment2.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } else { workFlowComment.Update(workFlowComment2); RoadFlow.Platform.Log.Add("修改了流程意见", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowComment2.Serialize()); } workFlowComment.RefreshCache(); base.ViewBag.Script = "new RoadUI.Window().reloadOpener();alert('保存成功!');"; } if (workFlowComment2 == null) { workFlowComment2 = new RoadFlow.Data.Model.WorkFlowComment(); workFlowComment2.Sort = workFlowComment.GetManagerMaxSort() + 5; } return(View(workFlowComment2)); }
public int Update(RoadFlow.Data.Model.WorkFlowComment model) { //IL_0019: Unknown result type (might be due to invalid IL or missing references) //IL_001e: Unknown result type (might be due to invalid IL or missing references) //IL_002a: Expected O, but got Unknown //IL_002b: 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_0049: Expected O, but got Unknown //IL_004a: Expected O, but got Unknown //IL_0054: Unknown result type (might be due to invalid IL or missing references) //IL_0059: Unknown result type (might be due to invalid IL or missing references) //IL_006a: Expected O, but got Unknown //IL_006b: Expected O, but got Unknown //IL_0075: Unknown result type (might be due to invalid IL or missing references) //IL_007a: Unknown result type (might be due to invalid IL or missing references) //IL_008b: Expected O, but got Unknown //IL_008c: Expected O, but got Unknown //IL_009a: Unknown result type (might be due to invalid IL or missing references) //IL_009f: 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 string sql = "UPDATE workflowcomment SET \r\n\t\t\t\tMemberID=@MemberID,Comment=@Comment,Type=@Type,Sort=@Sort\r\n\t\t\t\tWHERE ID=@ID"; MySqlParameter[] obj = new MySqlParameter[5]; MySqlParameter val = new MySqlParameter("@MemberID", 751, -1); ((DbParameter)val).Value = model.MemberID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@Comment", 752, -1); ((DbParameter)val2).Value = model.Comment; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Type", 3, 11); ((DbParameter)val3).Value = model.Type; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Sort", 3, 11); ((DbParameter)val4).Value = model.Sort; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@ID", 253, 36); ((DbParameter)val5).Value = model.ID; obj[4] = val5; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkFlowComment 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_003e: Unknown result type (might be due to invalid IL or missing references) //IL_0043: 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_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_0079: Unknown result type (might be due to invalid IL or missing references) //IL_007e: Unknown result type (might be due to invalid IL or missing references) //IL_008f: Expected O, but got Unknown //IL_0090: Expected O, but got Unknown //IL_009a: Unknown result type (might be due to invalid IL or missing references) //IL_009f: 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 string sql = "INSERT INTO workflowcomment\r\n\t\t\t\t(ID,MemberID,Comment,Type,Sort) \r\n\t\t\t\tVALUES(@ID,@MemberID,@Comment,@Type,@Sort)"; MySqlParameter[] obj = new MySqlParameter[5]; MySqlParameter val = new MySqlParameter("@ID", 253, 36); ((DbParameter)val).Value = model.ID; obj[0] = val; MySqlParameter val2 = new MySqlParameter("@MemberID", 751, -1); ((DbParameter)val2).Value = model.MemberID; obj[1] = val2; MySqlParameter val3 = new MySqlParameter("@Comment", 752, -1); ((DbParameter)val3).Value = model.Comment; obj[2] = val3; MySqlParameter val4 = new MySqlParameter("@Type", 3, 11); ((DbParameter)val4).Value = model.Type; obj[3] = val4; MySqlParameter val5 = new MySqlParameter("@Sort", 3, 11); ((DbParameter)val5).Value = model.Sort; obj[4] = val5; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
private List <RoadFlow.Data.Model.WorkFlowComment> DataReaderToList(MySqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowComment> list = new List <RoadFlow.Data.Model.WorkFlowComment>(); RoadFlow.Data.Model.WorkFlowComment workFlowComment = null; while (((DbDataReader)dataReader).Read()) { workFlowComment = new RoadFlow.Data.Model.WorkFlowComment(); workFlowComment.ID = ((DbDataReader)dataReader).GetString(0).ToGuid(); workFlowComment.MemberID = ((DbDataReader)dataReader).GetString(1); workFlowComment.Comment = ((DbDataReader)dataReader).GetString(2); workFlowComment.Type = ((DbDataReader)dataReader).GetInt32(3); workFlowComment.Sort = ((DbDataReader)dataReader).GetInt32(4); list.Add(workFlowComment); } return(list); }
public string Delete() { RoadFlow.Platform.WorkFlowComment workFlowComment = new RoadFlow.Platform.WorkFlowComment(); 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.WorkFlowComment workFlowComment2 = workFlowComment.Get(test); if (workFlowComment2 != null) { workFlowComment.Delete(test); RoadFlow.Platform.Log.Add("删除了流程意见", workFlowComment2.Serialize(), RoadFlow.Platform.Log.Types.流程相关); } } } workFlowComment.RefreshCache(); return("删除成功!"); }
private List <RoadFlow.Data.Model.WorkFlowComment> DataReaderToList(SqlDataReader dataReader) { List <RoadFlow.Data.Model.WorkFlowComment> list = new List <RoadFlow.Data.Model.WorkFlowComment>(); RoadFlow.Data.Model.WorkFlowComment workFlowComment = null; while (dataReader.Read()) { workFlowComment = new RoadFlow.Data.Model.WorkFlowComment(); workFlowComment.ID = dataReader.GetGuid(0); if (!dataReader.IsDBNull(1)) { workFlowComment.MemberID = dataReader.GetString(1); } workFlowComment.Comment = dataReader.GetString(2); workFlowComment.Type = dataReader.GetInt32(3); workFlowComment.Sort = dataReader.GetInt32(4); list.Add(workFlowComment); } return(list); }
public int Update(RoadFlow.Data.Model.WorkFlowComment model) { return(dataWorkFlowComment.Update(model)); }
public int Add(RoadFlow.Data.Model.WorkFlowComment model) { return(dataWorkFlowComment.Add(model)); }