合并上格新增代码

展杰

2024-08-13 a4f725f0fc99e1e51106af1b60263ac3bd2a7c30

合并上格新增代码

 MES.Service/DB/DbContext.cs

@@ -1,4 +1,5 @@
using SqlSugar;
using MES.Service.util;
using SqlSugar;

namespace MES.Service.DB;

@@ -12,7 +13,7 @@
    //mesQaItemXj02Context.Db.Queryable<MesQaItemXj02>().ToList();

    private static readonly string connectionString =
        "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev"; // è¿™é‡Œæ›¿æ¢æˆä½ çš„实际连接字符串;
        AppsettingsUtility.Settings.DataBaseConn; // è¿™é‡Œæ›¿æ¢æˆä½ çš„实际连接字符串;

    /// <summary>
    ///     æ³¨æ„ï¼šä¸èƒ½å†™æˆé™æ€çš„ //用来处理事务多表查询和复杂的操作

 MES.Service/DB/OracleSQLHelper.cs

@@ -1,4 +1,5 @@
using System.Data;
using MES.Service.util;
using Oracle.ManagedDataAccess.Client;

namespace MES.Service.DB;
@@ -8,11 +9,11 @@
/// </summary>
public class OracleSQLHelper
{
    public const string ConnectionString =
        "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev";

    private readonly string _connectionString;

    public readonly string ConnectionString =
        AppsettingsUtility.Settings.DataBaseConn;

    //public static string connectionString = "Data Source = 192.168.1.19; Persist Security Info=True;User ID = abtdev; Password=abt_dev";
    public string connectionString =
        "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev"; // è¿™é‡Œæ›¿æ¢æˆä½ çš„实际连接字符串

