/// <summary>
/// 取得流程审批记录
/// </summary>
/// <param name="formId"></param>
/// <returns></returns>
public IList <ProcessLogInfo> GetProcessLogList(string formId)
{
DataSet ds = dal.GetProcessLogList(formId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <ProcessLogInfo> pliList = new List <ProcessLogInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProcessLogInfo info = new ProcessLogInfo();
info.ProcessLogId = new Guid(dr["ProcessLogId"].ToString());
info.FormId = formId;
info.ActivityName = dr["ActivityName"].ToString();
info.ApproverName = dr["ApproverName"].ToString();
info.ApproverID = dr["ApproverID"].ToString();
info.ApprovePosition = dr["ApprovePosition"].ToString();
info.Operation = dr["Operation"].ToString();
info.Comments = dr["Comments"].ToString();
info.Operatetime = Convert.ToDateTime(dr["Operatetime"]);
info.State = Convert.ToInt32(dr["State"]);
info.CreatedBy = dr["CreatedBy"].ToString();
info.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
info.Description = dr["Description"].ToString();
pliList.Add(info);
}
return(pliList);
}
return(null);
}
/// <summary>
/// 添加审批记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool InsertProcessLog(ProcessLogInfo info)
{
try
{
string sql = "SProc_Admin_InsertProcessLog";
SqlParameter[] parms =
{
new SqlParameter("@FormId", info.FormId),
new SqlParameter("@ActivityName", info.ActivityName),
new SqlParameter("@ApproverName", info.ApproverName),
new SqlParameter("@ApproverID", info.ApproverID),
new SqlParameter("@ApprovePosition", info.ApprovePosition),
new SqlParameter("@Operation", info.Operation),
new SqlParameter("@Comments", info.Comments),
new SqlParameter("@Operatetime", info.Operatetime),
new SqlParameter("@CreatedBy", DBManager.GetCurrentUserAD())
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, sql, parms);
return(true);
}
catch (Exception ex)
{
DBManager.RecoreErrorProfile(ex, "ProcessLogDAL.InsertProcessLog", DBManager.GetCurrentUserAD());
return(false);
}
}
/// <summary>
/// process log
/// </summary>
/// <param name="action">process action</param>
/// <returns>success or not</returns>
public bool ProcessLog(string action)
{
Assembly ass = Assembly.Load("BLL");
Type type = ass.GetType("BLL.ProcessLogBLL");
MethodInfo info = type.GetMethod("InsertProcessLog");
Object obj = ass.CreateInstance("BLL.ProcessLogBLL");
if (WorkflowID == 3)
{
if (this.ActivityName.Equals("申请人重新提交", StringComparison.OrdinalIgnoreCase) && action.Equals("Cancel"))
{
//Entity.T_ProcessLog processlog1 = new Entity.T_ProcessLog() { ActivityName = "取消任务", Operation = action, ProcessLogId = Guid.NewGuid(), FormId = FormID, Operatetime = DateTime.Now, ApproverName = EmployeeName, ApproverCode = this.EmployeeCode, ApprovePosition = this.Post, Comments = this.Comments };
ProcessLogInfo processlog1 = new ProcessLogInfo();
processlog1.ActivityName = "取消任务";
processlog1.Operation = action;
processlog1.ProcessLogId = Guid.NewGuid();
processlog1.FormId = FormID;
processlog1.Operatetime = DateTime.Now;
processlog1.ApproverName = Employee.CHName;
processlog1.ApproverID = Employee.ID;
processlog1.ApprovePosition = this.Post;
processlog1.Comments = this.Comments;
//return processlogOP.InsertIntoProcessLog(processlog1);//插入审批记录
info.Invoke(obj, new ProcessLogInfo[] { processlog1 });
return(true);
}
}
//Entity.T_ProcessLog processlog = new Entity.T_ProcessLog() { ActivityName = this.ActivityName, Operation = action, ProcessLogId = Guid.NewGuid(), FormId = FormID, Operatetime = DateTime.Now, ApproverName = EmployeeName, ApproverCode = this.EmployeeCode, ApprovePosition = this.Post, Comments = this.Comments };
ProcessLogInfo processlog = new ProcessLogInfo();
processlog.ActivityName = this.ActivityName;
processlog.Operation = action;
processlog.ProcessLogId = Guid.NewGuid();
processlog.FormId = FormID;
processlog.Operatetime = DateTime.Now;
processlog.ApproverName = Employee.CHName;
processlog.ApproverID = Employee.ID;
processlog.ApprovePosition = this.Post;
processlog.Comments = this.Comments;
//return processlogOP.InsertIntoProcessLog(processlog);//插入审批记录
//return true;
info.Invoke(obj, new ProcessLogInfo[] { processlog });
return(true);
}
/// <summary>
/// process log
/// </summary>
/// <param name="action">process action</param>
/// <param name="action">activityName</param>
/// <returns>success or not</returns>
public bool ProcessLog(string action, string activityName)
{
ProcessLogInfo processlog = new ProcessLogInfo();
processlog.ActivityName = activityName;
processlog.Operation = action;
processlog.ProcessLogId = Guid.NewGuid();
processlog.FormId = FormID;
processlog.Operatetime = DateTime.Now;
processlog.ApproverName = Employee.CHName;
processlog.ApproverID = Employee.ID;
processlog.ApprovePosition = this.Post;
processlog.Comments = this.Comments;
Assembly ass = Assembly.Load("BLL");
Type type = ass.GetType("BLL.ProcessLogBLL");
MethodInfo info = type.GetMethod("InsertProcessLog");
Object obj = ass.CreateInstance("BLL.ProcessLogBLL");
info.Invoke(obj, new ProcessLogInfo[] { processlog });
return(true);
}
/// <summary>
/// 添加Log
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool InsertProcessLog(ProcessLogInfo info)
{
return(dal.InsertProcessLog(info));
}
