| | |
| | | { |
| | | DbType = DbType.Oracle, |
| | | ConnectionString = |
| | | @"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd", |
| | | @"Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev", |
| | | IsAutoCloseConnection = true |
| | | }, |
| | | db => |
| | |
| | | |
| | | public class ErpCustomer |
| | | { |
| | | //ERPå³è¼¸éä¾çæ¸æåå²å¨é裡//jsonæ ¼å¼å°å¯« |
| | | |
| | | |
| | | public string? Type { get; set; } |
| | | public string Id { get; set; } |
| | | public string? FNumber { get; set; } |
| | |
| | | public string? Fmobilephone { get; set; } |
| | | public string? Fseller { get; set; } |
| | | public string? FForbidStatus { get; set; } |
| | | |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | public string? Fremarks { get; set; } |
| | | } |
| | |
| | | public string? FForbidStatus { get; set; } |
| | | |
| | | public string? Type { get; set; } |
| | | public string? FParentID { get; set; } |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | } |
| | |
| | | public string? FGroup { get; set; } |
| | | |
| | | public string? Type { get; set; } |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | public string? FSUPPLIERID { get; set; } |
| | | public string? Fdeptid { get; set; } |
| | | |
| | | } |
| | |
| | | public string? FNumber { get; set; } |
| | | public string? FName { get; set; } |
| | | public string? FDescription { get; set; } |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | } |
| | |
| | | public double? FMaxStock { get; set; } |
| | | public double? FMinPackCount { get; set; } |
| | | public string? FStockId { get; set; } |
| | | public string? PPBOM00019124 { get; set; } |
| | | /// <summary> |
| | | //public string? PPBOM00019124 { get; set; } |
| | | /// </summary> |
| | | public string? FMaterialGroup { get; set; } |
| | | public string? FDescription { get; set; } |
| | | public decimal? FFinishReceiptOverRate { get; set; } |
| | |
| | | |
| | | public string? FPRODUCEUNITID { get; set; } |
| | | public string? FSUBCONUNITID { get; set; } |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | public string? FLOSSPERCENT { get; set; } |
| | | public string? FMnemonicCode { get; set; } |
| | | public string? FExpPeriod { get; set; } |
| | | |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpOrganize |
| | | { |
| | | public string? Type { get; set; } |
| | | public string Id { get; set; } |
| | | |
| | | public string? FNumber { get; set; } |
| | | public string? FName { get; set; } |
| | | public string? FForbidStatus { get; set; } |
| | | |
| | | } |
| | |
| | | public string? FForbidderId { get; set; } |
| | | |
| | | public string? FForbidDate { get; set; } |
| | | |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨ç¶æ A å¯ç¨ Bç¦ç¨ |
| | | /// </summary> |
| | |
| | | public string? Facctype { get; set; } |
| | | public string? FPurchaserId { get; set; } |
| | | |
| | | public string? F_UNW_Remarks_zlyq { get; set; } |
| | | // public string? F_UNW_Remarks_zlyq { get; set; } |
| | | |
| | | // public string? F_UNW_GYSLXR { get; set; } |
| | | // public string? F_UNW_LXRDH { get; set; } |
| | |
| | | // public string? FProviderAddress { get; set; } |
| | | public string? FSettleId { get; set; } |
| | | public string? FChargeId { get; set; } |
| | | public string? FProviderEMail { get; set; } |
| | | public string? F_UNW_Text_ysfs { get; set; } |
| | | public string? F_UNW_BZ { get; set; } |
| | | public string? F_UNW_Combo_zjmj { get; set; } |
| | | // public string? FProviderEMail { get; set; } |
| | | // public string? F_UNW_Text_ysfs { get; set; } |
| | | public string? FHEADNOTE { get; set; } |
| | | // public string? F_UNW_Combo_zjmj { get; set; } |
| | | public string? FCancelStatus { get; set; } |
| | | public string? FCancellerId { get; set; } |
| | | public string? FCancelDate { get; set; } |
| | |
| | | public string? FCHANGEREASON { get; set; } |
| | | |
| | | //éè´è®¢åA éè´è®¢ååæ´åB |
| | | public string? FBILLTYPE { get; set; } |
| | | //public string? FBILLTYPE { get; set; } |
| | | } |
| | |
| | | public string id { get; set; } |
| | | public string Eid { get; set; } |
| | | public string? FBillNo { get; set; } |
| | | public string? F_UNW_Text_xsddh { get; set; } |
| | | public string? FDEMANDBILLNO { get; set; } |
| | | public string? FSEQ { get; set; } |
| | | public string? FMaterialId { get; set; } |
| | | public string? FMaterialName { get; set; } |
| | | public string? FModel { get; set; } |
| | | public string? FUnitId { get; set; } |
| | | public string? FQty { get; set; } |
| | | public string? FStockUnitID { get; set; } |
| | | public string? FPriceUnitId { get; set; } |
| | | public string? FPriceUnitQty { get; set; } |
| | | public string? FDeliveryDate { get; set; } |
| | | public string? FDeliveryEarlyDate { get; set; } |
| | | public string? FDeliveryLastDate { get; set; } |
| | | public string? FRequireOrgId { get; set; } |
| | | public string? FRequireDeptId { get; set; } |
| | | public string? FReceiveOrgId { get; set; } |
| | | public string? FReceiveDeptId { get; set; } |
| | | public string? FSETTLEORGID { get; set; } |
| | | public string? FGiveAway { get; set; } |
| | | public string? FEntryNote { get; set; } |
| | | public string? Fnote { get; set; } |
| | | public string? FSupMatId { get; set; } |
| | | public string? FSupMatName { get; set; } |
| | | public string? FSUBREQBILLNO { get; set; } |
| | |
| | | public string? FMtoNo { get; set; } |
| | | public string? FChangeFlag { get; set; } |
| | | public string? FDEMANDTYPE { get; set; } |
| | | public string? FDEMANDBILLNO { get; set; } |
| | | //public string? FDEMANDBILLNO { get; set; } |
| | | public string? FDEMANDBILLENTRYSEQ { get; set; } |
| | | public string? PurchaseOrderLineNumber { get; set; } |
| | | public string? Demand { get; set; } |
| | | public string? Receiving { get; set; } |
| | | public string? Settlement { get; set; } |
| | | public string? fentryid { get; set; } |
| | | |
| | | } |
| | |
| | | public string? FStaffStartDate { get; set; } |
| | | public string? FDescription { get; set; } |
| | | public string? FForbidStatus { get; set; } |
| | | |
| | | public string? Fumbrella { get; set; } |
| | | public string? FSubsidiary { get; set; } |
| | | |
| | | } |
| | |
| | | public string? F_UNW_LXRDH { get; set; } |
| | | public string? FStaffId { get; set; } |
| | | public string? FForbidStatus { get; set; } |
| | | |
| | | public string? Fumbrella { get; set; } |
| | | public string? Fsubsidiary { get; set; } |
| | | public string? Fremarks { get; set; } |
| | | |
| | | } |
| | |
| | | public string? Fseller { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段1 |
| | | /// å註 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | [SugarColumn(ColumnName = "fremarks")] |
| | | public string? fremarks { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段2 |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | /* /// <summary> |
| | | /// èªå®ä¹å段3 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK3")] |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK5")] |
| | | public string? Remark5 { get; set; } |
| | | |
| | | */ |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | } |
| | |
| | | public string? MaterialProperti { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段1 |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// èªå®ä¹å段2 |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { 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; } |
| | | [SugarColumn(ColumnName = "FSTOCKSTATUSTYPE")] |
| | | public string? FStockStatusType { get; set; } |
| | | [SugarColumn(ColumnName = "FSUPPLIERID")] |
| | | public string? FSUPPLIERID { get; set; } |
| | | [SugarColumn(ColumnName = "Fdeptid")] |
| | | public string? Fdeptid { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PGROUP")] |
| | | public string? Pgroup { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | /// <summary> |
| | | /// æè¿° |
| | | /// </summary> |
| | |
| | | /// <summary> |
| | | /// ç©æåç±»ç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PPBOM00019124")] |
| | | public string? Ppbom00019124 { get; set; } |
| | | /* [SugarColumn(ColumnName = "PPBOM00019124")] |
| | | public string? Ppbom00019124 { get; set; }*/ |
| | | |
| | | /// <summary> |
| | | /// ç©æåç» |
| | |
| | | [SugarColumn(ColumnName = "SUBCON_UNIT")] |
| | | public string? SubconUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FLOSSPERCENT")] |
| | | public string? FLOSSPERCENT { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FMnemonicCode")] |
| | | |
| | | public string? FMnemonicCode { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FExpPeriod")] |
| | | public string? FExpPeriod { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | } |
| | |
| | | public string? Fforbidstatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { 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; } |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | |
| | | public string? CheckBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸æ è¯ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHECK_FALG")] |
| | | public short? CheckFalg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段1 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "changereason")] |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SETTLEMENT")] |
| | | public string? Settlement { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éæ±é¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEMAND_DEPARTMENT")] |
| | | public string? DemandDepartment { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶æé¨é¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")] |
| | | public string? ReceivingDepartment { get; set; } |
| | | } |
| | |
| | | public string FforbidStatus { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | /// <summary> |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | } |
| | |
| | | /// <summary> |
| | | /// èªå®ä¹å段1 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | [SugarColumn(ColumnName = "TYPE")] |
| | | public string? type { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段2 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK2")] |
| | | public string? Remark2 { get; set; } |
| | | [SugarColumn(ColumnName = "fremarks")] |
| | | public string? fremarks { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段3 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK3")] |
| | | public string? Remark3 { get; set; } |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段4 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK4")] |
| | | public string? Remark4 { get; set; } |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段5 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK5")] |
| | | public string? Remark5 { get; set; } |
| | | /* [SugarColumn(ColumnName = "REMARK5")] |
| | | public string? Remark5 { get; set; }*/ |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// ç»ç» |
| | | ///</summary> |
| | | [SugarTable("ORGANIZE")] |
| | | public class Organize |
| | | { |
| | | /// <summary> |
| | | /// ç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNUMBER" )] |
| | | public string Fnumber { get; set; } |
| | | /// <summary> |
| | | /// åç§° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNAME" )] |
| | | public string Fname { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | // [SugarColumn(ColumnName="ID" )] |
| | | [SugarColumn(IsPrimaryKey = true)] |
| | | public string Id { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨ç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFORBIDSTATUS" )] |
| | | public string Fforbidstatus { get; set; } |
| | | /// <summary> |
| | | /// æä½ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="TYPE" )] |
| | | public string Type { get; set; } |
| | | } |
| | | } |
| | |
| | | /// <summary> |
| | | /// èªå®ä¹å段1 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK1")] |
| | | public string? Remark1 { get; set; } |
| | | [SugarColumn(ColumnName = "FParentID")] |
| | | public string? FParentID { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使ç¨çµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | /// <summary> |
| | | /// åµå»ºçµç¹ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// èªå®ä¹å段2 |
| | |
| | | |
| | | private MesCustomer GetSysDepartment(ErpCustomer customer) |
| | | { |
| | | |
| | | //ERPå³è¼¸çæ¥å£æ¸æè½æçºMESæ¸æåº«åæ®µ |
| | | |
| | | return new MesCustomer |
| | | { |
| | | Id = Convert.ToDecimal(customer.Id), |
| | |
| | | Telf1 = customer.Fmobilephone, |
| | | Fseller = customer.Fseller, |
| | | Fforbidstatus = customer.FForbidStatus, |
| | | fremarks =customer.Fremarks, |
| | | FSubsidiary =customer.FSubsidiary, |
| | | Fumbrella = customer.Fumbrella, |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | Depottype = depots.FStockProperty, |
| | | IsNg = depots.FForbidStatus, |
| | | Zuid = depots.FGroup, |
| | | Company = "1000", |
| | | FSubsidiary = depots.FSubsidiary, |
| | | Fumbrella = depots.Fumbrella, |
| | | FSUPPLIERID = depots.FSUPPLIERID, |
| | | Fdeptid = depots.Fdeptid, |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
| | | } |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | |
| | |
| | | Tcode = department.FNumber, |
| | | Tname = department.FName, |
| | | Description = department.FDescription, |
| | | FSubsidiary = department.FSubsidiary, |
| | | Fumbrella = department.Fumbrella, |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | Highlimit = item.FMaxStock, |
| | | PrdPack = item.FMinPackCount, |
| | | DepotCode = item.FStockId, |
| | | Ppbom00019124 = item.PPBOM00019124, |
| | | //Ppbom00019124 = item.PPBOM00019124, |
| | | Fmaterialgroup = item.FMaterialGroup, |
| | | Remarks = item.FDescription, |
| | | Ffinishreceiptoverrate = item.FFinishReceiptOverRate, |
| | |
| | | ProductionWorkshop = item.FWorkShopId, |
| | | ProduceUnit = item.FPRODUCEUNITID, |
| | | SubconUnit = item.FSUBCONUNITID, |
| | | FSubsidiary = item.FSubsidiary, |
| | | Fumbrella = item.Fumbrella, |
| | | FLOSSPERCENT = item.FLOSSPERCENT , |
| | | FMnemonicCode = item.FMnemonicCode, |
| | | FExpPeriod = item.FExpPeriod , |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | PositionDescription = position.FDESCRIPTIONS, |
| | | Department = position.FDept, |
| | | Fforbidstatus = position.FForbidStatus, |
| | | FSubsidiary = position.FSubsidiary, |
| | | Fumbrella = position.Fumbrella, |
| | | CreationDate = position.FCreateDate != null |
| | | ? DateTime.ParseExact(position.FCreateDate, |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | |
| | | { |
| | | var rohInErpRohIn = rohIn.ErpRohIn; |
| | | var mesRohIn = GetMesRohIn(rohInErpRohIn); |
| | | var mesRohInDatas = |
| | | GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type); |
| | | var mesRohInDatas = GetMesRohInDatas(rohIn.ErpRohinDatas, rohInErpRohIn.Type); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (rohInErpRohIn.Type) |
| | | { |
| | | // case "2": |
| | | // return InsertData(db, mesRohIn, mesRohInDatas, |
| | | // rohInErpRohIn.FBILLTYPE) |
| | | // ? 1 |
| | | // : 0; |
| | | case "3": |
| | | return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | return SaveOrUpdateData(db, mesRohIn, mesRohInDatas) |
| | | ? 1 |
| | | : 0; |
| | | case "5": |
| | | return SaveOrUpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0; |
| | | case "3": |
| | | return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{rohInErpRohIn.Type}è¿ä¸ªç±»å"); |
| | |
| | | mesRohIn.PurchaseGroup = rohIn.FPurchaserGroupId; |
| | | mesRohIn.QtyAcceptance = rohIn.Facctype; |
| | | mesRohIn.Purchaser = rohIn.FPurchaserId; |
| | | mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq; |
| | | //mesRohIn.QualityReq = rohIn.F_UNW_Remarks_zlyq; |
| | | mesRohIn.SettlementParty = rohIn.FSettleId; |
| | | mesRohIn.PaymentParty = rohIn.FChargeId; |
| | | mesRohIn.Email = rohIn.FProviderEMail; |
| | | mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs; |
| | | mesRohIn.Remarks = rohIn.F_UNW_BZ; |
| | | mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj; |
| | | // mesRohIn.Email = rohIn.FProviderEMail; |
| | | // mesRohIn.TransportMethod = rohIn.F_UNW_Text_ysfs; |
| | | mesRohIn.Remarks = rohIn.FHEADNOTE; |
| | | // mesRohIn.FixtureMoldProcurement = rohIn.F_UNW_Combo_zjmj; |
| | | mesRohIn.CancellationStatus = rohIn.FCancelStatus; |
| | | mesRohIn.CancellationPerson = rohIn.FCancellerId; |
| | | |
| | |
| | | EbelnK3id = Convert.ToDecimal(s.id), |
| | | ErpId = Convert.ToDecimal(s.Eid), |
| | | BillNo = s.FBillNo, |
| | | SalesOrderId = s.F_UNW_Text_xsddh, |
| | | SalesOrderId=s.FDEMANDBILLNO, |
| | | OrderLineId=s.FSEQ, |
| | | ItemId = s.FMaterialId, |
| | | PurchaseUnit = s.FUnitId, |
| | | PurchaseQty = Convert.ToDecimal(s.FQty), |
| | | InventoryUnit = s.FStockUnitID, |
| | | PricingUnit = s.FPriceUnitId, |
| | | PricingQty = Convert.ToDecimal(s.FPriceUnitQty), |
| | | DeliveryDate = s.FDeliveryDate != null |
| | | ? DateTime.ParseExact(s.FDeliveryDate, |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | |
| | | "yyyy-MM-dd HH:mm:ss", null) |
| | | : null, |
| | | IsGift = s.FGiveAway, |
| | | Remarks = s.FEntryNote, |
| | | Remarks = s.Fnote, |
| | | SupplierItemCode = s.FSupMatId, |
| | | SupplierItemName = s.FSupMatName, |
| | | OutsourcingOrderId = s.FSUBREQBILLNO, |
| | |
| | | DemandSource = s.FDEMANDTYPE, |
| | | DemandDocumentId = s.FDEMANDBILLNO, |
| | | DemandDocumentLineId = s.FDEMANDBILLENTRYSEQ, |
| | | PurchaseOrderLineNumber = s.PurchaseOrderLineNumber, |
| | | Demand = s.Demand, |
| | | Receiving = s.Receiving, |
| | | Settlement = s.Settlement |
| | | DemandOrg = s.FRequireOrgId, |
| | | ReceivingOrg = s.FReceiveOrgId, |
| | | SettlementOrg = s.FSETTLEORGID, |
| | | PurchaseOrderLineNumber = s.FSEQ, |
| | | Demand =s.FRequireOrgId, |
| | | Receiving = s.FReceiveOrgId, |
| | | Settlement =s.FSETTLEORGID, |
| | | DemandDepartment = s.FRequireDeptId, |
| | | ReceivingDepartment = s.FReceiveDeptId |
| | | }; |
| | | |
| | | var single = rohInDataManager.GetSingle(it => |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | PositionName = staff.FPost, |
| | | PhoneNumber = staff.FMobile, |
| | | Remark = staff.FDescription, |
| | | FforbidStatus = staff.FForbidStatus |
| | | FforbidStatus = staff.FForbidStatus, |
| | | FSubsidiary = staff.FSubsidiary, |
| | | Fumbrella = staff.Fumbrella, |
| | | }; |
| | | |
| | | if (staff.FStaffStartDate != null) |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | Telf1 = supplier.F_UNW_LXRDH, |
| | | Fstaffid = supplier.FStaffId, |
| | | Fforbidstatus = supplier.FForbidStatus, |
| | | type= supplier.Type, |
| | | fremarks = supplier.Fremarks, |
| | | FSubsidiary = supplier.Fsubsidiary, |
| | | Fumbrella = supplier.Fumbrella, |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using MES.Service.Dto.webApi; |
| | | using System.Xml.Linq; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class OrganizeManager : Repository<Organize> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ OrganizeManager.cs |
| | | public bool Save(ErpOrganize item) |
| | | { |
| | | var entity = GetOrganize(item); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (item.Type) |
| | | { |
| | | case "0": |
| | | if (UpdateOrganizetatus(db, entity.Id, "A")) |
| | | return 1; |
| | | break; |
| | | case "1": |
| | | if (UpdateOrganizetatus(db, entity.Id, "B")) |
| | | return 1; |
| | | break; |
| | | case "2": |
| | | if (InsertItem(db, entity)) |
| | | return 1; |
| | | break; |
| | | case "3": |
| | | if (DeleteItem(db, Convert.ToDecimal(entity.Id))) |
| | | return 1; |
| | | break; |
| | | case "4": |
| | | if (InsertOrUpdate(db, entity)) |
| | | return 1; |
| | | break; |
| | | default: |
| | | throw new ArgumentNullException( |
| | | $"type没æ{item.Type}è¿ä¸ªç±»åçåæ°"); |
| | | } |
| | | |
| | | throw new NotImplementedException("æä½å¤±è´¥"); |
| | | }) > 0; |
| | | } |
| | | |
| | | public bool SaveList(List<ErpOrganize> Organize) |
| | | { |
| | | var list = Organize.Select(GetOrganize).ToList(); |
| | | var groupBy = list.GroupBy(s => s.Type) |
| | | .ToDictionary(g => g.Key, g => g.ToList()); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | foreach (var itemGroup in groupBy) |
| | | switch (itemGroup.Key) |
| | | { |
| | | case "0": |
| | | if (!UpdateOrganizetatusBatch(db, itemGroup.Value, "A")) |
| | | throw new NotImplementedException("å¯ç¨å¤±è´¥"); |
| | | break; |
| | | case "1": |
| | | if (!UpdateOrganizetatusBatch(db, itemGroup.Value, "B")) |
| | | throw new NotImplementedException("ç¦ç¨å¤±è´¥"); |
| | | break; |
| | | case "2": |
| | | if (!InsertItemBatch(db, itemGroup.Value)) |
| | | throw new NotImplementedException("æå
¥å¤±è´¥"); |
| | | break; |
| | | case "3": |
| | | if (!DeleteItemBatch(db, itemGroup.Value)) |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | break; |
| | | case "4": |
| | | if (!InsertOrUpdateBatch(db, itemGroup.Value)) |
| | | throw new NotImplementedException("åæ¥å¤±è´¥"); |
| | | break; |
| | | default: |
| | | throw new ArgumentNullException( |
| | | $"type没æ{itemGroup.Key}è¿ä¸ªç±»åçåæ°"); |
| | | } |
| | | |
| | | return 1; |
| | | }) > 0; |
| | | } |
| | | |
| | | private bool UpdateOrganizetatus(SqlSugarScope db, string itemId, |
| | | string status) |
| | | { |
| | | var result = db.Updateable<Organize>() |
| | | .SetColumns(s => s.Fforbidstatus == status) |
| | | .Where(s => s.Id == itemId).ExecuteCommand(); |
| | | |
| | | if (result > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException(status == "A" ? "å¯ç¨å¤±è´¥" : "ç¦ç¨å¤±è´¥"); |
| | | } |
| | | |
| | | private bool InsertItem(SqlSugarScope db, Organize entity) |
| | | { |
| | | var insert = db.Insertable(entity).ExecuteCommand(); |
| | | if (insert > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException("æå
¥å¤±è´¥"); |
| | | } |
| | | |
| | | private bool DeleteItem(SqlSugarScope db, decimal itemId) |
| | | { |
| | | var deleteById = db.Deleteable<Organize>().In(itemId).ExecuteCommand(); |
| | | if (deleteById > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | private Organize GetOrganize(ErpOrganize Organize) |
| | | { |
| | | return new Organize |
| | | { |
| | | |
| | | Id = Organize.Id, |
| | | Fnumber = Organize.FNumber, |
| | | Fname = Organize.FName, |
| | | Fforbidstatus = Organize.FForbidStatus, |
| | | Type = Organize.Type |
| | | }; |
| | | } |
| | | |
| | | private bool UpdateOrganizetatusBatch(SqlSugarScope db, |
| | | List<Organize> itemList, string status) |
| | | { |
| | | var ids = itemList.Select(it => it.Id).ToArray(); |
| | | var result = db.Updateable<Organize>() |
| | | .SetColumns(s => s.Fforbidstatus == status) |
| | | .Where(s => ids.Contains(s.Id)).ExecuteCommand(); |
| | | |
| | | if (result > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException(status == "A" ? "å¯ç¨å¤±è´¥" : "ç¦ç¨å¤±è´¥"); |
| | | } |
| | | |
| | | private bool InsertItemBatch(SqlSugarScope db, List<Organize> itemList) |
| | | { |
| | | var insertRange = db.Insertable(itemList).ExecuteCommand(); |
| | | if (insertRange > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException("æå
¥å¤±è´¥"); |
| | | } |
| | | |
| | | private bool DeleteItemBatch(SqlSugarScope db, List<Organize> itemList) |
| | | { |
| | | var ids = itemList.Select(it => it.Id).ToArray(); |
| | | var deleteByIds = db.Deleteable<Organize>().In(ids).ExecuteCommand(); |
| | | if (deleteByIds > 0) |
| | | return true; |
| | | |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | private bool InsertOrUpdate(SqlSugarScope db, Organize entity) |
| | | { |
| | | var exists = db.Queryable<Organize>().Any(e => e.Id == entity.Id); |
| | | if (exists) |
| | | { |
| | | var update = db.Updateable(entity).ExecuteCommand(); |
| | | if (update > 0) |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | var insert = db.Insertable(entity).ExecuteCommand(); |
| | | if (insert > 0) |
| | | return true; |
| | | } |
| | | |
| | | return false; |
| | | } |
| | | |
| | | private bool InsertOrUpdateBatch(SqlSugarScope db, List<Organize> itemList) |
| | | { |
| | | foreach (var entity in itemList) |
| | | if (!InsertOrUpdate(db, entity)) |
| | | return false; |
| | | |
| | | return true; |
| | | } |
| | | #region æå¦æ¹æ³ |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList();//æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel() { FieldName= typeof(Organize).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); |
| | | |
| | | base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new Organize() { };//æµè¯åæ° |
| | | var insertArray = new Organize[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new Organize() { };//æµè¯åæ° |
| | | var updateArray = new Organize[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new Organize() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new Organize() { };//æµè¯åæ° |
| | | base.Delete(deldata);//æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ |
| | | base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | using MES.Service.DB; |
| | | using Castle.Core.Resource; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | |
| | | Depextr2 = department.FGroup, |
| | | Depextr3 = department.FWIPStockID, |
| | | Depextr4 = department.FForbidStatus, |
| | | FParentID= department.FParentID, |
| | | FSubsidiary = department.FSubsidiary, |
| | | Fumbrella = department.Fumbrella, |
| | | Company = "1000", |
| | | Factory = "1000" |
| | | }; |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Microsoft.Extensions.Logging; |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Threading.Tasks; |
| | | using System.Dynamic; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.util; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.service.BasicData; |
| | | using Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers |
| | | { |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class OrganizeController : ControllerBase |
| | | { |
| | | private readonly MessageCenterManager _manager = new(); |
| | | |
| | | private readonly OrganizeManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "Organize"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/Organize/"; |
| | | |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(ErpOrganize unit) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(unit); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(unit); |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | [HttpPost("SaveList")] |
| | | public ResponseResult SaveList(List<ErpOrganize> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | // private OrganizeManager m = new OrganizeManager(); |
| | | |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <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(int id) |
| | | { |
| | | 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] Organize data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Insert(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] Organize 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] Organize 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); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | </PropertyGroup> |
| | | <PropertyGroup> |
| | | <ActiveDebugProfile>IIS Express</ActiveDebugProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Workspace\gs\RK_MESApplication\MESApplication\Properties\PublishProfiles\FolderProfile1.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Tools\StandardPda\MESApplication\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | </PropertyGroup> |
| | | </Project> |
| | |
| | | --> |
| | | <Project> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>D:\Workspace\gs\RK_MESApplication\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl> |
| | | <History>True|2024-04-10T04:55:31.3963752Z;True|2024-04-08T13:59:25.5487203+08:00;True|2024-04-06T09:30:09.5350539+08:00;True|2024-04-06T08:46:05.8814658+08:00;True|2024-04-05T14:06:52.0448024+08:00;True|2024-04-05T12:47:46.0561601+08:00;True|2024-02-26T08:46:22.0988887+08:00;True|2024-02-24T19:17:13.6770376+08:00;True|2024-02-24T14:32:37.4450337+08:00;True|2024-02-23T10:22:06.5150173+08:00;True|2024-02-22T13:19:56.6997993+08:00;True|2024-02-22T10:53:17.7929585+08:00;True|2024-02-21T17:08:06.5553444+08:00;True|2024-02-19T16:24:37.4912012+08:00;True|2024-02-02T10:07:23.2726075+08:00;True|2024-02-02T08:36:49.2904460+08:00;True|2024-01-29T17:44:43.6800769+08:00;True|2024-01-23T09:47:26.7811926+08:00;True|2024-01-18T16:23:30.3373836+08:00;True|2024-01-17T14:22:04.2552286+08:00;True|2024-01-16T16:54:42.2316892+08:00;True|2024-01-16T16:37:23.8028858+08:00;True|2024-01-16T09:25:24.4007775+08:00;True|2024-01-15T10:18:57.3362616+08:00;True|2024-01-15T10:07:14.2044763+08:00;True|2024-01-10T14:03:36.4451130+08:00;True|2024-01-09T16:45:32.9601815+08:00;True|2024-01-06T14:16:34.2732220+08:00;True|2024-01-06T14:11:45.2134717+08:00;True|2024-01-06T11:30:58.9198887+08:00;</History> |
| | | <_PublishTargetUrl>D:\Tools\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl> |
| | | <History>True|2024-08-07T02:32:10.3689256Z||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;True|2024-01-17T14:22:04.2552286+08:00||;True|2024-01-16T16:54:42.2316892+08:00||;True|2024-01-16T16:37:23.8028858+08:00||;True|2024-01-16T09:25:24.4007775+08:00||;True|2024-01-15T10:18:57.3362616+08:00||;True|2024-01-15T10:07:14.2044763+08:00||;True|2024-01-10T14:03:36.4451130+08:00||;True|2024-01-09T16:45:32.9601815+08:00||;True|2024-01-06T14:16:34.2732220+08:00||;True|2024-01-06T14:11:45.2134717+08:00||;True|2024-01-06T11:30:58.9198887+08:00||;</History> |
| | | <LastFailureDetails /> |
| | | </PropertyGroup> |
| | | </Project> |
| | |
| | | <aspNetCore processPath="dotnet" arguments=".\MESApplication.dll" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout" hostingModel="inprocess" /> |
| | | </system.webServer> |
| | | </location> |
| | | </configuration> |
| | | </configuration> |
| | | <!--ProjectGuid: C0B360C5-E8CC-4BC3-AAA5-3F03A2D6C0AA--> |
| | |
| | | { |
| | | "sdk": { |
| | | "version": "8.0.0", |
| | | "version": "8.0.101", |
| | | "rollForward": "latestMajor", |
| | | "allowPrerelease": false |
| | | } |