using Ninject; using System; using System.Collections.Generic; using System.Linq; using System.Web.Mvc; using System.Web.UI.WebControls; using WX.CRM.BLL.QH; using WX.CRM.Common; using WX.CRM.IBLL.Base; using WX.CRM.IBLL.QH; using WX.CRM.IBLL.SYQ; using WX.CRM.IBLL.Wx; using WX.CRM.Model.Entity; using WX.CRM.Model.Enum; using WX.CRM.WebHelper; namespace WX.CRM.WEB.Handler { public class ControlResource { private WX.CRM.IBLL.Base.IBAS_COMPANY_Q qy; private WX.CRM.IBLL.Base.IBAS_PARAMETERGROUP_Q pr; private WX.CRM.IBLL.Base.IBAS_COMTYPE_Q ct; private WX.CRM.IBLL.Base.IBAS_INNERUSER_Q iu; private WX.CRM.IBLL.Sms.ISMS_MSGTYPE_Q mstype; private WX.CRM.IBLL.Sms.ISMS_MSGSUBTYPE_Q mstsubtype; private WX.CRM.IBLL.Csvr.ICSVR_RECORDTYPE_Q recordType; private WX.CRM.IBLL.Quality.IQC_COMPLAINTDICT_Q qc_Q; IBAS_BUSINESSTYPE_Q businessBtypeQ; private WX.CRM.IBLL.Wx.IWX_BALANCE _balance; private WX.CRM.IBLL.QH.IQH_BALANCE _qhBalance; private WX.CRM.IBLL.QH.IQH_MONTHLYSTATEMENT_Q monthly; public ControlResource() { qy = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); pr = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); ct = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); iu = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); mstype = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); mstsubtype = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); monthly = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); recordType = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); qc_Q = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); businessBtypeQ = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); _balance = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); _qhBalance = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); } /// /// 判断试用期 /// public static void JudgeSYQ() { WX.CRM.IBLL.SYQ.ISYQManager _syq = WebHelper.Infrastructure.NinjectControllerFactory.ninjectKernel.Get(); _syq.SYQErro(); } #region 获取公司数据 /// /// 获取公司下拉列表数据源(包括了顶端无) /// type==0:不包括外部公司 /// type==1:默认为1 包括了外部公司 /// /// public List GetBas_companyList(int type = 1) { List companyList = qy.GetList(); if (type == 0) companyList = companyList.Where(m => m.ISOUTERAGENT == 0).ToList(); List list = new List(); list.Add(new SelectListItem() { Text = "--请选择--", Value = "0" }); foreach (WX.CRM.Model.Entity.BAS_COMPANY m in companyList) { list.Add(new SelectListItem() { Text = m.COMPANYNAME, Value = m.COMPANYID.ToString() }); } return list; } /// /// 获取公司下拉列表数据源(不包含无) /// type==0:不包括外部公司 /// type==1:默认为1 包括了外部公司 /// /// public List GetBas_companyNeatList(int type = 1) { List companyList = qy.GetList(); if (type == 0) companyList = companyList.Where(m => m.ISOUTERAGENT == 0).ToList(); List list = new List(); foreach (WX.CRM.Model.Entity.BAS_COMPANY m in companyList) { list.Add(new SelectListItem() { Text = m.COMPANYNAME, Value = m.COMPANYID.ToString() }); } return list; } #endregion #region 获取参数分组配置 /// /// 获取参数分组配置下拉列表数据源(包括了顶端无) /// /// public List GetBas_parameterGroupList() { List parameterGroupList = pr.GetList(); List list = new List(); list.Add(new SelectListItem() { Text = "--请选择--", Value = "0" }); foreach (WX.CRM.Model.Entity.BAS_PARAMETERGROUP m in parameterGroupList) { list.Add(new SelectListItem() { Text = m.GROUPNAME, Value = m.GROUPID.ToString() }); } return list; } #endregion #region 获取通用大类配置 /// /// 获取通用大类下拉列表数据源(包括了顶端无) /// /// public List GetBas_comTypeList() { List comTypeList = ct.GetList(); List list = new List(); list.Add(new SelectListItem() { Text = "--请选择--", Value = "0" }); foreach (WX.CRM.Model.Entity.BAS_COMTYPE m in comTypeList) { list.Add(new SelectListItem() { Text = m.TYPENAME, Value = m.TYPECODE.ToString() }); } return list; } #endregion #region 获取收藏标签类型 /// /// 获取收藏标签类型下拉列表数据源(包括了顶端无) /// /// i =0 则是查询页面使用,1则是操作页面使用 /// public List GetBas_subcomTypeList(int i) { var comTypeList = DataCacheHelper.GetCache().GetList_SubComType(WX.CRM.Model.Enum.ComType.FavoritesCustType).OrderByDescending(c => c.CTIME); var list = new List(); if (i == 0) { list.Add(new SelectListItem() { Text = "--全部--", Value = "0" }); } foreach (var m in comTypeList) { list.Add(new SelectListItem() { Text = m.SUBTYPENAME, Value = m.SUBTYPECODE.ToString() }); } return list; } #endregion #region 获取工单样式列表 /// /// 获取工单样式列表 /// /// public List GetOrd_MemoStyleList() { List memoTypeList = DataCacheHelper.GetCache().GetList_MemoStyle(); List list = new List(); foreach (var item in memoTypeList) { list.Add(new SelectListItem() { Text = item.STYLENAME, Value = item.STYLEID.ToString().Trim() }); } return list; } #endregion #region 获取开户状态列表 public List GetSchedualStatus(int i) { List parameterList = DataCacheHelper.GetCache().GetList_Parameter(ParameterGroup.FXH_ScheduleStatus); List list = new List(); if (i == 0) { list.Add(new SelectListItem() { Text = "--全部--", Value = "0" }); } foreach (var item in parameterList) { list.Add(new SelectListItem() { Text = item.map_PARANAME, Value = item.map_PARAVALUE }); } return list; } #endregion #region 获取开户状态列表 public List GetGjs_SchedualStatus(int i) { List parameterList = DataCacheHelper.GetCache().GetList_Parameter(ParameterGroup.GJS_ScheduleStatus); List list = new List(); if (i == 0) { list.Add(new SelectListItem() { Text = "--全部--", Value = "0" }); } foreach (var item in parameterList) { list.Add(new SelectListItem() { Text = item.map_PARANAME, Value = item.map_PARAVALUE }); } return list; } #endregion #region 获取软件客户状态列表 public List GetSoft_CustomerStatus(int i) { List list = new List(); if (i == 0) list.Add(new SelectListItem() { Text = "--全部--", Value = "0" }); foreach (var item in OperationUtil.GetItemFromEnum()) { list.Add(item); } return list; } #endregion #region 获取资金状态列表 public List GetGjs_AmtStatus(int i) { List parameterList = DataCacheHelper.GetCache().GetList_Parameter(ParameterGroup.GJS_AmtStatus); List list = new List(); if (i == 0) { list.Add(new SelectListItem() { Text = "--全部--", Value = "0" }); } foreach (var item in parameterList) { list.Add(new SelectListItem() { Text = item.map_PARANAME, Value = item.map_PARAVALUE }); } return list; } #endregion #region 获取时间类型列表 public List GetGjs_TimeType(int i, int selectedValue = 1) { List parameterList = DataCacheHelper.GetCache().GetList_Parameter(ParameterGroup.GJS_TimeType); List list = new List(); if (i == 0) { list.Add(new SelectListItem() { Text = "--全部--", Value = "-1" }); } foreach (var item in parameterList) { if (item.map_PARAVALUE == selectedValue.ToString()) list.Add(new SelectListItem() { Text = item.map_PARANAME, Value = item.map_PARAVALUE, Selected = true }); else list.Add(new SelectListItem() { Text = item.map_PARANAME, Value = item.map_PARAVALUE }); } return list; } #endregion #region 获取工单大类类型 /// /// 获取工单大类类型 /// /// type=1默认有"全部选项" 0没有全部 /// public List GetOrd_EnumMemoType(int type = 1) { List list = new List(); if (type == 1) list.Add(new SelectListItem() { Text = "全部", Value = "-1" }); foreach (var item in OperationUtil.GetItemFromEnum()) { list.Add(item); } return list; } #endregion #region 获取工单类型 /// /// 获取工单大类类型 /// /// type=1默认有"全部选项" 0没有全部 /// public ListOptGroup GetOrd_MemoType(int type = 1) { List memoTypeList = DataCacheHelper.GetCache().GetList_MemoType(); ListOptGroup groupList = new ListOptGroup(); groupList.selectListItem = new List(); groupList.groupList = new List(); if (type == 1) groupList.selectListItem.Add(new SelectListItem() { Text = "全部", Value = "-1" }); OptGroup group = null; IList typeList = OperationUtil.GetItemFromEnum(); foreach (SelectListItem item in typeList) { group = new OptGroup() { lable = item.Text, labValue = item.Value }; group.selectListItem = new List(); decimal memo_type = Convert.ToDecimal(item.Value); foreach (WX.CRM.Model.Entity.ORD_MEMOTYPE ordtype in memoTypeList.Where(m => m.MEMO_TYPE == memo_type)) { group.selectListItem.Add(new SelectListItem() { Text = ordtype.TYPENAME, Value = ordtype.TYPEID.ToString() }); } groupList.groupList.Add(group); } return groupList; } #endregion #region 获取短信类型 /// /// 获取短信类型 /// /// type=1默认有"全部选项" 0没有全部 /// public ListOptGroup GetOrd_MsgSubType(int type = 1) { List TypeList = mstype.GetList(); List SubList = mstsubtype.GetList(); ListOptGroup groupList = new ListOptGroup(); groupList.selectListItem = new List(); groupList.groupList = new List(); if (type == 1) groupList.selectListItem.Add(new SelectListItem() { Text = "全部", Value = "-1" }); OptGroup group = null; foreach (WX.CRM.Model.Entity.SMS_MSGTYPE item in TypeList) { group = new OptGroup() { lable = item.TYPENAME, labValue = item.TYPECODE }; group.selectListItem = new List(); foreach (WX.CRM.Model.Entity.SMS_MSGSUBTYPE ordtype in SubList.Where(m => m.TYPECODE == item.TYPECODE)) { group.selectListItem.Add(new SelectListItem() { Text = ordtype.SUBTYPENAME, Value = ordtype.SUBTYPEID.ToString() }); } groupList.groupList.Add(group); } return groupList; } #endregion #region 获取产品列表 下拉数据源 /// /// 获取产品列表 下拉数据源 /// /// type=1有全部选项 /// //public List GetGjs_Proudct(int type = 1) //{ // List productList = DataCacheHelper.GetCache().GetList_Gjs_Product(); // List list = (from a in productList // select new SelectListItem() // { // Text = a.PRODUCTNAME, // Value = a.PRODUCTCODE // }).ToList(); // if (type == 1) // { // List temp = new List(); // temp.Add(new SelectListItem() { Text = "全部", Value = "" }); // temp.AddRange(list); // list = temp; // } // return list; //} #endregion #region 获取exlce类型 public List GetExcelTypeList(int type = 1) { List typeList = DataCacheHelper.GetCache().GetList_ExcelImportType(); List drpList = new List(); if (type == 1) drpList.Add(new SelectListItem() { Value = "", Text = "--全部--" }); foreach (var model in typeList) { drpList.Add(new SelectListItem() { Text = model.TYPENAME, Value = model.TYPECODE }); } return drpList; } #endregion #region 获取组长类型 下拉数据源 public IList GetGroupLeaderType() { return OperationUtil.GetItemFromEnum(); } #endregion /// /// 显示全部列 /// /// 类型 1:显示顶端的“--请选择--” 0:不显示 /// public List GetTutoruserList(int type = 1) { List list = iu.GetListByUserExt(-1, -1, 1); List drpList = new List(); if (type == 1) drpList.Add(new SelectListItem() { Value = "0", Text = "--请选择--" }); foreach (var model in list) { drpList.Add(new SelectListItem() { Text = model.UNAME, Value = model.PKID.ToString() }); } return drpList; } #region 客户分类 //public List GetCustomerCategoryType(int type = 1) //{ // List customerType = DataCacheHelper.GetCache().GetList_CustomerCategroryType().Where(m => m.CATEGORYGROUP == 0).ToList(); // List checkList = new List(); // foreach (var model in customerType) // { // checkList.Add(new ListItem() { Text = model.CATEGORYNAME, Value = model.CATEGORYNAME }); // } // if (type == 1) // checkList.Add(new ListItem() { Text = "未分类", Value = "-1" }); // return checkList; //} #endregion #region 客户分类 //public List GetGjs_CustomerCategoryType(int type = 1) //{ // List customerType = DataCacheHelper.GetCache().GetList_Gjs_CustomerCategroryType().Where(m => m.CATEGORYGROUP == 0).OrderBy(m=>m.CATEGORYLEVEL).ToList(); // List checkList = new List(); // foreach (var model in customerType) // { // checkList.Add(new SelectListItem() { Text = model.CATEGORYNAME, Value = model.CATEGORYID.ToString(), Selected = true }); // } // if (type == 1) // checkList.Add(new SelectListItem() { Text = "未分类", Value = "-1",Selected=true }); // return checkList; //} //public List GetGjs_CustomerCategoryTypeByManual() //{ // List customerType = DataCacheHelper.GetCache().GetList_Gjs_CustomerCategroryType().Where(m => m.CATEGORYGROUP == 0&&m.OPTYPE==0).OrderBy(m => m.CATEGORYLEVEL).ToList(); // List checkList = new List(); // foreach (var model in customerType) // { // checkList.Add(new SelectListItem() { Text = model.CATEGORYNAME, Value = model.CATEGORYID.ToString(), Selected = true }); // } // return checkList; //} #endregion #region 所有月结年月 public List GetAllOpMonthAndYearList() { var monthList = _balance.GetList().OrderByDescending(p => p.MONTH).Select(p => p.MONTH).Distinct(); List list = new List(); foreach (var item in monthList) { var result = item.Year.ToString() + "-" + item.Month.ToString(); list.Add(new SelectListItem { Text = result.ToString(), Value = result.ToString() }); } return list; } public List GetAllQHMonthAndYearList() { var monthList = _qhBalance.GetList().OrderByDescending(p => p.MONTH).Select(p => p.MONTH).Distinct(); List list = new List(); foreach (var item in monthList) { var result = item.Year.ToString() + "-" + item.Month.ToString(); list.Add(new SelectListItem { Text = result.ToString(), Value = result.ToString() }); } return list; } public List GetMonthByUserPerformanct() { List monthList = monthly.GetMonthByUserPerformanct(); List list = new List(); foreach (var result in monthList) { list.Add(new SelectListItem { Text = result, Value = result }); } return list; } public List GetAllOpMonthByBackOrg() { BAS_MON_INNERUSER_BL bl = new BAS_MON_INNERUSER_BL(); List monthList = bl.GetBackupMont(); List list = new List(); foreach (DateTime result in monthList) { list.Add(new SelectListItem { Text = result.ToString("yyyy-MM-dd"), Value = result.ToString("yyyy-MM-dd") }); } return list; } #endregion #region 录音分类 public List GetRecordTypeList(int type = 1) { List list = DataCacheHelper.GetCache().GetList_RecordType(); List drpList = new List(); if (type == 1) drpList.Add(new SelectListItem() { Value = "0", Text = "全部", Selected = true }); foreach (var model in list) { drpList.Add(new SelectListItem() { Text = model.NAME, Value = model.ID.ToString() }); } return drpList; } #endregion #region 投诉客户来源分类 //1为查询所有 public List GetComplainCustomerFromTypeList(int i = 1) { List comTypeList = DataCacheHelper.GetCache().GetList_SubComType(WX.CRM.Model.Enum.ComType.ComplainFromType); List list = new List(); if (i == 1) { list.Add(new SelectListItem() { Text = "--全部--", Value = "" }); } foreach (WX.CRM.Model.Entity.BAS_SUBCOMTYPE m in comTypeList) { list.Add(new SelectListItem() { Text = m.SUBTYPENAME, Value = m.SUBTYPECODE.ToString() }); } return list; } #endregion #region 投诉客户等级分类 //1为查询所有 public List GetComplainCustomerLevelList(int i = 1) { //List comTypeList = DataCacheHelper.GetCache().GetList_SubComType(Model.Enum.ComType.ComplainCustomerLevel); //List list = new List(); //if (i == 1) //{ // list.Add(new SelectListItem() { Text = "--全部--", Value = "" }); //} //foreach (WX.CRM.Model.Entity.BAS_SUBCOMTYPE m in comTypeList) //{ // list.Add(new SelectListItem() { Text = m.SUBTYPENAME, Value = m.SUBTYPECODE.ToString() }); //} //return list; List levelList = qc_Q.GetList_ComplaintDict().OrderBy(m => m.ORD).ToList(); List list = new List(); if (i == 1) { List ItemList = new List() { new SelectListItem(){ Text ="所有", Value="" }, // new SelectListItem(){ // Text ="不等于无", // Value="0" //}, // new SelectListItem(){ // Text ="所有普通", // Value="PT" //}, // new SelectListItem(){ // Text ="所有严重", // Value="YZ" //} }; list.AddRange(ItemList); } foreach (WX.CRM.Model.Entity.QC_COMPLAINTDICT m in levelList) { list.Add(new SelectListItem() { Text = m.DICTDESC, Value = m.DICTVALUE.ToString() }); } return list; } #endregion #region 业务类型 public List BusinessTypeList() { var blist = businessBtypeQ.GetList(); List lis = new List(); lis.Clear(); lis.Add(new SelectListItem() { Value = "", Text = "-选择-" }); foreach (var o in blist) { SelectListItem item = new SelectListItem() { Value = o.BUSINESSCODE, Text = o.BUSINESSNAME }; lis.Add(item); } return lis; } #endregion } }