/// <summary>
/// 获取等审核信息
/// </summary>
/// <param name="userId">用户主键</param>
/// <param name="categoryCode">分类代码</param>
/// <param name="categorybillFullName"></param>
/// <param name="searchValue">查询字符串</param>
/// <param name="containsTheRejectedDocuments">显示退回的</param>
/// <returns>数据表</returns>
public DataTable GetWaitForAudit(string userId = null, string categoryCode = null, string categorybillFullName = null, string searchValue = null, bool containsTheRejectedDocuments = true)
{
if (string.IsNullOrEmpty(userId))
{
userId = this.UserInfo.Id;
}
string sqlQuery = "SELECT * "
+ " FROM " + BaseWorkFlowCurrentEntity.TableName
// 未被删除的，有效的数据，还没能审核结束的
+ " WHERE (" + BaseWorkFlowCurrentEntity.FieldDeletionStateCode + " = 0) "
// Enabled 0 表示，审核还没结束
// Enabled 1 表示，审核已经完成了
+ " AND (" + BaseWorkFlowCurrentEntity.FieldEnabled + " = 0) ";
if (!containsTheRejectedDocuments)
{
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldAuditStatus + " != 'AuditReject') ";
}
if (!string.IsNullOrEmpty(userId))
{
// 待审核的工作流（指向用户的）
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldToUserId + "='" + userId + "' ";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToUserId + " LIKE '%" + userId + "%'";
//（指向角色的）
BaseUserManager userManager = new BaseUserManager(this.UserInfo);
string[] roleIds = userManager.GetRoleIds(userId);
if (roleIds != null && roleIds.Length > 0)
{
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToRoleId + " IN (" + StringUtil.ArrayToList(roleIds) + ")";
}
//（指向部门的）
string[] organizeIds = userManager.GetAllOrganizeIds(userId);
if (organizeIds != null && organizeIds.Length > 0)
{
sqlQuery += " OR (" + BaseWorkFlowCurrentEntity.FieldToUserId + " IS NULL AND " + BaseWorkFlowCurrentEntity.FieldToDepartmentId + " IN (" + StringUtil.ArrayToList(organizeIds) + "))";
}
sqlQuery += " ) ";
}
if (!string.IsNullOrEmpty(categoryCode))
{
sqlQuery += " AND ProcessId IN (SELECT Id FROM BaseWorkFlowProcess WHERE (CategoryCode = '" + categoryCode + "')) ";
// BaseWorkFlowBillTemplateManager templateManager = new BaseWorkFlowBillTemplateManager(this.DbHelper, this.UserInfo);
// var result = templateManager.Search(string.Empty, categoryCode, string.Empty, null, false);
// string categoryCodes = BaseBusinessLogic.FieldToList(result, BaseWorkFlowBillTemplateEntity.FieldCode);
// if (!string.IsNullOrEmpty(categoryCodes))
// {
// sqlQuery += " AND (BaseWorkFlowCurrent.CategoryCode IN (" + categoryCodes + ")) ";
// }
}
if (!string.IsNullOrEmpty(categorybillFullName))
{
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.TableName + "." + BaseWorkFlowCurrentEntity.FieldCategoryFullName + " ='" + categorybillFullName + "') ";
}
List <IDbDataParameter> dbParameters = new List <IDbDataParameter>();
if (!String.IsNullOrEmpty(searchValue))
{
searchValue = searchValue.Trim();
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldObjectFullName + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldObjectFullName);
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditUserRealName + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldAuditUserRealName);
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditIdea + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldAuditIdea);
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditStatusName + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldAuditStatusName);
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToDepartmentName + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldToDepartmentName);
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToUserRealName + " LIKE " + DbHelper.GetParameter(BaseWorkFlowCurrentEntity.FieldToUserRealName) + ")";
if (searchValue.IndexOf("%") < 0)
{
searchValue = "%" + searchValue + "%";
}
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldObjectFullName, searchValue));
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldAuditUserRealName, searchValue));
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldAuditIdea, searchValue));
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldAuditStatusName, searchValue));
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldToDepartmentName, searchValue));
dbParameters.Add(DbHelper.MakeParameter(BaseWorkFlowCurrentEntity.FieldToUserRealName, searchValue));
}
// 排序字段
sqlQuery += " ORDER BY " + BaseWorkFlowCurrentEntity.FieldSendDate;
return(DbHelper.Fill(sqlQuery, dbParameters.ToArray()));
}
/// <summary>
/// 获取等审核信息
/// </summary>
/// <param name="userId">用户主键</param>
/// <param name="categoryCode">分类代码</param>
/// <param name="categorybillFullName"></param>
/// <param name="searchValue">查询字符串</param>
/// <param name="containsTheRejectedDocuments">显示退回的</param>
/// <returns>数据表</returns>
public DataTable GetWaitForAuditByPage(out int recordCount, int pageIndex = 0, int pageSize = 100, string sort = null, string direction = "ASC", string userId = null, string categoryCode = null, string categorybillFullName = null, string searchValue = null, bool containsTheRejectedDocuments = true)
{
if (string.IsNullOrEmpty(userId))
{
userId = this.UserInfo.Id;
}
string sqlQuery = "SELECT * "
+ " FROM " + BaseWorkFlowCurrentEntity.TableName
// 未被删除的，有效的数据，还没能审核结束的
+ " WHERE (" + BaseWorkFlowCurrentEntity.FieldDeletionStateCode + " = 0) "
// Enabled 0 表示，审核还没结束
// Enabled 1 表示，审核已经完成了
+ " AND (" + BaseWorkFlowCurrentEntity.FieldEnabled + " = 0) ";
if (!containsTheRejectedDocuments)
{
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldAuditStatus + " != 'AuditReject') ";
}
if (!string.IsNullOrEmpty(userId))
{
// 待审核的工作流（指向用户的）
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldToUserId + "='" + userId + "' ";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToUserId + " LIKE '%" + userId + "%'";
//（指向角色的）
BaseUserManager userManager = new BaseUserManager(this.UserInfo);
string[] roleIds = userManager.GetRoleIds(userId);
if (roleIds != null && roleIds.Length > 0)
{
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToRoleId + " IN (" + StringUtil.ArrayToList(roleIds) + ")";
}
//（指向部门的）
string[] organizeIds = userManager.GetAllOrganizeIds(userId);
if (organizeIds != null && organizeIds.Length > 0)
{
sqlQuery += " OR (" + BaseWorkFlowCurrentEntity.FieldToUserId + " IS NULL AND " + BaseWorkFlowCurrentEntity.FieldToDepartmentId + " IN (" + StringUtil.ArrayToList(organizeIds) + "))";
}
sqlQuery += " ) ";
}
if (!string.IsNullOrEmpty(categoryCode))
{
sqlQuery += " AND ProcessId IN (SELECT Id FROM BaseWorkFlowProcess WHERE (CategoryCode = '" + categoryCode + "')) ";
}
if (!string.IsNullOrEmpty(categorybillFullName))
{
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.TableName + "." + BaseWorkFlowCurrentEntity.FieldCategoryFullName + " ='" + categorybillFullName + "') ";
}
List <IDbDataParameter> dbParameters = new List <IDbDataParameter>();
if (!String.IsNullOrEmpty(searchValue))
{
if (searchValue.IndexOf("%") < 0)
{
searchValue = "%" + searchValue + "%";
}
sqlQuery += " AND (" + BaseWorkFlowCurrentEntity.FieldObjectFullName + " LIKE '" + searchValue + "'";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditUserRealName + " LIKE '" + searchValue + "'";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditIdea + " LIKE '" + searchValue + "'";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldAuditStatusName + " LIKE '" + searchValue + "'";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToDepartmentName + " LIKE '" + searchValue + "'";
sqlQuery += " OR " + BaseWorkFlowCurrentEntity.FieldToUserRealName + " LIKE '" + searchValue + "'" + ")";
}
sqlQuery = string.Format("({0})", sqlQuery);
var dt = DbLogic.GetDataTableByPage(this.dbHelper, out recordCount, sqlQuery, "*",
pageIndex, pageSize, null, null, "");
return(dt);
}
