BaoKai_202508_Wms_Jingwang_.../WMS.SqlServerData/SqlProvider.cs

1121 lines
30 KiB
C#
Raw Permalink Normal View History

2025-08-24 21:52:42 +08:00
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Collections.Specialized;
using WMS.IData;
using Oracle.ManagedDataAccess.Client;
using WMS.SqlServerData.BaseData;
using WMS.SqlServerData.SystemManageData;
using WMS.SqlServerData.CKData;
using WMS.SqlServerData.StockData;
using WMS.SqlServerData.ReportData;
using WMS.SqlServerData.SCData;
using WMS.SqlServerData.StrategyData;
using WMS.SqlServerData.Strategy;
namespace WMS.SqlServerData
{
/// <summary>
/// 数据类库提供者
/// </summary>
public class SqlProvider : DataProvider
{
private string connStringName;
#region
/// <summary>
/// 初始化提供者
/// </summary>
/// <param name="name"></param>
/// <param name="config"></param>
public override void Initialize(string name, NameValueCollection config)
{
if (config == null)
{
throw new ArgumentNullException("config");
}
if (String.IsNullOrEmpty(name))
{
name = "SqlProvider";
}
if (String.IsNullOrEmpty(config["description"]))
{
config.Remove("description");
config.Add("description", "Oracle description");
}
base.Initialize(name, config);
if (config["connectionStringName"] == null)
{
config["connectionStringName"] = "wmsConnString";
}
//获取连接字符串键名
connStringName = config["connectionStringName"];
config.Remove("connectionStringName");
//获取数据库连接字符串
//connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
}
#endregion
public override ITest Test
{
get { return new WMS.SqlServerData.TestData(); }
}
public override IData.IBase.ILogBaseData ErrLog
{
get { return new WMS.SqlServerData.BaseData.LogBaseOracleData(); }
}
public override WMS.IData.IBase.IDecStsData DecStsData
{
get { return new WMS.SqlServerData.BaseData.DecStsData(); }
}
public override IData.ICommon.ICommon Common
{
get { return new WMS.SqlServerData.Common.CommonData(); }
}
#region
public override IData.IBase.ISystemMenu SystemMenu
{
get { return new WMS.SqlServerData.BaseData.SystemMenuData(); }
}
#endregion
#region
public override IData.IBase.ISystemMenuFuc SystemMenuFuc
{
get { return new WMS.SqlServerData.BaseData.SystemMenuFucData(); }
}
#endregion
#region
public override IData.IBase.IProvederType ProvederType
{
get { return new WMS.SqlServerData.BaseData.ProvederTypeData(); }
}
#endregion
#region
public override IData.IBase.IProvider Provider
{
get { return new WMS.SqlServerData.BaseData.ProviderData(); }
}
#endregion
#region
//托盘
public override IData.IBase.IPallet Pallet
{
get { return new WMS.SqlServerData.BaseData.PalletData(); }
}
//托盘状态
public override IData.IBase.IPalletStatus PalletStatus
{
get { return new WMS.SqlServerData.BaseData.PalletStatusData(); }
}
public override IData.IBase.IBaseCtlGoods BaseCtlGoods
{
get { return new WMS.SqlServerData.BaseData.BaseCtlGoodsData(); }
}
#endregion
#region
/// <summary>
/// 字典明细
/// </summary>
public override IData.ISystemManage.IDictionaryTab DictionaryTab
{
get { return new WMS.SqlServerData.SystemManageData.DictionaryTabData(); }
}
/// <summary>
/// 字典类型
/// </summary>
public override IData.ISystemManage.IDictionaryType DictionaryType
{
get { return new WMS.SqlServerData.SystemManageData.DictionaryTypeData(); }
}
#endregion
#region
/// <summary>
/// 商品分类
/// </summary>
public override IData.IBase.IGoodsType GoodsType
{
get { return new BaseData.GoodsTypeData(); }
}
#endregion
#region
/// <summary>
/// 仓库分类
/// </summary>
public override IData.IBase.IStorageType StorageType
{
get { return new WMS.SqlServerData.BaseData.StorageTypeData(); }
}
/// <summary>
/// 仓库信息
/// </summary>
public override IData.IBase.IStorageInfo StorageInfo
{
get { return new WMS.SqlServerData.BaseData.StorageInfoData(); }
}
/// <summary>
/// 库区信息
/// </summary>
public override IData.IBase.IStorageArea StorageArea
{
get { return new WMS.SqlServerData.BaseData.StorageAreaData(); }
}
/// <summary>
/// 库位信息
/// </summary>
public override IData.IBase.IStorageAreaLocation StorageAreaLocation
{
get { return new WMS.SqlServerData.BaseData.StorageAreaLocationData(); }
}
/// <summary>
/// 库区库位关联
/// </summary>
public override IData.IBase.ILocArea LocArea
{
get { return new WMS.SqlServerData.BaseData.LocAreaData(); }
}
#endregion
#region
public override IData.IBase.IGoods Goods
{
get { return new BaseData.GoodsData(); }
}
#endregion
#region
/// <summary>
/// 商品单位
/// </summary>
public override IData.IBase.IGoodsMeasure GoodsMeasure
{
get { return new BaseData.GoodsMeasure(); }
}
#endregion
#region
/// <summary>
/// 商品供应商
/// </summary>
public override IData.IBase.IGoodProvider GoodProvider
{
get { return new BaseData.GoodProvider(); }
}
#endregion
public override WMS.IData.ICK.IPickingWaveInfo pickingWareInfo
{
get { return new PickingWaveInfo(); }
}
//#region 客户信息
//public override IData.IBase.IUpCustomer UpCustomer
//{
// get { return new BaseData.UpCustomerData(); }
//}
//#endregion
#region
public override IData.IStrategy.IAccording According
{
get { return new AccordingData(); }
}
#endregion
#region
public override IData.IStrategy.IStrAreaRep StrAreaRep
{
get { return new StrAreaRepData(); }
}
public override IData.IStrategy.IStrAreaRepStorage StrAreaRepStorage
{
get { return new StrAreaRepStorageData(); }
}
public override IData.IStrategy.IStrAreaRepGoods StrAreaRepGoods
{
get { return new StrAreaRepGoodsData(); }
}
#endregion
#region
public override IData.IStrategy.IDownStrategy DownStrategy
{
get { return new DownStrategyData(); }
}
public override IData.IStrategy.IDownStycts DownStycts
{
get { return new DownStyctsData(); }
}
#region
//入库验收
public override IData.IRK.IAcceptance Acceptance
{
get { return new WMS.SqlServerData.RKData.AcceptanceData(); }
}
#endregion
#region
public override WMS.IData.IStrategy.IUpStrategy UpStrategy
{
get { return new WMS.SqlServerData.Strategy.UpStrategyData(); }
}
#endregion
#endregion
#region
public override IData.IStrategy.IProRepStrategy ProRepStrategy
{
get { return new ProRepStrategyData(); }
}
#endregion
#region
public override IData.IStrategy.IAutoTask AutoTask
{
get { return new AutoTaskData(); }
}
#endregion
#region
public override IData.IBase.ICustomer Customer
{
get { return new BaseData.CustomerData(); }
}
#endregion
#region
public override IData.IBase.ICustomerType CustomerType
{
get { return new BaseData.CustomerTypeData(); }
}
#endregion
#region --
/// <summary>
/// 公司信息
/// </summary>
public override WMS.IData.IBase.ICompany Company
{
get { return new WMS.SqlServerData.BaseData.CompanyData(); }
}
#endregion
#region --
/// <summary>
/// 用户信息
/// </summary>
public override WMS.IData.IBase.ISystemUser SystemUser
{
get { return new WMS.SqlServerData.BaseData.SystemUserData(); }
}
#endregion
#region
/// <summary>
/// 备注信息
/// </summary>
public override WMS.IData.IBase.IBaseRemarkDictionary BaseRemarkDictionary
{
get { return new WMS.SqlServerData.BaseData.BaseRemarkDictionaryData(); }
}
#endregion
#region
/// <summary>
/// 备注信息
/// </summary>
public override WMS.IData.IBase.ICapacity Capacity
{
get { return new WMS.SqlServerData.BaseData.CapacityData(); }
}
#endregion
#region
public override WMS.IData.ICK.IOrders Orders
{
get
{
return new CKData.OrdersData();
}
}
#endregion
//#region 运力类型信息
///// <summary>
///// 备注信息
///// </summary>
//public override WMS.IData.IBase.ICapacityType CapacityType
//{
// get { return new WMS.SqlServerData.BaseData.CapacityTypeData(); }
//}
//#endregion
//#region 快递公司
///// <summary>
///// 快递公司信息
///// </summary>
//public override WMS.IData.IBase.ILogisticsComInfo LogisticsComInfo
//{
// get { return new WMS.SqlServerData.BaseData.LogisticsComInfoData(); }
//}
///// <summary>
///// 快递公司配送范围
///// </summary>
//public override WMS.IData.IBase.ILogisticsRange LogisticsRange
//{
// get { return new WMS.SqlServerData.BaseData.LogisticsRangeData(); }
//}
//#endregion
#region
/// <summary>
/// 权限管理
/// </summary>
public override IData.IBase.IRole Role
{
get { return new WMS.SqlServerData.BaseData.RoleData(); }
}
#endregion
#region
public override IData.IBase.IAddressArea AddressArea
{
get { return new WMS.SqlServerData.BaseData.AddressAreaData(); }
}
#endregion
//#region 城际距离
//public override IData.IBase.IInterCity InterCity
//{
// get { return new WMS.SqlServerData.BaseData.InterCityData(); }
//}
//#endregion
//#region 线路信息
//public override IData.IBase.ILineInfo LineInfo
//{
// get { return new WMS.SqlServerData.BaseData.LineInfoData(); }
//}
//#endregion
//#region 线路信息
//public override IData.IBase.ILineList LineList
//{
// get { return new WMS.SqlServerData.BaseData.LineListData(); }
//}
//#endregion
#region
/// <summary>
/// 入库通知单
/// </summary>
public override IData.IRK.IWareNotice WareNotice
{
get { return new WMS.SqlServerData.RKData.WareNoticeData(); }
}
/// <summary>
/// 入库商品明细
/// </summary>
public override IData.IRK.IWareNoticeTab WareNoticeTab
{
get { return new WMS.SqlServerData.RKData.WareNoticeTabData(); }
}
#endregion
//#region 入库验收
////入库验收
//public override IData.IRK.IAcceptance Acceptance
//{
// get { return new WMS.SqlServerData.RKData.AcceptanceData(); }
//}
//#endregion
#region
public override IData.IRK.ICodeDisk CodeDisk
{
get { return new WMS.SqlServerData.RKData.CodeDiskData(); }
}
#endregion
#region
public override IData.IRK.IReceve Receve
{
get { return new WMS.SqlServerData.RKData.ReceveData(); }
}
#endregion
#region
public override IData.IRK.IStorageLot StorageLot
{
get { return new WMS.SqlServerData.RKData.StorageLotData(); }
}
#endregion
//#region 上架策略
//public override WMS.IData.IStrategy.IUpStrategy UpStrategy
//{
// get { return new WMS.SqlServerData.Strategy.UpStrategyData(); }
//}
//#endregion
/// <summary>
/// 仓库间补货
/// </summary>
public override IData.IStock.IStorageRep StorageRep
{
get
{
return new StockData.StorageRepData();
}
}
/// <summary>
/// 供应商补货(生成建议采购单)
/// </summary>
public override IData.IStock.IProvideRep ProvideRep
{
get
{
return new StockData.ProvideRepData();
}
}
///// <summary>
///// 上架
///// </summary>
//public override WMS.IData.IRK.IOnGoodShelf OnGoodsShelf
//{
// get
// {
// return new RKData.OnGoodsShelf();
// }
//}
/// <summary>
/// 盘点任务
/// </summary>
public override WMS.IData.IStock.ICounting Counting
{
get
{
return new StockData.CountingData();
}
}
/// <summary>
/// 盘点任务明细
/// </summary>
public override WMS.IData.IStock.ICountingInfo CountingInfo
{
get
{
return new StockData.CountingInfoData();
}
}
#region
public override IData.ISystemManage.ISysRole SysRole
{
get
{
return new SystemManageData.SysRoleData();
}
}
#endregion
#region
public override IData.IStock.IAdjustList AdjustList
{
get
{
return new StockData.AdjustListData();
}
}
#endregion
#region
public override IData.IBase.IBaseLtkSts BaseLtkSts
{
get { return new BaseLtkSts(); }
}
#endregion
public override IData.IStock.IAdjustListInfo AdjustListInfo
{
get { return new StockData.AdjustListInfoData(); }
}
#region
/// <summary>
/// 移位单
/// </summary>
public override WMS.IData.IStock.IMoveLoc MoveLoc
{
get
{
return new StockData.MoveLocData();
}
}
/// <summary>
/// 移位单明细
/// </summary>
public override WMS.IData.IStock.IMoveLocTab MoveLocTab
{
get
{
return new StockData.MoveLocTabData();
}
}
#endregion
#region
/// <summary>
/// 库存表
/// </summary>
public override WMS.IData.IStock.IMIStock MIStock
{
get
{
return new StockData.MIStockData();
}
}
#endregion
#region
/// <summary>
/// 库区间调拨单
/// </summary>
public override WMS.IData.IStock.IAreaRep AreaRep
{
get
{
return new StockData.AreaRepData();
}
}
/// <summary>
/// 库区间调拨出库明细
/// </summary>
public override WMS.IData.IStock.IAreaRepOut AreaRepOut
{
get
{
return new StockData.AreaRepOutData();
}
}
/// <summary>
/// 库区间调拨入库明细
/// </summary>
public override WMS.IData.IStock.IAreaRepIn AreaRepIn
{
get
{
return new StockData.AreaRepInData();
}
}
#endregion
#region
/// <summary>
/// 库存表
/// </summary>
public override WMS.IData.IStock.IMIStockBack MIStockBack
{
get
{
return new StockData.MIStockBackData();
}
}
#endregion
#region
/// <summary>
/// 角色功能权限
/// </summary>
public override WMS.IData.ISystemManage.IFunctionRole FunctionRole
{
get
{
return new SystemManageData.FunctionRoleData();
}
}
#endregion
#region
/// <summary>
/// 角色商品权限
/// </summary>
public override WMS.IData.ISystemManage.IGoodsRole GoodsRole
{
get
{
return new SystemManageData.GoodsRoleData();
}
}
#endregion
#region
/// <summary>
/// 角色菜单权限
/// </summary>
public override WMS.IData.ISystemManage.IMenuRole MenuRole
{
get
{
return new SystemManageData.MenuRoleData();
}
}
#endregion
#region
/// <summary>
/// 角色菜单权限
/// </summary>
public override WMS.IData.ISystemManage.IProviderRole ProviderRole
{
get
{
return new SystemManageData.ProviderRoleData();
}
}
#endregion
#region
/// <summary>
/// 角色菜单权限
/// </summary>
public override WMS.IData.IBase.IRoleStorage RoleStorage
{
get
{
return new BaseData.RoleStorageData();
}
}
#endregion
#region
/// <summary>
/// 仓库订单配送区域
/// </summary>
public override WMS.IData.IBase.IStorageOrder StorageOrder
{
get
{
return new BaseData.StorageOrderData();
}
}
#endregion
//#region 出库通知单
//public override WMS.IData.ICK.IOrders Orders
//{
// get
// {
// return new CKData.OrdersData();
// }
//}
//#endregion
#region
public override WMS.IData.ICK.IOrderDetail OrderDetail
{
get
{
return new CKData.OrderDetailData();
}
}
#endregion
#region
/// <summary>
/// 捡货单
/// </summary>
public override WMS.IData.ICK.IPickingWave PickingWave
{
get
{
return new CKData.PickingWaveData();
}
}
/// <summary>
/// 捡货单明细
/// </summary>
public override WMS.IData.ICK.IPickingWaveGoods PickingWaveGoods
{
get
{
return new CKData.PickingWaveGoodsData();
}
}
#endregion
#region
public override WMS.IData.IStock.IMIPackStock MIPackStock
{
get
{
return new StockData.MIPackStockData();
}
}
#endregion
#region
public override WMS.IData.IStock.IMIPackStockBack MIPackStockBack
{
get
{
return new StockData.MIPackStockBackData();
}
}
#endregion
#region
public override IData.ICK.IPackWeighing PackWeighing
{
get
{
return new CKData.PackWeighingData();
}
}
#endregion
#region
public override IData.ISystemManage.ITeam Team
{
get
{
return new SystemManageData.TeamData();
}
}
#endregion
#region
public override IData.ISystemManage.ITeamUser TeamUser
{
get
{
return new SystemManageData.TeamUserData();
}
}
#endregion
#region
public override IData.IBase.IUserDepart UserDepart
{
get
{
return new UserDepartData();
}
}
#endregion
#region
public override IData.IBase.IRoleDepart RoleDepart
{
get
{
return new RoleDepartData();
}
}
#endregion
#region
public override IData.ISystemManage.IRoleDictionary RoleDictionary
{
get { return new RoleDictionaryData(); }
}
#endregion
#region
public override IData.IBase.IPrintInfo PrintInfo
{
get { return new PrintInfoData(); }
}
#endregion
//#region 下架策略
//public override IData.IStrategy.IDownStrategy DownStrategy
//{
// get { return new DownStrategyData(); }
//}
//public override IData.IStrategy.IDownStycts DownStycts
//{
// get { return new DownStyctsData(); }
//}
//#endregion
//#region 快递单号规则
//public override IData.IBase.IExpressNORule ExpressNORule
//{
// get { return new ExpressNORuleData(); }
//}
//#endregion
#region
public override IData.IBase.IWorkType WorkType
{
get { return new WorkTypeData(); }
}
#endregion
//#region 工作量
//public override IData.IBase.IWorkLoad WorkLoad
//{
// get { return new WorkLoadData(); }
//}
//#endregion
#region
public override IData.IBase.IMessage Message
{
get { return new MessageData(); }
}
#endregion
//#region 派工表
//public override IData.IBase.IDispatching Dispatching
//{
// get { return new DispatchingData(); }
//}
//#endregion
//#region 派工明细
//public override IData.IBase.IDispatchingInfo DispatchingInfo
//{
// get { return new DispatchingInfoData(); }
//}
//#endregion
#region
public override IData.IBase.IWorkTypeContack WorkTypeContack
{
get { return new WorkTypeContackData(); }
}
#endregion
//#region 库区间定时补货策略
//public override IData.IStrategy.IStrAreaRep StrAreaRep
//{
// get { return new StrAreaRepData(); }
//}
//public override IData.IStrategy.IStrAreaRepStorage StrAreaRepStorage
//{
// get { return new StrAreaRepStorageData(); }
//}
//public override IData.IStrategy.IStrAreaRepGoods StrAreaRepGoods
//{
// get { return new StrAreaRepGoodsData(); }
//}
//#endregion
//#region 供应商补货策略
//public override IData.IStrategy.IProRepStrategy ProRepStrategy
//{
// get { return new ProRepStrategyData(); }
//}
//#endregion
//#region 自动指派任务策略
//public override IData.IStrategy.IAutoTask AutoTask
//{
// get { return new AutoTaskData(); }
//}
//#endregion
//#region 指派依据
//public override IData.IStrategy.IAccording According
//{
// get { return new AccordingData(); }
//}
//#endregion
#region
public override IData.ISC.IGoodsMaterial GoodsMaterial
{
get { return new GoodsMaterialData(); }
}
#endregion
#region
public override IData.ISC.IProcessPlan ProcessPlan
{
get { return new ProcessPlanData(); }
}
#endregion
#region
public override IData.ISC.IPlanGoods PlanGoods
{
get { return new PlanGoodsData(); }
}
#endregion
#region
public override IData.ISC.ITask Task
{
get { return new TaskData(); }
}
#endregion
#region
public override IData.ISC.IWorkingTask WorkingTask
{
get { return new WorkingTaskData(); }
}
#endregion
#region
public override IData.ISC.IProBreak ProBreak
{
get { return new ProBreakData(); }
}
#endregion
#region
public override IData.ISC.IProcess Process
{
get { return new ProcessData(); }
}
#endregion
#region
public override IData.ISystemManage.IScheduling Scheduling
{
get { return new SchedulingData(); }
}
#endregion
#region
public override IData.IBase.IAreaGoodsType AreaGoodsType
{
get { return new AreaGoodsTypeData(); }
}
#endregion
#region
public override IData.IStock.IMIStockOccupy MIStockOccupy
{
get { return new MIStockOccupyData(); }
}
#endregion
#region ()
public override IData.IBase.IUserArea UserArea
{
get { return new UserAreaData(); }
}
#endregion
//#region 运输
//public override IData.ITR.ITransport Transport
//{
// get { return new TransportData(); }
//}
//public override IData.ITR.ITransportTab TransportTab
//{
// get { return new TransportTabData(); }
//}
//#endregion
#region -
public override IData.IReport.IMIStockSearch MIStockSearch
{
get { return new MIStockSearchData(); }
}
#endregion
#region -
public override IData.IReport.ICKReport CKReport
{
get { return new CKReportData(); }
}
#endregion
#region -
public override IData.IReport.IRKReport RKReport
{
get { return new RKReportData(); }
}
#endregion
#region SKU
public override IData.IBase.ISKU SKU
{
get { return new SKUData(); }
}
#endregion
//#region SKU明细
//public override IData.IBase.ISKUTab SKUTab
//{
// get { return new SKUTabData(); }
//}
//#endregion
#region
public override IData.ISystemManage.ISystemParams SystemParam
{
get { return new SystemParamsData(); }
}
#endregion
#region
public override IData.IBase.IDocumentTable DocumentTable
{
get { return new DocumentTableData(); }
}
#endregion
#region
public override IData.ISystemManage.IRoleMessage RoleMessage
{
get { return new RoleMessageData(); }
}
#endregion
public override WMS.IData.IRK.IAutoRkData AutoRkData
{
get { return new WMS.SqlServerData.RKData.Auto.AutoRkData(); }
}
public override WMS.IData.ISC.ICUX_WMS_PO_HEADES_ITF CUX_WMS_PO_HEADES_ITF
{
get { return new WMS.SqlServerData.SCData.CUX_WMS_PO_HEADES_ITF(); }
}
public override WMS.IData.ISC.ICUX_WMS_ISSUE_HEADER_ITF CUX_WMS_ISSUE_HEADER_ITF
{
get { return new WMS.SqlServerData.SCData.CUX_WMS_ISSUE_HEADER_ITF(); }
}
public override WMS.IData.ISC.ICUX_WMS_MOVE_ORDER_ISSU_ITF CUX_WMS_MOVE_ORDER_ISSU_ITF
{
get { return new WMS.SqlServerData.SCData.CUX_WMS_MOVE_ORDER_ISSU_ITF(); }
}
public override WMS.IData.ISC.ICUX_WMS_FIX_ISSUE_ITF CUX_WMS_FIX_ISSUE_ITF
{
get { return new WMS.SqlServerData.SCData.CUX_WMS_FIX_ISSUE_ITF(); }
}
}
}