public VehicleArticleManager(string user)
{
Logger = LogManager.GetLogger(typeof(VehicleArticleManager));
dbScopeManagerConfiguration = new DBScopeManager(configurationConn);
dbScopeManagerConfigurationRead = new DBScopeManager(configurationReadConn);
_user = user;
}
public BaoYangConfigManager()
{
this.connectionManager =
new ConnectionManager(ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString);
this.dbScopeManagerBY = new DBScopeManager(this.connectionManager);
this.dbBaoYangScopeManager = new DBScopeManager(new ConnectionManager(ConfigurationManager.ConnectionStrings["BaoYang"].ConnectionString));
}
static CouponActivityConfigManagerV2()
{
Logger = Common.Logging.LogManager.GetLogger(typeof(CouponActivityConfigManagerV2));
dbScopeManagerConfig = new DBScopeManager(configConnString);
dbScopeManagerConfigRead = new DBScopeManager(configReadConnString);
dbScopeManagerConfiguration = new DBScopeManager(ConfigurationManager.ConnectionStrings["Configuration"].ConnectionString);
dbScopeManagerConfigurationRead = new DBScopeManager(ConfigurationManager.ConnectionStrings["Configuration_AlwaysOnRead"].ConnectionString);
}
static BaoYangInstallFeeConfigManager()
{
Logger = Common.Logging.LogManager.GetLogger(typeof(BaoYangInstallFeeConfigManager));
dbScopeManagerGungnir = new DBScopeManager(gungnirConnRo);
dbScopeManagerGungnirRead = new DBScopeManager(gungnirReadConnRo);
dbScopeManagerConfig = new DBScopeManager(configConnRo);
dbScopeManagerConfigRead = new DBScopeManager(configReadConnRo);
}
public VendorProductCouponPriceManager()
{
Logger = LogManager.GetLogger(typeof(VendorProductCouponPriceManager));
dbScopeManagerConfiguration = new DBScopeManager(configurationConn);
dbScopeManagerConfigurationRead = new DBScopeManager(configurationReadConn);
_dal = new DalVendorProductCouponPriceConfig();
_vendorProductService = new VendorProductService();
}
static PaintDiscountConfigManager()
{
Logger = LogManager.GetLogger(typeof(PaintDiscountConfigManager));
dbScopeManagerConfiguration = new DBScopeManager(configurationConn);
dbScopeManagerConfigurationRead = new DBScopeManager(configurationReadConn);
dbScopeManagerProductcatalogRead = new DBScopeManager(productcatalogReadConn);
dbScopeManagerTuhulog = new DBScopeManager(tuhuLogConn);
}
static BatteryLevelUpManager()
{
Logger = Common.Logging.LogManager.GetLogger(typeof(BatteryLevelUpManager));
dbScopeManagerConfig = new DBScopeManager(configConnString);
dbScopeManagerConfigRead = new DBScopeManager(configReadConnString);
dbScopeManagerBaoYang = new DBScopeManager(ConfigurationManager.ConnectionStrings["BaoYang"].ConnectionString);
dbScopeManagerBaoYangRead = new DBScopeManager(ConfigurationManager.ConnectionStrings["BaoYang_AlwaysOnRead"].ConnectionString);
}
public BatteryCouponPriceDisplayManager(string user)
{
Logger = LogManager.GetLogger(typeof(BatteryCouponPriceDisplayManager));
dbScopeManagerConfiguration = new DBScopeManager(configurationConn);
dbScopeManagerConfigurationRead = new DBScopeManager(configurationReadConn);
_user = user;
_dal = new DalBatteryCouponPriceDisplay();
}
public UnivRedemptionCodeManager()
{
this.DbTuhuGrouponScopeManager = new DBScopeManager(TuhuGrouponConnectionManager);
this.DbTuhuGrouponScopeReadManager = new DBScopeManager(TuhuGrouponConnectionReadManager);
this.DbTuhuLogScopeReadManager = new DBScopeManager(TuhuLogConnectionManager);
this.DbTuhuGunginrScopeManager = new DBScopeManager(TuhuGunginrConnectionManager);
this.DbTuhuGunginrScopeReadManager = new DBScopeManager(TuhuGunginrConnectionReadManager);
}
static VehicleAnnualInspectionAgentManager()
{
Logger = LogManager.GetLogger(typeof(VehicleAnnualInspectionAgentManager));
dbScopeManagerGungnirRead = new DBScopeManager(gungnirReadConn);
dbScopeManagerConfiguration = new DBScopeManager(configurationConn);
dbScopeManagerConfigurationRead = new DBScopeManager(configurationReadConn);
dbScopeManagerProductcatalogRead = new DBScopeManager(productcatalogReadConn);
dbScopeManagerTuhulog = new DBScopeManager(tuhuLogConn);
}
static BatteryFastDeliveryConfigManager()
{
Logger = Common.Logging.LogManager.GetLogger(typeof(BatteryFastDeliveryConfigManager));
dbScopeManagerConfig = new DBScopeManager(configConnString);
dbScopeManagerConfigRead = new DBScopeManager(configReadConnString);
dbScopeManagerProductRead = new DBScopeManager(productReadConnString);
dbScopeManagerGungnir = new DBScopeManager(ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString);
dbScopeManagerGungnirRead = new DBScopeManager(ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString);
}
public DianpingManager()
{
this.thirdpartyConnection = new ConnectionManager(ConfigurationManager.ConnectionStrings["ThirdParty"].ConnectionString);
this.dbScopeManager = new DBScopeManager(thirdpartyConnection);
this.thirdpartyReadConnection = new ConnectionManager(ConfigurationManager.ConnectionStrings["ThirdPartyReadOnly"].ConnectionString);
this.dbScopeReadManager = new DBScopeManager(thirdpartyReadConnection);
this.dalGroupConfig = new DalGroupConfig();
this.dalShopConfig = new DalShopConfig();
this.logger = LogManager.GetLogger(typeof(DianpingManager));
}
static BeautyCodeManager()
{
var connRw = ConfigurationManager.ConnectionStrings["Tuhu_Groupon"].ConnectionString;
var connRo = ConfigurationManager.ConnectionStrings["Tuhu_Groupon_ReadOnly"].ConnectionString;
var connManagerRw = new ConnectionManager(SecurityHelp.IsBase64Formatted(connRw) ? SecurityHelp.DecryptAES(connRw) : connRw);
var connManagerRo = new ConnectionManager(SecurityHelp.IsBase64Formatted(connRo) ? SecurityHelp.DecryptAES(connRo) : connRo);
TuhuGrouponDbScopeManager = new DBScopeManager(connManagerRw);
TuhuGrouponDbScopeManagerReadOnly = new DBScopeManager(connManagerRo);
}
public VendorProductCoverAreaManager()
{
_dbScopeManagerConfig = new DBScopeManager(configConnRo);
_dbScopeManagerConfigRead = new DBScopeManager(configReadConnRo);
_dal = new DalVendorProductCoverArea();
_baoYangManager = new BaoYangManager();
_regionService = new RegionService();
_logger = LogManager.GetLogger(typeof(VendorProductCoverAreaManager));
_vendorProductService = new VendorProductService();
}
public PushManager()
{
this.connectionManager =
new ConnectionManager(ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString);
this.bIConnectionMgr =
new ConnectionManager(ConfigurationManager.ConnectionStrings["Tuhu_BI"].ConnectionString);
this.dbScopeManagerGR = new DBScopeManager(this.connectionManager);
this.dbScopeManagerBI = new DBScopeManager(this.bIConnectionMgr);
this.handler = new PushHandler();
}
public ConfigCategoryManager()
{
dbScopeManagerBY = new DBScopeManager(connectionManager);
GRAlwaysOnReadDbScopeManager = new DBScopeManager(grAlwaysOnReadConnectionManager);
//using (var client = new CacheClient())
//{
// client.UpdateBaoYangActivityAsync("activtiyId");
// client.UpdateTuhuRecommendConfigAsync();
//}
}
public BatteryManager(string @operator)
{
_operator = @operator;
var connectionManagerBaoYang = new ConnectionManager(ConfigurationManager.ConnectionStrings["BaoYang"].ConnectionString);
var connectionManagerBaoYangRead = new ConnectionManager(ConfigurationManager.ConnectionStrings["BaoYang_AlwaysOnRead"].ConnectionString);
var connectionManagerProductRead = new ConnectionManager(ConfigurationManager.ConnectionStrings["Tuhu_productcatalog_AlwaysOnRead"].ConnectionString);
dbScopeManagerBaoYang = new DBScopeManager(connectionManagerBaoYang);
dbScopeManagerBaoYangRead = new DBScopeManager(connectionManagerBaoYangRead);
dbScopeManagerProductRead = new DBScopeManager(connectionManagerProductRead);
_battery = new DalBattery();
}
public InstallTypeConfigManager()
{
this.connectionManager =
new ConnectionManager(ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString);
this.dbScopeManager = new DBScopeManager(this.connectionManager);
this.connectionManagerRead =
new ConnectionManager(ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString);
this.dbScopeManagerRead = new DBScopeManager(this.connectionManager);
this.dalInstallType = new DalBaoYangInstallTypeConfig();
this.logger = LogManager.GetLogger(typeof(InstallTypeConfigManager));
}
public ActivityManager()
{
string gungnirConnStr = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString;
string gungnirReadOnlyConnStr = ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(gungnirConnStr))
{
gungnirConnStr = SecurityHelp.DecryptAES(gungnirConnStr);
}
if (SecurityHelp.IsBase64Formatted(gungnirReadOnlyConnStr))
{
gungnirReadOnlyConnStr = SecurityHelp.DecryptAES(gungnirReadOnlyConnStr);
}
DbGungnirManager = new DBScopeManager(new ConnectionManager(gungnirConnStr));
DbGungnirReadOnlyManager = new DBScopeManager(new ConnectionManager(gungnirReadOnlyConnStr));
handler = new ActivityHandler();
handlerReadonly = new ActivityHandler();
}
public RebateConfigManager()
{
this.dbScopeManager = new DBScopeManager(ConnectionManager);
this.dbScopeReadManager = new DBScopeManager(ConnectionReadManager);
}
public SprayPaintVehicleManager()
{
dbScopeManagerCF = new DBScopeManager(confConnectionManager);
CFAlwaysOnReadDbScopeManager = new DBScopeManager(confAlwaysOnReadConnectionManager);
GRAlwaysOnReadDbScopeManager = new DBScopeManager(grAlwaysOnReadConnectionManager);
}
public ArticleHandler(IDBScopeManager dbManager)
{
this.dbManager = dbManager;
}
static LiveWorkShopConfigManager()
{
Logger = Common.Logging.LogManager.GetLogger(typeof(LiveWorkShopConfigManager));
dbScopeManagerConfig = new DBScopeManager(configConnRo);
dbScopeManagerConfigRead = new DBScopeManager(configReadConnRo);
}
/// <summary>
/// 查询商品相关信息（库存，活动价格，商品基本信息）
/// </summary>
/// <param name="pids"></param>
/// <param name="conn"></param>
/// <returns></returns>
static async Task <List <CarProductPriceModel> > FullStockData(List <string> pids, SqlConnection conn, IDBScopeManager mana)
{
var list = await DalCarProductPrice.GetProductBaseInfoByCatalog(conn, pids);
if (list == null || list.Count < 1)
{
return(list);
}
//活动价格 activityType:1.天天秒杀 4.限时抢购
var activityPrices = await DalCarProductPrice.GetActivityPricesByPids(conn, pids, DateTime.Now);
//拼团价格
var pintuanPirces = await DalCarProductPrice.GetPintuanPricesByPids(conn, pids, DateTime.Now);
//采购相关价格信息
//var carigouPrices = await DalCarProductPrice.GetCaigouPriceByPids(conn, pids);
List <CarPriceManagementResponse> carigouPrices = new List <CarPriceManagementResponse>();
using (PurchaseClient _OperationResult = new PurchaseClient())
{
List <CarPriceManagementRequest> req = pids.Select(p => new CarPriceManagementRequest()
{
PID = p
}).ToList();
var result = _OperationResult.SelectPurchaseInfoByPID(req);
if (result.Success && result.Result.Any())
{
carigouPrices = result.Result.ToList();
}
}
//11410.广州保养仓库、 8598.上海保养仓库 、7295.武汉保养仓库、8634.北京保养仓库、缺少一个义乌（还未上线此仓库）
var wareHouseIds = new List <string> {
"8598", "7295", "11410", "8634"
};
var stockInfos = await DalCarProductPrice.GetStockQuantityByPids(conn, pids, wareHouseIds);
foreach (var item in list)
{
#region 字段赋值
var tempPintuanPrices = pintuanPirces.Where(x => x.PID == item.PID);
var temp0ActivityPrices = activityPrices?.Where(x => x.PID == item.PID && x.ActiveType == 0);
var temp1ActivityPrices = activityPrices?.Where(x => x.PID == item.PID && x.ActiveType == 1);
var temp4ActivityPrices = activityPrices?.Where(x => x.PID == item.PID && x.ActiveType == 4);
//最小价格
item.FullNetActivityPrice = (temp0ActivityPrices.OrderBy(x => x.Price).FirstOrDefault()?.Price) ?? 0;
item.DaydaySeckillPrice = (temp1ActivityPrices.OrderBy(x => x.Price).FirstOrDefault()?.Price) ?? 0;
item.FlashSalePrice = (temp4ActivityPrices.OrderBy(x => x.Price).FirstOrDefault()?.Price) ?? 0;
item.PintuanPrice = (tempPintuanPrices.OrderBy(x => x.Price).FirstOrDefault()?.Price) ?? 0;
var tempCarigouPrices = carigouPrices?.Where(x => x.PID == item.PID);
//采购相关价格信息
item.PurchasePrice = tempCarigouPrices.OrderBy(p => p.PurchasePrice).FirstOrDefault()?.PurchasePrice ?? 0;
item.ContractPrice = tempCarigouPrices.OrderBy(p => p.ContractPrice).FirstOrDefault()?.ContractPrice ?? 0;
item.OfferPurchasePrice = tempCarigouPrices.OrderBy(p => p.OfferPurchasePrice).FirstOrDefault()?.OfferPurchasePrice ?? 0;
item.OfferContractPrice = tempCarigouPrices.OrderBy(p => p.OfferContractPrice).FirstOrDefault()?.OfferContractPrice ?? 0;
//历史价格
item.FullNetActivityPriceList = temp0ActivityPrices.ToList();
item.DaydaySeckillPriceList = temp1ActivityPrices.ToList();
item.FlashSalePriceList = temp4ActivityPrices.ToList();
item.PintuanPriceList = tempPintuanPrices.ToList();
//库存
var tempStockInfos8598 = stockInfos?.FirstOrDefault(x => x.PID == item.PID && x.WAREHOUSEID == 8598);
item.SH_AvailableStockQuantity = tempStockInfos8598?.TotalAvailableStockQuantity ?? 0;
item.SH_ZaituStockQuantity = tempStockInfos8598?.CaigouZaitu ?? 0;
var tempStockInfos7295 = stockInfos?.FirstOrDefault(x => x.PID == item.PID && x.WAREHOUSEID == 7295);
item.WH_AvailableStockQuantity = tempStockInfos7295?.TotalAvailableStockQuantity ?? 0;
item.WH_ZaituStockQuantity = tempStockInfos7295?.CaigouZaitu ?? 0;
var tempStockInfos11410 = stockInfos?.FirstOrDefault(x => x.PID == item.PID && x.WAREHOUSEID == 11410);
item.GZ_AvailableStockQuantity = tempStockInfos11410?.TotalAvailableStockQuantity ?? 0;
item.GZ_ZaituStockQuantity = tempStockInfos11410?.CaigouZaitu ?? 0;
var tempStockInfos111 = stockInfos?.FirstOrDefault(x => x.PID == item.PID && x.WAREHOUSEID == 111);
item.YW_AvailableStockQuantity = tempStockInfos111?.TotalAvailableStockQuantity ?? 0;
item.YW_ZaituStockQuantity = tempStockInfos111?.CaigouZaitu ?? 0;
item.TotalAvailableStockQuantity = stockInfos?.Sum(x => x.TotalAvailableStockQuantity) ?? 0;
item.TotalZaituStockQuantity = stockInfos?.Sum(x => x.CaigouZaitu) ?? 0;
#endregion
}
return(list);
}
public MonitorHandler(IDBScopeManager dbManager)
{
this.dbManager = dbManager;
}
static UploadFileManager()
{
logger = LogManager.GetLogger(typeof(UploadFileManager));
dbScopeManagerTuhulog = new DBScopeManager(tuhuLogConn);
}
public QRCodeStatisticsConfigHandler(IDBScopeManager dbManager)
{
this.dbManager = dbManager;
}
internal ActivityCalendarHandler(IDBScopeManager dbManager)
{
this._dbManager = dbManager;
}
public MessagePushHandler(IDBScopeManager dbManager)
{
this.dbManager = dbManager;
}
public CarsAffairsManager()
{
dbScopeManagerTuhuLog = new DBScopeManager(tuhuLogConnectionManager);
}