/// <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);
}