 MES.Service/DB/Repository.cs

@@ -1,4 +1,5 @@
using SqlSugar;
using MES.Service.util;
using SqlSugar;

namespace MES.Service.DB;

@@ -7,8 +8,7 @@
    public static SqlSugarScope Db = new(new ConnectionConfig
        {
            DbType = DbType.Oracle,
            ConnectionString =
                @"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev",
            ConnectionString = AppsettingsUtility.Settings.DataBaseConn,
            IsAutoCloseConnection = true
        },
        db =>

 MES.Service/DB/SqlSugarHelper.cs

@@ -1,11 +1,12 @@
using SqlSugar;
using MES.Service.util;
using SqlSugar;

namespace MES.Service.DB;

public class SqlSugarHelper
{
    private static readonly string _connectionString =
        "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev"; // è¿™é‡Œæ›¿æ¢æˆä½ çš„实际连接字符串
        AppsettingsUtility.Settings.DataBaseConn; // è¿™é‡Œæ›¿æ¢æˆä½ çš„实际连接字符串

    public static SqlSugarClient GetInstance()
    {

 MES.Service/Dto/webApi/ErpCAA.cs

@@ -4,6 +4,8 @@
{
    public string Id { get; set; }
    public string? Type { get; set; }

    public string? FBILLTYPE { get; set; }
    public string? FBillNo { get; set; }
    public string? FWorkShopID0 { get; set; }
    public string? FRoutingId { get; set; }
@@ -36,4 +38,8 @@
    public string? FCloseType { get; set; }
    public string? FSrcSplitBillNo { get; set; }
    public string? FMemoItem { get; set; }

    public string? planId { get; set; }
    public string? planSeq { get; set; }
    public string? planNum { get; set; }
}

 MES.Service/Dto/webApi/ErpCAB.cs

@@ -20,5 +20,7 @@
    public string? FNumerator { get; set; }
    public string? FDenominator { get; set; }
    public string ID { get; set; }
    public string PID { get; set; }
    public string? PID { get; set; }

    public string? FSeq { get; set; }
}

 MES.Service/Modes/MesInvItemIns.cs

@@ -1,5 +1,3 @@
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;

namespace MES.Service.Modes;
@@ -7,404 +5,311 @@
/// <summary>
///     ç‰©æ–™å…¥åº“主表
/// </summary>
[Table("MES_INV_ITEM_INS")]
[SugarTable("MES_INV_ITEM_INS")] //用于SqlSugar
[SugarTable("MES_INV_ITEM_INS")]
public class MesInvItemIns
{
    /// <summary>
    ///     ID(SEQ_INV_ID)
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(ColumnName = "ID")] //用于SqlSugar
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     å…¥åº“单号
    /// </summary>
    [Column("BILL_NO")]
    [SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "入库单号长度不能超出100")]
    [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { get; set; }

    /// <summary>
    ///     å•æ®ç±»åž‹ID
    ///     çŠ¶æ€|0-未审核1-审核入库\结案
    /// </summary>
    [Column("BILL_TYPE_ID")]
    [SugarColumn(ColumnName = "BILL_TYPE_ID")] //用于SqlSugar
    public decimal? BillTypeId { get; set; }
    [SugarColumn(ColumnName = "STATUS")]
    public short? Status { get; set; }

    /// <summary>
    ///     åˆ°è´§å•å·/计划单号
    ///     ä»“库
    /// </summary>
    [Column("CBILL_NO")]
    [SugarColumn(ColumnName = "CBILL_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "到货单号/计划单号长度不能超出50")]
    public string CbillNo { get; set; }
    [SugarColumn(ColumnName = "DEPOTS_ID")]
    public decimal? DepotsId { get; set; }

    /// <summary>
    ///     å®¡æ ¸æ—¥æœŸ
    ///     åŽŸå› 
    /// </summary>
    [Column("CHECK_DATE")]
    [SugarColumn(ColumnName = "CHECK_DATE")] //用于SqlSugar
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     å·²æ¡æ•°é‡
    /// </summary>
    [Column("CHECK_QTY")]
    [SugarColumn(ColumnName = "CHECK_QTY")] //用于SqlSugar
    public decimal? CheckQty { get; set; }

    /// <summary>
    ///     æ£€éªŒç»“æžœ
    /// </summary>
    [Column("CHECK_RES")]
    [SugarColumn(ColumnName = "CHECK_RES")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "检验结果长度不能超出50")]
    public string CheckRes { get; set; }

    /// <summary>
    ///     å®¡æ ¸äºº
    /// </summary>
    [Column("CHECK_USER")]
    [SugarColumn(ColumnName = "CHECK_USER")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "审核人长度不能超出32")]
    public string CheckUser { get; set; }

    /// <summary>
    ///     å…¬å¸ä»£ç 
    /// </summary>
    [Column("COMPANY")]
    [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "公司代码长度不能超出20")]
    public string Company { get; set; }
    [SugarColumn(ColumnName = "REASON")]
    public string Reason { get; set; }

    /// <summary>
    ///     åˆ›å»ºäºº
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "创建人长度不能超出30")]
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string CreateBy { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
    /// </summary>
    [Column("CREATE_DATE")]
    [SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     å®¢æˆ·åç§°
    /// </summary>
    [Column("CUST_NAME")]
    [SugarColumn(ColumnName = "CUST_NAME")] //用于SqlSugar
    [StringLength(300, ErrorMessage = "客户名称长度不能超出300")]
    public string CustName { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç¼–号
    /// </summary>
    [Column("CUST_NO")]
    [SugarColumn(ColumnName = "CUST_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "客户编号长度不能超出50")]
    public string CustNo { get; set; }

    /// <summary>
    ///     ä»“库编码
    /// </summary>
    [Column("DEPOTS_CODE")]
    [SugarColumn(ColumnName = "DEPOTS_CODE")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "仓库编码长度不能超出30")]
    public string DepotsCode { get; set; }

    /// <summary>
    ///     ä»“库
    /// </summary>
    [Column("DEPOTS_ID")]
    [SugarColumn(ColumnName = "DEPOTS_ID")] //用于SqlSugar
    public decimal? DepotsId { get; set; }

    /// <summary>
    ///     SAP采购订单号
    /// </summary>
    [Column("EBELN")]
    [SugarColumn(ColumnName = "EBELN")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "SAP采购订单号长度不能超出50")]
    public string Ebeln { get; set; }

    /// <summary>
    ///     å·¥åŽ‚编码
    /// </summary>
    [Column("FACTORY")]
    [SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "工厂编码长度不能超出10")]
    public string Factory { get; set; }

    /// <summary>
    ///     æŠ•æ–™å•è¡Œå·
    /// </summary>
    [Column("FBILL_LINO")]
    [SugarColumn(ColumnName = "FBILL_LINO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "投料单行号长度不能超出50")]
    public string FbillLino { get; set; }

    /// <summary>
    ///     æŠ•æ–™é€šçŸ¥å•å•å·
    /// </summary>
    [Column("FBILLNO")]
    [SugarColumn(ColumnName = "FBILLNO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "投料通知单单号长度不能超出50")]
    public string Fbillno { get; set; }

    /// <summary>
    ///     å…¥åº“审核日期
    /// </summary>
    [Column("FCHECK_DATE")]
    [SugarColumn(ColumnName = "FCHECK_DATE")] //用于SqlSugar
    public DateTime? FcheckDate { get; set; }

    /// <summary>
    ///     å…¥åº“审核人
    /// </summary>
    [Column("FCHECK_USER")]
    [SugarColumn(ColumnName = "FCHECK_USER")] //用于SqlSugar
    [StringLength(10, ErrorMessage = "入库审核人长度不能超出10")]
    public string FcheckUser { get; set; }

    /// <summary>
    ///     å…¥åº“状态
    /// </summary>
    [Column("FSTATUS")]
    [SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar
    public decimal? Fstatus { get; set; }

    /// <summary>
    ///     å®¡æ ¸å…¥åº“人
    /// </summary>
    [Column("INSBY")]
    [SugarColumn(ColumnName = "INSBY")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "审核入库人长度不能超出32")]
    public string Insby { get; set; }

    /// <summary>
    ///     ç¡®è®¤å…¥åº“日期
    /// </summary>
    [Column("INSDATE")]
    [SugarColumn(ColumnName = "INSDATE")] //用于SqlSugar
    public DateTime? Insdate { get; set; }

    /// <summary>
    ///     å…¥åº“日期
    /// </summary>
    [Column("INS_DATE")]
    [SugarColumn(ColumnName = "INS_DATE")] //用于SqlSugar
    public DateTime? InsDate { get; set; }

    /// <summary>
    ///     IQC检验单号
    /// </summary>
    [Column("IQC_RELEASE_NO")]
    [SugarColumn(ColumnName = "IQC_RELEASE_NO")] //用于SqlSugar
    [StringLength(300, ErrorMessage = "IQC检验单号长度不能超出300")]
    public string IqcReleaseNo { get; set; }

    /// <summary>
    ///     æ˜¯å¦æ£€éªŒ
    /// </summary>
    [Column("ISCHECK")]
    [SugarColumn(ColumnName = "ISCHECK")] //用于SqlSugar
    public decimal? Ischeck { get; set; }

    /// <summary>
    ///     æ˜¯å¦æ˜¾ç¤º
    /// </summary>
    [Column("IS_VISUAL")]
    [SugarColumn(ColumnName = "IS_VISUAL")] //用于SqlSugar
    public decimal? IsVisual { get; set; }

    /// <summary>
    ///     åŠæˆå“ç¼–号
    /// </summary>
    [Column("ITEM_NO")]
    [SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "半成品编号长度不能超出50")]
    public string ItemNo { get; set; }

    /// <summary>
    ///     æœ€åŽæ›´æ–°äºº
    /// </summary>
    [Column("LASTUPDATE_BY")]
    [SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "最后更新人长度不能超出30")]
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string LastupdateBy { get; set; }

    /// <summary>
    ///     æœ€åŽæ›´æ–°æ—¶é—´
    /// </summary>
    [Column("LASTUPDATE_DATE")]
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     é‡‡è´­å•è¡Œå·
    ///     å•æ®ç±»åž‹ID
    /// </summary>
    [Column("LINE_NO")]
    [SugarColumn(ColumnName = "LINE_NO")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "采购单行号长度不能超出20")]
    public string LineNo { get; set; }

    /// <summary>
    ///     é¢†æ–™å·¥æ®µ
    /// </summary>
    [Column("MMLIST")]
    [SugarColumn(ColumnName = "MMLIST")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "领料工段长度不能超出30")]
    public string Mmlist { get; set; }

    /// <summary>
    ///     ç”Ÿäº§è®¢å•
    /// </summary>
    [Column("MOCODE")]
    [SugarColumn(ColumnName = "MOCODE")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "生产订单长度不能超出50")]
    public string Mocode { get; set; }

    /// <summary>
    ///     å†²é”€äº‹åŠ¡ç±»åž‹ç¼–码
    /// </summary>
    [Column("MTTRANSCTION_NO")]
    [SugarColumn(ColumnName = "MTTRANSCTION_NO")] //用于SqlSugar
    public decimal? MttransctionNo { get; set; }

    /// <summary>
    ///     é€è´§å•å·
    /// </summary>
    [Column("PAPER_BILL_NO")]
    [SugarColumn(ColumnName = "PAPER_BILL_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "送货单号长度不能超出50")]
    public string PaperBillNo { get; set; }

    /// <summary>
    ///     0 ç”³è¯·å•ï¼Œ1入库单标识
    /// </summary>
    [Column("PICK_INS")]
    [SugarColumn(ColumnName = "PICK_INS")] //用于SqlSugar
    public decimal? PickIns { get; set; }

    /// <summary>
    ///     åŽŸå› 
    /// </summary>
    [Column("REASON")]
    [SugarColumn(ColumnName = "REASON")] //用于SqlSugar
    [StringLength(1000, ErrorMessage = "原因长度不能超出1000")]
    public string Reason { get; set; }

    /// <summary>
    ///     é€€æ–™åŽŸå› 
    /// </summary>
    [Column("REM")]
    [SugarColumn(ColumnName = "REM")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "退料原因长度不能超出50")]
    public string Rem { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [Column("REMARK")]
    [SugarColumn(ColumnName = "REMARK")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "备注长度不能超出255")]
    public string Remark { get; set; }

    /// <summary>
    ///     SAP返回单据
    /// </summary>
    [Column("SAPNO")]
    [SugarColumn(ColumnName = "SAPNO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "SAP返回单据长度不能超出50")]
    public string Sapno { get; set; }

    /// <summary>
    ///     æ˜¯å¦å·²å›žå†™SAP
    /// </summary>
    [Column("SAPSTATUS")]
    [SugarColumn(ColumnName = "SAPSTATUS")] //用于SqlSugar
    public decimal? Sapstatus { get; set; }

    /// <summary>
    ///     SAP返回信息
    /// </summary>
    [Column("SAPTEXT")]
    [SugarColumn(ColumnName = "SAPTEXT")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "SAP返回信息长度不能超出200")]
    public string Saptext { get; set; }

    /// <summary>
    ///     SAP返回年份
    /// </summary>
    [Column("SAPYEAR")]
    [SugarColumn(ColumnName = "SAPYEAR")] //用于SqlSugar
    public decimal? Sapyear { get; set; }

    /// <summary>
    ///     çŠ¶æ€|0-未审核1-审核入库\结案
    /// </summary>
    [Column("STATUS")]
    [SugarColumn(ColumnName = "STATUS")] //用于SqlSugar
    public decimal? Status { get; set; }

    /// <summary>
    ///     ä¾›åº”商编码
    /// </summary>
    [Column("SUPP_NO")]
    [SugarColumn(ColumnName = "SUPP_NO")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "供应商编码长度不能超出30")]
    public string SuppNo { get; set; }

    /// <summary>
    ///     å·¥å•è¡Œå·
    /// </summary>
    [Column("TASK_LINO")]
    [SugarColumn(ColumnName = "TASK_LINO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "工单行号长度不能超出50")]
    public string TaskLino { get; set; }

    /// <summary>
    ///     ä»»åŠ¡å•å·
    /// </summary>
    [Column("TASK_NO")]
    [SugarColumn(ColumnName = "TASK_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "任务单号长度不能超出50")]
    public string TaskNo { get; set; }
    [SugarColumn(ColumnName = "BILL_TYPE_ID")]
    public decimal? BillTypeId { get; set; }

    /// <summary>
    ///     äº‹åŠ¡ç±»åž‹ID
    /// </summary>
    [Column("TRANSACTION_ID")]
    [SugarColumn(ColumnName = "TRANSACTION_ID")] //用于SqlSugar
    [SugarColumn(ColumnName = "TRANSACTION_ID")]
    public decimal? TransactionId { get; set; }

    /// <summary>
    ///     äº‹åŠ¡ç±»åž‹ç¼–码
    ///     å¤‡æ³¨
    /// </summary>
    [Column("TRANSCTION_NO")]
    [SugarColumn(ColumnName = "TRANSCTION_NO")] //用于SqlSugar
    [StringLength(30, ErrorMessage = "事务类型编码长度不能超出30")]
    public string TransctionNo { get; set; }
    [SugarColumn(ColumnName = "REMARK")]
    public string Remark { get; set; }

    /// <summary>
    ///     æ€¥æ–™æ ‡è¯†
    ///     é€è´§å•å·
    /// </summary>
    [Column("URGENT_FLAG")]
    [SugarColumn(ColumnName = "URGENT_FLAG")] //用于SqlSugar
    public decimal? UrgentFlag { get; set; }
    [SugarColumn(ColumnName = "PAPER_BILL_NO")]
    public string PaperBillNo { get; set; }

    /// <summary>
    ///     é€€æ–™äººå·¥å·
    /// </summary>
    [Column("USER_NO_BACK")]
    [SugarColumn(ColumnName = "USER_NO_BACK")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "退料人工号长度不能超出20")]
    [SugarColumn(ColumnName = "USER_NO_BACK")]
    public string UserNoBack { get; set; }

    /// <summary>
    ///     å®¡æ ¸äºº
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_USER")]
    public string CheckUser { get; set; }

    /// <summary>
    ///     å®¡æ ¸æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     ç”Ÿäº§è®¢å•å·
    /// </summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string TaskNo { get; set; }

    /// <summary>
    ///     å…¥åº“日期
    /// </summary>
    [SugarColumn(ColumnName = "INS_DATE")]
    public DateTime? InsDate { get; set; }

    /// <summary>
    ///     æ£€éªŒç»“æžœ
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_RES")]
    public string CheckRes { get; set; }

    /// <summary>
    ///     å·²æ¡æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_QTY")]
    public decimal? CheckQty { get; set; }

    /// <summary>
    ///     é¢†æ–™å·¥æ®µ
    /// </summary>
    [SugarColumn(ColumnName = "MMLIST")]
    public string Mmlist { get; set; }

    /// <summary>
    ///     SAP采购订单号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN")]
    public string Ebeln { get; set; }

    /// <summary>
    ///     ä»“库编码
    /// </summary>
    [SugarColumn(ColumnName = "DEPOTS_CODE")]
    public string DepotsCode { get; set; }

    /// <summary>
    ///     äº‹åŠ¡ç±»åž‹ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "TRANSCTION_NO")]
    public string TransctionNo { get; set; }

    /// <summary>
    ///     ä¾›åº”商编码
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string SuppNo { get; set; }

    /// <summary>
    ///     å…¥åº“状态
    /// </summary>
    [SugarColumn(ColumnName = "FSTATUS")]
    public short? Fstatus { get; set; }

    /// <summary>
    ///     å·¥åŽ‚编码
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }

    /// <summary>
    ///     æ˜¯å¦å·²å›žå†™SAP
    /// </summary>
    [SugarColumn(ColumnName = "SAPSTATUS")]
    public short? Sapstatus { get; set; }

    /// <summary>
    ///     SAP返回单据
    /// </summary>
    [SugarColumn(ColumnName = "SAPNO")]
    public string Sapno { get; set; }

    /// <summary>
    ///     SAP返回年份
    /// </summary>
    [SugarColumn(ColumnName = "SAPYEAR")]
    public short? Sapyear { get; set; }

    /// <summary>
    ///     SAP返回信息
    /// </summary>
    [SugarColumn(ColumnName = "SAPTEXT")]
    public string Saptext { get; set; }

    /// <summary>
    ///     ç¡®è®¤å…¥åº“日期
    /// </summary>
    [SugarColumn(ColumnName = "INSDATE")]
    public DateTime? InsdateA { get; set; }

    /// <summary>
    ///     æ˜¯å¦æ£€éªŒ
    /// </summary>
    [SugarColumn(ColumnName = "ISCHECK")]
    public decimal? Ischeck { get; set; }

    /// <summary>
    ///     å®¡æ ¸å…¥åº“人
    /// </summary>
    [SugarColumn(ColumnName = "INSBY")]
    public string Insby { get; set; }

    /// <summary>
    ///     æ˜¯å¦æ˜¾ç¤º
    /// </summary>
    [SugarColumn(ColumnName = "IS_VISUAL")]
    public decimal? IsVisual { get; set; }

    /// <summary>
    ///     å…¬å¸ä»£ç 
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }

    /// <summary>
    ///     æ€¥æ–™æ ‡è¯†
    /// </summary>
    [SugarColumn(ColumnName = "URGENT_FLAG")]
    public short? UrgentFlag { get; set; }

    /// <summary>
    ///     é‡‡è´­å•è¡Œå·
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string LineNo { get; set; }

    /// <summary>
    ///     å†²é”€äº‹åŠ¡ç±»åž‹ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
    public decimal? MttransctionNo { get; set; }

    /// <summary>
    ///     å·¥å•è¡Œå·
    /// </summary>
    [SugarColumn(ColumnName = "TASK_LINO")]
    public string TaskLino { get; set; }

    /// <summary>
    ///     æŠ•æ–™é€šçŸ¥å•å•å·
    /// </summary>
    [SugarColumn(ColumnName = "FBILLNO")]
    public string Fbillno { get; set; }

    /// <summary>
    ///     æŠ•æ–™å•è¡Œå·
    /// </summary>
    [SugarColumn(ColumnName = "FBILL_LINO")]
    public string FbillLino { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "CUST_NO")]
    public string CustNo { get; set; }

    /// <summary>
    ///     å®¢æˆ·åç§°
    /// </summary>
    [SugarColumn(ColumnName = "CUST_NAME")]
    public string CustName { get; set; }

    /// <summary>
    ///     IQC检验单号
    /// </summary>
    [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
    public string IqcReleaseNo { get; set; }

    /// <summary>
    ///     åˆ°è´§å•å·
    /// </summary>
    [SugarColumn(ColumnName = "CBILL_NO")]
    public string CbillNo { get; set; }

    /// <summary>
    ///     0 ç”³è¯·å•ï¼Œ1入库单标识
    /// </summary>
    [SugarColumn(ColumnName = "PICK_INS")]
    public decimal? PickIns { get; set; }

    /// <summary>
    ///     å…¥åº“审核人
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_USER")]
    public string FcheckUser { get; set; }

    /// <summary>
    ///     å…¥åº“审核日期
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_DATE")]
    public DateTime? FcheckDate { get; set; }

    /// <summary>
    ///     ä»»åŠ¡æ±‡æŠ¥å•
    /// </summary>
    [SugarColumn(ColumnName = "RBILL_NO")]
    public string RbillNo { get; set; }

    //在数据库查询时忽略这个字段
    [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }

    [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
}

 MES.Service/Modes/MesItems.cs

@@ -216,7 +216,7 @@
    ///     é‡‡è´­å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASEUNITID")]
    public string? Fpurchaseunitid { get; set; }
    public decimal? Fpurchaseunitid { get; set; }

    /// <summary>
    ///     è‡ªå®šä¹‰å­—段1

 MES.Service/Modes/MessageCenter.cs

@@ -105,6 +105,21 @@
    [SugarColumn(ColumnName = "ROUTE")]
    public string? Route { get; set; }

    /// <summary>
    ///     å‚数类型
    /// </summary>
    [SugarColumn(ColumnName = "Content_Type")]
    public string? ContentType { get; set; }

    //
    /// <summary>
    ///     æ˜¯å¦æ˜¯æ¶ˆæ¯  0为推送失败 1为消息,默认为0
    /// </summary>
    [SugarColumn(ColumnName = "is_message")]
    public short? IsMessage { get; set; }


    [SugarColumn(IsIgnore = true)] public int? isShow { get; set; }

    [SugarColumn(IsIgnore = true)] public decimal? Count { get; set; }
}

 MES.Service/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/service/BasicData/MesItemsManager.cs

@@ -136,7 +136,7 @@
            Fissuetype = item.FIssueType,
            Fisbatchmanage = item.FIsBatchManage,
            Fpurchaserid = item.FPurchaserId,
            Fpurchaseunitid = item.FPurchaseUnitId,
            Fpurchaseunitid = Convert.ToDecimal(item.FPurchaseUnitId),
            Storeunit = item.FStoreUnitID,
            Saleunit = item.FSaleUnitId,
            Fforbidstatus = item.FForbidStatus,

 MES.Service/service/MessageCenterManager.cs

@@ -1,5 +1,6 @@
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service;

@@ -7,25 +8,54 @@
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    public List<MessageCenter> getPushFailedPage(MessageCenter query)
    public List<MessageCenter> GetPushFailedPage(MessageCenter query)
    {
        return Context.Queryable<MessageCenter>()
            .Where(it =>
                it.Result == 0 && it.Status == 1 &&
                it.Seq == 1 &&
                it.CreateBy == query.CreateBy)
                it.Seq == 1 && it.Title != null)
            .WhereIF(query.isShow == 1, it => it.DealWith == 0)
            .OrderByDescending(it => it.CreateDate)
            .ToPageList(1, 20);
    }

    public bool save(MessageCenter entity)
    public int save(MessageCenter entity)
    {
        entity.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        entity.Method = "POST";
        return Db.Insertable(entity).ExecuteReturnIdentity();
    }

    public bool SetError(MessageCenter entity)
    {
        entity.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
        entity.Method = "POST";
        entity.Result = 0;
        entity.DealWith = 0;
        entity.Status = 1;
        return base.Insert(entity);
    }

    //获取所有没有成功的请求
    public List<MessageCenter> ErrorMsg()
    {
        return Context.Queryable<MessageCenter>()
            .GroupBy(a => new
            {
                a.TableName, a.Pid, a.Title, a.PageName
            })
            .Where(a =>
                a.DealWith == 0 && a.Status == 0 && a.Result == 0 &&
                a.Title == null)
            .Select<MessageCenter>(a => new MessageCenter
            {
                TableName = a.TableName,
                Pid = a.Pid,
                Title = a.Title,
                PageName = a.PageName,
                Count = SqlFunc.AggregateCount(a.Id)
            }).ToList();
    }
    //根据几种情况更新  ä¿æŒé¡µé¢id是固定的



 MES.Service/service/QC/XJService.cs

@@ -64,7 +64,7 @@
                BoardModel = b.BoardModel,
                PlanQty = c.PlanQty,
                Mocode = a.Mocode,
                BoardStyle = c.BoardStyle,
                // BoardStyle = c.BoardStyle,
                Id = a.Id
            })
            .ToList();
