/// <summary> /// 轮询是否有新被拒绝的供应链流程 /// 如果有 新增到备忘录表中 /// </summary> public void AddNewNote() { DataView dv = GetData(); int Task = 0; BPMInstTasksDal taskdal = new BPMInstTasksDal(); BPMInstTasks taskmodel = new BPMInstTasks(); foreach (DataRowView dr in dv) { Task = Convert.ToInt32(dr["TaskID"].ToString()); taskmodel = taskdal.Detail(Task); if (!IsExist(Task)) { Add(new JD_PrivateNote { TaskID = Task, SNumber = taskmodel.SerialNum, ProcessName = taskmodel.ProcessName, Submiter = taskmodel.OwnerAccount, SubmitDate = taskmodel.CreateAt, IsCheck = 0, BelongDept = "供应链部", RejectReason = GetRejectComment(dr["TaskID"].ToString()) }); } } }
/// <summary> /// 插入日志查询列表 /// </summary> /// <param name="TaskID"></param> /// <param name="TableName">轮询日志表名</param> /// <param name="TableItemID">轮询日志表ID</param> /// <param name="LogType">"API"|"SQL"</param> /// <param name="Message">返回信息</param> /// <param name="Success">是否成功</param> /// <returns></returns> public void AddLogQueue(int TaskID, string TableName, int TableItemID, string LogType, string Message, bool Success) { JD_LogMngQueueDal dal = new JD_LogMngQueueDal(); JD_LogMngFailedDal faildal = new JD_LogMngFailedDal(); BPMInstTasksDal taskdal = new BPMInstTasksDal(); DateTime NowDate = DateTime.Now; BPMInstTasks taskMol = taskdal.Detail(TaskID); int LogQueID = dal.Add(new JD_LogMngQueue { TaskID = TaskID, TableItemID = TableItemID, LogTableName = TableName, Message = Message, CreateTime = NowDate, LogType = LogType, Year = NowDate.Year, Month = NowDate.Month, IsSuccess = (Success == true) ? 1 : 0, FileName = taskMol.ProcessName, SNumber = taskMol.SerialNum }); //如果不成功 插入错误日志 if (!Success) { faildal.Add(new JD_LogMngFailed { TaskID = TaskID, TableItemID = TableItemID, LogTableName = TableName, CreateTime = NowDate, FileName = taskMol.ProcessName, SNumber = taskMol.SerialNum, LogQueID = LogQueID, LogType = LogType, Message = Message }); } }
/// <summary> /// 对象BPMInstTasks明细 /// 编写人:ywk /// 编写日期:2018/8/10 星期五 /// </summary> public BPMInstTasks Detail(int TaskID) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM BPMInstTasks WHERE TaskID = @m_TaskID", con); con.Open(); cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = TaskID; BPMInstTasks myDetail = new BPMInstTasks(); SqlDataReader myReader = cmd.ExecuteReader(); if (myReader.Read()) { if (!Convert.IsDBNull(myReader["TaskID"])) { myDetail.TaskID = Convert.ToInt32(myReader["TaskID"]); } if (!Convert.IsDBNull(myReader["ProcessName"])) { myDetail.ProcessName = Convert.ToString(myReader["ProcessName"]); } if (!Convert.IsDBNull(myReader["OwnerAccount"])) { myDetail.OwnerAccount = Convert.ToString(myReader["OwnerAccount"]); } if (!Convert.IsDBNull(myReader["AgentAccount"])) { myDetail.AgentAccount = Convert.ToString(myReader["AgentAccount"]); } if (!Convert.IsDBNull(myReader["CreateAt"])) { myDetail.CreateAt = Convert.ToDateTime(myReader["CreateAt"]); } if (!Convert.IsDBNull(myReader["Description"])) { myDetail.Description = Convert.ToString(myReader["Description"]); } if (!Convert.IsDBNull(myReader["FinishAt"])) { myDetail.FinishAt = Convert.ToDateTime(myReader["FinishAt"]); } if (!Convert.IsDBNull(myReader["State"])) { myDetail.State = Convert.ToString(myReader["State"]); } if (!Convert.IsDBNull(myReader["SerialNum"])) { myDetail.SerialNum = Convert.ToString(myReader["SerialNum"]); } if (!Convert.IsDBNull(myReader["OptUser"])) { myDetail.OptUser = Convert.ToString(myReader["OptUser"]); } if (!Convert.IsDBNull(myReader["OptAt"])) { myDetail.OptAt = Convert.ToDateTime(myReader["OptAt"]); } if (!Convert.IsDBNull(myReader["OptMemo"])) { myDetail.OptMemo = Convert.ToString(myReader["OptMemo"]); } if (!Convert.IsDBNull(myReader["FormDataSetID"])) { myDetail.FormDataSetID = Convert.ToInt32(myReader["FormDataSetID"]); } if (!Convert.IsDBNull(myReader["ExtYear"])) { myDetail.ExtYear = Convert.ToInt32(myReader["ExtYear"]); } if (!Convert.IsDBNull(myReader["ExtInitiator"])) { myDetail.ExtInitiator = Convert.ToString(myReader["ExtInitiator"]); } if (!Convert.IsDBNull(myReader["ExtDeleted"])) { myDetail.ExtDeleted = Convert.ToBoolean(myReader["ExtDeleted"]); } if (!Convert.IsDBNull(myReader["OwnerPositionID"])) { myDetail.OwnerPositionID = Convert.ToInt32(myReader["OwnerPositionID"]); } if (!Convert.IsDBNull(myReader["ParentTaskID"])) { myDetail.ParentTaskID = Convert.ToInt32(myReader["ParentTaskID"]); } if (!Convert.IsDBNull(myReader["ParentStepID"])) { myDetail.ParentStepID = Convert.ToInt32(myReader["ParentStepID"]); } if (!Convert.IsDBNull(myReader["ParentStepName"])) { myDetail.ParentStepName = Convert.ToString(myReader["ParentStepName"]); } if (!Convert.IsDBNull(myReader["ProcessVersion"])) { myDetail.ProcessVersion = Convert.ToString(myReader["ProcessVersion"]); } if (!Convert.IsDBNull(myReader["ParentServerIdentity"])) { myDetail.ParentServerIdentity = Convert.ToString(myReader["ParentServerIdentity"]); } if (!Convert.IsDBNull(myReader["ReturnToParent"])) { myDetail.ReturnToParent = Convert.ToBoolean(myReader["ReturnToParent"]); } if (!Convert.IsDBNull(myReader["UrlParams"])) { myDetail.UrlParams = Convert.ToString(myReader["UrlParams"]); } if (!Convert.IsDBNull(myReader["Context"])) { myDetail.Context = Convert.ToString(myReader["Context"]); } } myReader.Close(); cmd.Dispose(); con.Close(); con.Dispose(); return(myDetail); }