/// <summary> /// 获取基本信息(组织信息,个人客户信息,单位客户信息等等) /// </summary> /// <typeparam name="D">结果Model类型</typeparam> /// <param name="paramTBModel">查询条件TBModel,基本信息对应的TBModel(其类型即系统缓存的Key)</param> /// <param name="paramIsGetInfoFromDBDirectly">是否直接从数据库中获取信息 /// <para>paramIsGetInfoFromDBDirectly=true,直接从数据库中取数据。</para> /// <para>paramIsGetInfoFromDBDirectly=false,先从缓存取数据,未取到的场合,再从数据库中取数据。</para> /// </param> /// <returns>结果ModelList</returns> public static List <D> GetBaseInfor <D>(object paramTBModel, bool paramIsGetInfoFromDBDirectly) { LogHelper.WriteBussLogStart(Trans.COM, LoginInfoDAX.UserName, MethodBase.GetCurrentMethod().ToString(), string.Empty, string.Empty, null); //结果List List <D> resultList = new List <D>(); //非直接从数据库中获取信息 if (!paramIsGetInfoFromDBDirectly) { //根据TBModel类型从缓存获取信息 object obj = CacheDAX.GetItself(paramTBModel.GetType().FullName); if (obj != null) { resultList = obj as List <D>; return(resultList); } } //检查参数是否为TBModel if (paramTBModel != null && !paramTBModel.GetType().FullName.Contains(SysConst.EN_TBMODEL)) { LogHelper.WriteBussLogEndNG(Trans.COM, LoginInfoDAX.UserName, MethodBase.GetCurrentMethod().ToString(), string.Empty, string.Empty, null); return(resultList); } //根据TBModel对象,查询信息 if (paramTBModel != null) { baseDAX.QueryForList <D>(paramTBModel, resultList); //将结果信息添加到缓存,已经存在则覆盖原来的信息 CacheDAX.Add(paramTBModel.GetType().FullName, resultList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, MethodBase.GetCurrentMethod().ToString(), string.Empty, string.Empty, null); return(resultList); }
/// <summary> /// 初始化客户 /// </summary> public static void InitCustomer() { var funcName = "InitCustomer"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的客户 List <CustomerQueryUIModel> resultCustomerList = new List <CustomerQueryUIModel>(); _baseDax.QueryForList(SQLID.COMM_SQL11, new CustomerQueryQCModel { //组织ID WHERE_OrgID = LoginInfoDAX.UserID == SysConst.SUPER_ADMIN ? null : LoginInfoDAX.OrgID, }, resultCustomerList); if (resultCustomerList.Count > 0) { List <MDLSM_Organization> allVenusOrgList = new List <MDLSM_Organization>(); List <string> autoFactoryCodeList = resultCustomerList.Where(x => x.CustomerType == CustomerTypeEnum.Name.PTNQXSH && !string.IsNullOrEmpty(x.AutoFactoryCode)).Select(x => x.AutoFactoryCode).Distinct().ToList(); foreach (var loopAutoFactoryCode in autoFactoryCodeList) { //根据指定的汽修商户数据库信息获取Venus组织列表 List <MDLSM_Organization> tempVenusOrgList = new List <MDLSM_Organization>(); BLLCom.QueryAutoFactoryCustomerOrgList(loopAutoFactoryCode, tempVenusOrgList); allVenusOrgList.AddRange(tempVenusOrgList); } foreach (var loopCustomer in resultCustomerList) { if (loopCustomer.CustomerType != CustomerTypeEnum.Name.PTNQXSH) { continue; } foreach (var loopVenusOrg in allVenusOrgList) { if (loopCustomer.AutoFactoryOrgCode == loopVenusOrg.Org_Code && !string.IsNullOrEmpty(loopVenusOrg.Org_ShortName) && !string.IsNullOrEmpty(loopVenusOrg.Org_ID)) { loopCustomer.AutoFactoryOrgInfo = loopCustomer.CustomerID + SysConst.Semicolon_DBC + loopVenusOrg.Org_ID + SysConst.Semicolon_DBC + loopCustomer.AutoFactoryOrgCode; } } } //将客户保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.Customer, resultCustomerList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }
/// <summary> /// 初始化车辆品牌、车系、车型描述 /// </summary> public static void InitVehicleBrand() { var funcName = "InitVehicleBrand"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的车辆品牌车系 List <MDLBS_VehicleBrandInspireSumma> resultVehicleBrandAndInspireList = new List <MDLBS_VehicleBrandInspireSumma>(); _baseDax.QueryForList(new MDLBS_VehicleBrandInspireSumma() { WHERE_VBIS_IsValid = true, }, resultVehicleBrandAndInspireList); //品牌 List <MDLBS_VehicleBrandInspireSumma> resultVehicleBrandList = new List <MDLBS_VehicleBrandInspireSumma>(); _baseDax.CopyModelList(resultVehicleBrandAndInspireList, resultVehicleBrandList); //车系 List <MDLBS_VehicleBrandInspireSumma> resultVehicleInspireList = new List <MDLBS_VehicleBrandInspireSumma>(); _baseDax.CopyModelList(resultVehicleBrandAndInspireList, resultVehicleInspireList); //车型描述 List <MDLBS_VehicleBrandInspireSumma> resultVehicleModelDescList = new List <MDLBS_VehicleBrandInspireSumma>(); _baseDax.CopyModelList(resultVehicleBrandAndInspireList, resultVehicleModelDescList); if (resultVehicleBrandList.Count > 0) { resultVehicleBrandList = resultVehicleBrandList.GroupBy(p => new { p.VBIS_Brand, p.VBIS_BrandSpellCode }) .Select(g => g.First()).OrderBy(x => x.VBIS_Brand).ToList(); //将车辆品牌保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.VehicleBrand, resultVehicleBrandList, true); } if (resultVehicleInspireList.Count > 0) { resultVehicleInspireList = resultVehicleInspireList.GroupBy(p => new { p.VBIS_Brand, p.VBIS_Inspire, p.VBIS_InspireSpellCode }) .Select(g => g.First()).OrderBy(x => x.VBIS_Brand).ThenBy(x => x.VBIS_Inspire).ToList(); //将车辆车系保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.VehicleBrandInspire, resultVehicleInspireList, true); } if (resultVehicleModelDescList.Count > 0) { resultVehicleModelDescList = resultVehicleModelDescList.GroupBy(p => new { p.VBIS_Brand, p.VBIS_Inspire, p.VBIS_ModelDesc }) .Select(g => g.First()).OrderBy(x => x.VBIS_Brand).ThenBy(x => x.VBIS_Inspire).ThenBy(x => x.VBIS_ModelDesc).ToList(); //将车型描述保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.VehicleModelDesc, resultVehicleModelDescList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }
public void InitSystemConfigData() { //初始化系统枚举 EnumDAX.InitializeEnum(); //初始化CodeTable CodeTableHelp.InitializeCode(); //初始化系统缓存 //CacheDAX.InitSystemParameter(); //初始化用户习惯 //CacheDAX.InitUserPractice(LoginInfoDAX.UserID); //初始化车辆的品牌车系信息 //CacheDAX.InitVehicleBrandInspireList(); CacheDAX.InitializeCache(); //初始化系统消息 SystemDAX.InitializeSystemMessage(); //初始化汽修商户到缓存 BLLCom.InitializeARMerchantToCache(); //初始化汽修商户数据库配置信息 BLLCom.InitializeARMerchantDBConfigInfo(); //初始化系统用户 CacheDAX.InitSystemUser(); //初始化配件名称 CacheDAX.InitAutoPartsName(); //初始化配件类别 CacheDAX.InitAutoPartsType(); //初始化供应商 CacheDAX.InitAutoPartsSupplier(); //初始化仓库 CacheDAX.InitWarehouse(); //初始化仓位 CacheDAX.InitWarehouseBin(); //初始化车辆品牌 CacheDAX.InitVehicleBrand(); //初始化车辆车系 CacheDAX.InitVehicleInspire(); //初始化客户 CacheDAX.InitCustomer(); //初始化系统数据表和字段信息 //SystemDAX.InitializeSystemTableAndColumnInfo(); }
/// <summary> /// 初始化仓位 /// </summary> public static void InitWarehouseBin() { var funcName = "InitWarehouseBin"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的仓位 List <MDLPIS_WarehouseBin> resultWarehouseBinList = new List <MDLPIS_WarehouseBin>(); _baseDax.QueryForList(new MDLPIS_WarehouseBin() { WHERE_WHB_IsValid = true, }, resultWarehouseBinList); if (resultWarehouseBinList.Count > 0) { resultWarehouseBinList = resultWarehouseBinList.OrderBy(x => x.WHB_Name).ToList(); //将仓位保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.WarehouseBin, resultWarehouseBinList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }
/// <summary> /// 初始化配件供应商 /// </summary> public static void InitAutoPartsSupplier() { var funcName = "InitAutoPartsSupplier"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的供应商 List <MDLPIS_Supplier> resultSupplierList = new List <MDLPIS_Supplier>(); _baseDax.QueryForList(new MDLPIS_Supplier() { WHERE_SUPP_IsValid = true, }, resultSupplierList); if (resultSupplierList.Count > 0) { resultSupplierList = resultSupplierList.OrderBy(x => x.SUPP_Name).ToList(); //将供应商保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.AutoPartsSupplier, resultSupplierList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }
/// <summary> /// 初始化配件类别 /// </summary> public static void InitAutoPartsType() { var funcName = "InitAutoPartsType"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的配件类别 List <MDLBS_AutoPartsType> resultAutoPartsTypeList = new List <MDLBS_AutoPartsType>(); _baseDax.QueryForList(new MDLBS_AutoPartsType() { WHERE_APT_IsValid = true, }, resultAutoPartsTypeList); if (resultAutoPartsTypeList.Count > 0) { resultAutoPartsTypeList = resultAutoPartsTypeList.OrderBy(x => x.APT_Name).ToList(); //将配件类别保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.AutoPartsType, resultAutoPartsTypeList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }
/// <summary> /// 初始化系统用户 /// </summary> public static void InitSystemUser() { var funcName = "InitSystemUser"; LogHelper.WriteBussLogStart(BussID, LoginInfoDAX.UserName, funcName, "", "", null); //查询所有有效的系统用户 List <MDLSM_User> resultUserList = new List <MDLSM_User>(); _baseDax.QueryForList(new MDLSM_User() { WHERE_User_IsValid = true, }, resultUserList); if (resultUserList.Count > 0) { resultUserList = resultUserList.OrderBy(x => x.User_Name).ThenBy(x => x.User_EMPNO).ToList(); //将系统用户保存到缓存 CacheDAX.Add(CacheDAX.ConfigDataKey.SystemUser, resultUserList, true); } LogHelper.WriteBussLogEndOK(Trans.COM, LoginInfoDAX.UserName, funcName, "", "", null); }