11

啊鑫

3 天以前 2f0a743446b5b9771445e3db22089264f7d237cb

11

 MES.Service/Dto/webApi/ErpRohinData.cs

@@ -67,6 +67,9 @@
    public string? FDemandType { get; set; }
    public string? FDemandBillNo { get; set; }
    public string? FDemandBillEntrySeq { get; set; }
    public string? FSUBREQENTRYID { get; set; }

    public string? FXifgKhdd { get; set; }
    public string? FXifgKhxsdh { get; set; }
    public string? FXifgNbddh { get; set; }
    public string? Fsubreqentryid { get; set; }
}

 MES.Service/Modes/MesRohInData.cs

@@ -1,382 +1,375 @@
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     采购订单明细表
/// </summary>
[SugarTable("MES_ROH_IN_DATA")]
public class MesRohInData
namespace MES.Service.Modes
{
    /// <summary>
    ///     采购单号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }
    /// 采购订单明细表
    ///</summary>
    [SugarTable("MES_ROH_IN_DATA")]
    public class MesRohInData
    {
        /// <summary>
        /// 收料部门 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
        public string? ReceivingDepartment { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER_ID")]
    public string? SalesOrderId { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_ID")]
        public string? SalesOrderId { get; set; }

    /// <summary>
    ///     采购订单行号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_LINE_ID")]
    public string? OrderLineId { get; set; }
        /// <summary>
        /// 采购订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_LINE_ID")]
        public string? OrderLineId { get; set; }

    /// <summary>
    ///     物料编码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public string? ItemId { get; set; }
        /// <summary>
        /// 物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_ID")]
        public string? ItemId { get; set; }

    /// <summary>
    ///     物料名称
    /// </summary>
    // [SugarColumn(ColumnName = "ITEM_NAME")]
    [SugarColumn(IsIgnore = true)]
    public string? ItemName { get; set; }
        /// <summary>
        /// 采购单位 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_UNIT")]
        public string? PurchaseUnit { get; set; }

    /// <summary>
    ///     物料规格
    /// </summary>
    // [SugarColumn(ColumnName = "ITEM_SPEC")]
    [SugarColumn(IsIgnore = true)]
    public string? ItemSpec { get; set; }
        /// <summary>
        /// 采购数量 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_QTY")]
        public decimal? PurchaseQty { get; set; }

    /// <summary>
    ///     采购单位
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_UNIT")]
    public string? PurchaseUnit { get; set; }
        /// <summary>
        /// 库存单位 
        ///</summary>
        [SugarColumn(ColumnName = "INVENTORY_UNIT")]
        public string? InventoryUnit { get; set; }

    /// <summary>
    ///     采购数量
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_QTY")]
    public decimal? PurchaseQty { get; set; }
        /// <summary>
        /// 计价单位 
        ///</summary>
        [SugarColumn(ColumnName = "PRICING_UNIT")]
        public string? PricingUnit { get; set; }

    /// <summary>
    ///     库存单位
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_UNIT")]
    public string? InventoryUnit { get; set; }
        /// <summary>
        /// 计价数量 
        ///</summary>
        [SugarColumn(ColumnName = "PRICING_QTY")]
        public decimal? PricingQty { get; set; }

    /// <summary>
    ///     计价单位
    /// </summary>
    [SugarColumn(ColumnName = "PRICING_UNIT")]
    public string? PricingUnit { get; set; }
        /// <summary>
        /// 交货日期 
        ///</summary>
        [SugarColumn(ColumnName = "DELIVERY_DATE")]
        public DateTime? DeliveryDate { get; set; }

    /// <summary>
    ///     计价数量
    /// </summary>
    [SugarColumn(ColumnName = "PRICING_QTY")]
    public decimal? PricingQty { get; set; }
        /// <summary>
        /// 最早交货日期 
        ///</summary>
        [SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
        public DateTime? EarliestDeliveryDate { get; set; }

    /// <summary>
    ///     交货日期
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public DateTime? DeliveryDate { get; set; }
        /// <summary>
        /// 最晚交货日期 
        ///</summary>
        [SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
        public DateTime? LatestDeliveryDate { get; set; }

    /// <summary>
    ///     最早交货日期
    /// </summary>
    [SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
    public DateTime? EarliestDeliveryDate { get; set; }
        /// <summary>
        /// 需求组织 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_ORG")]
        public string? DemandOrg { get; set; }

    /// <summary>
    ///     最晚交货日期
    /// </summary>
    [SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
    public DateTime? LatestDeliveryDate { get; set; }
        /// <summary>
        /// 收料组织 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVING_ORG")]
        public string? ReceivingOrg { get; set; }

    /// <summary>
    ///     需求组织
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_ORG")]
    public string? DemandOrg { get; set; }
        /// <summary>
        /// 结算组织 
        ///</summary>
        [SugarColumn(ColumnName = "SETTLEMENT_ORG")]
        public string? SettlementOrg { get; set; }

    /// <summary>
    ///     收料组织
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_ORG")]
    public string? ReceivingOrg { get; set; }
        /// <summary>
        /// 是否赠品 
        ///</summary>
        [SugarColumn(ColumnName = "IS_GIFT")]
        public string? IsGift { get; set; }

    /// <summary>
    ///     结算组织
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT_ORG")]
    public string? SettlementOrg { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }

    /// <summary>
    ///     是否赠品
    /// </summary>
    [SugarColumn(ColumnName = "IS_GIFT")]
    public string? IsGift { get; set; }
        /// <summary>
        /// 供应商物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
        public string? SupplierItemCode { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARKS")]
    public string? Remarks { get; set; }
        /// <summary>
        /// 供应商物料名称 
        ///</summary>
        [SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
        public string? SupplierItemName { get; set; }

    /// <summary>
    ///     供应商物料编码
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
    public string? SupplierItemCode { get; set; }
        /// <summary>
        /// 委外订单编号 
        ///</summary>
        [SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
        public string? OutsourcingOrderId { get; set; }

    /// <summary>
    ///     供应商物料名称
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
    public string? SupplierItemName { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_NUMBER")]
        public string? BatchNumber { get; set; }

    /// <summary>
    ///     委外订单编号
    /// </summary>
    [SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
    public string? OutsourcingOrderId { get; set; }
        /// <summary>
        /// 业务关闭  A:正常，B:业务终止 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_CLOSE")]
        public string? BusinessClose { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "BATCH_NUMBER")]
    public string? BatchNumber { get; set; }
        /// <summary>
        /// 业务冻结  A:正常，B:业务终止 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_FREEZE")]
        public string? BusinessFreeze { get; set; }

    /// <summary>
    ///     业务关闭  A:正常，B:业务终止
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_CLOSE")]
    public string? BusinessClose { get; set; }
        /// <summary>
        /// 冻结人 
        ///</summary>
        [SugarColumn(ColumnName = "FREEZER")]
        public string? Freezer { get; set; }

    /// <summary>
    ///     业务冻结  A:正常，B:业务终止
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_FREEZE")]
    public string? BusinessFreeze { get; set; }
        /// <summary>
        /// 冻结时间 
        ///</summary>
        [SugarColumn(ColumnName = "FREEZE_TIME")]
        public DateTime? FreezeTime { get; set; }

    /// <summary>
    ///     冻结人
    /// </summary>
    [SugarColumn(ColumnName = "FREEZER")]
    public string? Freezer { get; set; }
        /// <summary>
        /// 业务终止 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
        public string? BusinessTerminate { get; set; }

    /// <summary>
    ///     冻结时间
    /// </summary>
    [SugarColumn(ColumnName = "FREEZE_TIME")]
    public DateTime? FreezeTime { get; set; }
        /// <summary>
        /// 终止人 
        ///</summary>
        [SugarColumn(ColumnName = "TERMINATOR")]
        public string? Terminator { get; set; }

    /// <summary>
    ///     业务终止
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
    public string? BusinessTerminate { get; set; }
        /// <summary>
        /// 终止时间 
        ///</summary>
        [SugarColumn(ColumnName = "TERMINATE_TIME")]
        public DateTime? TerminateTime { get; set; }

    /// <summary>
    ///     终止人
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATOR")]
    public string? Terminator { get; set; }
        /// <summary>
        /// 累计收料数量 
        ///</summary>
        [SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
        public decimal? TotalReceivedQty { get; set; }

    /// <summary>
    ///     终止时间
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATE_TIME")]
    public DateTime? TerminateTime { get; set; }
        /// <summary>
        /// 剩余收料数量 
        ///</summary>
        [SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
        public decimal? RemainingReceivedQty { get; set; }

    /// <summary>
    ///     累计收料数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
    public decimal? TotalReceivedQty { get; set; }
        /// <summary>
        /// 累计入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
        public decimal? TotalStoredQty { get; set; }

    /// <summary>
    ///     剩余收料数量
    /// </summary>
    [SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
    public decimal? RemainingReceivedQty { get; set; }
        /// <summary>
        /// 剩余入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
        public decimal? RemainingStoredQty { get; set; }

    /// <summary>
    ///     累计入库数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
    public decimal? TotalStoredQty { get; set; }
        /// <summary>
        /// 累计退料数量 
        ///</summary>
        [SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
        public decimal? TotalReturnedQty { get; set; }

    /// <summary>
    ///     剩余入库数量
    /// </summary>
    [SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
    public decimal? RemainingStoredQty { get; set; }
        /// <summary>
        /// 收料可退数量 
        ///</summary>
        [SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
        public decimal? ReturnableReceivedQty { get; set; }

    /// <summary>
    ///     累计退料数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
    public decimal? TotalReturnedQty { get; set; }
        /// <summary>
        /// 库存可退数量 
        ///</summary>
        [SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
        public decimal? ReturnableStoredQty { get; set; }

    /// <summary>
    ///     收料可退数量
    /// </summary>
    [SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
    public decimal? ReturnableReceivedQty { get; set; }
        /// <summary>
        /// 源单类型 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
        public string? SourceDocumentType { get; set; }

    /// <summary>
    ///     库存可退数量
    /// </summary>
    [SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
    public decimal? ReturnableStoredQty { get; set; }
        /// <summary>
        /// 源单单号 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
        public string? SourceDocumentId { get; set; }

    /// <summary>
    ///     源单类型
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
    public string? SourceDocumentType { get; set; }
        /// <summary>
        /// 需求跟踪号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
        public string? DemandTrackingId { get; set; }

    /// <summary>
    ///     源单单号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
    public string? SourceDocumentId { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
        [SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
        public string? PlanTrackingId { get; set; }

    /// <summary>
    ///     需求跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
    public string? DemandTrackingId { get; set; }
        /// <summary>
        /// 变更标志 
        ///</summary>
        [SugarColumn(ColumnName = "CHANGE_FLAG")]
        public string? ChangeFlag { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
    public string? PlanTrackingId { get; set; }
        /// <summary>
        /// 需求来源 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_SOURCE")]
        public string? DemandSource { get; set; }

    /// <summary>
    ///     变更标志
    /// </summary>
    [SugarColumn(ColumnName = "CHANGE_FLAG")]
    public string? ChangeFlag { get; set; }
        /// <summary>
        /// 需求单据编号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
        public string? DemandDocumentId { get; set; }

    /// <summary>
    ///     需求来源
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_SOURCE")]
    public string? DemandSource { get; set; }
        /// <summary>
        /// 需求单据行号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
        public string? DemandDocumentLineId { get; set; }

    /// <summary>
    ///     需求单据编号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
    public string? DemandDocumentId { get; set; }
        /// <summary>
        /// ERP的ID号 
        ///</summary>
        [SugarColumn(ColumnName = "EBELN_K3ID")]
        public decimal? EbelnK3id { get; set; }

    /// <summary>
    ///     需求单据行号
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
    public string? DemandDocumentLineId { get; set; }
        /// <summary>
        /// 自定义字段1 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK1")]
        public string? Remark1 { get; set; }

    /// <summary>
    ///     ERP的ID号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public decimal? EbelnK3id { get; set; }
        /// <summary>
        /// 自定义字段2 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK2")]
        public string? Remark2 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "REMARK1")]
    public string? Remark1 { get; set; }
        /// <summary>
        /// 自定义字段3 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK3")]
        public string? Remark3 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "REMARK2")]
    public string? Remark2 { get; set; }
        /// <summary>
        /// 自定义字段4 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK4")]
        public string? Remark4 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "REMARK3")]
    public string? Remark3 { get; set; }
        /// <summary>
        /// 自定义字段5 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK5")]
        public string? Remark5 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "REMARK4")]
    public string? Remark4 { get; set; }
        /// <summary>
        /// SEQ_BASEINFO_ID 
        ///</summary>
        [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BASEINFO_ID",
            IsPrimaryKey = true)]
        public decimal Id { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "REMARK5")]
    public string? Remark5 { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_ID")]
        public decimal? ErpId { get; set; }

    /// <summary>
    ///     SEQ_BASEINFO_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BASEINFO_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }
        /// <summary>
        /// 采购订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")]
        public string? PurchaseOrderLineNumber { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public decimal? ErpId { get; set; }
        /// <summary>
        /// 需求组织 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND")]
        public string? Demand { get; set; }

    /// <summary>
    ///     采购订单行号
    /// </summary>
    [SugarColumn(ColumnName = "purchase_order_line_number")]
    public string? PurchaseOrderLineNumber { get; set; }
        /// <summary>
        /// 收料组织 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVING")]
        public string? Receiving { get; set; }

    /// <summary>
    ///     需求组织
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND")]
    public string? Demand { get; set; }
        /// <summary>
        /// 结算组织 
        ///</summary>
        [SugarColumn(ColumnName = "SETTLEMENT")]
        public string? Settlement { get; set; }

    /// <summary>
    ///     收料组织
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING")]
    public string? Receiving { get; set; }
        /// <summary>
        /// 已交货数量 
        ///</summary>
        [SugarColumn(ColumnName = "CGB014")]
        public decimal? Cgb014 { get; set; }

    /// <summary>
    ///     收料部门
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
    public string? ReceivingDepartment { get; set; }
        /// <summary>
        /// 需求部门 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_DEPT")]
        public string? DemandDept { get; set; }

    /// <summary>
    ///     结算组织
    /// </summary>
    [SugarColumn(ColumnName = "SETTLEMENT")]
    public string? Settlement { get; set; }
        /// <summary>
        /// 收料部门 
        ///</summary>
        [SugarColumn(ColumnName = "RECEIVING_DEPT")]
        public string? ReceivingDept { get; set; }

    /// <summary>
    ///     需求部门
    /// </summary>
    [SugarColumn(ColumnName = "DEMAND_DEPT")]
    public string? DemandDept { get; set; }
        /// <summary>
        /// 预计到货时间 
        ///</summary>
        [SugarColumn(ColumnName = "ARRIVE_DATE")]
        public DateTime? ArriveDate { get; set; }

    /// <summary>
    ///     需求部门
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVING_DEPT")]
    public string? ReceivingDept { get; set; }

    /// <summary>
    ///     预计到货时间
    /// </summary>
    [SugarColumn(ColumnName = "ARRIVE_DATE")]
    public DateTime? ArriveDate { get; set; }


    /// <summary>
    ///     需求部门
    /// </summary>
    [SugarColumn(ColumnName = "FSUBREQENTRYID")]
    public decimal? FSUBREQENTRYID { get; set; }

        /// <summary>
        /// 采购单号 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string? BillNo { get; set; }
    }
}

 MES.Service/service/BasicData/MesRohInManager.cs

@@ -271,7 +271,11 @@
                DemandDocumentId = s.FDemandBillNo,
                DemandDocumentLineId = s.FDemandBillEntrySeq,
                DemandDept = s.FRequireDeptId,
                FSUBREQENTRYID = Convert.ToDecimal(s.FSUBREQENTRYID)
                Remark1 = s.FXifgKhdd, //客户订单
                Remark2 = s.FXifgKhxsdh, //客户销售单号
                Remark3 = s.FXifgNbddh, //内部订单号
                Remark4 = s.Fsubreqentryid,//委外订单分录内码
                
            };

            var single = rohInDataManager.GetSingle(it =>

 MESApplication/appsettings.json

@@ -10,6 +10,6 @@
    "AppSettings": {
        "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo",
        "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal",
        "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.110.189)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xg_dev; Password=xgdev"
        "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.46)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xg_dev; Password=xgdev"
    }
}