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