@@ -156,7 +156,7 @@
                CatQty = a.CatQty,
                MoidNum = s.MoidNum,
                Daa020 = a.LineNo,
                DetailMem = a.DetailMem,
                // DetailMem = a.DetailMem,
                TaskNo = a.TaskNo,
                Id = s.Id,
                CreateBy = s.CreateBy,
@@ -169,9 +169,9 @@
                FcheckResu = s.FcheckResu,
                Remarks = s.Remarks,
                BoardModel = b.BoardModel,
                PlanQty = c.PlanQty,
                Mocode = a.Mocode,
                BoardStyle = c.BoardStyle
                PlanQty = c.PlanQty
                // Mocode = a.Mocode,
                // BoardStyle = c.BoardStyle
            }).OrderBy(s => s.CreateDate, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);
    }

 MES.Service/service/WomcaaManager.cs

@@ -74,12 +74,13 @@

    private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
    {
        return new Womcaa
        var entity = new Womcaa
        {
            Erpid = Convert.ToDecimal(dto.Id),
            Caa001 = dto.FBillNo,
            WorkShopId = dto.FWorkShopID0,
            Caa021 = dto.FWorkShopID0,
            RoutingId = dto.FRoutingId,
            WorkShopId = dto.FREMWorkShopId,
            DepotCode = dto.FStockId,
            CreateDate = dto.FDate,
            Caa004 = dto.FBillType,
@@ -109,8 +110,16 @@
            ForceCloserid = dto.FForceCloserId,
            CloseType = dto.FCloseType,
            SrcSplitBillno = dto.FSrcSplitBillNo,
            Caa016 = dto.FMemoItem
            Caa016 = dto.FMemoItem,
            Caa018 = Convert.ToDecimal(dto.planId),
            Caa019 = Convert.ToDecimal(dto.planSeq),
            Caa020 = dto.planNum
        };

        var single = base.GetSingle(it => it.Erpid == entity.Erpid);
        if (single != null) entity.Id = single.Id;

        return entity;
    }

    private List<Womcab> MapErpCABtoWomcab(List<ErpCAB> dtoList)
