/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowComment实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowComment model)
{
string sql = @"UPDATE WorkFlowComment SET
MemberID=:MemberID,Comment=:Comment,Type=:Type,Sort=:Sort
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":MemberID", OracleDbType.Clob)
{
Value = model.MemberID
},
new OracleParameter(":Comment", OracleDbType.NVarchar2, 1000)
{
Value = model.Comment
},
new OracleParameter(":Type", OracleDbType.Int32)
{
Value = model.Type
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
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[] sqlParameterArray = new SqlParameter[5];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.ID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@MemberID", SqlDbType.VarChar, -1);
sqlParameter2.Value = (object)model.MemberID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Comment", SqlDbType.NVarChar, 1000);
sqlParameter3.Value = (object)model.Comment;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Type", SqlDbType.Int, -1);
sqlParameter4.Value = (object)model.Type;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.Sort;
sqlParameterArray[index5] = sqlParameter5;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowComment实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowComment model)
{
string sql = @"INSERT INTO WorkFlowComment
(ID,MemberID,Comment,Type,Sort)
VALUES(@ID,@MemberID,@Comment,@Type,@Sort)" ;
SqlParameter[] parameters = new SqlParameter[] {
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, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowComment实体类</param>
public int Update(RoadFlow.Data.Model.WorkFlowComment model)
{
string sql = @"UPDATE WorkFlowComment SET
MemberID=@MemberID,Comment=@Comment,Type=@Type,Sort=@Sort
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
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, parameters));
}
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";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[5];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@MemberID", MySqlDbType.LongText, -1);
mySqlParameter1.Value = (object)model.MemberID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Comment", MySqlDbType.Text, -1);
mySqlParameter2.Value = (object)model.Comment;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Type", MySqlDbType.Int32, 11);
mySqlParameter3.Value = (object)model.Type;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter4.Value = (object)model.Sort;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter5.Value = (object)model.ID;
mySqlParameterArray[index5] = mySqlParameter5;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
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[] sqlParameterArray = new SqlParameter[5];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@MemberID", SqlDbType.VarChar, -1);
sqlParameter1.Value = (object)model.MemberID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Comment", SqlDbType.NVarChar, 1000);
sqlParameter2.Value = (object)model.Comment;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Type", SqlDbType.Int, -1);
sqlParameter3.Value = (object)model.Type;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter4.Value = (object)model.Sort;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter5.Value = (object)model.ID;
sqlParameterArray[index5] = sqlParameter5;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.WorkFlowComment实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.WorkFlowComment model)
{
string sql = @"INSERT INTO WorkFlowComment
(ID,MemberID,Comment,Type,Sort)
VALUES(:ID,:MemberID,:Comment,:Type,:Sort)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":MemberID", OracleDbType.Clob)
{
Value = model.MemberID
},
new OracleParameter(":Comment", OracleDbType.NVarchar2, 1000)
{
Value = model.Comment
},
new OracleParameter(":Type", OracleDbType.Int32)
{
Value = model.Type
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
}
};
return(dbHelper.Execute(sql, parameters));
}
public ActionResult Edit(FormCollection collection)
{
RoadFlow.Platform.WorkFlowComment bworkFlowComment = new RoadFlow.Platform.WorkFlowComment();
RoadFlow.Data.Model.WorkFlowComment workFlowComment = null;
string id = Request.QueryString["id"];
string member = string.Empty;
string comment = string.Empty;
string sort = string.Empty;
bool isOneSelf = "1" == Request.QueryString["isoneself"];
Guid commentID;
if (id.IsGuid(out commentID))
{
workFlowComment = bworkFlowComment.Get(commentID);
member = workFlowComment.MemberID;
comment = workFlowComment.Comment;
sort = workFlowComment.Sort.ToString();
}
string oldXML = workFlowComment.Serialize();
if (collection != null)
{
member = isOneSelf ? RoadFlow.Platform.UsersBLL.PREFIX + RoadFlow.Platform.UsersBLL.CurrentUserID.ToString() : Request.Form["Member"];
comment = Request.Form["Comment"];
sort = Request.Form["Sort"];
bool isAdd = !id.IsGuid();
if (workFlowComment == null)
{
workFlowComment = new RoadFlow.Data.Model.WorkFlowComment();
workFlowComment.ID = Guid.NewGuid();
workFlowComment.Type = isOneSelf ? 1 : 0;
}
workFlowComment.MemberID = member.IsNullOrEmpty() ? "" : member.Trim();
workFlowComment.Comment = comment.IsNullOrEmpty() ? "" : comment.Trim();
workFlowComment.Sort = sort.IsInt() ? sort.Convert <int>() : bworkFlowComment.GetManagerMaxSort();
if (isAdd)
{
bworkFlowComment.Add(workFlowComment);
RoadFlow.Platform.Log.Add("添加了流程意见", workFlowComment.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
}
else
{
bworkFlowComment.Update(workFlowComment);
RoadFlow.Platform.Log.Add("修改了流程意见", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowComment.Serialize());
}
bworkFlowComment.RefreshCache();
ViewBag.Script = "new RoadUI.Window().reloadOpener();alert('保存成功!');";
}
return(View(workFlowComment == null ? new RoadFlow.Data.Model.WorkFlowComment() : workFlowComment));
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
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 model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.WorkFlowComment();
model.ID = dataReader.GetGuid(0);
model.MemberID = dataReader.GetString(1);
model.Comment = dataReader.GetString(2);
model.Type = dataReader.GetInt32(3);
model.Sort = dataReader.GetInt32(4);
List.Add(model);
}
return(List);
}
public int Add(RoadFlow.Data.Model.WorkFlowComment model)
{
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[] oracleParameterArray = new OracleParameter[5];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2;
if (model.MemberID != null)
{
OracleParameter oracleParameter3 = new OracleParameter(":MemberID", OracleDbType.Clob);
oracleParameter3.Value = (object)model.MemberID;
oracleParameter2 = oracleParameter3;
}
else
{
oracleParameter2 = new OracleParameter(":MemberID", OracleDbType.Clob);
oracleParameter2.Value = (object)DBNull.Value;
}
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter4 = new OracleParameter(":Comment1", OracleDbType.NVarchar2);
oracleParameter4.Value = (object)model.Comment;
oracleParameterArray[index3] = oracleParameter4;
int index4 = 3;
OracleParameter oracleParameter5 = new OracleParameter(":Type", OracleDbType.Int32);
oracleParameter5.Value = (object)model.Type;
oracleParameterArray[index4] = oracleParameter5;
int index5 = 4;
OracleParameter oracleParameter6 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter6.Value = (object)model.Sort;
oracleParameterArray[index5] = oracleParameter6;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
private List <RoadFlow.Data.Model.WorkFlowComment> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.WorkFlowComment> workFlowCommentList = new List <RoadFlow.Data.Model.WorkFlowComment>();
while (dataReader.Read())
{
RoadFlow.Data.Model.WorkFlowComment 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);
workFlowCommentList.Add(workFlowComment);
}
return(workFlowCommentList);
}
public int Update(RoadFlow.Data.Model.WorkFlowComment model)
{
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[] oracleParameterArray = new OracleParameter[5];
int index1 = 0;
OracleParameter oracleParameter1;
if (model.MemberID != null)
{
OracleParameter oracleParameter2 = new OracleParameter(":MemberID", OracleDbType.Clob);
oracleParameter2.Value = (object)model.MemberID;
oracleParameter1 = oracleParameter2;
}
else
{
oracleParameter1 = new OracleParameter(":MemberID", OracleDbType.Clob);
oracleParameter1.Value = (object)DBNull.Value;
}
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter3 = new OracleParameter(":Comment1", OracleDbType.NVarchar2);
oracleParameter3.Value = (object)model.Comment;
oracleParameterArray[index2] = oracleParameter3;
int index3 = 2;
OracleParameter oracleParameter4 = new OracleParameter(":Type", OracleDbType.Int32);
oracleParameter4.Value = (object)model.Type;
oracleParameterArray[index3] = oracleParameter4;
int index4 = 3;
OracleParameter oracleParameter5 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter5.Value = (object)model.Sort;
oracleParameterArray[index4] = oracleParameter5;
int index5 = 4;
OracleParameter oracleParameter6 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter6.Value = (object)model.ID;
oracleParameterArray[index5] = oracleParameter6;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public string Delete()
{
RoadFlow.Platform.WorkFlowComment workFlowComment1 = new RoadFlow.Platform.WorkFlowComment();
string str1 = this.Request.Form["ids"];
char[] chArray = new char[1] {
','
};
foreach (string str2 in str1.Split(chArray))
{
Guid test;
if (str2.IsGuid(out test))
{
RoadFlow.Data.Model.WorkFlowComment workFlowComment2 = workFlowComment1.Get(test);
if (workFlowComment2 != null)
{
workFlowComment1.Delete(test);
RoadFlow.Platform.Log.Add("删除了流程意见", workFlowComment2.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null);
}
}
}
workFlowComment1.RefreshCache();
return("删除成功!");
}
public ActionResult Edit(FormCollection collection)
{
RoadFlow.Platform.WorkFlowComment workFlowComment = new RoadFlow.Platform.WorkFlowComment();
RoadFlow.Data.Model.WorkFlowComment model = (RoadFlow.Data.Model.WorkFlowComment)null;
string str1 = this.Request.QueryString["id"];
string str2 = string.Empty;
string str3 = string.Empty;
string empty = string.Empty;
bool flag = "1" == this.Request.QueryString["isoneself"];
Guid test;
if (str1.IsGuid(out test))
{
model = workFlowComment.Get(test);
str2 = model.MemberID;
str3 = model.Comment;
empty = model.Sort.ToString();
}
string oldXML = model.Serialize();
if (collection != null)
{
string str4 = flag ? "u_" + RoadFlow.Platform.Users.CurrentUserID.ToString() : this.Request.Form["Member"];
string str5 = this.Request.Form["Comment"];
string str6 = this.Request.Form["Sort"];
int num = !str1.IsGuid() ? 1 : 0;
if (model == null)
{
model = new RoadFlow.Data.Model.WorkFlowComment();
model.ID = Guid.NewGuid();
model.Type = flag ? 1 : 0;
}
model.MemberID = str4.IsNullOrEmpty() ? "" : str4.Trim();
model.Comment = str5.IsNullOrEmpty() ? "" : str5.Trim();
model.Sort = str6.IsInt() ? str6.ToInt() : workFlowComment.GetManagerMaxSort();
if (num != 0)
{
workFlowComment.Add(model);
RoadFlow.Platform.Log.Add("添加了流程意见", model.Serialize(), RoadFlow.Platform.Log.Types.流程相关, "", "", (RoadFlow.Data.Model.Users)null);
}
else
{
workFlowComment.Update(model);
RoadFlow.Platform.Log.Add("修改了流程意见", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, model.Serialize(), (RoadFlow.Data.Model.Users)null);
}
workFlowComment.RefreshCache();
// ISSUE: reference to a compiler-generated field
if (WorkFlowCommentsController.\u003C\u003Eo__4.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
WorkFlowCommentsController.\u003C\u003Eo__4.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Script", typeof(WorkFlowCommentsController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj = WorkFlowCommentsController.\u003C\u003Eo__4.\u003C\u003Ep__0.Target((CallSite)WorkFlowCommentsController.\u003C\u003Eo__4.\u003C\u003Ep__0, this.ViewBag, "new RoadUI.Window().reloadOpener();alert('保存成功!');");
}
if (model == null)
{
model = new RoadFlow.Data.Model.WorkFlowComment();
model.Sort = workFlowComment.GetManagerMaxSort() + 5;
}
return((ActionResult)this.View((object)model));
}
public int Update(RoadFlow.Data.Model.WorkFlowComment model)
{
return(this.dataWorkFlowComment.Update(model));
}
public int Add(RoadFlow.Data.Model.WorkFlowComment model)
{
return(this.dataWorkFlowComment.Add(model));
}
protected void Page_Load(object sender, EventArgs e)
{
RoadFlow.Platform.WorkFlowComment bworkFlowComment = new RoadFlow.Platform.WorkFlowComment();
RoadFlow.Data.Model.WorkFlowComment workFlowComment = null;
string id = Request.QueryString["id"];
string member = string.Empty;
string comment = string.Empty;
string sort = string.Empty;
bool isOneSelf = "1" == Request.QueryString["isoneself"];
if (isOneSelf)
{
this.usermemberid.Visible = false;
}
Guid commentID;
if (id.IsGuid(out commentID))
{
workFlowComment = bworkFlowComment.Get(commentID);
member = workFlowComment.MemberID;
comment = workFlowComment.Comment;
sort = workFlowComment.Sort.ToString();
}
string oldXML = workFlowComment.Serialize();
if (IsPostBack)
{
member = isOneSelf ? RoadFlow.Platform.Users.PREFIX + RoadFlow.Platform.Users.CurrentUserID.ToString() : Request.Form["Member"];
comment = Request.Form["Comment"];
sort = Request.Form["Sort"];
bool isAdd = !id.IsGuid();
if (workFlowComment == null)
{
workFlowComment = new RoadFlow.Data.Model.WorkFlowComment();
workFlowComment.ID = Guid.NewGuid();
workFlowComment.Type = isOneSelf ? 1 : 0;
}
workFlowComment.MemberID = member.IsNullOrEmpty() ? "" : member.Trim();
workFlowComment.Comment = comment.IsNullOrEmpty() ? "" : comment.Trim();
workFlowComment.Sort = sort.IsInt() ? sort.ToInt() : bworkFlowComment.GetManagerMaxSort();
if (isAdd)
{
bworkFlowComment.Add(workFlowComment);
RoadFlow.Platform.Log.Add("添加了流程意见", workFlowComment.Serialize(), RoadFlow.Platform.Log.Types.流程相关);
}
else
{
bworkFlowComment.Update(workFlowComment);
RoadFlow.Platform.Log.Add("修改了流程意见", "", RoadFlow.Platform.Log.Types.流程相关, oldXML, workFlowComment.Serialize());
}
bworkFlowComment.RefreshCache();
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "new RoadUI.Window().reloadOpener();alert('保存成功!'); new RoadUI.Window().close();", true);
}
if (workFlowComment != null)
{
this.Comment.Value = workFlowComment.Comment;
this.Member.Value = workFlowComment.MemberID;
this.Sort.Value = workFlowComment.Sort.ToString();
}
}