From 3d571e02cdb908ff583549f6f512a9a91ca95132 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 14 十一月 2024 18:11:07 +0800
Subject: [PATCH] 添加实体，添加登录的验证和菜单的查询
---
appsettings.json | 2
entity/MessageCenter.cs | 145 +
entity/MesInvItemStocks.cs | 182 +
entity/MesUnit.cs | 128 +
entity/Purdhb.cs | 233 ++
entity/Womcaa.cs | 353 +++
entity/MesItems.cs | 273 ++
entity/Purdka.cs | 113 +
entity/MesInvItemBarcodes.cs | 429 +++
entity/MesPosition.cs | 98
service/base/GetErpParametersServer.cs | 78
entity/MesSysLookups.cs | 98
entity/MesRohInData.cs | 309 ++
entity/MesQaMj.cs | 69
entity/MesItemType.cs | 87
entity/MesSupplier.cs | 156 +
entity/MesInvItemInCDetails.cs | 319 ++
entity/SysDepartment.cs | 147 +
service/base/LoginService.cs | 46
entity/SysUser.cs | 107
entity/MesDepots.cs | 179 +
entity/MesQmAql2.cs | 119 +
entity/Womcab.cs | 213 +
Startup.cs | 2
entity/MesInvItemArn.cs | 209 +
entity/MesQmCheckitem.cs | 184 +
service/base/MessageCenterManager.cs | 108
entity/MesQmCheckitemDt.cs | 224 ++
entity/Purdkb.cs | 123 +
Controllers/base/MessageCenterController.cs | 317 ++
entity/MesInvItemArnDetail.cs | 219 ++
entity/SysOrganization.cs | 79
entity/MesCustomer.cs | 162 +
entity/MesRohIn.cs | 258 ++
util/UtilityHelper.cs | 2
/dev/null | 91
entity/MesSysPageview.cs | 35
Controllers/LoginController.cs | 1
entity/MesSysLookupTypes.cs | 108
entity/MesStaff.cs | 134 +
entity/MesQmAql1.cs | 123 +
DB/RepositoryNoEntity.cs | 6
entity/MesQmAql3.cs | 239 ++
43 files changed, 6,412 insertions(+), 95 deletions(-)
diff --git a/Controllers/LoginController.cs b/Controllers/LoginController.cs
index 064c835..ae59ab9 100644
--- a/Controllers/LoginController.cs
+++ b/Controllers/LoginController.cs
@@ -2,6 +2,7 @@
using Microsoft.AspNetCore.Mvc;
using NewPdaSqlServer.Dto.@base;
using NewPdaSqlServer.service;
+using NewPdaSqlServer.service.@base;
using NewPdaSqlServer.util;
using Newtonsoft.Json.Linq;
diff --git a/Controllers/base/MessageCenterController.cs b/Controllers/base/MessageCenterController.cs
new file mode 100644
index 0000000..8ee7542
--- /dev/null
+++ b/Controllers/base/MessageCenterController.cs
@@ -0,0 +1,317 @@
+锘縰sing System.Dynamic;
+using Microsoft.AspNetCore.Mvc;
+using NewPdaSqlServer.entity;
+using NewPdaSqlServer.service.@base;
+using NewPdaSqlServer.util;
+using Newtonsoft.Json.Linq;
+
+namespace NewPdaSqlServer.Controllers.@base;
+
+[ApiController]
+[Route("api/[controller]")]
+public class MessageCenterController : ControllerBase
+{
+ private readonly GetErpParametersServer ErpParametersServer = new();
+ private readonly MessageCenterManager m = new();
+
+
+ //ResetUpdate
+ [HttpPost("ResetUpdate")]
+ public ResponseResult ResetUpdate([FromBody] MessageCenter data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.ResetUpdate(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //Resend
+ [HttpPost("Resend")]
+ public ResponseResult Resend(MessageCenter data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ //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,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ [HttpPost("getPushFailed")]
+ public ResponseResult getPushFailed(MessageCenter query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var (item, totalCount) = m.GetPushFailedPage(query);
+ resultInfos.tbBillList = item;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos,
+ TotalCount = totalCount
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //IsShow
+ [HttpPost("IsShow")]
+ public ResponseResult IsShow(MessageCenter query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.IsShow(query);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //UpdateRead
+ [HttpPost("UpdateRead")]
+ public ResponseResult UpdateRead(MessageCenter query)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.UpdateRead(query);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /***杩涘叆妯＄増绠＄悊鍙互淇敼妯＄増***/
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈�
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetList")]
+ public ResponseResult GetList()
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetList();
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鑾峰彇
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("GetById")]
+ public ResponseResult GetById([FromBody] JObject data)
+ {
+ var id = Convert.ToDecimal(data["id"].ToString());
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.GetById(id);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 鏍规嵁涓婚敭鍒犻櫎
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("DeleteByIds")]
+ public ResponseResult DeleteByIds([FromBody] object[] ids)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.DeleteByIds(ids);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Insert")]
+ public ResponseResult Add([FromBody] MessageCenter data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.save(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 娣诲姞杩斿洖鑷
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("InsertReturnIdentity")]
+ public ResponseResult InsertReturnIdentity([FromBody] MessageCenter data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.InsertReturnIdentity(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ /// <summary>
+ /// 淇敼
+ /// </summary>
+ /// <returns></returns>
+ [HttpPost("Update")]
+ public ResponseResult Update([FromBody] MessageCenter data)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ resultInfos.tbBillList = m.Update(data);
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+}
\ No newline at end of file
diff --git a/DB/RepositoryNoEntity.cs b/DB/RepositoryNoEntity.cs
index fa20a12..8012f58 100644
--- a/DB/RepositoryNoEntity.cs
+++ b/DB/RepositoryNoEntity.cs
@@ -9,7 +9,11 @@
{
DbType = DbType.SqlServer,
ConnectionString = AppsettingsUtility.Settings.DataBaseConn,
- IsAutoCloseConnection = true
+ IsAutoCloseConnection = true,
+ MoreSettings = new ConnMoreSettings
+ {
+ IsNoReadXmlDescription = true // 璁剧疆蹇界暐璇诲彇XML鎻忚堪
+ }
},
db =>
{
diff --git a/Startup.cs b/Startup.cs
index 66a2042..7ab10eb 100644
--- a/Startup.cs
+++ b/Startup.cs
@@ -34,7 +34,7 @@
{
c.SwaggerDoc("v1",
new OpenApiInfo
- { Title = "PadApplication.Api", Version = "v1" });
+ { Title = "NewPdaSqlServer.Api", Version = "v1" });
var xmlFile =
$"{Assembly.GetExecutingAssembly().GetName().Name}.xml";
var xmlPath = Path.Combine(AppContext.BaseDirectory, xmlFile);
diff --git a/appsettings.json b/appsettings.json
index 565414e..09b39ee 100644
--- a/appsettings.json
+++ b/appsettings.json
@@ -9,6 +9,6 @@
"AppSettings": {
"TestErpUrl": "http://192.168.1.149:8066/WebService1.asmx/MesToErpinfoTest",
"ProductionErpUrl": "http://192.168.1.149:8066/WebService1.asmx/MesToErpinfoTest",
- "DataBaseConn": "Data Source=192.168.1.146;Initial Catalog=GS_MES;User ID=sa;Password =qixi123"
+ "DataBaseConn": "Data Source=192.168.1.146;Initial Catalog=GS_MES;User ID=sa;Password =qixi123;Encrypt=True;TrustServerCertificate=True;"
}
}
diff --git a/entity/MesCustomer.cs b/entity/MesCustomer.cs
new file mode 100644
index 0000000..feccfd6
--- /dev/null
+++ b/entity/MesCustomer.cs
@@ -0,0 +1,162 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_CUSTOMER")]
+ public class MesCustomer
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ID
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="cust_no" )]
+ public string CustNo { get; set; }
+ /// <summary>
+ /// 鍦板尯
+ ///</summary>
+ [SugarColumn(ColumnName="land" )]
+ public string Land { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="cust_name" )]
+ public string CustName { get; set; }
+ /// <summary>
+ /// 瀹㈡埛绠�绉�
+ ///</summary>
+ [SugarColumn(ColumnName="cust_sname" )]
+ public string CustSname { get; set; }
+ /// <summary>
+ /// 鍦板潃
+ ///</summary>
+ [SugarColumn(ColumnName="stras" )]
+ public string Stras { get; set; }
+ /// <summary>
+ /// 鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="telf1" )]
+ public string Telf1 { get; set; }
+ /// <summary>
+ /// 浼犵湡
+ ///</summary>
+ [SugarColumn(ColumnName="telfx" )]
+ public string Telfx { get; set; }
+ /// <summary>
+ /// 鑱旂郴浜�
+ ///</summary>
+ [SugarColumn(ColumnName="anred" )]
+ public string Anred { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀规椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀逛汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏄惁鍏辩(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="item_c" )]
+ public int? ItemC { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏄惁鍥炲啓SAP鎺ュ彛(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="item_sap" )]
+ public int? ItemSap { get; set; }
+ /// <summary>
+ /// 鏄惁鎵规绠＄悊(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="lot_flag" )]
+ public int? LotFlag { get; set; }
+ /// <summary>
+ /// WMS鏄惁鍙戦�佹暟鎹細1宸插彂閫侊紝鍏朵粬鍧囨湭鍙戦��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="iscommit" )]
+ public int? Iscommit { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="fforbidstatus" )]
+ public string Fforbidstatus { get; set; }
+ /// <summary>
+ /// 閿�鍞憳
+ ///</summary>
+ [SugarColumn(ColumnName="fseller" )]
+ public string Fseller { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName="remark3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ /// <summary>
+ /// 鍗曟嵁鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="DATA_TYPE" )]
+ public string DataType { get; set; }
+ }
+}
diff --git a/entity/MesDepots.cs b/entity/MesDepots.cs
new file mode 100644
index 0000000..6d4ae7b
--- /dev/null
+++ b/entity/MesDepots.cs
@@ -0,0 +1,179 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_DEPOTS")]
+ public class MesDepots
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ID(SEQ_INV_ID)
+ ///</summary>
+ [SugarColumn(ColumnName="depot_id" )]
+ public int DepotId { get; set; }
+ /// <summary>
+ /// 浠撳簱绫诲埆缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="depot_code" )]
+ public string DepotCode { get; set; }
+ /// <summary>
+ /// 浠撳簱绫诲埆鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="depot_name" )]
+ public string DepotName { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="description" )]
+ public string Description { get; set; }
+ /// <summary>
+ /// 浠撳簱璐熻矗浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 浠撳簱绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="depottype" )]
+ public string Depottype { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鐗╂枡浣跨敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="type_1" )]
+ public int? Type1 { get; set; }
+ /// <summary>
+ /// 鎴愬搧浣跨敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="type_2" )]
+ public int? Type2 { get; set; }
+ /// <summary>
+ /// 浠撳簱绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="depottypecode" )]
+ public int? Depottypecode { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鐪嬫澘鍥炬爣鏍峰紡
+ ///</summary>
+ [SugarColumn(ColumnName="icon_type" )]
+ public int? IconType { get; set; }
+ /// <summary>
+ /// 鏄惁濮斿浠撳簱
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="is_wy" )]
+ public int? IsWy { get; set; }
+ /// <summary>
+ /// 鏄惁涓嶈壇鍝佷粨
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="is_ng" )]
+ public string IsNg { get; set; }
+ /// <summary>
+ /// 浠撳簱鍦板潃
+ ///</summary>
+ [SugarColumn(ColumnName="cwhaddress" )]
+ public string Cwhaddress { get; set; }
+ /// <summary>
+ /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="pi_type" )]
+ public string PiType { get; set; }
+ /// <summary>
+ /// 鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName="zuid" )]
+ public string Zuid { get; set; }
+ /// <summary>
+ /// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛�
+ ///</summary>
+ [SugarColumn(ColumnName="is_fkc" )]
+ public string IsFkc { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName="production_workshop" )]
+ public string ProductionWorkshop { get; set; }
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ ///</summary>
+ [SugarColumn(ColumnName="material_properti" )]
+ public string MaterialProperti { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName="remark3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="check_date" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="check_by" )]
+ public string CheckBy { get; set; }
+ /// <summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="check_status" )]
+ public bool? CheckStatus { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ }
+}
diff --git a/entity/MesInvItemArn.cs b/entity/MesInvItemArn.cs
new file mode 100644
index 0000000..53c077d
--- /dev/null
+++ b/entity/MesInvItemArn.cs
@@ -0,0 +1,209 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_ARN")]
+ public class MesInvItemArn
+ {
+ /// <summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="bill_no" )]
+ public string BillNo { get; set; }
+ /// <summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="status" )]
+ public int? Status { get; set; }
+ /// <summary>
+ /// 鍘熷洜
+ ///</summary>
+ [SugarColumn(ColumnName="reason" )]
+ public string Reason { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ ///</summary>
+ [SugarColumn(ColumnName="bill_type_id" )]
+ public int? BillTypeId { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ ///</summary>
+ [SugarColumn(ColumnName="transaction_id" )]
+ public int? TransactionId { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 閫佽揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="paper_bill_no" )]
+ public string PaperBillNo { get; set; }
+ /// <summary>
+ /// 閫�鏂欎汉宸ュ彿
+ ///</summary>
+ [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="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 int? CheckQty { get; set; }
+ /// <summary>
+ /// 浠撳簱id
+ ///</summary>
+ [SugarColumn(ColumnName="depots_id" )]
+ public string DepotsId { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="transction_no" )]
+ public string TransctionNo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟唅d
+ ///</summary>
+ [SugarColumn(ColumnName="supp_id" )]
+ public string SuppId { get; set; }
+ /// <summary>
+ /// 鎻愪氦鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="fstatus" )]
+ public bool? Fstatus { get; set; }
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="sapstatus" )]
+ public int? Sapstatus { get; set; }
+ /// <summary>
+ /// 鏄惁妫�楠�
+ ///</summary>
+ [SugarColumn(ColumnName="ischeck" )]
+ public bool? Ischeck { get; set; }
+ /// <summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ ///</summary>
+ [SugarColumn(ColumnName="insby" )]
+ public string Insby { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="urgent_flag" )]
+ public bool? UrgentFlag { get; set; }
+ /// <summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="mttransction_no" )]
+ public int? MttransctionNo { get; set; }
+ /// <summary>
+ /// IQC妫�楠屽崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="iqc_release_no" )]
+ public string IqcReleaseNo { get; set; }
+ /// <summary>
+ /// 鏄惁鏄剧ず
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="is_visual" )]
+ public int? IsVisual { get; set; }
+ /// <summary>
+ /// 0=閲囪喘锛�1=濮斿
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="f_type" )]
+ public bool? FType { get; set; }
+ /// <summary>
+ /// ERP鍒拌揣鍗旾D
+ ///</summary>
+ [SugarColumn(ColumnName="ebeln_k3id" )]
+ public string EbelnK3id { get; set; }
+ /// <summary>
+ /// 鏉＄爜鏉″嵃杩涘害
+ ///</summary>
+ [SugarColumn(ColumnName="barcode_ratio" )]
+ public int? BarcodeRatio { get; set; }
+ /// <summary>
+ /// ERP鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="erpno" )]
+ public string Erpno { get; set; }
+ /// <summary>
+ /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ ///</summary>
+ [SugarColumn(ColumnName="thstatus" )]
+ public int? Thstatus { get; set; }
+ /// <summary>
+ /// ERP閫�璐у崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="erpthno" )]
+ public string Erpthno { get; set; }
+ /// <summary>
+ /// 缁勭粐缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="organize_code" )]
+ public string OrganizeCode { get; set; }
+ }
+}
diff --git a/entity/MesInvItemArnDetail.cs b/entity/MesInvItemArnDetail.cs
new file mode 100644
index 0000000..9994991
--- /dev/null
+++ b/entity/MesInvItemArnDetail.cs
@@ -0,0 +1,219 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_ARN_DETAIL")]
+ public class MesInvItemArnDetail
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="parent_Guid" )]
+ public Guid? ParentGuid { get; set; }
+ /// <summary>
+ /// MES_ROH_IN_DATA鐨刧uid
+ ///</summary>
+ [SugarColumn(ColumnName="about_Guid" )]
+ public Guid? AboutGuid { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="ebeln" )]
+ public string Ebeln { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="ebeln_line" )]
+ public int? EbelnLine { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="ebeln_qty" )]
+ public decimal? EbelnQty { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="item_no" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鏀惰揣鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="quantity" )]
+ public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗旾D
+ ///</summary>
+ [SugarColumn(ColumnName="ebeln_k3id" )]
+ public int? EbelnK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曡ID
+ ///</summary>
+ [SugarColumn(ColumnName="line_k3id" )]
+ public int? LineK3id { get; set; }
+ /// <summary>
+ /// 鏈搴旀敹鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="sub_qty" )]
+ public decimal? SubQty { get; set; }
+ /// <summary>
+ /// 浣欓噺
+ ///</summary>
+ [SugarColumn(ColumnName="margin_qty" )]
+ public int? MarginQty { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="work_no" )]
+ public string WorkNo { get; set; }
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="urgent_flag" )]
+ public bool? UrgentFlag { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="memo" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ ///</summary>
+ [SugarColumn(ColumnName="check_res" )]
+ public string CheckRes { get; set; }
+ /// <summary>
+ /// 妫�楠岀姸鎬� 锛堝緟妫�銆佸垎閫夈�佺壒閲囥�佸凡妫�锛�
+ /// 榛樿鍊�: ('寰呮')
+ ///</summary>
+ [SugarColumn(ColumnName="check_states" )]
+ public string CheckStates { get; set; }
+ /// <summary>
+ /// 鏀惰揣浣欓噺
+ ///</summary>
+ [SugarColumn(ColumnName="quantity_m" )]
+ public int? QuantityM { get; set; }
+ /// <summary>
+ /// 鏈搴旀敹浣欓噺
+ ///</summary>
+ [SugarColumn(ColumnName="sub_mqty" )]
+ public int? SubMqty { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="check_date" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ischeck" )]
+ public int? Ischeck { get; set; }
+ /// <summary>
+ /// 宸叉敹鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="ok_qty" )]
+ public int? OkQty { get; set; }
+ /// <summary>
+ /// 宸叉敹浣欓噺
+ ///</summary>
+ [SugarColumn(ColumnName="ok_mqty" )]
+ public int? OkMqty { get; set; }
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ ///</summary>
+ [SugarColumn(ColumnName="board_style" )]
+ public string BoardStyle { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="work_line" )]
+ public int? WorkLine { get; set; }
+ /// <summary>
+ /// 0銆侀噰璐崟锛�1銆佸澶栧崟
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="f_type" )]
+ public int? FType { get; set; }
+ /// <summary>
+ /// 鏄惁鍏ュ簱
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="isdeps_in" )]
+ public bool? IsdepsIn { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="dha001" )]
+ public string Dha001 { get; set; }
+ /// <summary>
+ /// 宸插叆搴撴暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="ok_rkqty" )]
+ public int? OkRkqty { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="cbill_no" )]
+ public string CbillNo { get; set; }
+ /// <summary>
+ /// 閲囪喘鍏ュ簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="cg_rkqty" )]
+ public int? CgRkqty { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="item_id" )]
+ public int? ItemId { get; set; }
+ /// <summary>
+ /// 閫�璐ф爣璇�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="return_flag" )]
+ public int? ReturnFlag { get; set; }
+ /// <summary>
+ /// 鎺ㄩ�佺姸鎬�
+ ///</summary>
+ [SugarColumn(ColumnName="states" )]
+ public string States { get; set; }
+ }
+}
diff --git a/entity/MesInvItemBarcodes.cs b/entity/MesInvItemBarcodes.cs
new file mode 100644
index 0000000..126aec7
--- /dev/null
+++ b/entity/MesInvItemBarcodes.cs
@@ -0,0 +1,429 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 鐗╂枡鏉＄爜琛�
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_BARCODES")]
+ public class MesInvItemBarcodes
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE" )]
+ public string ItemBarcode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鎴愬搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="C_PRODUCT_CODE" )]
+ public string CProductCode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="C_ITEM_BARCODE" )]
+ public string CItemBarcode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="C_ITEM_CODE" )]
+ public string CItemCode { get; set; }
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鍘傚鎵规
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_NO" )]
+ public string LotNo { get; set; }
+ /// <summary>
+ /// 鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="QUANTITY" )]
+ public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 鏄惁鐜繚(0:鍚�,1:鏄�)
+ ///</summary>
+ [SugarColumn(ColumnName="EP_FLAG" )]
+ public bool? EpFlag { get; set; }
+ /// <summary>
+ /// 鐢熶骇宸ュ崟
+ ///</summary>
+ [SugarColumn(ColumnName="TASK_NO" )]
+ public string TaskNo { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="CUST_NO" )]
+ public string CustNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE_TEXT" )]
+ public string ItemBarcodeText { get; set; }
+ /// <summary>
+ /// 鍘烶SN鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="OLD_ITEM_BARCODE" )]
+ public string OldItemBarcode { get; set; }
+ /// <summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="MBLNR" )]
+ public string Mblnr { get; set; }
+ /// <summary>
+ /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="ZEILE" )]
+ public int? Zeile { get; set; }
+ /// <summary>
+ /// 鏀舵枡琛↖D
+ ///</summary>
+ [SugarColumn(ColumnName="ROH_IN_ID" )]
+ public long? RohInId { get; set; }
+ /// <summary>
+ /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODESTATUS" )]
+ public bool? Barcodestatus { get; set; }
+ /// <summary>
+ /// 鍘熷鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="OLDQTY" )]
+ public long? Oldqty { get; set; }
+ /// <summary>
+ /// 浣跨敤鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="USEQTY" )]
+ public long? Useqty { get; set; }
+ /// <summary>
+ /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="LOCATION" )]
+ public byte? Location { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="UNIT" )]
+ public string Unit { get; set; }
+ /// <summary>
+ /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="WEIGHT_UNIT" )]
+ public decimal? WeightUnit { get; set; }
+ /// <summary>
+ /// 鍗曚环
+ ///</summary>
+ [SugarColumn(ColumnName="PRICE" )]
+ public decimal? Price { get; set; }
+ /// <summary>
+ /// 鍘熸潯鐮佹暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="OLD_BAR_QUANTITY" )]
+ public long? OldBarQuantity { get; set; }
+ /// <summary>
+ /// 姹囨�绘潯鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SUM_BARCODE" )]
+ public string SumBarcode { get; set; }
+ /// <summary>
+ /// 鎵规鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_DATE" )]
+ public string LotDate { get; set; }
+ /// <summary>
+ /// 鎴愬搧鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="MOCODE" )]
+ public string Mocode { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPP_NO" )]
+ public string SuppNo { get; set; }
+ /// <summary>
+ /// 鍙戣揣浣嶇疆
+ ///</summary>
+ [SugarColumn(ColumnName="SPOSTION" )]
+ public string Spostion { get; set; }
+ /// <summary>
+ /// 鍒拌揣浣嶇疆
+ ///</summary>
+ [SugarColumn(ColumnName="EPOSTION" )]
+ public string Epostion { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_SNAME" )]
+ public string ItemSname { get; set; }
+ /// <summary>
+ /// 鏄惁鍙
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="VISABLE" )]
+ public bool? Visable { get; set; }
+ /// <summary>
+ /// 澶栧彂鎵规鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="TR_LOTNO" )]
+ public string TrLotno { get; set; }
+ /// <summary>
+ /// 鍙戣揣鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="FLEZZ_DATE" )]
+ public DateTime? FlezzDate { get; set; }
+ /// <summary>
+ /// 澶栧彂鍘熷洜
+ ///</summary>
+ [SugarColumn(ColumnName="FLEZZ_REASON" )]
+ public string FlezzReason { get; set; }
+ /// <summary>
+ /// 澶栧彂浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FLEZZ_BY" )]
+ public string FlezzBy { get; set; }
+ /// <summary>
+ /// 鍙戣揣鏈�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="DELANY_MONTH" )]
+ public int? DelanyMonth { get; set; }
+ /// <summary>
+ /// 鏄惁鏈�灏忓寘瑁�
+ ///</summary>
+ [SugarColumn(ColumnName="MINPACK_FLAG" )]
+ public bool? MinpackFlag { get; set; }
+ /// <summary>
+ /// 鎵撳嵃ID
+ ///</summary>
+ [SugarColumn(ColumnName="PRINT_ID" )]
+ public string PrintId { get; set; }
+ /// <summary>
+ /// 鐜鐗╂枡
+ ///</summary>
+ [SugarColumn(ColumnName="EP_ITEM" )]
+ public string EpItem { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鍙戠エ鍙风爜
+ ///</summary>
+ [SugarColumn(ColumnName="CB_NO" )]
+ public string CbNo { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="LINFLINE" )]
+ public string Linfline { get; set; }
+ /// <summary>
+ /// 鏈夋晥鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="VALID_TIME" )]
+ public DateTime? ValidTime { get; set; }
+ /// <summary>
+ /// 璐ㄦ鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="IQC_STATUS" )]
+ public string IqcStatus { get; set; }
+ /// <summary>
+ /// 杞﹀彿
+ ///</summary>
+ [SugarColumn(ColumnName="FCAR" )]
+ public string Fcar { get; set; }
+ /// <summary>
+ /// 姣涢噸
+ ///</summary>
+ [SugarColumn(ColumnName="GWEIGHT" )]
+ public string Gweight { get; set; }
+ /// <summary>
+ /// 鍑�閲�
+ ///</summary>
+ [SugarColumn(ColumnName="NWEIGHT" )]
+ public string Nweight { get; set; }
+ /// <summary>
+ /// 鎵╁睍鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="EXT_DATE" )]
+ public long? ExtDate { get; set; }
+ /// <summary>
+ /// 鏉＄爜绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODETYPE" )]
+ public string Barcodetype { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPP_NAME" )]
+ public string SuppName { get; set; }
+ /// <summary>
+ /// 鍙戠エ缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="BILL_NO" )]
+ public string BillNo { get; set; }
+ /// <summary>
+ /// 鏄惁绱ф��
+ ///</summary>
+ [SugarColumn(ColumnName="URGENT_FLAG" )]
+ public bool? UrgentFlag { get; set; }
+ /// <summary>
+ /// 棰滆壊鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="COLOR_NAME" )]
+ public string ColorName { get; set; }
+ /// <summary>
+ /// 鏉垮瀷
+ ///</summary>
+ [SugarColumn(ColumnName="BOARD_STYLE" )]
+ public string BoardStyle { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="INS_DATE" )]
+ public DateTime? InsDate { get; set; }
+ /// <summary>
+ /// 宸ュ簭绾�
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_LINE" )]
+ public int? WorkLine { get; set; }
+ /// <summary>
+ /// 涓嶈壇澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO_BAD" )]
+ public string MemoBad { get; set; }
+ /// <summary>
+ /// 宸ュ崟
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_NO" )]
+ public string WorkNo { get; set; }
+ /// <summary>
+ /// 鍒拌揣鏍囪
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="COME_FLG" )]
+ public bool? ComeFlg { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_NO" )]
+ public string LineNo { get; set; }
+ /// <summary>
+ /// 涓濆嵃鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="SILK_PQTY" )]
+ public long? SilkPqty { get; set; }
+ /// <summary>
+ /// 涓濆嵃瑙勬牸
+ ///</summary>
+ [SugarColumn(ColumnName="SILK" )]
+ public string Silk { get; set; }
+ /// <summary>
+ /// 涓濆嵃ID
+ ///</summary>
+ [SugarColumn(ColumnName="SILK_ID" )]
+ public long? SilkId { get; set; }
+ /// <summary>
+ /// 宸ュ崟鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_FLG" )]
+ public bool? WorkFlg { get; set; }
+ /// <summary>
+ /// 宸ュ崟鏈�鍚庤
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_LAST" )]
+ public int? WorkLast { get; set; }
+ /// <summary>
+ /// HBDY
+ ///</summary>
+ [SugarColumn(ColumnName="HBDY" )]
+ public int? Hbdy { get; set; }
+ /// <summary>
+ /// HBDYTM
+ ///</summary>
+ [SugarColumn(ColumnName="HBDYTM" )]
+ public int? Hbdytm { get; set; }
+ /// <summary>
+ /// 宸ュ簭鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_FLGTIME" )]
+ public string WorkFlgtime { get; set; }
+ /// <summary>
+ /// K3ID璁㈠崟
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_K3ID" )]
+ public long? EbelnK3id { get; set; }
+ /// <summary>
+ /// K3ID琛�
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_K3ID" )]
+ public long? LineK3id { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public long? ItemId { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="GX_ID" )]
+ public long? GxId { get; set; }
+ /// <summary>
+ /// 涓存椂鎵归噺guid
+ ///</summary>
+ [SugarColumn(ColumnName="tmpGuid" )]
+ public Guid? TmpGuid { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟唅d
+ ///</summary>
+ [SugarColumn(ColumnName="supp_id" )]
+ public string SuppId { get; set; }
+ }
+}
diff --git a/entity/MesInvItemInCDetails.cs b/entity/MesInvItemInCDetails.cs
new file mode 100644
index 0000000..fd05a40
--- /dev/null
+++ b/entity/MesInvItemInCDetails.cs
@@ -0,0 +1,319 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 鐗╂枡鍏ュ簱鏉＄爜鏄庣粏
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
+ public class MesInvItemInCDetails
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鍗昳d
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_IN_ID" )]
+ public long? ItemInId { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜PSN
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE" )]
+ public string ItemBarcode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ ///</summary>
+ [SugarColumn(ColumnName="C_ITEM_CODE" )]
+ public string CItemCode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="C_ITEM_BARCODE" )]
+ public string CItemBarcode { get; set; }
+ /// <summary>
+ /// 楠屾敹鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="QUANTITY" )]
+ public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="BARCODE_FLAG" )]
+ public bool? BarcodeFlag { get; set; }
+ /// <summary>
+ /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛�
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="EP_FLAG" )]
+ public bool? EpFlag { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉＄爜鏋�1-鏃犵嚎鏉＄爜鏋�
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_TYPE" )]
+ public long? WorkType { get; set; }
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鍘傚鎵规
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_NO" )]
+ public string LotNo { get; set; }
+ /// <summary>
+ /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="COMANAGEMENT_FLAG" )]
+ public bool? ComanagementFlag { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="CUST_NO" )]
+ public string CustNo { 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="CHECK_STATES" )]
+ public string CheckStates { get; set; }
+ /// <summary>
+ /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FORCE_IN_FLAG" )]
+ public bool? ForceInFlag { get; set; }
+ /// <summary>
+ /// 浠撳簱缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_CODE" )]
+ public string DepotCode { get; set; }
+ /// <summary>
+ /// 璐т綅缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_SECTION_CODE" )]
+ public string DepotSectionCode { get; set; }
+ /// <summary>
+ /// 鐗硅浜嬮」
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE2" )]
+ public string ItemBarcode2 { get; set; }
+ /// <summary>
+ /// 鏂版潯鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE3" )]
+ public string ItemBarcode3 { get; set; }
+ /// <summary>
+ /// 宸蹭娇鐢ㄦ暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="USE_QTY" )]
+ public decimal? UseQty { get; set; }
+ /// <summary>
+ /// 鍑哄簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="OUT_QTY" )]
+ public decimal? OutQty { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_SNAME" )]
+ public string ItemSname { get; set; }
+ /// <summary>
+ /// 璧峰浣嶇疆
+ ///</summary>
+ [SugarColumn(ColumnName="SPOSTION" )]
+ public int? Spostion { get; set; }
+ /// <summary>
+ /// 缁撴潫浣嶇疆
+ ///</summary>
+ [SugarColumn(ColumnName="EPOSTION" )]
+ public int? Epostion { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_DATE" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="UNIT" )]
+ public string Unit { get; set; }
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ISCHECK" )]
+ public bool? Ischeck { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN" )]
+ public string Ebeln { get; set; }
+ /// <summary>
+ /// 鎵规鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_DATE" )]
+ public string LotDate { get; set; }
+ /// <summary>
+ /// 鍙戠エ鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="BILL_NO" )]
+ public string BillNo { get; set; }
+ /// <summary>
+ /// 鏄惁鍏ュ簱鎴愬姛
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="STOCK_OK" )]
+ public bool? StockOk { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// CB鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CB_NO" )]
+ public string CbNo { get; set; }
+ /// <summary>
+ /// 绠卞彿
+ ///</summary>
+ [SugarColumn(ColumnName="BOX_NO" )]
+ public string BoxNo { get; set; }
+ /// <summary>
+ /// 浠撳簱ID
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_ID" )]
+ public long? DepotId { get; set; }
+ /// <summary>
+ /// 璐т綅ID
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_SECTION_ID" )]
+ public long? DepotSectionId { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_NUM" )]
+ public string LineNum { get; set; }
+ /// <summary>
+ /// 鎵弿鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="SM_QTY" )]
+ public decimal? SmQty { get; set; }
+ /// <summary>
+ /// 鍙戣揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="VGBEL" )]
+ public string Vgbel { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="KDPOS" )]
+ public long? Kdpos { get; set; }
+ /// <summary>
+ /// 浣滀笟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_NO" )]
+ public string WorkNo { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_LINE_NO" )]
+ public long? EbelnLineNo { get; set; }
+ /// <summary>
+ /// CB鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CBILL_NO" )]
+ public string CbillNo { get; set; }
+ /// <summary>
+ /// 绱ф�ユ爣璁�
+ ///</summary>
+ [SugarColumn(ColumnName="URGENT_FLAG" )]
+ public bool? UrgentFlag { get; set; }
+ /// <summary>
+ /// 鏉垮瀷
+ ///</summary>
+ [SugarColumn(ColumnName="BOARD_STYLE" )]
+ public string BoardStyle { get; set; }
+ /// <summary>
+ /// 宸ヤ綔琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_LINE" )]
+ public int? WorkLine { get; set; }
+ /// <summary>
+ /// 浠诲姟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="TASK_NO" )]
+ public string TaskNo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPP_NO" )]
+ public string SuppNo { get; set; }
+ /// <summary>
+ /// 鏀惰揣鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="RBILL_NO" )]
+ public string RbillNo { get; set; }
+ /// <summary>
+ /// K3 閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_K3ID" )]
+ public long? EbelnK3id { get; set; }
+ /// <summary>
+ /// K3 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_K3ID" )]
+ public long? LineK3id { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public long? ItemId { get; set; }
+ }
+}
diff --git a/entity/MesInvItemStocks.cs b/entity/MesInvItemStocks.cs
new file mode 100644
index 0000000..9dda5fc
--- /dev/null
+++ b/entity/MesInvItemStocks.cs
@@ -0,0 +1,182 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 鐗╂枡搴撳瓨琛�
+ ///</summary>
+ [SugarTable("MES_INV_ITEM_STOCKS")]
+ public class MesInvItemStocks
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鐢熶骇璁㈠崟
+ ///</summary>
+ [SugarColumn(ColumnName="TASK_NO" )]
+ public string TaskNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_BARCODE" )]
+ public string ItemBarcode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ ///</summary>
+ [SugarColumn(ColumnName="C_ITEM_CODE" )]
+ public string CItemCode { get; set; }
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 瀛愬簱id
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOTS_ID" )]
+ public long? DepotsId { get; set; }
+ /// <summary>
+ /// 璐т綅id
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_SECTIONS_ID" )]
+ public long? DepotSectionsId { get; set; }
+ /// <summary>
+ /// 鍘傚鎵规
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_NO" )]
+ public string LotNo { get; set; }
+ /// <summary>
+ /// 鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="QUANTITY" )]
+ public decimal? Quantity { get; set; }
+ /// <summary>
+ /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級(0-鍚︼紝1-鏄�)
+ ///</summary>
+ [SugarColumn(ColumnName="EP_FLAG" )]
+ public byte? EpFlag { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="CUSTOMER_NO" )]
+ public string CustomerNo { get; set; }
+ /// <summary>
+ /// 閲嶉噺
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_WT" )]
+ public decimal? ItemWt { get; set; }
+ /// <summary>
+ /// 瀛愬簱CODE
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOTS_CODE" )]
+ public string DepotsCode { get; set; }
+ /// <summary>
+ /// 璐т綅CODE
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_SECTIONS_CODE" )]
+ public string DepotSectionsCode { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_DATE" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_TYPE" )]
+ public byte? ItemType { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鏃ユ湡
+ /// 榛樿鍊�: (getdate())
+ ///</summary>
+ [SugarColumn(ColumnName="INDEP_DATE" )]
+ public DateTime? IndepDate { get; set; }
+ /// <summary>
+ /// 宸ュ巶缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 璐ㄩ噺鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="IQC_STATUS" )]
+ public string IqcStatus { get; set; }
+ /// <summary>
+ /// F鍗�
+ ///</summary>
+ [SugarColumn(ColumnName="FCAR" )]
+ public string Fcar { get; set; }
+ /// <summary>
+ /// 鍙鎻愪氦鏍囧織锛�0-鍚︼紝1-鏄級
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="VISABLE_SUBMIT" )]
+ public byte? VisableSubmit { get; set; }
+ /// <summary>
+ /// 鍙鎻愪氦浜�
+ ///</summary>
+ [SugarColumn(ColumnName="VISABLE_SUBMIT_BY" )]
+ public string VisableSubmitBy { get; set; }
+ /// <summary>
+ /// 鍙鎻愪氦鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="VISABLE_SUBMIT_DATE" )]
+ public DateTime? VisableSubmitDate { get; set; }
+ /// <summary>
+ /// 鏉垮瀷
+ ///</summary>
+ [SugarColumn(ColumnName="BOARD_STYLE" )]
+ public string BoardStyle { get; set; }
+ /// <summary>
+ /// 宸ュ崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_NO" )]
+ public string WorkNo { get; set; }
+ /// <summary>
+ /// 宸ュ崟琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_LINE" )]
+ public int? WorkLine { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPP_NO" )]
+ public string SuppNo { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_NO" )]
+ public string LineNo { get; set; }
+ /// <summary>
+ /// 鍗曟嵁缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="BILL_NO" )]
+ public string BillNo { get; set; }
+ /// <summary>
+ /// K3ID
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_K3ID" )]
+ public long? EbelnK3id { get; set; }
+ /// <summary>
+ /// 琛孠3ID
+ ///</summary>
+ [SugarColumn(ColumnName="LINE_K3ID" )]
+ public long? LineK3id { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public long? ItemId { get; set; }
+ }
+}
diff --git a/entity/MesItemType.cs b/entity/MesItemType.cs
new file mode 100644
index 0000000..db0c019
--- /dev/null
+++ b/entity/MesItemType.cs
@@ -0,0 +1,87 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_ITEM_TYPE")]
+ public class MesItemType
+ {
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ID
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="tcode" )]
+ public string Tcode { get; set; }
+ /// <summary>
+ /// 绫诲瀷鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="tname" )]
+ public string Tname { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// IQC鍒嗙被
+ ///</summary>
+ [SugarColumn(ColumnName="iqc_type" )]
+ public string IqcType { get; set; }
+ /// <summary>
+ /// IQC鍒嗙被鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="iqc_type_name" )]
+ public string IqcTypeName { get; set; }
+ /// <summary>
+ /// 涓婄骇鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName="pgroup" )]
+ public string Pgroup { get; set; }
+ /// <summary>
+ /// 鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName="description" )]
+ public string Description { get; set; }
+ }
+}
diff --git a/entity/MesItems.cs b/entity/MesItems.cs
new file mode 100644
index 0000000..c89691a
--- /dev/null
+++ b/entity/MesItems.cs
@@ -0,0 +1,273 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_ITEMS")]
+ public class MesItems
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public long Id { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="item_no" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="item_name" )]
+ public string ItemName { get; set; }
+ /// <summary>
+ /// 鐗╂枡绠�绉�
+ ///</summary>
+ [SugarColumn(ColumnName="item_sname" )]
+ public string ItemSname { get; set; }
+ /// <summary>
+ /// 瑙勬牸鍨嬪彿
+ ///</summary>
+ [SugarColumn(ColumnName="item_model" )]
+ public string ItemModel { get; set; }
+ /// <summary>
+ /// 鐗╂枡鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName="item_description" )]
+ public string ItemDescription { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="item_unit" )]
+ public string ItemUnit { get; set; }
+ /// <summary>
+ /// 鐗╂枡绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="item_type" )]
+ public string ItemType { get; set; }
+ /// <summary>
+ /// 浜у搧鐗堟湰
+ ///</summary>
+ [SugarColumn(ColumnName="item_version" )]
+ public string ItemVersion { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="cust_no" )]
+ public string CustNo { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏈�浣庡簱瀛�
+ ///</summary>
+ [SugarColumn(ColumnName="lowlimit" )]
+ public decimal? Lowlimit { get; set; }
+ /// <summary>
+ /// 鏈�澶у簱瀛�
+ ///</summary>
+ [SugarColumn(ColumnName="highlimit" )]
+ public decimal? Highlimit { get; set; }
+ /// <summary>
+ /// 鏈�灏忓寘瑁呮暟
+ ///</summary>
+ [SugarColumn(ColumnName="prd_pack" )]
+ public decimal? PrdPack { get; set; }
+ /// <summary>
+ /// 璁㈠崟鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="orderunit" )]
+ public string Orderunit { get; set; }
+ /// <summary>
+ /// 閿�鍞崟浣�
+ ///</summary>
+ [SugarColumn(ColumnName="saleunit" )]
+ public string Saleunit { get; set; }
+ /// <summary>
+ /// 搴撴埧鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="storeunit" )]
+ public string Storeunit { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="e_item_id" )]
+ public long? EItemId { get; set; }
+ /// <summary>
+ /// ERP鏂欏彿
+ ///</summary>
+ [SugarColumn(ColumnName="erp_item_no" )]
+ public string ErpItemNo { get; set; }
+ /// <summary>
+ /// 榛樿浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="depot_code" )]
+ public string DepotCode { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙被缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="ppbom00019124" )]
+ public string Ppbom00019124 { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName="remarks" )]
+ public string Remarks { get; set; }
+ /// <summary>
+ /// 閲囪喘鍛�
+ ///</summary>
+ [SugarColumn(ColumnName="fpurchaserid" )]
+ public string Fpurchaserid { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="fforbidstatus" )]
+ public string Fforbidstatus { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName="fmaterialgroup" )]
+ public string Fmaterialgroup { get; set; }
+ /// <summary>
+ /// 瀹屽伐瓒呮敹姣斾緥
+ ///</summary>
+ [SugarColumn(ColumnName="ffinishreceiptoverrate" )]
+ public int? Ffinishreceiptoverrate { get; set; }
+ /// <summary>
+ /// 鍙戞枡鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName="fissuetype" )]
+ public string Fissuetype { get; set; }
+ /// <summary>
+ /// 鍚敤鎵瑰彿绠＄悊
+ ///</summary>
+ [SugarColumn(ColumnName="fisbatchmanage" )]
+ public int? Fisbatchmanage { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="fpurchaseunitid" )]
+ public string Fpurchaseunitid { get; set; }
+ /// <summary>
+ /// 鎹熻�楃巼
+ ///</summary>
+ [SugarColumn(ColumnName="loss_percent" )]
+ public string LossPercent { get; set; }
+ /// <summary>
+ /// 鍔╄鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="mnemonic_code" )]
+ public string MnemonicCode { get; set; }
+ /// <summary>
+ /// 淇濊川鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="exp_period" )]
+ public string ExpPeriod { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName="production_workshop" )]
+ public string ProductionWorkshop { get; set; }
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ ///</summary>
+ [SugarColumn(ColumnName="material_properti" )]
+ public string MaterialProperti { get; set; }
+ /// <summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="produce_unit" )]
+ public string ProduceUnit { get; set; }
+ /// <summary>
+ /// 濮斿鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="subcon_unit" )]
+ public string SubconUnit { get; set; }
+ /// <summary>
+ /// 鍥剧墖1
+ ///</summary>
+ [SugarColumn(ColumnName="bz06" )]
+ public string Bz06 { get; set; }
+ /// <summary>
+ /// 鍥剧墖2
+ ///</summary>
+ [SugarColumn(ColumnName="bz07" )]
+ public string Bz07 { get; set; }
+ /// <summary>
+ /// 鍥剧墖3
+ ///</summary>
+ [SugarColumn(ColumnName="bz08" )]
+ public string Bz08 { get; set; }
+ /// <summary>
+ /// 鍥剧墖4
+ ///</summary>
+ [SugarColumn(ColumnName="bz09" )]
+ public string Bz09 { get; set; }
+ /// <summary>
+ /// 鍥剧墖5
+ ///</summary>
+ [SugarColumn(ColumnName="bz10" )]
+ public string Bz10 { get; set; }
+ /// <summary>
+ /// QC鍒嗙粍ID
+ ///</summary>
+ [SugarColumn(ColumnName="qc_teamid" )]
+ public string QcTeamid { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="item_id" )]
+ public long? ItemId { get; set; }
+ /// <summary>
+ /// 棰滆壊
+ ///</summary>
+ [SugarColumn(ColumnName="color_name" )]
+ public string ColorName { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ }
+}
diff --git a/entity/MesPosition.cs b/entity/MesPosition.cs
new file mode 100644
index 0000000..0a69e90
--- /dev/null
+++ b/entity/MesPosition.cs
@@ -0,0 +1,98 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_POSITION")]
+ public class MesPosition
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 宀椾綅缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="position_id" )]
+ public string PositionId { get; set; }
+ /// <summary>
+ /// 宀椾綅鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="position_name" )]
+ public string PositionName { get; set; }
+ /// <summary>
+ /// 宀椾綅鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName="position_description" )]
+ public string PositionDescription { get; set; }
+ /// <summary>
+ /// 鎵�灞為儴闂�
+ ///</summary>
+ [SugarColumn(ColumnName="department" )]
+ public string Department { get; set; }
+ /// <summary>
+ /// 寤虹珛鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="creation_date" )]
+ public DateTime? CreationDate { get; set; }
+ /// <summary>
+ /// 绂佺敤浜�
+ ///</summary>
+ [SugarColumn(ColumnName="disabled_by" )]
+ public string DisabledBy { get; set; }
+ /// <summary>
+ /// 绂佺敤鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="disabled_date" )]
+ public DateTime? DisabledDate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="remark1" )]
+ public string Remark1 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="remark2" )]
+ public string Remark2 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="remark3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="fforbidstatus" )]
+ public string Fforbidstatus { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ }
+}
diff --git a/entity/MesQaMj.cs b/entity/MesQaMj.cs
new file mode 100644
index 0000000..08707e3
--- /dev/null
+++ b/entity/MesQaMj.cs
@@ -0,0 +1,69 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 鍏嶆琛�
+ ///</summary>
+ [SugarTable("MES_QA_MJ")]
+ public class MesQaMj
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { 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>
+ /// 瀹℃牳鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="STATUS" )]
+ public bool? Status { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public int? ItemId { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPP_ID" )]
+ public string SuppId { get; set; }
+ }
+}
diff --git a/entity/MesQmAql1.cs b/entity/MesQmAql1.cs
new file mode 100644
index 0000000..d46c3a5
--- /dev/null
+++ b/entity/MesQmAql1.cs
@@ -0,0 +1,123 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯
+ ///</summary>
+ [SugarTable("MES_QM_AQL1")]
+ public class MesQmAql1
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_NAME" )]
+ public string CreateName { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏇存柊浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_NAME" )]
+ public string LastupdateName { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏍囧噯缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="SAMPLE_SIZE_NO" )]
+ public string SampleSizeNo { get; set; }
+ /// <summary>
+ /// 鏍囧噯鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="SAMPLE_SIZE_NAME" )]
+ public string SampleSizeName { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 鎵�灞炲伐鍘�
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 瀹℃壒鏍囪
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKED" )]
+ public bool? FoneChecked { get; set; }
+ /// <summary>
+ /// 瀹℃壒浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKOR" )]
+ public string FoneCheckor { get; set; }
+ /// <summary>
+ /// 瀹℃壒鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKDATE" )]
+ public DateTime? FoneCheckdate { get; set; }
+ /// <summary>
+ /// 纭鏍囪
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKED" )]
+ public bool? FtwoChecked { get; set; }
+ /// <summary>
+ /// 纭浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKOR" )]
+ public string FtwoCheckor { get; set; }
+ /// <summary>
+ /// 纭鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKDATE" )]
+ public DateTime? FtwoCheckdate { get; set; }
+ /// <summary>
+ /// 淇敼/鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="EDIT_STATUS" )]
+ public bool? EditStatus { get; set; }
+ /// <summary>
+ /// 鐗堟湰鍙�
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FVERSION" )]
+ public int? Fversion { get; set; }
+ /// <summary>
+ /// 鏄惁鍙敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ISENABLED" )]
+ public bool? Isenabled { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ }
+}
diff --git a/entity/MesQmAql2.cs b/entity/MesQmAql2.cs
new file mode 100644
index 0000000..6714779
--- /dev/null
+++ b/entity/MesQmAql2.cs
@@ -0,0 +1,119 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯鏍锋湰閲忓瓙鐮�
+ ///</summary>
+ [SugarTable("MES_QM_AQL2")]
+ public class MesQmAql2
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_NAME" )]
+ public string CreateName { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏇存柊浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_NAME" )]
+ public string LastupdateName { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鎵归噺寮�濮�
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_FROM" )]
+ public int? LotFrom { get; set; }
+ /// <summary>
+ /// 鎵归噺缁撴潫
+ ///</summary>
+ [SugarColumn(ColumnName="LOT_TO" )]
+ public int? LotTo { get; set; }
+ /// <summary>
+ /// 鐗规畩妫�楠屾按骞硘S-1
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_S1" )]
+ public string FlevelS1 { get; set; }
+ /// <summary>
+ /// 鐗规畩妫�楠屾按骞硘S-2
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_S2" )]
+ public string FlevelS2 { get; set; }
+ /// <summary>
+ /// 鐗规畩妫�楠屾按骞硘S-3
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_S3" )]
+ public string FlevelS3 { get; set; }
+ /// <summary>
+ /// 鐗规畩妫�楠屾按骞硘S-4
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_S4" )]
+ public string FlevelS4 { get; set; }
+ /// <summary>
+ /// 涓�鑸楠屾按骞硘I
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_I" )]
+ public string FlevelI { get; set; }
+ /// <summary>
+ /// 涓�鑸楠屾按骞硘II
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_II" )]
+ public string FlevelIi { get; set; }
+ /// <summary>
+ /// 涓�鑸楠屾按骞硘III
+ ///</summary>
+ [SugarColumn(ColumnName="FLEVEL_III" )]
+ public string FlevelIii { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 淇敼/鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="EDIT_STATUS" )]
+ public bool? EditStatus { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯ID
+ ///</summary>
+ [SugarColumn(ColumnName="AQL1_ID" )]
+ public Guid? Aql1Id { get; set; }
+ }
+}
diff --git a/entity/MesQmAql3.cs b/entity/MesQmAql3.cs
new file mode 100644
index 0000000..78cf8cc
--- /dev/null
+++ b/entity/MesQmAql3.cs
@@ -0,0 +1,239 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯鎶芥牱鏂规
+ ///</summary>
+ [SugarTable("MES_QM_AQL3")]
+ public class MesQmAql3
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_NAME" )]
+ public string CreateName { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏇存柊浜哄鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_NAME" )]
+ public string LastupdateName { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏍锋湰澶у皬
+ ///</summary>
+ [SugarColumn(ColumnName="FSAMPLE_SIZE_WORD" )]
+ public int? FsampleSizeWord { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.10
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_010" )]
+ public int? Aql0010 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.15
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_015" )]
+ public int? Aql0015 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.25
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_025" )]
+ public int? Aql0025 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.40
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_040" )]
+ public int? Aql0040 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.65
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_065" )]
+ public int? Aql0065 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1.0
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_100" )]
+ public int? Aql0100 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1.5
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_150" )]
+ public int? Aql0150 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩2.5
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_250" )]
+ public int? Aql0250 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩4.0
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_400" )]
+ public int? Aql0400 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩6.5
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_650" )]
+ public int? Aql0650 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩10
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_1_000" )]
+ public int? Aql1000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩15
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_1_500" )]
+ public int? Aql1500 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩25
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_2_500" )]
+ public int? Aql2500 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩40
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_4_000" )]
+ public int? Aql4000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩65
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_6_500" )]
+ public int? Aql6500 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩100
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_10_000" )]
+ public int? Aql10000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩150
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_15_000" )]
+ public int? Aql15000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩250
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_25_000" )]
+ public int? Aql25000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩400
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_40_000" )]
+ public int? Aql40000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩650
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_65_000" )]
+ public int? Aql65000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1000
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_100_000" )]
+ public int? Aql100000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1500
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_150_000" )]
+ public int? Aql150000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩2500
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_250_000" )]
+ public int? Aql250000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩4000
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_400_000" )]
+ public int? Aql400000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩6500
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_650_000" )]
+ public int? Aql650000 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩10000
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_1000_000" )]
+ public int? Aql1000000 { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 鏍锋湰澶у皬瀛楃爜
+ ///</summary>
+ [SugarColumn(ColumnName="SAMPLE_SIZE_WORD" )]
+ public string SampleSizeWord { get; set; }
+ /// <summary>
+ /// 淇敼/ 鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="EDIT_STATUS" )]
+ public byte? EditStatus { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.010
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_0010" )]
+ public int? Aql00010 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.015
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_0015" )]
+ public int? Aql00015 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.025
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_0025" )]
+ public int? Aql00025 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.040
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_0040" )]
+ public int? Aql00040 { get; set; }
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.065
+ ///</summary>
+ [SugarColumn(ColumnName="AQL_0_0065" )]
+ public int? Aql00065 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯ID
+ ///</summary>
+ [SugarColumn(ColumnName="AQL1_ID" )]
+ public Guid? Aql1Id { get; set; }
+ }
+}
diff --git a/entity/MesQmCheckitem.cs b/entity/MesQmCheckitem.cs
new file mode 100644
index 0000000..ec7079f
--- /dev/null
+++ b/entity/MesQmCheckitem.cs
@@ -0,0 +1,184 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// IQC銆丱QC妫�楠岄」鐩�
+ ///</summary>
+ [SugarTable("MES_QM_CHECKITEM")]
+ public class MesQmCheckitem
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 鐗╂枡浜у搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鍒嗙被
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="FTYPE" )]
+ public string Ftype { get; set; }
+ /// <summary>
+ /// 椤圭洰鍒嗙被(1:鎶芥 2:宸℃ 3:瀹屽伐妫�楠�)
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_TYPE" )]
+ public string CheckType { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="NAME1" )]
+ public string Name1 { get; set; }
+ /// <summary>
+ /// 鐗规畩瑙勬牸鐗╂枡
+ ///</summary>
+ [SugarColumn(ColumnName="FSPECIAL_ITEM" )]
+ public long? FspecialItem { get; set; }
+ /// <summary>
+ /// 鎵�灞炲伐鍘�
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 妫�楠屾按鍑�
+ ///</summary>
+ [SugarColumn(ColumnName="FINSPECTION_LEVEL" )]
+ public string FinspectionLevel { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_LEVEL" )]
+ public string FcheckLevel { get; set; }
+ /// <summary>
+ /// 鎺ユ敹姘村钩
+ ///</summary>
+ [SugarColumn(ColumnName="FRECEIVING_LEVEL" )]
+ public string FreceivingLevel { get; set; }
+ /// <summary>
+ /// 瀹℃壒鏍囪
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKED" )]
+ public bool? FoneChecked { get; set; }
+ /// <summary>
+ /// 瀹℃壒浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKOR" )]
+ public string FoneCheckor { get; set; }
+ /// <summary>
+ /// 瀹℃壒鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="FONE_CHECKDATE" )]
+ public DateTime? FoneCheckdate { get; set; }
+ /// <summary>
+ /// 鎵瑰噯鏍囪
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKED" )]
+ public bool? FtwoChecked { get; set; }
+ /// <summary>
+ /// 鎵瑰噯浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKOR" )]
+ public string FtwoCheckor { get; set; }
+ /// <summary>
+ /// 鎵瑰噯鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="FTWO_CHECKDATE" )]
+ public DateTime? FtwoCheckdate { get; set; }
+ /// <summary>
+ /// 淇敼/ 鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="EDIT_STATUS" )]
+ public bool? EditStatus { get; set; }
+ /// <summary>
+ /// 鐗堟湰
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FVERSION" )]
+ public long? Fversion { get; set; }
+ /// <summary>
+ /// 鏄惁鍙敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ISENABLED" )]
+ public bool? Isenabled { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="KUNNR" )]
+ public string Kunnr { get; set; }
+ /// <summary>
+ /// 鏈�澶ф娊妫�鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="MAX_CHECK_QTY" )]
+ public long? MaxCheckQty { get; set; }
+ /// <summary>
+ /// 鎻愰啋娆℃暟
+ ///</summary>
+ [SugarColumn(ColumnName="REM_QTY" )]
+ public long? RemQty { get; set; }
+ /// <summary>
+ /// 鏈璇佺墿鏂�
+ ///</summary>
+ [SugarColumn(ColumnName="OTHERFLAG" )]
+ public bool? Otherflag { get; set; }
+ /// <summary>
+ /// 鎴愬搧鐢垫睜绫诲瀷锛氬姩鍔�/ 鍌ㄨ兘
+ ///</summary>
+ [SugarColumn(ColumnName="BATTYPE" )]
+ public string Battype { get; set; }
+ /// <summary>
+ /// 椤圭洰鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="PROJECT_NAME" )]
+ public string ProjectName { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="TNAME" )]
+ public string Tname { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public long? ItemId { get; set; }
+ }
+}
diff --git a/entity/MesQmCheckitemDt.cs b/entity/MesQmCheckitemDt.cs
new file mode 100644
index 0000000..90805c2
--- /dev/null
+++ b/entity/MesQmCheckitemDt.cs
@@ -0,0 +1,224 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 妫�楠岄」鐩粠琛�
+ ///</summary>
+ [SugarTable("MES_QM_CHECKITEM_DT")]
+ public class MesQmCheckitemDt
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 鐗╂枡浜у搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 椤哄簭
+ ///</summary>
+ [SugarColumn(ColumnName="FORDER" )]
+ public long? Forder { get; set; }
+ /// <summary>
+ /// 涓婂叕宸�
+ ///</summary>
+ [SugarColumn(ColumnName="FUP_ALLOW" )]
+ public string FupAllow { get; set; }
+ /// <summary>
+ /// 妫�楠岄」鐩�
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_ITEM" )]
+ public string FcheckItem { get; set; }
+ /// <summary>
+ /// 鐗规畩鐗规�х被鍒�
+ ///</summary>
+ [SugarColumn(ColumnName="FSPEC_TYPE" )]
+ public string FspecType { get; set; }
+ /// <summary>
+ /// 澶囩敤
+ ///</summary>
+ [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )]
+ public long? WorkshopCenterCode { get; set; }
+ /// <summary>
+ /// 宸ュ簭
+ ///</summary>
+ [SugarColumn(ColumnName="PROC_NO" )]
+ public string ProcNo { get; set; }
+ /// <summary>
+ /// 妫�楠屾按鍑嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SAMPLE_SIZE_NO" )]
+ public string SampleSizeNo { get; set; }
+ /// <summary>
+ /// 妫�楠屽伐鍏�
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_TOOL" )]
+ public string FcheckTool { get; set; }
+ /// <summary>
+ /// 涓嬪叕宸�
+ ///</summary>
+ [SugarColumn(ColumnName="FDOWN_ALLOW" )]
+ public string FdownAllow { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_LEVEL" )]
+ public string FcheckLevel { get; set; }
+ /// <summary>
+ /// 鏍囧噯鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="FSTAND" )]
+ public string Fstand { get; set; }
+ /// <summary>
+ /// 鎺ユ敹姘村钩
+ ///</summary>
+ [SugarColumn(ColumnName="FAC_LEVEL" )]
+ public string FacLevel { get; set; }
+ /// <summary>
+ /// 澶囩敤
+ ///</summary>
+ [SugarColumn(ColumnName="FEATU_PROC" )]
+ public string FeatuProc { get; set; }
+ /// <summary>
+ /// 澶囩敤
+ ///</summary>
+ [SugarColumn(ColumnName="FEATU_PROD" )]
+ public string FeatuProd { get; set; }
+ /// <summary>
+ /// 澶囩敤
+ ///</summary>
+ [SugarColumn(ColumnName="AQL1_ID" )]
+ public string Aql1Id { get; set; }
+ /// <summary>
+ /// 澶囩敤
+ ///</summary>
+ [SugarColumn(ColumnName="FQA_TYPE" )]
+ public string FqaType { get; set; }
+ /// <summary>
+ /// 鏄惁妗ｄ綅
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="ISDANWEI" )]
+ public bool? Isdanwei { get; set; }
+ /// <summary>
+ /// 榛樿鐢ㄤ簬鍦ㄥ簱閲嶆
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="FTYPE" )]
+ public long? Ftype { get; set; }
+ /// <summary>
+ /// 淇敼/ 鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="EDIT_STATUS" )]
+ public bool? EditStatus { get; set; }
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_QTY" )]
+ public long? CheckQty { get; set; }
+ /// <summary>
+ /// 鍏佹敹鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="FAC_QTY" )]
+ public long? FacQty { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 棰戞
+ ///</summary>
+ [SugarColumn(ColumnName="FREQUENCY" )]
+ public string Frequency { get; set; }
+ /// <summary>
+ /// 瑙勬牸瑕佹眰
+ ///</summary>
+ [SugarColumn(ColumnName="FSPEC_REQU" )]
+ public string FspecRequ { get; set; }
+ /// <summary>
+ /// 椤圭洰绫诲埆
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_TYPE" )]
+ public string FcheckType { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="FUNIT" )]
+ public string Funit { get; set; }
+ /// <summary>
+ /// 鎶ヨ〃閫夋嫨
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="REPORF_CHECK" )]
+ public bool? ReporfCheck { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="GIVEN_MODIFY" )]
+ public bool? GivenModify { get; set; }
+ /// <summary>
+ /// UCL_X璁惧畾鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="FUCL" )]
+ public decimal? Fucl { get; set; }
+ /// <summary>
+ /// LCL_X璁惧畾鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="FLCL" )]
+ public decimal? Flcl { get; set; }
+ /// <summary>
+ /// UCL_R璁惧畾鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="FRUCL" )]
+ public decimal? Frucl { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public long? ItemId { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="pid" )]
+ public Guid? Pid { get; set; }
+ }
+}
diff --git a/entity/MesRohIn.cs b/entity/MesRohIn.cs
new file mode 100644
index 0000000..0822787
--- /dev/null
+++ b/entity/MesRohIn.cs
@@ -0,0 +1,258 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛�
+ ///</summary>
+ [SugarTable("MES_ROH_IN")]
+ public class MesRohIn
+ {
+ /// <summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="BILL_NO" )]
+ public string BillNo { get; set; }
+ /// <summary>
+ /// 鍗曟嵁鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="DOCUMENT_STATUS" )]
+ public string DocumentStatus { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="DOCUMENT_TYPE" )]
+ public string DocumentType { get; set; }
+ /// <summary>
+ /// 涓氬姟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="BUSINESS_TYPE" )]
+ public string BusinessType { get; set; }
+ /// <summary>
+ /// 閲囪喘鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_DATE" )]
+ public DateTime? PurchaseDate { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPPLIER" )]
+ public string Supplier { get; set; }
+ /// <summary>
+ /// 鍏抽棴鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="CLOSE_STATUS" )]
+ public string CloseStatus { get; set; }
+ /// <summary>
+ /// 閲囪喘缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_ORG" )]
+ public string PurchaseOrg { get; set; }
+ /// <summary>
+ /// 閲囪喘閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_DEPT" )]
+ public string PurchaseDept { get; set; }
+ /// <summary>
+ /// 閲囪喘缁�
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_GROUP" )]
+ public string PurchaseGroup { get; set; }
+ /// <summary>
+ /// 鏁伴噺楠屾敹
+ ///</summary>
+ [SugarColumn(ColumnName="QTY_ACCEPTANCE" )]
+ public string QtyAcceptance { get; set; }
+ /// <summary>
+ /// 閲囪喘鍛�
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASER" )]
+ public string Purchaser { get; set; }
+ /// <summary>
+ /// 璐ㄩ噺瑕佹眰
+ ///</summary>
+ [SugarColumn(ColumnName="QUALITY_REQ" )]
+ public string QualityReq { get; set; }
+ /// <summary>
+ /// 缁撶畻鏂�
+ ///</summary>
+ [SugarColumn(ColumnName="SETTLEMENT_PARTY" )]
+ public string SettlementParty { get; set; }
+ /// <summary>
+ /// 鏀舵鏂�
+ ///</summary>
+ [SugarColumn(ColumnName="PAYMENT_PARTY" )]
+ public string PaymentParty { get; set; }
+ /// <summary>
+ /// 閭
+ ///</summary>
+ [SugarColumn(ColumnName="EMAIL" )]
+ public string Email { get; set; }
+ /// <summary>
+ /// 杩愯緭鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName="TRANSPORT_METHOD" )]
+ public string TransportMethod { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="REMARKS" )]
+ public string Remarks { get; set; }
+ /// <summary>
+ /// 娌诲叿涓舵ā鍏峰姞宸ュ強閲囪喘
+ ///</summary>
+ [SugarColumn(ColumnName="FIXTURE_MOLD_PROCUREMENT" )]
+ public string FixtureMoldProcurement { get; set; }
+ /// <summary>
+ /// 浣滃簾鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="CANCELLATION_STATUS" )]
+ public string CancellationStatus { get; set; }
+ /// <summary>
+ /// 浣滃簾浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CANCELLATION_PERSON" )]
+ public string CancellationPerson { get; set; }
+ /// <summary>
+ /// 浣滃簾鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CANCELLATION_DATE" )]
+ public DateTime? CancellationDate { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀规椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀逛汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_CHECK_BY" )]
+ public string ErpCheckBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_CHECK_DATE" )]
+ public string ErpCheckDate { get; set; }
+ /// <summary>
+ /// ERP鐨処D鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_K3ID" )]
+ public long? EbelnK3id { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_DATE" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_BY" )]
+ public string CheckBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏍囪瘑
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_FALG" )]
+ public int? CheckFalg { get; set; }
+ /// <summary>
+ /// 鎵撳嵃娆℃暟
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK1" )]
+ public string Remark1 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�2
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK2" )]
+ public string Remark2 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="CHANGEREASON" )]
+ public string Changereason { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="Prearrivaldate" )]
+ public DateTime? Prearrivaldate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="ReceiveOrgId" )]
+ public string ReceiveOrgId { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="Provider_Id" )]
+ public string ProviderId { get; set; }
+ /// <summary>
+ /// 鑱旂郴浜�
+ ///</summary>
+ [SugarColumn(ColumnName="anred" )]
+ public string Anred { get; set; }
+ /// <summary>
+ /// 鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="telf1" )]
+ public string Telf1 { get; set; }
+ /// <summary>
+ /// 鍥哄畾鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="Fixed_Telephone" )]
+ public string FixedTelephone { get; set; }
+ /// <summary>
+ /// 閫氳鍦板潃
+ ///</summary>
+ [SugarColumn(ColumnName="Address" )]
+ public string Address { get; set; }
+ /// <summary>
+ /// 楠屾敹鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName="Acctype" )]
+ public string Acctype { get; set; }
+ }
+}
diff --git a/entity/MesRohInData.cs b/entity/MesRohInData.cs
new file mode 100644
index 0000000..04564ea
--- /dev/null
+++ b/entity/MesRohInData.cs
@@ -0,0 +1,309 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 閲囪喘璁㈠崟鏄庣粏琛�
+ ///</summary>
+ [SugarTable("MES_ROH_IN_DATA")]
+ public class MesRohInData
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="BILL_NO" )]
+ public string BillNo { 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="ITEM_ID" )]
+ public string ItemId { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_UNIT" )]
+ public string PurchaseUnit { get; set; }
+ /// <summary>
+ /// 閲囪喘鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_QTY" )]
+ public decimal? PurchaseQty { get; set; }
+ /// <summary>
+ /// 搴撳瓨鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="INVENTORY_UNIT" )]
+ public string InventoryUnit { get; set; }
+ /// <summary>
+ /// 璁′环鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="PRICING_UNIT" )]
+ public string PricingUnit { get; set; }
+ /// <summary>
+ /// 璁′环鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="PRICING_QTY" )]
+ public decimal? PricingQty { get; set; }
+ /// <summary>
+ /// 浜よ揣鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="DELIVERY_DATE" )]
+ public DateTime? DeliveryDate { get; set; }
+ /// <summary>
+ /// 鏈�鏃╀氦璐ф棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="EARLIEST_DELIVERY_DATE" )]
+ public DateTime? EarliestDeliveryDate { get; set; }
+ /// <summary>
+ /// 鏈�鏅氫氦璐ф棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="LATEST_DELIVERY_DATE" )]
+ public DateTime? LatestDeliveryDate { get; set; }
+ /// <summary>
+ /// 闇�姹傜粍缁�
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_ORG" )]
+ public string DemandOrg { get; set; }
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="RECEIVING_ORG" )]
+ public string ReceivingOrg { get; set; }
+ /// <summary>
+ /// 缁撶畻缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="SETTLEMENT_ORG" )]
+ public string SettlementOrg { get; set; }
+ /// <summary>
+ /// 鏄惁璧犲搧
+ ///</summary>
+ [SugarColumn(ColumnName="IS_GIFT" )]
+ public string IsGift { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="REMARKS" )]
+ public string Remarks { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙墿鏂欑紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPPLIER_ITEM_CODE" )]
+ public string SupplierItemCode { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙墿鏂欏悕绉�
+ ///</summary>
+ [SugarColumn(ColumnName="SUPPLIER_ITEM_NAME" )]
+ public string SupplierItemName { get; set; }
+ /// <summary>
+ /// 濮斿璁㈠崟缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="OUTSOURCING_ORDER_ID" )]
+ public string OutsourcingOrderId { get; set; }
+ /// <summary>
+ /// 鎵瑰彿
+ ///</summary>
+ [SugarColumn(ColumnName="BATCH_NUMBER" )]
+ public string BatchNumber { get; set; }
+ /// <summary>
+ /// 涓氬姟鍏抽棴
+ ///</summary>
+ [SugarColumn(ColumnName="BUSINESS_CLOSE" )]
+ public string BusinessClose { get; set; }
+ /// <summary>
+ /// 涓氬姟鍐荤粨
+ ///</summary>
+ [SugarColumn(ColumnName="BUSINESS_FREEZE" )]
+ public string BusinessFreeze { get; set; }
+ /// <summary>
+ /// 鍐荤粨浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FREEZER" )]
+ public string Freezer { get; set; }
+ /// <summary>
+ /// 鍐荤粨鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="FREEZE_TIME" )]
+ public DateTime? FreezeTime { get; set; }
+ /// <summary>
+ /// 涓氬姟缁堟
+ ///</summary>
+ [SugarColumn(ColumnName="BUSINESS_TERMINATE" )]
+ public string BusinessTerminate { get; set; }
+ /// <summary>
+ /// 缁堟浜�
+ ///</summary>
+ [SugarColumn(ColumnName="TERMINATOR" )]
+ public string Terminator { get; set; }
+ /// <summary>
+ /// 缁堟鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="TERMINATE_TIME" )]
+ public DateTime? TerminateTime { get; set; }
+ /// <summary>
+ /// 绱鏀舵枡鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="TOTAL_RECEIVED_QTY" )]
+ public int? TotalReceivedQty { get; set; }
+ /// <summary>
+ /// 鍓╀綑鏀舵枡鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="REMAINING_RECEIVED_QTY" )]
+ public decimal? RemainingReceivedQty { get; set; }
+ /// <summary>
+ /// 绱鍏ュ簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="TOTAL_STORED_QTY" )]
+ public int? TotalStoredQty { get; set; }
+ /// <summary>
+ /// 鍓╀綑鍏ュ簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="REMAINING_STORED_QTY" )]
+ public decimal? RemainingStoredQty { get; set; }
+ /// <summary>
+ /// 绱閫�鏂欐暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="TOTAL_RETURNED_QTY" )]
+ public int? TotalReturnedQty { get; set; }
+ /// <summary>
+ /// 鏀舵枡鍙��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="RETURNABLE_RECEIVED_QTY" )]
+ public int? ReturnableReceivedQty { get; set; }
+ /// <summary>
+ /// 搴撳瓨鍙��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="RETURNABLE_STORED_QTY" )]
+ public int? ReturnableStoredQty { get; set; }
+ /// <summary>
+ /// 婧愬崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="SOURCE_DOCUMENT_TYPE" )]
+ public string SourceDocumentType { get; set; }
+ /// <summary>
+ /// 婧愬崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="SOURCE_DOCUMENT_ID" )]
+ public string SourceDocumentId { get; set; }
+ /// <summary>
+ /// 闇�姹傝窡韪彿
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_TRACKING_ID" )]
+ public string DemandTrackingId { get; set; }
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="PLAN_TRACKING_ID" )]
+ public string PlanTrackingId { get; set; }
+ /// <summary>
+ /// 鍙樻洿鏍囧織
+ ///</summary>
+ [SugarColumn(ColumnName="CHANGE_FLAG" )]
+ public string ChangeFlag { get; set; }
+ /// <summary>
+ /// 闇�姹傛潵婧�
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_SOURCE" )]
+ public string DemandSource { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鎹紪鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_DOCUMENT_ID" )]
+ public string DemandDocumentId { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鎹鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_DOCUMENT_LINE_ID" )]
+ public string DemandDocumentLineId { get; set; }
+ /// <summary>
+ /// ERP鐨処D鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="EBELN_K3ID" )]
+ public int? EbelnK3id { get; set; }
+ /// <summary>
+ /// 瀹㈡埛璐у彿
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK1" )]
+ public string Remark1 { get; set; }
+ /// <summary>
+ /// 鍖呰鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK2" )]
+ public string Remark2 { get; set; }
+ /// <summary>
+ /// 涓讳骇鍝�
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// SMT澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// ERP鐨勫ごID鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_ID" )]
+ public int? ErpId { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="PURCHASE_ORDER_LINE_NUMBER" )]
+ public string PurchaseOrderLineNumber { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND" )]
+ public string Demand { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="RECEIVING" )]
+ public string Receiving { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="SETTLEMENT" )]
+ public string Settlement { get; set; }
+ /// <summary>
+ /// erp鎺ㄦ潵鐨勫凡浜よ揣鏁伴噺
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="CGB014" )]
+ public int? Cgb014 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DEMAND_DEPARTMENT" )]
+ public string DemandDepartment { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="RECEIVING_DEPARTMENT" )]
+ public string ReceivingDepartment { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FPREARRIVALDATE" )]
+ public DateTime? Fprearrivaldate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FDEMANDBILLNO_LINE" )]
+ public string FdemandbillnoLine { get; set; }
+ }
+}
diff --git a/entity/MesStaff.cs b/entity/MesStaff.cs
new file mode 100644
index 0000000..c8be4a4
--- /dev/null
+++ b/entity/MesStaff.cs
@@ -0,0 +1,134 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_STAFF")]
+ public class MesStaff
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ID
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 鍛樺伐缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="staff_no" )]
+ public string StaffNo { get; set; }
+ /// <summary>
+ /// 鍛樺伐濮撳悕
+ ///</summary>
+ [SugarColumn(ColumnName="staff_name" )]
+ public string StaffName { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="department_no" )]
+ public string DepartmentNo { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="department_name" )]
+ public string DepartmentName { get; set; }
+ /// <summary>
+ /// 宀椾綅缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="position_code" )]
+ public string PositionCode { get; set; }
+ /// <summary>
+ /// 宀椾綅鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="position_name" )]
+ public string PositionName { get; set; }
+ /// <summary>
+ /// 鎵嬫満鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="phone_number" )]
+ public string PhoneNumber { get; set; }
+ /// <summary>
+ /// 浠诲矖寮�濮嬫棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="start_date" )]
+ public DateTime? StartDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName="remark3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏇存柊浜�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏇存柊鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="memo" )]
+ public string Memo { get; set; }
+ /// <summary>
+ /// 鐢熶骇绾�
+ ///</summary>
+ [SugarColumn(ColumnName="line_no" )]
+ public string LineNo { get; set; }
+ /// <summary>
+ /// 鐢熶骇鍛樺伐鏍囪瘑
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName="work_mk" )]
+ public int? WorkMk { get; set; }
+ /// <summary>
+ /// 鏄惁绂佺敤
+ ///</summary>
+ [SugarColumn(ColumnName="fforbid_status" )]
+ public string FforbidStatus { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ }
+}
diff --git a/entity/MesSupplier.cs b/entity/MesSupplier.cs
new file mode 100644
index 0000000..a60984c
--- /dev/null
+++ b/entity/MesSupplier.cs
@@ -0,0 +1,156 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_SUPPLIER")]
+ public class MesSupplier
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ID
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="supp_no" )]
+ public string SuppNo { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗗悕绉�
+ ///</summary>
+ [SugarColumn(ColumnName="supp_name" )]
+ public string SuppName { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟嗙畝绉�
+ ///</summary>
+ [SugarColumn(ColumnName="supp_sname" )]
+ public string SuppSname { get; set; }
+ /// <summary>
+ /// 鍦板尯
+ ///</summary>
+ [SugarColumn(ColumnName="land1" )]
+ public string Land1 { get; set; }
+ /// <summary>
+ /// 鍦板潃
+ ///</summary>
+ [SugarColumn(ColumnName="stras" )]
+ public string Stras { get; set; }
+ /// <summary>
+ /// 鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="telf1" )]
+ public string Telf1 { get; set; }
+ /// <summary>
+ /// 浼犵湡
+ ///</summary>
+ [SugarColumn(ColumnName="telfx" )]
+ public string Telfx { get; set; }
+ /// <summary>
+ /// 璁板綍鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�杩戞洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�杩戞洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 绠�鐮�(鎵撳嵃鏉＄爜鐢�)
+ ///</summary>
+ [SugarColumn(ColumnName="fscode" )]
+ public string Fscode { get; set; }
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏄惁鍏辩(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="item_c" )]
+ public int? ItemC { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏄惁鍥炲啓SAP鎺ュ彛(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="item_sap" )]
+ public int? ItemSap { get; set; }
+ /// <summary>
+ /// 鏄惁鎵规绠＄悊(鏄紝鍚�)
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="lot_flag" )]
+ public int? LotFlag { get; set; }
+ /// <summary>
+ /// 鑱旂郴浜�
+ ///</summary>
+ [SugarColumn(ColumnName="lxr" )]
+ public string Lxr { get; set; }
+ /// <summary>
+ /// 璐熻矗浜�
+ ///</summary>
+ [SugarColumn(ColumnName="fstaffid" )]
+ public string Fstaffid { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="fforbidstatus" )]
+ public string Fforbidstatus { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName="remark3" )]
+ public string Remark3 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ }
+}
diff --git a/entity/MesSysLookupTypes.cs b/entity/MesSysLookupTypes.cs
new file mode 100644
index 0000000..9adfa96
--- /dev/null
+++ b/entity/MesSysLookupTypes.cs
@@ -0,0 +1,108 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 绯荤粺蹇爜鍒嗙被琛�
+ ///</summary>
+ [SugarTable("MES_SYS_LOOKUP_TYPES")]
+ public class MesSysLookupTypes
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_TYPE_CODE" )]
+ public string LookupTypeCode { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜绫诲瀷鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_TYPE_NAME" )]
+ public string LookupTypeName { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜绫诲瀷|0-绯荤粺绾э紝1-鐢ㄦ埛绾э紝绯荤粺绾т笉鍏佽淇敼
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_TYPE" )]
+ public byte? LookupType { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜绉嶇被|涓氬姟鍒嗙被
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_SORT" )]
+ public string LookupSort { get; set; }
+ /// <summary>
+ /// 鍏佽淇敼鏄剧ず鍊紎0-鍚︼紝1-鏄�
+ ///</summary>
+ [SugarColumn(ColumnName="ALLOW_UPDATE_FLAG" )]
+ public byte? AllowUpdateFlag { get; set; }
+ /// <summary>
+ /// 鍏佽澧炲姞璁板綍|0-鍚︼紝1-鏄�
+ ///</summary>
+ [SugarColumn(ColumnName="ALLOW_ADD_FLAG" )]
+ public byte? AllowAddFlag { get; set; }
+ /// <summary>
+ /// 鍏佽鍒犻櫎璁板綍|0-鍚︼紝1-鏄�
+ ///</summary>
+ [SugarColumn(ColumnName="ALLOW_DEL_FLAG" )]
+ public byte? AllowDelFlag { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="DESCRIPTION" )]
+ public string Description { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 妯″潡绫诲埆
+ ///</summary>
+ [SugarColumn(ColumnName="FTYPE" )]
+ public string Ftype { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="check_date" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName="check_by" )]
+ public string CheckBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="check_status" )]
+ public bool? CheckStatus { get; set; }
+ }
+}
diff --git a/entity/MesSysLookups.cs b/entity/MesSysLookups.cs
new file mode 100644
index 0000000..701de74
--- /dev/null
+++ b/entity/MesSysLookups.cs
@@ -0,0 +1,98 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 绯荤粺蹇爜琛�
+ ///</summary>
+ [SugarTable("MES_SYS_LOOKUPS")]
+ public class MesSysLookups
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_VALUE" )]
+ public string LookupValue { get; set; }
+ /// <summary>
+ /// 绯荤粺蹇爜鏄剧ず鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_NAME" )]
+ public string LookupName { get; set; }
+ /// <summary>
+ /// 椤哄簭鍊�
+ ///</summary>
+ [SugarColumn(ColumnName="ORDER_NO" )]
+ public long? OrderNo { get; set; }
+ /// <summary>
+ /// 鍐呴儴浠ｇ爜|绯荤粺鐗规畩浣跨敤
+ ///</summary>
+ [SugarColumn(ColumnName="INSIDE_CODE" )]
+ public string InsideCode { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="DESCRIPTION" )]
+ public string Description { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 宸ヤ綔涓績缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_CENTER" )]
+ public string WorkCenter { get; set; }
+ /// <summary>
+ /// 宸ヤ綔涓績鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_CENTER_NAME" )]
+ public string WorkCenterName { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="FACTORY" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍒嗙被(鎵嬪伐鍜岃嚜鍔�)
+ ///</summary>
+ [SugarColumn(ColumnName="F_TYPE" )]
+ public string FType { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="COMPANY" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 妫�鏌ュぇ绫�
+ ///</summary>
+ [SugarColumn(ColumnName="FQM_TYPE_ID" )]
+ public string FqmTypeId { get; set; }
+ /// <summary>
+ /// 鐖秈d
+ ///</summary>
+ [SugarColumn(ColumnName="LOOKUP_GUID" )]
+ public Guid? LookupGuid { get; set; }
+ }
+}
diff --git a/entity/MesSysPageview.cs b/entity/MesSysPageview.cs
new file mode 100644
index 0000000..a56145d
--- /dev/null
+++ b/entity/MesSysPageview.cs
@@ -0,0 +1,35 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using SqlSugar;
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 椤甸潰閰嶇疆琛�
+ ///</summary>
+ [SugarTable("MES_SYS_PAGEVIEW")]
+ public class MesSysPageview
+ {
+ /// <summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 椤甸潰涓枃鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="PAGE_VIEW" )]
+ public string PageView { get; set; }
+ /// <summary>
+ /// 椤甸潰璺緞
+ ///</summary>
+ [SugarColumn(ColumnName="PATH" )]
+ public string Path { get; set; }
+ /// <summary>
+ /// 椤甸潰鍥炬爣
+ ///</summary>
+ [SugarColumn(ColumnName="ICOIMG" )]
+ public string Icoimg { get; set; }
+ }
+}
diff --git a/entity/MesUnit.cs b/entity/MesUnit.cs
new file mode 100644
index 0000000..2accf9e
--- /dev/null
+++ b/entity/MesUnit.cs
@@ -0,0 +1,128 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MES_UNIT")]
+ public class MesUnit
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// BASEINFO
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int Id { get; set; }
+ /// <summary>
+ /// 鍘熷崟浣�
+ ///</summary>
+ [SugarColumn(ColumnName="oldunit" )]
+ public string Oldunit { get; set; }
+ /// <summary>
+ /// 鐩殑鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="newunit" )]
+ public string Newunit { get; set; }
+ /// <summary>
+ /// 鍘熷崟浣嶆暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="oldqty" )]
+ public int? Oldqty { get; set; }
+ /// <summary>
+ /// 鐩殑鍗曚綅鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="newqty" )]
+ public int? Newqty { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="fnumber" )]
+ public string Fnumber { get; set; }
+ /// <summary>
+ /// 鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="fname" )]
+ public string Fname { get; set; }
+ /// <summary>
+ /// 鎵�灞炵粍鍒�
+ ///</summary>
+ [SugarColumn(ColumnName="funitgroupid" )]
+ public string Funitgroupid { get; set; }
+ /// <summary>
+ /// 鎹㈢畻鍒嗘瘝
+ ///</summary>
+ [SugarColumn(ColumnName="fconvertdenominator" )]
+ public decimal? Fconvertdenominator { get; set; }
+ /// <summary>
+ /// 褰撳墠鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="fcurrentunitid" )]
+ public string Fcurrentunitid { get; set; }
+ /// <summary>
+ /// 鎹㈢畻鍒嗗瓙
+ ///</summary>
+ [SugarColumn(ColumnName="fconvertnumerator" )]
+ public decimal? Fconvertnumerator { get; set; }
+ /// <summary>
+ /// 鍩哄噯鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="fbaseunit" )]
+ public string Fbaseunit { get; set; }
+ /// <summary>
+ /// 鑸嶅叆绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="froundtype" )]
+ public string Froundtype { get; set; }
+ /// <summary>
+ /// 绮惧害
+ ///</summary>
+ [SugarColumn(ColumnName="fprecision" )]
+ public int? Fprecision { get; set; }
+ /// <summary>
+ /// 鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName="fdescription" )]
+ public string Fdescription { get; set; }
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="fforbidstatus" )]
+ public string Fforbidstatus { get; set; }
+ }
+}
diff --git a/entity/MessageCenter.cs b/entity/MessageCenter.cs
new file mode 100644
index 0000000..aed92ec
--- /dev/null
+++ b/entity/MessageCenter.cs
@@ -0,0 +1,145 @@
+锘縰sing NewPdaSqlServer.Dto.@base;
+using SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("MESSAGE_CENTER")]
+ public class MessageCenter : Page
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "table_name")]
+ public string? TableName { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "url")]
+ public string? Url { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "method")]
+ public string? Method { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "result")]
+ public int? Result { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "result_data")]
+ public string? ResultData { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "status")]
+ public int? Status { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "create_by")]
+ public string? CreateBy { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "create_date")]
+ public string? CreateDate { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "title")]
+ public string? Title { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "page_name")]
+ public string? PageName { get; set; }
+
+ /// <summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName = "deal_with")]
+ public int? DealWith { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "pid")]
+ public int? Pid { get; set; }
+
+ /// <summary>
+ ///
+ /// 榛樿鍊�: ((1))
+ ///</summary>
+ [SugarColumn(ColumnName = "seq")]
+ public int? Seq { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "route")]
+ public string? Route { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "data")]
+ public string? Data { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "content_type")]
+ public string? ContentType { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "is_message")]
+ public int? IsMessage { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "update_date")]
+ public string? UpdateDate { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "update_by")]
+ public string? UpdateBy { get; set; }
+
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "prc_mame")]
+ public string? PrcMame { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public int? isShow { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public decimal? Count { get; set; }
+ }
+}
\ No newline at end of file
diff --git a/entity/Purdhb.cs b/entity/Purdhb.cs
new file mode 100644
index 0000000..6f70e6c
--- /dev/null
+++ b/entity/Purdhb.cs
@@ -0,0 +1,233 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 閲囪喘鍒拌揣鍗曡〃韬�
+ ///</summary>
+ [SugarTable("PURDHB")]
+ public class Purdhb
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB001" )]
+ public string Dhb001 { get; set; }
+ /// <summary>
+ /// 搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB002" )]
+ public string Dhb002 { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="DHB003" )]
+ public string Dhb003 { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="DHB004" )]
+ public string Dhb004 { get; set; }
+ /// <summary>
+ /// 鐗╂枡瑙勬牸
+ ///</summary>
+ [SugarColumn(ColumnName="DHB005" )]
+ public string Dhb005 { get; set; }
+ /// <summary>
+ /// 浜よ揣鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DHB006" )]
+ public int? Dhb006 { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="DHB007" )]
+ public string Dhb007 { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="DHB008" )]
+ public string Dhb008 { get; set; }
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="DHB009" )]
+ public string Dhb009 { get; set; }
+ /// <summary>
+ /// 鎵瑰彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB010" )]
+ public string Dhb010 { get; set; }
+ /// <summary>
+ /// 鏉ユ簮鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB011" )]
+ public string Dhb011 { get; set; }
+ /// <summary>
+ /// 鏉ユ簮搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB012" )]
+ public int? Dhb012 { get; set; }
+ /// <summary>
+ /// 娓呯偣鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DHB013" )]
+ public int? Dhb013 { get; set; }
+ /// <summary>
+ /// 鍒板巶鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="DHB014" )]
+ public string Dhb014 { get; set; }
+ /// <summary>
+ /// 楠屾敹鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DHB015" )]
+ public int? Dhb015 { get; set; }
+ /// <summary>
+ /// 楠岄��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DHB016" )]
+ public int? Dhb016 { get; set; }
+ /// <summary>
+ /// 杩涜揣鍗曚环
+ ///</summary>
+ [SugarColumn(ColumnName="DHB017" )]
+ public int? Dhb017 { get; set; }
+ /// <summary>
+ /// 杩涜揣閲戦
+ ///</summary>
+ [SugarColumn(ColumnName="DHB018" )]
+ public int? Dhb018 { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鏂欏彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB019" )]
+ public string Dhb019 { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="DHB020" )]
+ public string Dhb020 { get; set; }
+ /// <summary>
+ /// 璧犲搧鏁�
+ ///</summary>
+ [SugarColumn(ColumnName="DHB021" )]
+ public int? Dhb021 { get; set; }
+ /// <summary>
+ /// 鏇存柊ERP
+ ///</summary>
+ [SugarColumn(ColumnName="DHB022" )]
+ public string Dhb022 { get; set; }
+ /// <summary>
+ /// 妫�楠岀姸鎬�
+ ///</summary>
+ [SugarColumn(ColumnName="DHB023" )]
+ public string Dhb023 { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="DHB024" )]
+ public string Dhb024 { get; set; }
+ /// <summary>
+ /// 瀹℃牳
+ ///</summary>
+ [SugarColumn(ColumnName="AUDITING" )]
+ public int? Auditing { get; set; }
+ /// <summary>
+ /// ERP閲囪喘鍗曞彿ID
+ ///</summary>
+ [SugarColumn(ColumnName="DHB026" )]
+ public int? Dhb026 { get; set; }
+ /// <summary>
+ /// ERP閲囪喘搴忓彿ID
+ ///</summary>
+ [SugarColumn(ColumnName="DHB027" )]
+ public int? Dhb027 { get; set; }
+ /// <summary>
+ /// ERP鐗╂枡ID
+ ///</summary>
+ [SugarColumn(ColumnName="DHB028" )]
+ public int? Dhb028 { get; set; }
+ /// <summary>
+ /// 寰呮鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DHB029" )]
+ public int? Dhb029 { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="DHB030" )]
+ public string Dhb030 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅1
+ ///</summary>
+ [SugarColumn(ColumnName="DHB031" )]
+ public string Dhb031 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅2
+ ///</summary>
+ [SugarColumn(ColumnName="DHB032" )]
+ public int? Dhb032 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅3
+ ///</summary>
+ [SugarColumn(ColumnName="DHB033" )]
+ public string Dhb033 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅4
+ ///</summary>
+ [SugarColumn(ColumnName="DHB034" )]
+ public string Dhb034 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅5
+ ///</summary>
+ [SugarColumn(ColumnName="DHB035" )]
+ public int? Dhb035 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅6
+ ///</summary>
+ [SugarColumn(ColumnName="DHB037" )]
+ public int? Dhb037 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅7
+ ///</summary>
+ [SugarColumn(ColumnName="DHB036" )]
+ public string Dhb036 { get; set; }
+ /// <summary>
+ /// 澶囨敞淇℃伅8
+ ///</summary>
+ [SugarColumn(ColumnName="DHB038" )]
+ public int? Dhb038 { get; set; }
+ /// <summary>
+ /// ERP婧愬崟鍐呯爜
+ ///</summary>
+ [SugarColumn(ColumnName="DHB039" )]
+ public int? Dhb039 { get; set; }
+ /// <summary>
+ /// ERP婧愬崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="DHB040" )]
+ public int? Dhb040 { get; set; }
+ /// <summary>
+ /// ERP璁㈠崟鍐呯爜
+ ///</summary>
+ [SugarColumn(ColumnName="DHB041" )]
+ public int? Dhb041 { get; set; }
+ /// <summary>
+ /// 鏄惁妫�楠岋紝1涓哄凡妫�
+ ///</summary>
+ [SugarColumn(ColumnName="ISCHECK" )]
+ public int? Ischeck { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="DHB042" )]
+ public string Dhb042 { get; set; }
+ }
+}
diff --git a/entity/Purdka.cs b/entity/Purdka.cs
new file mode 100644
index 0000000..0a80084
--- /dev/null
+++ b/entity/Purdka.cs
@@ -0,0 +1,113 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 閫�鏂欏崟澶�
+ ///</summary>
+ [SugarTable("PURDKA")]
+ public class Purdka
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜哄憳
+ ///</summary>
+ [SugarColumn(ColumnName="CREATEUSER" )]
+ public string Createuser { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATETIME" )]
+ public string Createtime { get; set; }
+ /// <summary>
+ /// 淇敼鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="MODIFYTIME" )]
+ public string Modifytime { get; set; }
+ /// <summary>
+ /// 淇敼浜哄憳
+ ///</summary>
+ [SugarColumn(ColumnName="MODIFYUSER" )]
+ public string Modifyuser { get; set; }
+ /// <summary>
+ /// 瀹℃牳
+ ///</summary>
+ [SugarColumn(ColumnName="AUDITING" )]
+ public string Auditing { get; set; }
+ /// <summary>
+ /// 閫�璐у崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="DKA001" )]
+ public string Dka001 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA002" )]
+ public string Dka002 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA003" )]
+ public string Dka003 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA004" )]
+ public string Dka004 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA005" )]
+ public string Dka005 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA006" )]
+ public string Dka006 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA007" )]
+ public string Dka007 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA008" )]
+ public string Dka008 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA009" )]
+ public string Dka009 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA010" )]
+ public string Dka010 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="ERPID" )]
+ public int? Erpid { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA011" )]
+ public string Dka011 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="DKA012" )]
+ public string Dka012 { get; set; }
+ /// <summary>
+ /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
+ ///</summary>
+ [SugarColumn(ColumnName="DKA013" )]
+ public int? Dka013 { get; set; }
+ }
+}
diff --git a/entity/Purdkb.cs b/entity/Purdkb.cs
new file mode 100644
index 0000000..0ca723b
--- /dev/null
+++ b/entity/Purdkb.cs
@@ -0,0 +1,123 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 閫�鏂欏崟瀛愯〃
+ ///</summary>
+ [SugarTable("PURDKB")]
+ public class Purdkb
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 瀹℃牳
+ ///</summary>
+ [SugarColumn(ColumnName="AUDITING" )]
+ public string Auditing { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATETIME" )]
+ public string Createtime { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜哄憳
+ ///</summary>
+ [SugarColumn(ColumnName="CREATEUSER" )]
+ public string Createuser { get; set; }
+ /// <summary>
+ /// 鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="DKB001" )]
+ public string Dkb001 { get; set; }
+ /// <summary>
+ /// 搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="DKB002" )]
+ public string Dkb002 { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="DKB003" )]
+ public string Dkb003 { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="DKB004" )]
+ public string Dkb004 { get; set; }
+ /// <summary>
+ /// 鐗╂枡瑙勬牸
+ ///</summary>
+ [SugarColumn(ColumnName="DKB005" )]
+ public string Dkb005 { get; set; }
+ /// <summary>
+ /// 搴旈��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DKB006" )]
+ public int? Dkb006 { get; set; }
+ /// <summary>
+ /// 瀹為��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DKB007" )]
+ public int? Dkb007 { get; set; }
+ /// <summary>
+ /// 寰呴��鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="DKB008" )]
+ public int? Dkb008 { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="DKB009" )]
+ public string Dkb009 { get; set; }
+ /// <summary>
+ /// 鍗曚环
+ ///</summary>
+ [SugarColumn(ColumnName="DKB010" )]
+ public int? Dkb010 { get; set; }
+ /// <summary>
+ /// 閲戦
+ ///</summary>
+ [SugarColumn(ColumnName="DKB011" )]
+ public int? Dkb011 { get; set; }
+ /// <summary>
+ /// 鏉ユ簮鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="DKB012" )]
+ public string Dkb012 { get; set; }
+ /// <summary>
+ /// 鏉ユ簮搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="DKB013" )]
+ public string Dkb013 { get; set; }
+ /// <summary>
+ /// 涓嶈壇鍒嗙被
+ ///</summary>
+ [SugarColumn(ColumnName="DKB014" )]
+ public string Dkb014 { get; set; }
+ /// <summary>
+ /// 涓嶈壇椤圭洰
+ ///</summary>
+ [SugarColumn(ColumnName="DKB015" )]
+ public string Dkb015 { get; set; }
+ /// <summary>
+ /// 浠撳簱缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="DKB016" )]
+ public string Dkb016 { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="DKB017" )]
+ public string Dkb017 { get; set; }
+ /// <summary>
+ /// 浠撳簱鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="DKB018" )]
+ public string Dkb018 { get; set; }
+ }
+}
diff --git a/entity/SysDepartment.cs b/entity/SysDepartment.cs
new file mode 100644
index 0000000..a918d51
--- /dev/null
+++ b/entity/SysDepartment.cs
@@ -0,0 +1,147 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("SYS_DEPARTMENT")]
+ public class SysDepartment
+ {
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍏徃
+ ///</summary>
+ [SugarColumn(ColumnName="company" )]
+ public string Company { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬ID
+ ///</summary>
+ [SugarColumn(ColumnName="departmentid" )]
+ public int? Departmentid { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="departmentcode" )]
+ public string Departmentcode { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="departmentname" )]
+ public string Departmentname { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬灞炴��
+ ///</summary>
+ [SugarColumn(ColumnName="depextr1" )]
+ public string Depextr1 { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName="depextr2" )]
+ public string Depextr2 { get; set; }
+ /// <summary>
+ /// WIP浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="depextr3" )]
+ public string Depextr3 { get; set; }
+ /// <summary>
+ /// 鏄惁绂佺敤 A 鍚敤 B绂佺敤
+ ///</summary>
+ [SugarColumn(ColumnName="depextr4" )]
+ public string Depextr4 { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬鎵╁睍瀛楁5
+ ///</summary>
+ [SugarColumn(ColumnName="depextr5" )]
+ public string Depextr5 { get; set; }
+ /// <summary>
+ /// 杞﹂棿ID
+ ///</summary>
+ [SugarColumn(ColumnName="workshop_no" )]
+ public string WorkshopNo { get; set; }
+ /// <summary>
+ /// 杞﹂棿鍚�
+ ///</summary>
+ [SugarColumn(ColumnName="workshop_name" )]
+ public string WorkshopName { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬缁忕悊
+ ///</summary>
+ [SugarColumn(ColumnName="fmanager" )]
+ public string Fmanager { get; set; }
+ /// <summary>
+ /// 宸ュ巶
+ ///</summary>
+ [SugarColumn(ColumnName="factory" )]
+ public string Factory { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="create_by" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="create_date" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀逛汉
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_by" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏈�鍚庝慨鏀规棩鏈�
+ ///</summary>
+ [SugarColumn(ColumnName="lastupdate_date" )]
+ public DateTime? LastupdateDate { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="remark" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬id
+ ///</summary>
+ [SugarColumn(ColumnName="id" )]
+ public int? Id { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName="production_workshop" )]
+ public string ProductionWorkshop { get; set; }
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ ///</summary>
+ [SugarColumn(ColumnName="material_properti" )]
+ public string MaterialProperti { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName="remark4" )]
+ public string Remark4 { get; set; }
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName="remark5" )]
+ public string Remark5 { get; set; }
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="Fumbrella" )]
+ public string Fumbrella { get; set; }
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="FSubsidiary" )]
+ public string FSubsidiary { get; set; }
+ /// <summary>
+ /// 涓婄骇閮ㄩ棬
+ ///</summary>
+ [SugarColumn(ColumnName="FParentID" )]
+ public string FParentID { get; set; }
+ }
+}
diff --git a/entity/SysOrganization.cs b/entity/SysOrganization.cs
new file mode 100644
index 0000000..09b38a3
--- /dev/null
+++ b/entity/SysOrganization.cs
@@ -0,0 +1,79 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("SYS_ORGANIZATION")]
+ public class SysOrganization
+ {
+ /// <summary>
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="GUID" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="NAME" )]
+ public string Name { get; set; }
+ /// <summary>
+ /// 鑱旂郴浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CON_PEOPLE" )]
+ public string ConPeople { get; set; }
+ /// <summary>
+ /// 鑱旂郴鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="CON_TEL" )]
+ public string ConTel { get; set; }
+ /// <summary>
+ /// 绯荤粺鍐呯疆
+ ///</summary>
+ [SugarColumn(ColumnName="IS_SYS" )]
+ public int? IsSys { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="IS_STATUS" )]
+ public bool? IsStatus { get; set; }
+ /// <summary>
+ /// 缂栬緫鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="EDT_TIME" )]
+ public DateTime? EdtTime { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="check_date" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="check_by" )]
+ public string CheckBy { get; set; }
+ /// <summary>
+ ///
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName="check_status" )]
+ public bool? CheckStatus { get; set; }
+ /// <summary>
+ /// 缁勭粐ID
+ ///</summary>
+ [SugarColumn(ColumnName="FID" )]
+ public string Fid { get; set; }
+ /// <summary>
+ /// 缁勭粐缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="FNumber" )]
+ public string FNumber { get; set; }
+ /// <summary>
+ /// 鐖剁骇ID
+ ///</summary>
+ [SugarColumn(ColumnName="FParentlD" )]
+ public string FParentlD { get; set; }
+ }
+}
diff --git a/entity/SysUser.cs b/entity/SysUser.cs
new file mode 100644
index 0000000..a8d13a6
--- /dev/null
+++ b/entity/SysUser.cs
@@ -0,0 +1,107 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarTable("SYS_USER")]
+ public class SysUser
+ {
+ /// <summary>
+ /// 涓婚敭
+ ///</summary>
+ [SugarColumn(ColumnName="GUID" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// 璐﹀彿
+ ///</summary>
+ [SugarColumn(ColumnName="ACCOUNT" )]
+ public string Account { get; set; }
+ /// <summary>
+ /// 瀵嗙爜
+ ///</summary>
+ [SugarColumn(ColumnName="PASSWORD" )]
+ public string Password { get; set; }
+ /// <summary>
+ /// 鐢ㄦ埛濮撳悕
+ ///</summary>
+ [SugarColumn(ColumnName="USER_NAME" )]
+ public string UserName { get; set; }
+ /// <summary>
+ /// 浣忓潃
+ ///</summary>
+ [SugarColumn(ColumnName="ADDRESS" )]
+ public string Address { get; set; }
+ /// <summary>
+ /// 鐢佃瘽
+ ///</summary>
+ [SugarColumn(ColumnName="TEL" )]
+ public string Tel { get; set; }
+ /// <summary>
+ /// 閭
+ ///</summary>
+ [SugarColumn(ColumnName="EMAIL" )]
+ public string Email { get; set; }
+ /// <summary>
+ /// 鏈�鍚庣櫥褰曟椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTLOGIN_TIME" )]
+ public DateTime? LastloginTime { get; set; }
+ /// <summary>
+ /// 鏈�鍚庨��鍑烘椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTLOGOUT_TIME" )]
+ public DateTime? LastlogoutTime { get; set; }
+ /// <summary>
+ /// 鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="IS_STATUS" )]
+ public bool? IsStatus { get; set; }
+ /// <summary>
+ /// 寤虹珛鑰�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 寤虹珛鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_TIME" )]
+ public DateTime? CreateTime { get; set; }
+ /// <summary>
+ /// 鏇存柊鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_TIME" )]
+ public DateTime? LastupdateTime { get; set; }
+ /// <summary>
+ /// 鏇存柊浜�
+ ///</summary>
+ [SugarColumn(ColumnName="LASTUPDATE_BY" )]
+ public string LastupdateBy { get; set; }
+ /// <summary>
+ /// 鏄惁鍦ㄧ嚎
+ ///</summary>
+ [SugarColumn(ColumnName="FLAG_ONLINE" )]
+ public int? FlagOnline { get; set; }
+ /// <summary>
+ /// 鐧诲綍娆℃暟
+ ///</summary>
+ [SugarColumn(ColumnName="LOGIN_COUNTER" )]
+ public int? LoginCounter { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="REMARK" )]
+ public string Remark { get; set; }
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="DEPART_NO" )]
+ public string DepartNo { get; set; }
+ /// <summary>
+ /// 鏄惁绯荤粺鍐呯疆
+ ///</summary>
+ [SugarColumn(ColumnName="IS_SYS" )]
+ public int? IsSys { get; set; }
+ }
+}
diff --git a/entity/Womcaa.cs b/entity/Womcaa.cs
new file mode 100644
index 0000000..9147466
--- /dev/null
+++ b/entity/Womcaa.cs
@@ -0,0 +1,353 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 浠诲姟鍗曡〃
+ ///</summary>
+ [SugarTable("WOMCAA")]
+ public class Womcaa
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ERPID
+ ///</summary>
+ [SugarColumn(ColumnName="ERPID" )]
+ public int? Erpid { get; set; }
+ /// <summary>
+ /// 鍗曟嵁缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA001" )]
+ public string Caa001 { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷("1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� 2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 3銆佸伐搴忔眹鎶�-鏅�氱敓浜� 4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇")
+ ///</summary>
+ [SugarColumn(ColumnName="CAA004" )]
+ public string Caa004 { get; set; }
+ /// <summary>
+ /// 璁″垝涓嬭揪鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CAA005" )]
+ public string Caa005 { get; set; }
+ /// <summary>
+ /// 浜у搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="CAA006" )]
+ public string Caa006 { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="CAA009" )]
+ public string Caa009 { get; set; }
+ /// <summary>
+ /// 棰勮寮�宸ユ椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName="CAA010" )]
+ public string Caa010 { get; set; }
+ /// <summary>
+ /// 棰勮瀹屽伐鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA011" )]
+ public string Caa011 { get; set; }
+ /// <summary>
+ /// 宸ュ崟鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="CAA012" )]
+ public decimal? Caa012 { get; set; }
+ /// <summary>
+ /// BOM鐗堟
+ ///</summary>
+ [SugarColumn(ColumnName="CAA013" )]
+ public string Caa013 { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA015" )]
+ public string Caa015 { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="CAA016" )]
+ public string Caa016 { get; set; }
+ /// <summary>
+ /// 宸叉帓鏁伴噺锛堝純鐢級
+ ///</summary>
+ [SugarColumn(ColumnName="CAA017" )]
+ public int? Caa017 { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟ID
+ ///</summary>
+ [SugarColumn(ColumnName="CAA018" )]
+ public int? Caa018 { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA019" )]
+ public int? Caa019 { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA020" )]
+ public string Caa020 { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA021" )]
+ public string Caa021 { get; set; }
+ /// <summary>
+ /// 瀹℃牳鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="FSTATUS" )]
+ public int? Fstatus { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_DATE" )]
+ public DateTime? CheckDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CHECK_USER" )]
+ public string CheckUser { get; set; }
+ /// <summary>
+ /// 鏈帓鏁伴噺锛堝純鐢級
+ ///</summary>
+ [SugarColumn(ColumnName="CAA022" )]
+ public int? Caa022 { get; set; }
+ /// <summary>
+ /// 涓氬姟鐘舵��("1锛岃鍒掞紝2銆佽鍒掔‘璁� 2銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗堬紝7銆佺粨绠�")
+ ///</summary>
+ [SugarColumn(ColumnName="CAA023" )]
+ public string Caa023 { get; set; }
+ /// <summary>
+ /// 宸插叆搴撴暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="CAA024" )]
+ public int? Caa024 { get; set; }
+ /// <summary>
+ /// 宸ヨ壓璺嚎
+ ///</summary>
+ [SugarColumn(ColumnName="ROUTING_ID" )]
+ public string RoutingId { get; set; }
+ /// <summary>
+ /// 浜х嚎
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_SHOP_ID" )]
+ public string WorkShopId { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_CODE" )]
+ public string DepotCode { get; set; }
+ /// <summary>
+ /// 鍗曟嵁鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public string CreateDate { get; set; }
+ /// <summary>
+ /// 璁″垝缁�
+ ///</summary>
+ [SugarColumn(ColumnName="WORK_GROUP_ID" )]
+ public string WorkGroupId { get; set; }
+ /// <summary>
+ /// 璁″垝鍛�
+ ///</summary>
+ [SugarColumn(ColumnName="PLAN_ID" )]
+ public string PlanId { get; set; }
+ /// <summary>
+ /// 鍏ュ簱涓婇檺
+ ///</summary>
+ [SugarColumn(ColumnName="STOCK_INLIMITH" )]
+ public string StockInlimith { get; set; }
+ /// <summary>
+ /// 鍏ュ簱涓嬮檺
+ ///</summary>
+ [SugarColumn(ColumnName="STOCK_INLIMITL" )]
+ public string StockInlimitl { get; set; }
+ /// <summary>
+ /// 涓昏溅闂磋皟搴﹀崟
+ ///</summary>
+ [SugarColumn(ColumnName="MTONO" )]
+ public string Mtono { get; set; }
+ /// <summary>
+ /// 鎵规
+ ///</summary>
+ [SugarColumn(ColumnName="LOT" )]
+ public string Lot { get; set; }
+ /// <summary>
+ /// 寮曠敤鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAA015_HEAD" )]
+ public string Caa015Head { get; set; }
+ /// <summary>
+ /// 鍒跺崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_TYPE" )]
+ public string CreateType { get; set; }
+ /// <summary>
+ /// 鏉ユ簮鍗曟嵁绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="SRC_BILL_TYPE" )]
+ public string SrcBillType { get; set; }
+ /// <summary>
+ /// 鏉ユ簮鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="SRC_BILL_NO" )]
+ public string SrcBillNo { get; set; }
+ /// <summary>
+ /// 鏉ユ簮琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="SRC_BILLENTRYSEQ" )]
+ public string SrcBillentryseq { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="SALE_ORDER_NO" )]
+ public string SaleOrderNo { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ" )]
+ public string SaleOrderEntryseq { get; set; }
+ /// <summary>
+ /// 寮哄埗鍏抽棴浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FORCE_CLOSERID" )]
+ public string ForceCloserid { get; set; }
+ /// <summary>
+ /// 鍏抽棴绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="CLOSE_TYPE" )]
+ public string CloseType { get; set; }
+ /// <summary>
+ /// 鍒嗗崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="SRC_SPLIT_BILLNO" )]
+ public string SrcSplitBillno { get; set; }
+ /// <summary>
+ /// 鏄惁绠℃帶
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_SCZZ" )]
+ public int? ErpSczz { get; set; }
+ /// <summary>
+ /// 鏄惁濮旀墭
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_WTZZ" )]
+ public int? ErpWtzz { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="MAIN_PRODUCT_NO" )]
+ public string MainProductNo { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="MAIN_PRODUCT_QTY" )]
+ public int? MainProductQty { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="CUSTOMER_ITEM_NUMBER" )]
+ public string CustomerItemNumber { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="PACKING_LIST_NUMBER" )]
+ public string PackingListNumber { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="CUSTOMER_NAME" )]
+ public string CustomerName { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="CUSTOMER" )]
+ public string Customer { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="TYPE" )]
+ public string Type { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="JA_BS" )]
+ public string JaBs { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="JA_TIME" )]
+ public DateTime? JaTime { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="YP_NUM" )]
+ public int? YpNum { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="CAA011_1" )]
+ public string Caa0111 { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_GYZZ" )]
+ public int? ErpGyzz { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_FLZZ" )]
+ public int? ErpFlzz { get; set; }
+ /// <summary>
+ /// 鏄惁鍏ュ簱
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_SLZZ" )]
+ public int? ErpSlzz { get; set; }
+ /// <summary>
+ /// 鏄惁閫�搴�
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_RKZZ" )]
+ public int? ErpRkzz { get; set; }
+ /// <summary>
+ /// 鏄惁鎹㈣揣
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_RKHZ" )]
+ public int? ErpRkhz { get; set; }
+ /// <summary>
+ /// 鏄惁瀵勫敭
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_JJDS" )]
+ public int? ErpJjds { get; set; }
+ /// <summary>
+ /// 鏄惁鎸夋
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_BZDS" )]
+ public int? ErpBzds { get; set; }
+ /// <summary>
+ /// 鏄惁鏂板缓
+ ///</summary>
+ [SugarColumn(ColumnName="CAA025" )]
+ public int? Caa025 { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="FPURORDERNO" )]
+ public string Fpurorderno { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName="FPURORDERENTRYSEQ" )]
+ public string Fpurorderentryseq { get; set; }
+ /// <summary>
+ /// 澶囨敞锛堣〃浣擄級
+ ///</summary>
+ [SugarColumn(ColumnName="Btbz" )]
+ public string Btbz { get; set; }
+ }
+}
diff --git a/entity/Womcab.cs b/entity/Womcab.cs
new file mode 100644
index 0000000..b3d9d77
--- /dev/null
+++ b/entity/Womcab.cs
@@ -0,0 +1,213 @@
+锘縰sing SqlSugar;
+
+namespace NewPdaSqlServer.entity
+{
+ /// <summary>
+ /// 浠诲姟鍗曠墿鏂欒〃
+ ///</summary>
+ [SugarTable("WOMCAB")]
+ public class Womcab
+ {
+ /// <summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
+ [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
+ public Guid Guid { get; set; }
+ /// <summary>
+ /// ERPID
+ ///</summary>
+ [SugarColumn(ColumnName="ERPID" )]
+ public int? Erpid { get; set; }
+ /// <summary>
+ /// 宸ュ崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAB001" )]
+ public string Cab001 { get; set; }
+ /// <summary>
+ /// 搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName="CAB002" )]
+ public int? Cab002 { get; set; }
+ /// <summary>
+ /// 鏉愭枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="CAB003" )]
+ public string Cab003 { get; set; }
+ /// <summary>
+ /// 闇�棰嗙敤閲�
+ ///</summary>
+ [SugarColumn(ColumnName="CAB006" )]
+ public decimal? Cab006 { get; set; }
+ /// <summary>
+ /// 宸查鐢ㄩ噺
+ ///</summary>
+ [SugarColumn(ColumnName="CAB007" )]
+ public decimal? Cab007 { get; set; }
+ /// <summary>
+ /// 宸ヨ壓
+ ///</summary>
+ [SugarColumn(ColumnName="CAB008" )]
+ public string Cab008 { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName="CAB009" )]
+ public string Cab009 { get; set; }
+ /// <summary>
+ /// 缁勬垚鐢ㄩ噺
+ ///</summary>
+ [SugarColumn(ColumnName="CAB012" )]
+ public decimal? Cab012 { get; set; }
+ /// <summary>
+ /// 鏄惁鏇挎枡
+ ///</summary>
+ [SugarColumn(ColumnName="CAB014" )]
+ public string Cab014 { get; set; }
+ /// <summary>
+ /// PID
+ ///</summary>
+ [SugarColumn(ColumnName="PID" )]
+ public int? Pid { get; set; }
+ /// <summary>
+ /// ERP澶碔D
+ ///</summary>
+ [SugarColumn(ColumnName="EID" )]
+ public int? Eid { get; set; }
+ /// <summary>
+ /// 浣嶇疆鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="POSITION_NO" )]
+ public string PositionNo { get; set; }
+ /// <summary>
+ /// 鍙戞枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="ISSUING_ORGANIZATION" )]
+ public string IssuingOrganization { get; set; }
+ /// <summary>
+ /// 渚涘簲缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName="SUPPLY_ORGANIZATION" )]
+ public string SupplyOrganization { get; set; }
+ /// <summary>
+ /// 璐т富
+ ///</summary>
+ [SugarColumn(ColumnName="OWNER_ID" )]
+ public string OwnerId { get; set; }
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="MTONO" )]
+ public string Mtono { get; set; }
+ /// <summary>
+ /// 鎵瑰彿
+ ///</summary>
+ [SugarColumn(ColumnName="LOT" )]
+ public string Lot { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName="DEPOT_CODE" )]
+ public string DepotCode { get; set; }
+ /// <summary>
+ /// 鍙戞枡鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName="ISSUE_TYPE" )]
+ public string IssueType { get; set; }
+ /// <summary>
+ /// 渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿)
+ ///</summary>
+ [SugarColumn(ColumnName="SUPPLY_TYPE" )]
+ public string SupplyType { get; set; }
+ /// <summary>
+ /// 鍒嗗瓙
+ ///</summary>
+ [SugarColumn(ColumnName="NUMERATOR" )]
+ public string Numerator { get; set; }
+ /// <summary>
+ /// 鍒嗘瘝
+ ///</summary>
+ [SugarColumn(ColumnName="DENOMINATOR" )]
+ public string Denominator { get; set; }
+ /// <summary>
+ /// 鍥哄畾鎹熻��
+ ///</summary>
+ [SugarColumn(ColumnName="SCRAPQTY" )]
+ public string Scrapqty { get; set; }
+ /// <summary>
+ /// 鍙樺姩鎹熻�楃巼
+ ///</summary>
+ [SugarColumn(ColumnName="SCRAPRATE" )]
+ public string Scraprate { get; set; }
+ /// <summary>
+ /// 瀹㈡埛璐у彿
+ ///</summary>
+ [SugarColumn(ColumnName="CUSTOMER_ITEM_NUMBER" )]
+ public string CustomerItemNumber { get; set; }
+ /// <summary>
+ /// 鍖呰鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="PACKING_LIST_NUMBER" )]
+ public string PackingListNumber { get; set; }
+ /// <summary>
+ /// 涓讳骇鍝�
+ ///</summary>
+ [SugarColumn(ColumnName="MAIN_PRODUCT" )]
+ public string MainProduct { get; set; }
+ /// <summary>
+ /// 涓讳骇鍝佹暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName="MAIN_PRODUCT_QTY" )]
+ public int? MainProductQty { get; set; }
+ /// <summary>
+ /// 鐖堕」鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="PARENT_ITEM_NAME" )]
+ public string ParentItemName { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗�
+ ///</summary>
+ [SugarColumn(ColumnName="FSALEORDERNO" )]
+ public string Fsaleorderno { get; set; }
+ /// <summary>
+ /// 璐т富绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="FOWNERTYPEID" )]
+ public string Fownertypeid { get; set; }
+ /// <summary>
+ /// 椤规鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="FREPLACEGROUP" )]
+ public int? Freplacegroup { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName="ERP_XSDDH" )]
+ public string ErpXsddh { get; set; }
+ /// <summary>
+ /// 瀛愰」绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="FMATERIALTYPE" )]
+ public string Fmaterialtype { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="FUNITID" )]
+ public string Funitid { get; set; }
+ /// <summary>
+ /// 搴斿彂鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName="Must_Qty" )]
+ public decimal? MustQty { get; set; }
+ /// <summary>
+ /// 浣跨敤姣斾緥锛�%锛�
+ ///</summary>
+ [SugarColumn(ColumnName="Use_Rate" )]
+ public decimal? UseRate { get; set; }
+ /// <summary>
+ /// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
+ ///</summary>
+ [SugarColumn(ColumnName="Material_Type" )]
+ public string MaterialType { get; set; }
+ }
+}
diff --git a/service/LoginService.cs b/service/LoginService.cs
deleted file mode 100644
index 5cde7e9..0000000
--- a/service/LoginService.cs
+++ /dev/null
@@ -1,91 +0,0 @@
-锘縰sing System.Data;
-using System.Text;
-
-namespace NewPdaSqlServer.service;
-
-public class LoginService
-{
- //public static OracleSQLHelper SQLHelper = new();
-
- public DataTable login(string name, string pwd)
- {
- // var sql =
- // string.Format(@"select * from SYS_USER where FCODE = '{0}'",
- // name);
- // var dataTable = SQLHelper.ExecuteQuery(sql);
- // if (dataTable.Rows.Count <= 0) throw new Exception("鐢ㄦ埛涓嶅瓨鍦�");
- //
- // var row = dataTable.Rows[0];
- // var db_password = row["FPASSWORD"].ToString();
- // db_password = ProPass(db_password);
- // if (!pwd.Equals(db_password)) throw new Exception("鐢ㄦ埛鍚嶆垨鑰呭瘑鐮侀敊璇�");
- //
- // return dataTable;
- return null;
- }
-
- public DataTable getUserMenu(string name)
- {
- // var sql = "";
- //
- // if ("PL017".Equals(name))
- // sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
- // else
- // sql = string.Format(@"select PAGE_VIEW,PATH,ICOIMG
- // from (select PAGE_VIEW,PATH,ICOIMG
- // from MES_SYS_GUP_USER a
- // join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
- // join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
- // where USERID = (select fid from SYS_USER where FCODE = '{0}')
- // union all
- // select PAGE_VIEW,PATH,ICOIMG
- // from MES_SYS_GUP_USER a
- // join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
- // where a.ROLEID = (select FCODE from SYS_USER where FCODE = '{0}'))
- // group by PATH, PAGE_VIEW, ICOIMG", name);
- //
- // return SQLHelper.ExecuteQuery(sql);
- return null;
- }
-
- public int resetPassword(string newPwd, string name, string pwd)
- {
- // login(name, pwd);
- // var passwordHash = encryptPass(newPwd);
- // var sql = string.Format(
- // @"update SYS_USER set FPASSWORD = '{0}' where FCODE = '{1}'",
- // passwordHash,
- // name);
- // return SQLHelper.ExecuteNonQuery(sql);
- return 0;
- }
-
- //瑙ｅ瘑
- private string encryptPass(string str)
- {
- var b = Encoding.GetEncoding("iso-8859-1").GetBytes(str);
- var temp = (byte[])b.Clone();
- for (var i = 0; i < b.Length; i++) temp[i] = (byte)(b[i] ^ (8 + 18));
-
- var result =
- 8 + Encoding.GetEncoding("iso-8859-1").GetString(temp);
- return result;
- }
-
- //鍔犲瘑
- private string ProPass(string src)
- {
- var result = "";
- var first = int.Parse(src.Substring(0, 1));
- var src_tem = src.Substring(1);
- var b = Encoding.GetEncoding("iso-8859-1")
- .GetBytes(src_tem);
- var temp = (byte[])b.Clone();
- for (var i = 0; i < b.Length; i++)
- temp[i] = (byte)(temp[i] ^ (first + 18));
-
- result = Encoding.GetEncoding("iso-8859-1")
- .GetString(temp);
- return result;
- }
-}
\ No newline at end of file
diff --git a/service/base/GetErpParametersServer.cs b/service/base/GetErpParametersServer.cs
new file mode 100644
index 0000000..1960d02
--- /dev/null
+++ b/service/base/GetErpParametersServer.cs
@@ -0,0 +1,78 @@
+锘縰sing System.Text;
+using NewPdaSqlServer.entity;
+using Newtonsoft.Json;
+
+namespace NewPdaSqlServer.service.@base;
+
+public class GetErpParametersServer
+{
+ // private readonly MesInvItemInCDetailsManager _invItemInCDetailsServer =
+ // new();
+ //
+ // private readonly MesInvItemOutsManager _invItemOutsServer =
+ // new();
+
+ private readonly MessageCenterManager _messageCenterServer = new();
+
+
+ private async Task<string> sendHttp(List<MessageCenter> requestList)
+ {
+ var sortedRequests = requestList.OrderBy(r => r.Seq).ToList();
+
+ using var httpClient = new HttpClient();
+
+ var responses = "";
+
+ foreach (var request in sortedRequests)
+ {
+ var httpRequestMessage = new HttpRequestMessage
+ {
+ Method = new HttpMethod(request.Method),
+ RequestUri = new Uri(request.Url),
+ Content = new StringContent(request.Data, Encoding.UTF8,
+ request.ContentType)
+ };
+
+ var response =
+ await httpClient.SendAsync(httpRequestMessage);
+ var responseData = await response.Content.ReadAsStringAsync();
+
+ var result = JsonConvert.DeserializeObject<Result>(responseData);
+
+ responses += result.msg + "!!!";
+ responses += result.message + "!!!";
+
+ if ("500".Equals(result.state))
+ {
+ responses = "杩斿洖鎶ラ敊锛�" + responses;
+ return responses;
+ }
+
+ if ("1".Equals(result.status))
+ {
+ responses = "杩斿洖鎶ラ敊锛�" + responses;
+ return responses;
+ }
+
+ request.Result = 1;
+ request.ResultData = result.msg;
+ request.Status = 1;
+ request.DealWith = 1;
+
+ _messageCenterServer.ResetUpdate(request);
+ }
+
+ responses = "閲嶆帹鎴愬姛锛�" + responses;
+ return responses;
+ }
+}
+
+public class Result
+{
+ public string? state { get; set; }
+ public string? msg { get; set; }
+
+ public string? status { get; set; }
+
+ public string? message { get; set; }
+}
\ No newline at end of file
diff --git a/service/base/LoginService.cs b/service/base/LoginService.cs
new file mode 100644
index 0000000..d8147f3
--- /dev/null
+++ b/service/base/LoginService.cs
@@ -0,0 +1,46 @@
+锘縰sing NewPdaSqlServer.DB;
+using NewPdaSqlServer.entity;
+using NewPdaSqlServer.util;
+
+namespace NewPdaSqlServer.service.@base;
+
+public class LoginService : RepositoryNoEntity
+{
+
+ public SysUser login(string name, string pwd)
+ {
+ var strPass = UtilityHelper.MD5Encrypt32(pwd);
+ var sysUser = Db.Queryable<SysUser>()
+ .Where(s => s.Account == name
+ && s.Password == strPass).First();
+
+ if (sysUser == null) throw new Exception("鐢ㄦ埛涓嶅瓨鍦�");
+
+ var db_password = sysUser.Password;
+ if (!strPass.Equals(db_password)) throw new Exception("鐢ㄦ埛鍚嶆垨鑰呭瘑鐮侀敊璇�");
+
+ return sysUser;
+ }
+
+ public List<MesSysPageview> getUserMenu(string name)
+ {
+ var sql = "";
+
+ if ("admin".Equals(name))
+ return Db.Queryable<MesSysPageview>()
+ .ToList();
+
+ return null;
+ }
+
+ public int resetPassword(string newPwd, string name, string pwd)
+ {
+ login(name, pwd);
+ var passwordHash = UtilityHelper.MD5Encrypt32(newPwd);
+
+ return Db.Updateable<SysUser>()
+ .SetColumns(s => s.Password == passwordHash)
+ .Where(s => s.Account == name)
+ .ExecuteCommand();
+ }
+}
\ No newline at end of file
diff --git a/service/base/MessageCenterManager.cs b/service/base/MessageCenterManager.cs
new file mode 100644
index 0000000..8fbb98b
--- /dev/null
+++ b/service/base/MessageCenterManager.cs
@@ -0,0 +1,108 @@
+锘縰sing System.Collections.Specialized;
+using NewPdaSqlServer.DB;
+using NewPdaSqlServer.entity;
+using SqlSugar;
+
+namespace NewPdaSqlServer.service.@base;
+
+public class MessageCenterManager : Repository<MessageCenter>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ public (List<MessageCenter> item, int TotalCount) GetPushFailedPage(
+ MessageCenter query)
+ {
+ var totalCount = 0;
+ var messageCenters = Db.Queryable<MessageCenter>()
+ .Where(s => s.Result == 0
+ && s.Seq == 1 && s.Title != null)
+ .OrderByDescending(s => s.CreateDate)
+ .ToPageList(query.PageIndex, query.Limit, ref totalCount);
+
+ return (messageCenters, totalCount);
+ }
+
+ //鏌ョ湅鏄惁鏈夋湭澶勭悊鐨勬秷鎭�
+ public int IsShow(MessageCenter query)
+ {
+ return Context.Queryable<MessageCenter>()
+ .Where(it =>
+ it.Result == 0 && it.Status == 1 &&
+ it.Seq == 1 && it.Title != null)
+ .WhereIF(query.isShow == 1, it => it.DealWith == 0)
+ .Count();
+ }
+
+ //灏嗘秷鎭缃负宸茶鐨�
+ public int UpdateRead(MessageCenter query)
+ {
+ return Db.Updateable<MessageCenter>()
+ .SetColumns(s => s.DealWith == 1)
+ .SetColumns(s => s.UpdateBy == query.UpdateBy)
+ .SetColumns(s =>
+ s.UpdateDate == DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))
+ .Where(s => s.Guid == query.Guid)
+ .ExecuteCommand();
+ }
+
+
+ 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.Guid)
+ }).ToList();
+ }
+ //鏍规嵁鍑犵鎯呭喌鏇存柊 淇濇寔椤甸潰id鏄浐瀹氱殑
+
+
+ //鍓嶅彴閲嶆柊鍙戦��
+ public int ResetUpdate(MessageCenter entity)
+ {
+ return UseTransaction(db =>
+ {
+ return db.Updateable<MessageCenter>()
+ .SetColumns(a => a.Data == entity.Data)
+ .SetColumns(a => a.Result == entity.Result)
+ .SetColumns(a => a.ResultData == entity.ResultData)
+ .SetColumns(a => a.Status == entity.Status)
+ .SetColumns(a => a.DealWith == entity.DealWith)
+ .SetColumnsIF(!string.IsNullOrEmpty(entity.UpdateBy),
+ a => a.UpdateBy == entity.UpdateBy)
+ .SetColumnsIF(!string.IsNullOrEmpty(entity.UpdateDate),
+ a => a.UpdateDate == entity.UpdateDate)
+ .Where(a => a.Guid == entity.Guid)
+ .ExecuteCommand();
+ });
+ }
+}
\ No newline at end of file
diff --git a/util/UtilityHelper.cs b/util/UtilityHelper.cs
index ca662f9..fef1427 100644
--- a/util/UtilityHelper.cs
+++ b/util/UtilityHelper.cs
@@ -23,7 +23,7 @@
for (var i = 0; i < s.Length; i++) pwd = pwd + s[i].ToString("X");
return pwd;
}
-
+
/// <summary>
/// table杞珼ynamicList
/// </summary>
--
Gitblit v1.9.3