/// <summary> /// 创建待审核数量 查询sql /// </summary> /// <param name="user">当前登录用户</param> /// <param name="step">步骤</param> /// <returns></returns> private StringBuilder CreateShenCountSql(OperatorInfo user, InPutStepEnum step) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(" SELECT COUNT(1) TotalNum FROM order_ter_input WHERE 1=1"); if (step == InPutStepEnum.Validate) { sql.AppendFormat(" AND Step=1"); sql.AppendFormat(" AND ShenHeManId={0}", user.UserIdStr); } return(sql); }
/// <summary> /// 获取审核数量 /// </summary> /// <param name="user">当前登录用户</param> /// <param name="step">审核步骤</param> /// <returns></returns> public async Task <int> GetShenCount(OperatorInfo user, InPutStepEnum 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); }