/// <summary>
/// 获取审核数量
/// </summary>
/// <param name="user">当前登录用户</param>
/// <param name="step">审核步骤</param>
/// <returns></returns>
public async Task <int> GetShenCount(OperatorInfo user, OutPutStepEnum step)
{
/*
* var expression = ListFilter(param);
* var list= await this.BaseRepository().FindList(expression, pagination);
* return list.ToList();
*/
int count = 0;
StringBuilder sql = CreateShenCountSql(user, step);
object data = await this.BaseRepository().FindObject(sql.ToString());
if (data != null)
{
int.TryParse(data.ToString(), out count);
}
return(count);
}
/// <summary>
/// 创建待审核数量 查询sql
/// </summary>
/// <param name="user">当前登录用户</param>
/// <param name="step">步骤</param>
/// <returns></returns>
private StringBuilder CreateShenCountSql(OperatorInfo user, OutPutStepEnum step)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" SELECT COUNT(1) TotalNum FROM order_ter_issue WHERE 1=1");
if (step == OutPutStepEnum.Validate)
{
sql.AppendFormat(" AND Step=1");
sql.AppendFormat(" AND ShenHeManId={0}", user.UserIdStr);
}
else
{
sql.AppendFormat(" AND Step=2");
sql.AppendFormat(" AND SentManId={0}", user.UserIdStr);
}
return(sql);
}
