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