@@ -123,6 +132,7 @@
            {
                Erpid = Convert.ToDecimal(dto.ID),
                Cab001 = dto.FBillNo,
                Cab002 = dto.FSeq,
                Cab003 = dto.FMaterialID2,
                Cab006 = !string.IsNullOrEmpty(dto.FNeedQty2)
                    ? Convert.ToDecimal(dto.FNeedQty2)
@@ -148,6 +158,10 @@
                Eid = Convert.ToDecimal(dto.PID)
            };

            var entity = Db.Queryable<Womcab>()
                .Where(s => s.Erpid == womcab.Erpid).Single();
            if (entity != null) womcab.Id = entity.Id;

            womcabList.Add(womcab);
        }


 MESApplication/Controllers/Base/DemoController.cs

ÎļþÃû´Ó MESApplication/Controllers/DemoController.cs ÐÞ¸Ä
@@ -4,7 +4,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.Base;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/Base/LoginController.cs

ÎļþÃû´Ó MESApplication/Controllers/LoginController.cs ÐÞ¸Ä
@@ -5,7 +5,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.Base;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/Base/MessageCenterController.cs

ÎļþÃû´Ó MESApplication/Controllers/MessageCenterController.cs ÐÞ¸Ä
@@ -3,13 +3,15 @@
using MES.Service.service;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.Base;

