/// <summary>
/// 获取引擎待办任务（主数据）
/// </summary>
/// <param name="strUserID"></param>
/// <param name="strStatus"></param>
/// <param name="iTop"></param>
/// <param name="LastDay"></param>
/// <returns></returns>
public List<T_FLOW_ENGINEMSGLIST> GetEngineMainMsgList(string strUserID, string strStatus, string message, int iTop, int LastDay)
{
List<T_FLOW_ENGINEMSGLIST> DataList = new List<T_FLOW_ENGINEMSGLIST>();
if (iTop <= 0)
{
return DataList;
}
try
{
dao.Open();
string strFields = " APPLICATIONURL,MODELCODE,BEFOREPROCESSDATE,ORDERID,CREATEDATETIME,MESSAGEBODY,DOTASKID,CLOSEDDATE,RECEIVEUSERID,DOTASKSTATUS,SYSTEMCODE,MODELNAME ";
string strLastDay = string.Empty;
string sqlWhere = "";
if (!string.IsNullOrWhiteSpace(message))
{
sqlWhere = " and MESSAGEBODY like'%" + message + "%'";
}
string strsql = "";
if (strStatus.ToUpper() == "OPEN")
{
if (LastDay > 0)
{
strLastDay = " and CREATEDATETIME>to_date('" + DateTime.Now.AddDays(-LastDay).ToString("yyyy/MM/dd") + "','YYYY-MM-DD')";
}
strsql = "SELECT " + strFields + " FROM (SELECT " + strFields + " FROM T_WF_DOTASK where RECEIVEUSERID='" + strUserID + "' and DOTASKSTATUS=0 " + sqlWhere + strLastDay + " order by BEFOREPROCESSDATE) where rownum <=" + iTop;
}
else if (strStatus.ToUpper() == "CLOSE")
{
if (LastDay > 0)
{
strLastDay = " and CLOSEDDATE>to_date('" + DateTime.Now.AddDays(-LastDay).ToString("yyyy/MM/dd") + "','YYYY-MM-DD')";
}
strsql = "SELECT " + strFields + " FROM (SELECT " + strFields + " FROM T_WF_DOTASK where RECEIVEUSERID='" + strUserID + "' and DOTASKSTATUS=1 " + sqlWhere + strLastDay + " order by CLOSEDDATE desc) where rownum <=" + iTop;
}
DataTable table = dao.GetDataTable(strsql);
int tt = 0;
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
tt++;
T_FLOW_ENGINEMSGLIST msgList = new T_FLOW_ENGINEMSGLIST();
msgList.MESSAGEID = string.Concat(dr["DOTASKID"]);
msgList.APPLICATIONURL = string.Concat(dr["APPLICATIONURL"]);
msgList.MESSAGESTATUS = dr["DOTASKSTATUS"].ToString();
msgList.ORDERNODECODE = string.Concat(dr["SYSTEMCODE"]) + "_" + string.Concat(dr["ORDERID"]);
msgList.APPLICATIONCODE = string.Concat(dr["SYSTEMCODE"]);
msgList.BEFOREPROCESSDATE = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
msgList.CREATEDATE = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("yyyy/MM/dd");
msgList.CREATETIME = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("HH:mm");
msgList.MESSAGEBODY = string.Concat(dr["MESSAGEBODY"]);
msgList.OPERATIONDATE = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("yyyy/MM/dd") : "";
msgList.OPERATIONTIME = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("HH:mm") : "";
msgList.RECEIVEUSER = string.Concat(dr["RECEIVEUSERID"]);
msgList.MODELCODE = TypeConverter.ToString(dr["MODELCODE"]);
msgList.MODELNAME = TypeConverter.ToString(dr["MODELNAME"]);
DateTime OverTime = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
TimeSpan timeSpan = OverTime - DateTime.Now;
if (TypeConverter.ToInt(timeSpan.TotalHours) == 0)//小于一小时范围内
{
if (timeSpan.Minutes > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(timeSpan.Minutes) + "M";
}
else if (timeSpan.Minutes == 0)
{
msgList.TEMPFIELD = "+0M";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(timeSpan.Minutes) + "M";
}
}
else
{
if (timeSpan.TotalHours > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
else if (timeSpan.TotalHours == 0)
{
msgList.TEMPFIELD = "+0H";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
}
DataList.Add(msgList);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "GetEngineMainMsgList()", "获取引擎待办任务（主数据）", ex);
return null;
}
finally
{
dao.Close();
}
return DataList;
}
private T_FLOW_ENGINEMSGLIST GeneralEngineMsgModel(DataRow dr)
{
T_FLOW_ENGINEMSGLIST msgList = new T_FLOW_ENGINEMSGLIST();
msgList.MESSAGEID = string.Concat(dr["DOTASKID"]);
msgList.APPLICATIONCODE = string.Concat(dr["SYSTEMCODE"]);
msgList.ORDERNODECODE = string.Concat(dr["ORDERID"]);
msgList.MESSAGESTATUS = string.Concat(dr["DOTASKSTATUS"]);
msgList.APPLICATIONURL = string.Concat(dr["applicationurl"]);
msgList.BEFOREPROCESSDATE = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
msgList.CREATEDATE = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("yyyy/MM/dd");
msgList.CREATETIME = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("HH:mm");
msgList.MESSAGEBODY = string.Concat(dr["MESSAGEBODY"]);
msgList.OPERATIONDATE = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("yyyy/MM/dd") : "";
msgList.OPERATIONTIME = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("HH:mm") : "";
msgList.RECEIVEUSER = string.Concat(dr["RECEIVEUSERID"]);
msgList.MODELCODE = TypeConverter.ToString(dr["MODELCODE"]);
msgList.MODELNAME = TypeConverter.ToString(dr["MODELNAME"]);
DateTime OverTime = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
TimeSpan timeSpan = OverTime - DateTime.Now;
if (TypeConverter.ToInt(timeSpan.TotalHours) == 0)//小于一小时范围内
{
if (timeSpan.Minutes > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(timeSpan.Minutes) + "M";
}
else if (timeSpan.Minutes == 0)
{
msgList.TEMPFIELD = "+0M";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(timeSpan.Minutes) + "M";
}
}
else
{
if (timeSpan.TotalHours > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
else if (timeSpan.TotalHours == 0)
{
msgList.TEMPFIELD = "+0H";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
}
return msgList;
}
/// <summary>
/// 手机版待办任务分页查询
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="strReceiveUser"></param>
/// <param name="strStatus"></param>
/// <param name="msgBody"></param>
/// <param name="beginDate"></param>
/// <param name="endDate"></param>
/// <param name="rowCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List<T_FLOW_ENGINEMSGLIST> MsgListByPagingForMobile(int pageIndex, int pageSize, string strReceiveUser, string strStatus, string msgBody, DateTime beginDate, DateTime endDate, ref int rowCount, ref int pageCount)
{
List<T_FLOW_ENGINEMSGLIST> DataList = new List<T_FLOW_ENGINEMSGLIST>();
try
{
string strOrderBy = "BEFOREPROCESSDATE";
if (strStatus.ToUpper() == "CLOSE")
{
strOrderBy = " CLOSEDDATE DESC";
}
int limitPageSize = 0;
Int32.TryParse(ConfigurationManager.AppSettings["LimitPageSize"].ToString(), out limitPageSize);
//如果当前pageSize大于最大记录数，则当前pageSize=设置最大记录数。
pageSize = pageSize > limitPageSize ? limitPageSize : pageSize;
#region where
int status = 0;
if (strStatus.ToUpper() == "CLOSE")
{
status = 1;
}
else if (strStatus.ToUpper() == "OPEN")
{
status = 0;
}
string where = " RECEIVEUSERID='" + strReceiveUser + "' and dotaskstatus=" + status + " ";
if (!string.IsNullOrEmpty(msgBody))
where += " and MESSAGEBODY LIKE '%" + msgBody + "%'";
if (strStatus.ToUpper() == "CLOSE")
{
if (beginDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
where += " and CLOSEDDATE>=to_date('" + beginDate + "','YYYY-MM-DD') and CLOSEDDATE<=to_date('" + endDate + "','YYYY-MM-DD')";
}
else if (beginDate != DateTime.MinValue)
{
where += " and CLOSEDDATE>=to_date('" + beginDate + "','YYYY-MM-DD')";
}
else if (endDate != DateTime.MinValue)
{
where += " and CLOSEDDATE<=to_date('" + endDate + "','YYYY-MM-DD')";
}
}
if (strStatus.ToUpper() == "OPEN")
{
if (beginDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
where += " and CREATEDATETIME>=to_date('" + beginDate + "','YYYY-MM-DD') and CREATEDATETIME<=to_date('" + endDate + "','YYYY-MM-DD')";
}
else if (beginDate != DateTime.MinValue)
{
where += " and CREATEDATETIME>=to_date('" + beginDate + "','YYYY-MM-DD')";
}
else if (endDate != DateTime.MinValue)
{
where += " and CREATEDATETIME<=to_date('" + endDate + "','YYYY-MM-DD')";
}
}
#endregion
dao.Open();
string strCountSql = "SELECT count(1) FROM T_WF_DOTASK a RIGHT JOIN T_WF_MOBILEFILTER b on a.MODELCODE = b.MODELCODE where " + where;
DataTable tbCount = dao.GetDataTable(strCountSql);
if (tbCount != null && tbCount.Rows.Count > 0)
{
rowCount = TypeConverter.ToInt(tbCount.Rows[0][0]);
}
if (rowCount == 0)//检查统计没有数据直接返回
return null;
pageCount = rowCount / pageSize + (rowCount % pageSize > 0 ? 1 : 0);
string fields = "BEFOREPROCESSDATE,CREATEDATETIME,MESSAGEBODY,applicationurl,DOTASKID,CLOSEDDATE,RECEIVEUSERID,DOTASKSTATUS";
int iRecStart = (pageIndex - 1) * pageSize + 1;
int iRecEnd = pageIndex * pageSize;
where = string.IsNullOrEmpty(where) ? " 1=1 " : where;
string strSql = "select MODELCODE,MODELNAME,ORDERID," + fields + ",SYSTEMCODE " +
" from( " +
" select rownum num,MODELCODE,MODELNAME,ORDERID," + fields + ",SYSTEMCODE " +
" from( " +
"SELECT a.MODELCODE,a.MODELNAME,a.ORDERID," + fields + ",a.SYSTEMCODE,ROUND(TO_NUMBER(sysdate - BEFOREPROCESSDATE) * 24 * 60) as OverTime FROM T_WF_DOTASK a RIGHT JOIN T_WF_MOBILEFILTER b on a.MODELCODE = b.MODELCODE " +
"where " + where + " order by " + strOrderBy + " ) temp1 " +
" where rownum<=" + iRecEnd +
")temp2 " +
"where temp2.num>=" + iRecStart;
//LogHelper.WriteLog("手机版待办任务分页查询 SQL语句：\r\n" + strSql);
DataTable table = dao.GetDataTable(strSql);
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
T_FLOW_ENGINEMSGLIST msgList = new T_FLOW_ENGINEMSGLIST();
msgList.MESSAGEID = string.Concat(dr["DOTASKID"]);
msgList.ORDERNODECODE = string.Concat(dr["ORDERID"]);
msgList.APPLICATIONURL = string.Concat(dr["applicationurl"]);
msgList.APPLICATIONCODE = string.Concat(dr["SYSTEMCODE"]);
msgList.BEFOREPROCESSDATE = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
msgList.CREATEDATE = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("yyyy/MM/dd");
msgList.CREATETIME = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("HH:mm");
msgList.MESSAGEBODY = string.Concat(dr["MESSAGEBODY"]);
msgList.OPERATIONDATE = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("yyyy/MM/dd") : "";
msgList.OPERATIONTIME = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("HH:mm") : "";
msgList.RECEIVEUSER = string.Concat(dr["RECEIVEUSERID"]);
msgList.MODELCODE = TypeConverter.ToString(dr["MODELCODE"]);
msgList.MODELNAME = TypeConverter.ToString(dr["MODELNAME"]);
DateTime OverTime = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
TimeSpan timeSpan = OverTime - DateTime.Now;
if (TypeConverter.ToInt(timeSpan.TotalHours) == 0)//小于一小时范围内
{
if (timeSpan.Minutes > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(timeSpan.Minutes) + "M";
}
else if (timeSpan.Minutes == 0)
{
msgList.TEMPFIELD = "+0M";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(timeSpan.Minutes) + "M";
}
}
else
{
if (timeSpan.TotalHours > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
else if (timeSpan.TotalHours == 0)
{
msgList.TEMPFIELD = "+0H";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
}
DataList.Add(msgList);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "MsgListByPagingForMobile()", "手机版待办任务分页查询", ex);
return null;
}
finally
{
dao.Close();
}
return DataList;
}
public T_FLOW_ENGINEMSGLIST PendingDetailTasksByPhone(string ordernodecode)
{
try
{
string sql = "SELECT * FROM T_WF_DOTASK where orderid='" + ordernodecode + "'ORDER BY CREATEDATETIME DESC ";
dao.Open();
//LogHelper.WriteLog("获取引擎细节任务（细节数据）SQL语句：\r\n" + sql);
DataTable dt = dao.GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
T_FLOW_ENGINEMSGLIST msg = new T_FLOW_ENGINEMSGLIST();
msg.APPLICATIONURL = string.Concat(dt.Rows[0]["APPLICATIONURL"]);
msg.APPFIELDVALUE = string.Concat(dt.Rows[0]["APPFIELDVALUE"]);
msg.MESSAGESTATUS = string.Concat(dt.Rows[0]["DOTASKSTATUS"]) == "1" ? "close" : "open";//供手机使用
msg.SYSTEMNAME = string.Concat(dt.Rows[0]["SYSTEMNAME"]);
msg.MODELNAME = string.Concat(dt.Rows[0]["MODELNAME"]);
msg.FLOWXML = TypeConverter.ToString(dt.Rows[0]["FLOWXML"]);
msg.APPXML = TypeConverter.ToString(dt.Rows[0]["APPXML"]);
msg.ORDERNODECODE = TypeConverter.ToString(dt.Rows[0]["SYSTEMCODE"]) + "_" + TypeConverter.ToString(dt.Rows[0]["ORDERID"]);
return msg;
}
return null;
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "PendingDetailTasksByPhone()", "获取引擎细节任务（细节数据）", ex);
return null;
}
finally
{
dao.Close();
}
}
/// <summary>
/// 获取引擎细节任务（细节数据）
/// </summary>
/// <param name="strMsgID"></param>
/// <returns></returns>
public T_FLOW_ENGINEMSGLIST GetEngineMsgDetail(string dotaskid, bool isPhone)
{
try
{
string sql = "SELECT * FROM T_WF_DOTASK where dotaskid='" + dotaskid + "' ";
dao.Open();
DataTable dt = dao.GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
T_FLOW_ENGINEMSGLIST msg = new T_FLOW_ENGINEMSGLIST();
msg.APPLICATIONURL = string.Concat(dt.Rows[0]["APPLICATIONURL"]);
msg.APPFIELDVALUE = string.Concat(dt.Rows[0]["APPFIELDVALUE"]);
msg.MESSAGESTATUS = string.Concat(dt.Rows[0]["DOTASKSTATUS"]) == "1" ? "close" : "open";//供手机使用
//msg.SYSTEMNAME = string.Concat(dt.Rows[0]["SYSTEMNAME"]);
msg.MODELNAME = string.Concat(dt.Rows[0]["MODELNAME"]);
if (isPhone)//手机需要的字段
{
msg.FLOWXML = TypeConverter.ToString(dt.Rows[0]["FLOWXML"]);
msg.APPXML = TypeConverter.ToString(dt.Rows[0]["APPXML"]);
msg.ORDERNODECODE = TypeConverter.ToString(dt.Rows[0]["SYSTEMCODE"]) + "_" + TypeConverter.ToString(dt.Rows[0]["ORDERID"]);
}
return msg;
}
return null;
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "GetEngineMsgDetail()", "获取引擎细节任务（细节数据）", ex);
return null;
}
finally
{
dao.Close();
}
}
/// <summary>
/// 待办任务分页查询
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="strReceiveUser"></param>
/// <param name="strStatus"></param>
/// <param name="msgBody"></param>
/// <param name="beginDate"></param>
/// <param name="endDate"></param>
/// <param name="rowCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List<T_FLOW_ENGINEMSGLIST> MsgListByPaging(int pageIndex, int pageSize, string strReceiveUser, string strStatus, string msgBody, DateTime beginDate, DateTime endDate, ref int rowCount, ref int pageCount)
{
List<T_FLOW_ENGINEMSGLIST> DataList = new List<T_FLOW_ENGINEMSGLIST>();
try
{
string strOrderBy = " BEFOREPROCESSDATE ";
if (strStatus.ToUpper() == "CLOSE")
{
strOrderBy = "CLOSEDDATE DESC";
}
int limitPageSize = 0;
Int32.TryParse(ConfigurationManager.AppSettings["LimitPageSize"].ToString(), out limitPageSize);
//如果当前pageSize大于最大记录数，则当前pageSize=设置最大记录数。
pageSize = pageSize > limitPageSize ? limitPageSize : pageSize;
#region where
int status = 0;
string where = "";
if (strStatus.ToUpper() == "CLOSE")
{
status = 1;
where = " RECEIVEUSERID='" + strReceiveUser + "' and DOTASKSTATUS=" + status + " ";
}
else if (strStatus.ToUpper() == "OPEN")
{
status = 0;
where = " RECEIVEUSERID='" + strReceiveUser + "' and DOTASKSTATUS=" + status + " ";
}
else
{
strOrderBy = " CREATEDATETIME DESC";
where = " RECEIVEUSERID='" + strReceiveUser + "' ";
}
if (!string.IsNullOrEmpty(msgBody))
where += " and MESSAGEBODY LIKE '%" + msgBody + "%'";
if (strStatus.ToUpper() == "CLOSE")
{
if (beginDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
where += " and CLOSEDDATE>=to_date('" + beginDate + "','YYYY-MM-DD') and CLOSEDDATE<=to_date('" + endDate + "','YYYY-MM-DD')";
}
else if (beginDate != DateTime.MinValue)
{
where += " and CLOSEDDATE>=to_date('" + beginDate + "','YYYY-MM-DD')";
}
else if (endDate != DateTime.MinValue)
{
where += " and CLOSEDDATE<=to_date('" + endDate + "','YYYY-MM-DD')";
}
}
if (strStatus.ToUpper() == "OPEN")
{
if (beginDate != DateTime.MinValue && endDate != DateTime.MinValue)
{
where += " and CREATEDATETIME>=to_date('" + beginDate + "','YYYY-MM-DD') and CREATEDATETIME<=to_date('" + endDate + "','YYYY-MM-DD')";
}
else if (beginDate != DateTime.MinValue)
{
where += " and CREATEDATETIME>=to_date('" + beginDate + "','YYYY-MM-DD')";
}
else if (endDate != DateTime.MinValue)
{
where += " and CREATEDATETIME<=to_date('" + endDate + "','YYYY-MM-DD')";
}
}
#endregion
string strCountSql = "SELECT count(DOTASKID) FROM T_WF_DOTASK where " + where;
DataTable dt = dao.GetDataTable(strCountSql);
//Tracer.Debug("MsgListByPaging()" + strCountSql);
if (dt != null && dt.Rows.Count > 0)
{
rowCount = int.Parse(dt.Rows[0][0].ToString());
}
if (rowCount == 0)//检查统计没有数据直接返回
return null;
pageCount = rowCount / pageSize + (rowCount % pageSize > 0 ? 1 : 0);
string fields = " ORDERID,APPLICATIONURL,MODELCODE,BEFOREPROCESSDATE,CREATEDATETIME,MESSAGEBODY,DOTASKID,CLOSEDDATE,RECEIVEUSERID,DOTASKSTATUS,SYSTEMCODE,MODELNAME ";
int iRecStart = (pageIndex - 1) * pageSize + 1;
//if (rowCount % pageSize == 0 && pageIndex > 1)
//{
// iRecStart = (pageIndex - 2) * pageSize + 1;
//}
int iRecEnd = pageIndex * pageSize;
where = string.IsNullOrEmpty(where) ? " 1=1 " : where;
string strSql = "select " + fields + " " +
" from( " +
" select rownum num," + fields + " " +
" from( " +
"SELECT " + fields + " FROM T_WF_DOTASK " +
"where " + where + " order by " + strOrderBy + ") temp1 " +
" where rownum<=" + iRecEnd +
")temp2 " +
"where temp2.num>=" + iRecStart;
DataTable table = dao.GetDataTable(strSql);
//Tracer.Debug("MsgListByPaging()" + table.Rows.Count + "||" + strSql);
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow dr in table.Rows)
{
//Tracer.Debug("消息：" + dr["MESSAGEBODY"].ToString() + "||状态：" + dr["DOTASKSTATUS"].ToString() + "\n\r");
T_FLOW_ENGINEMSGLIST msgList = new T_FLOW_ENGINEMSGLIST();
msgList.MESSAGEID = string.Concat(dr["DOTASKID"]);
msgList.ORDERNODECODE = string.Concat(dr["ORDERID"]);
msgList.APPLICATIONURL = string.Concat(dr["APPLICATIONURL"]);
msgList.MESSAGESTATUS = string.Concat(dr["DOTASKSTATUS"]);
msgList.APPLICATIONCODE = string.Concat(dr["SYSTEMCODE"]);
msgList.BEFOREPROCESSDATE = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
msgList.CREATEDATE = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("yyyy/MM/dd");
msgList.CREATETIME = Convert.ToDateTime(dr["CREATEDATETIME"].ToString()).ToString("HH:mm");
msgList.MESSAGEBODY = string.Concat(dr["MESSAGEBODY"]);
msgList.OPERATIONDATE = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("yyyy/MM/dd") : "";
msgList.OPERATIONTIME = dr["CLOSEDDATE"].ToString() != "" ? Convert.ToDateTime(dr["CLOSEDDATE"].ToString()).ToString("HH:mm") : "";
msgList.RECEIVEUSER = string.Concat(dr["RECEIVEUSERID"]);
msgList.MODELCODE = TypeConverter.ToString(dr["MODELCODE"]);
msgList.MODELNAME = TypeConverter.ToString(dr["MODELNAME"]);
DateTime OverTime = TypeConverter.ToDateTime(dr["BEFOREPROCESSDATE"]);
TimeSpan timeSpan = OverTime - DateTime.Now;
if (TypeConverter.ToInt(timeSpan.TotalHours) == 0)//小于一小时范围内
{
if (timeSpan.Minutes > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(timeSpan.Minutes) + "M";
}
else if (timeSpan.Minutes == 0)
{
msgList.TEMPFIELD = "+0M";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(timeSpan.Minutes) + "M";
}
}
else
{
if (timeSpan.TotalHours > 0)
{
msgList.TEMPFIELD = "+" + TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
else if (timeSpan.TotalHours == 0)
{
msgList.TEMPFIELD = "+0H";
}
else
{
msgList.TEMPFIELD = TypeConverter.ToString(TypeConverter.ToInt(timeSpan.TotalHours)) + "H";
}
}
DataList.Add(msgList);
}
}
}
catch (Exception ex)
{
Tracer.Debug("MsgListByPaging()待办任务分页列表"+ ex.ToString());
return null;
}
finally
{
}
//Tracer.Debug("平台待办分页接口 数量＝" + DataList.Count);
return DataList;
}