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