public async Task <WfprocessPageView> GetPageList(WfprocessParm parm)
{
return(await WithConnection(async c =>
{
StringBuilder sql = new StringBuilder();
sql.Append($@" SELECT
ID,
ProcessGUID,
ProcessName,
Version,
IsUsing,
AppType,
PageUrl,
XmlFileName,
XmlFilePath,
XmlContent,
StartType,
StartExpression,
EndType,
EndExpression,
Description,
CreatedDateTime,LastUpdatedDateTime FROM wfprocess
");
StringBuilder whereSql = new StringBuilder();
//whereSql.Append(" WHERE ai.ProcessInstanceID = '" + parm.ProcessInstanceID + "'");
//if (parm.AppName != null)
//{
// whereSql.Append(" and ai.AppName like '%" + parm.AppName.Trim() + "%'");
//}
sql.Append(whereSql);
//验证是否有参与到流程中
//string sqlcheck = sql.ToString();
//sqlcheck += ("AND ai.CreatedByUserID = '" + parm.UserID + "'");
//var checkdata = await c.QueryFirstOrDefaultAsync<TaskViewModel>(sqlcheck);
//if (checkdata == null)
//{
// return null;
//}
var data = await c.QueryAsync <Wfprocess>(sql.ToString());
var total = data.ToList().Count;
sql.Append(" order by " + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
var ets = await c.QueryAsync <Wfprocess>(sql.ToString());
WfprocessPageView ret = new WfprocessPageView();
ret.rows = ets.ToList();
ret.total = total;
return ret;
}));
}
public async Task <ApiResult> GetPageList(WfprocessParm parm)
{
ApiResult ret = new ApiResult();
try
{
//parm.UserID = _userID;
//parm.UserID = 40;
var data = await _repo.GetPageList(parm);
ret.code = Code.Success;
ret.data = data;
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
}
return(ret);
}