[ApiController]
[Route("api/[controller]")]
public class MessageCenterController : ControllerBase
{
    private readonly GetErpParametersServer ErpParametersServer = new();
    private readonly MessageCenterManager m = new();


@@ -34,13 +36,60 @@
        }
    }

    [HttpPost("GetByPid")]
    public ResponseResult ResetUpdate(int pid)
    //Resend
    [HttpPost("Resend")]
    public ResponseResult Resend(MessageCenter data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetList(it => it.Pid == pid);
            resultInfos.tbBillList = ErpParametersServer.Resend(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //saveError
    [HttpPost("SetError")]
    public ResponseResult SetError([FromBody] MessageCenter data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.SetError(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    [HttpPost("GetByPid")]
    public ResponseResult ResetUpdate([FromBody] JObject data)
    {
        var pid = Convert.ToDecimal(data["pid"].ToString());
        try
        {
            dynamic resultInfos = new ExpandoObject();

            var messageCenter = m.GetById(pid);
            var messageCenters = m.GetList(it => it.Pid == pid);
            messageCenters.Add(messageCenter);
            resultInfos.tbBillList = messageCenters;
            return new ResponseResult
            {
                status = 0,
@@ -60,7 +109,7 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.getPushFailedPage(query);
            resultInfos.tbBillList = m.GetPushFailedPage(query);
            return new ResponseResult
            {
                status = 0,
@@ -106,8 +155,9 @@
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetById")]
    public ResponseResult GetById(int id)
    public ResponseResult GetById([FromBody] JObject data)
    {
        var id = Convert.ToDecimal(data["id"].ToString());
        try
        {
            dynamic resultInfos = new ExpandoObject();

 MESApplication/Controllers/BasicData/MesItemsController.cs

@@ -32,6 +32,7 @@
        entity.Data = JsonConvert.SerializeObject(unit);
        entity.Status = 1;
        entity.CreateBy = "PL017";

        try
        {
            dynamic resultInfos = new ExpandoObject();

 MESApplication/Controllers/QC/BaseController.cs

ÎļþÃû´Ó MESApplication/Controllers/BaseController.cs ÐÞ¸Ä
@@ -5,7 +5,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/QC/MesLineUserController.cs

ÎļþÃû´Ó MESApplication/Controllers/MesLineUserController.cs ÐÞ¸Ä
@@ -4,7 +4,7 @@
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[ApiController]
[Route("api/[controller]")]

 MESApplication/Controllers/QC/RKJController.cs

ÎļþÃû´Ó MESApplication/Controllers/RKJController.cs ÐÞ¸Ä
@@ -6,7 +6,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/QC/SJController.cs

ÎļþÃû´Ó MESApplication/Controllers/SJController.cs ÐÞ¸Ä
@@ -6,7 +6,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/QC/SuspendController.cs

ÎļþÃû´Ó MESApplication/Controllers/SuspendController.cs ÐÞ¸Ä
@@ -5,7 +5,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/QC/XJController.cs

ÎļþÃû´Ó MESApplication/Controllers/XJController.cs ÐÞ¸Ä
@@ -6,7 +6,7 @@
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;

namespace MESApplication.Controllers;
namespace MESApplication.Controllers.QC;

[Route("api/[controller]")]
[ApiController]

 MESApplication/Controllers/WomcaaController.cs

@@ -12,9 +12,8 @@
[Route("api/[controller]")]
public class WomcaaController : ControllerBase
{
    private readonly WomcaaManager m = new();

    private readonly MessageCenterManager _manager = new();
    private readonly WomcaaManager m = new();

    private readonly string METHOD = "POST";

@@ -41,9 +40,13 @@
            resultInfos.tbBillList = save;

            entity.Result = 0;
            if (save) entity.Result = 1;
            entity.DealWith = 0;
            if (save)
            {
                entity.Result = 1;
                entity.DealWith = 1;
            }

            entity.DealWith = 1;
            _manager.save(entity);

            return new ResponseResult

 MESApplication/Startup.cs

@@ -1,4 +1,6 @@
using Microsoft.OpenApi.Models;
using MES.Service.Dto.@base;
using MES.Service.util;
using Microsoft.OpenApi.Models;
using Newtonsoft.Json;
using Newtonsoft.Json.Serialization;
using Swashbuckle.AspNetCore.SwaggerUI;
@@ -13,6 +15,8 @@
    public Startup(IConfiguration configuration)
    {
        Configuration = configuration;

        new AppsettingsUtility().Initial(configuration);
    }

    public IConfiguration Configuration { get; }
@@ -21,11 +25,16 @@
    public void ConfigureServices(IServiceCollection services)
    {
        services.AddControllers();

        // è¯»å– ç³»ç»Ÿ è®¾ç½®å¹¶æ³¨å…¥åˆ°æœåŠ¡ä¸­
        services.Configure<AppSettings>(
            Configuration.GetSection("AppSettings"));

        services.AddSwaggerGen(c =>
        {
            c.SwaggerDoc("v1",
                new OpenApiInfo
                    { Title = "WebFirst.Api", Version = "v1" });
                    { Title = "MESApplication.Api", Version = "v1" });
        });

        //配置JSON.NET
@@ -42,6 +51,9 @@
            // è®¾ç½®å‘½åç­–略为驼峰命名
            opt.SerializerSettings.ContractResolver =
                new CamelCasePropertyNamesContractResolver();

            //返回给前端的时间格式化
            opt.SerializerSettings.DateFormatString = "yyyy-MM-dd HH:mm:ss";
        });

        //配置可以跨域

 MESApplication/appsettings.json

@@ -6,5 +6,10 @@
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
  "AllowedHosts": "*",
  "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.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
  }
}

 MESApplication/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/appsettings.json

@@ -6,5 +6,10 @@
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
  "AllowedHosts": "*",
  "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.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
  }
}

 MESApplication/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/appsettings.json

@@ -6,5 +6,10 @@
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
  "AllowedHosts": "*",
  "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.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
  }
}

 MESApplication/bin/Release/net8.0/publish/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/appsettings.json

@@ -6,5 +6,10 @@
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*"
  "AllowedHosts": "*",
  "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.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"
  }
}