/// <summary> /// 统计指定用户的某一类型的需求的数目 /// </summary> /// <param name="Type">统计类型</param> /// <param name="loginName">用户名</param> /// <returns></returns> public int GetCount(Tz888.BLL.Common.AuditStatus Type, string loginName, string RoleName) { string strWhere = ""; switch ((int)Type) { case 0: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); break; case 1: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); break; case 2: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); break; case 3: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE()"; break; default: break; } return(this.GetCount("", strWhere)); }
/// <summary> /// 统计指定用户的某一类型的需求的数目 /// </summary> /// <param name="Type">统计类型</param> /// <param name="loginName">用户名</param> /// <returns></returns> public int GetCount(Tz888.BLL.Common.AuditStatus Type, string loginName, string infoType) { string strWhere = ""; switch ((int)Type) { case 0: strWhere = "UserName = '******' And AuditStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); break; case 1: strWhere = "UserName = '******' And AuditStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); break; case 2: strWhere = "UserName = '******' And AuditStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); break; case 3: strWhere = "UserName = '******' "; break; default: break; } return(this.GetCount(infoType, strWhere)); }
/// <summary> /// 获取带数目和需求类型的提示信息 /// </summary> /// <param name="loginName">用户名称</param> /// <param name="model">信息模版[***{0}**{1}***],第一个参数为需求数目,第二个参数为需求类型名</param> /// <param name="Type">需求类型</param> /// <returns></returns> public string GetRemind(string model, Tz888.BLL.Common.AuditStatus type, string InfoType) { string remindInfo = ""; switch ((int)type) { case 0: remindInfo = "待审核"; break; case 1: remindInfo = "通过审核"; break; case 2: remindInfo = "未通过审核"; break; case 3: remindInfo = "已过期"; break; default: break; } int count = this.GetCount(type, InfoType); string request = string.Format(model, count.ToString(), remindInfo); return(request); }
protected int GetCount(Tz888.BLL.Common.AuditStatus Type) { //string loginName = CON_LoginName; string loginName = Page.User.Identity.Name; Tz888.BLL.Info.MainInfoBLL bll = new Tz888.BLL.Info.MainInfoBLL(); return(bll.GetCount(Type, loginName, "0")); }
/// <summary> /// 根据需求管理类型获取列表(拓富中心需求管理使用) /// </summary> /// <param name="strGetFields"></param> /// <param name="fldName"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="OrderType"></param> /// <param name="loginName"></param> /// <param name="RoleName"></param> /// <param name="type"></param> /// <returns></returns> public DataSet GetList(string strGetFields, string fldName, int PageSize, int PageIndex, int OrderType, string loginName, string RoleName, Tz888.BLL.Common.AuditStatus type) { string strWhere = ""; switch ((int)type) { case 0: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); break; case 1: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); break; case 2: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); break; case 3: strWhere = "LoginName = '" + loginName + "' And InfoOriginRoleName = '" + RoleName + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE()"; break; default: break; } return(dal.GetList(strGetFields, fldName, PageSize, PageIndex, OrderType, strWhere)); }
/// <summary> /// 获取查询条件 /// </summary> public static string GetCriteria(Tz888.BLL.Common.AuditStatus Type, string InfoType) { string strWhere = ""; switch ((int)Type) { case 0: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } break; case 1: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 2: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } break; case 3: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 5: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1"; } else { strWhere = "DelStatus <> 1"; } break; default: break; } return(strWhere); }
/// <summary> /// 统计信息的数目 /// </summary> /// <param name="Type">信息状态</param> /// <param name="InfoType">信息类型</param> /// <param name="strWhere">查询条件</param> /// <returns></returns> public int GetInfoCount(Tz888.BLL.Common.AuditStatus Type, Tz888.BLL.Common.InfoType InfoType, string Criteria) { string strInfoType = ""; switch ((int)InfoType) { case 0: strInfoType = "Merchant"; break; case 1: strInfoType = "Project"; break; case 2: strInfoType = "Capital"; break; default: break; } string strWhere = ""; switch ((int)Type) { case 0: if (!string.IsNullOrEmpty(strInfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } break; case 1: if (!string.IsNullOrEmpty(strInfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 2: if (!string.IsNullOrEmpty(strInfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } break; case 3: if (!string.IsNullOrEmpty(strInfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 5: if (!string.IsNullOrEmpty(strInfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1"; } else { strWhere = "DelStatus <> 1"; } break; default: break; } if (string.IsNullOrEmpty(strWhere)) { strWhere = Criteria; } else { strWhere += " AND " + Criteria; } return(this.GetCount(strInfoType, strWhere)); }
/// <summary> /// 根据需求管理类型获取列表(总站后台需求管理使用) /// </summary> /// <param name="strGetFields"></param> /// <param name="fldName"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="OrderType"></param> /// <param name="loginName"></param> /// <param name="RoleName"></param> /// <param name="type"></param> /// <returns></returns> public DataSet GetList(string strGetFields, string fldName, int PageSize, int PageIndex, int OrderType, Tz888.BLL.Common.AuditStatus type, string InfoType) { string strWhere = ""; switch ((int)type) { case 0: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Auditing).ToString(); } break; case 1: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) > GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 2: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } else { strWhere = "DelStatus <> 1 And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.NoPass).ToString(); } break; case 3: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } else { strWhere = "DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And AuditingStatus = " + ((int)Tz888.BLL.Common.AuditStatus.Pass).ToString(); } break; case 5: if (!string.IsNullOrEmpty(InfoType)) { strWhere = "InfoTypeID = '" + InfoType + "' And DelStatus <> 1"; } else { strWhere = "DelStatus <> 1"; } break; default: break; } return(dal.GetList(strGetFields, fldName, PageSize, PageIndex, OrderType, strWhere)); }