¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpOut |
| | | { |
| | | public ErpOutWare ErpOutWares { get; set; } |
| | | public List<ErpOutWareDetails> ErpOutWareDetailss { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpOutWare |
| | | { |
| | | |
| | | |
| | | public decimal OutType { get; set; } |
| | | public string OutNo { get; set; } |
| | | public DateTime? BillDate { get; set; } |
| | | public string? CustNo { get; set; } |
| | | public string? BusinessBy { get; set; } |
| | | public string? WorkCode { get; set; } |
| | | public string? DeliveryCust { get; set; } |
| | | public string? QuickNo { get; set; } |
| | | public string? DeliveryAddress { get; set; } |
| | | public string? CheckBy { get; set; } |
| | | public DateTime? CheckDate { get; set; } |
| | | public string? CreateBy { get; set; } |
| | | public DateTime? CreateDate { get; set; } |
| | | public string? Remarks { get; set; } |
| | | public string? Type { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpOutWareDetails |
| | | { |
| | | |
| | | |
| | | public decimal OrderType { get; set; } |
| | | public string OrderNumber { get; set; } |
| | | public string OrderNo { get; set; } |
| | | public string? ItemNo { get; set; } |
| | | public string? ItemName { get; set; } |
| | | public string? ItemModel { get; set; } |
| | | public string? DepotCode { get; set; } |
| | | public decimal? Quantity { get; set; } |
| | | public decimal? OutQuantity { get; set; } |
| | | public decimal OutType { get; set; } |
| | | public string OutNo { get; set; } |
| | | public string? Remarks { get; set; } |
| | | public string? Type { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpReturn |
| | | { |
| | | public ErpReturnWare ErpReturnWares { get; set; } |
| | | public List<ErpReturnWareDetails> ErpReturnWareDetailss { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpReturnWare |
| | | { |
| | | |
| | | |
| | | public decimal ReturnType { get; set; } |
| | | public string ReturnNo { get; set; } |
| | | public string? CustNo { get; set; } |
| | | public DateTime? BillDate { get; set; } |
| | | public string? BusinessBy { get; set; } |
| | | public string? WorkCode { get; set; } |
| | | public string? Remarks { get; set; } |
| | | public string? CreateBy { get; set; } |
| | | public DateTime? CreateDate { get; set; } |
| | | public string? Type { get; set; } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpReturnWareDetails |
| | | { |
| | | |
| | | public string? ItemNo { get; set; } |
| | | public string? ItemName { get; set; } |
| | | public string? ItemModel { get; set; } |
| | | public decimal? Quantity { get; set; } |
| | | public string? Type { get; set; } |
| | | public string? DepotCode { get; set; } |
| | | public decimal? ReturnType { get; set; } |
| | | public string? ReturnNo { get; set; } |
| | | public string? ReturnOrder { get; set; } |
| | | public decimal OrderType { get; set; } |
| | | public string OrderNumber { get; set; } |
| | | public string OrderNo { get; set; } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// éå®åè´§éç¥ä¸»è¡¨ |
| | | ///</summary> |
| | | [SugarTable("MES_OUTWARE")] |
| | | public class MesOutware |
| | | { |
| | | /// <summary> |
| | | /// 主é®ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// éå®åºè´§åå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUTWARE_TYPE" )] |
| | | public decimal? OutwareType { get; set; } |
| | | /// <summary> |
| | | /// éå®åºè´§åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUTWARE_NO" )] |
| | | public string OutwareNo { get; set; } |
| | | /// <summary> |
| | | /// 客æ·ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CUST_NO" )] |
| | | public string CustNo { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BILL_DATE" )] |
| | | public DateTime? BillDate { get; set; } |
| | | /// <summary> |
| | | /// ä¸å¡äººå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BUSINESS_BY" )] |
| | | public string BusinessBy { get; set; } |
| | | /// <summary> |
| | | /// é¨é¨ç¼ç (å·¥ä½ä¸å¿) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )] |
| | | public string WorkshopCenterCode { get; set; } |
| | | /// <summary> |
| | | /// éè´§å®¢æ· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DELIVERY_CUST" )] |
| | | public string DeliveryCust { get; set; } |
| | | /// <summary> |
| | | /// å¿«æ·ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="QUICK_NO" )] |
| | | public string QuickNo { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸è
|
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_BY" )] |
| | | public string CheckBy { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_DATE" )] |
| | | public DateTime? CheckDate { 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="REMARKS" )] |
| | | public string Remarks { get; set; } |
| | | /// <summary> |
| | | /// éè´§å°å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DELIVERY_ADDRESS" )] |
| | | public string DeliveryAddress { 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("MES_OUTWARE_DETAILS")] |
| | | public class MesOutwareDetails |
| | | { |
| | | /// <summary> |
| | | /// 主é®ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// 主表ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="PID" )] |
| | | public decimal? Pid { get; set; } |
| | | /// <summary> |
| | | /// 订ååå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_TYPE" )] |
| | | public decimal? OrderType { get; set; } |
| | | /// <summary> |
| | | /// 订ååºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_NUMBER" )] |
| | | public string OrderNumber { get; set; } |
| | | /// <summary> |
| | | /// 订ååå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_NO" )] |
| | | public string OrderNo { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç (åå·) |
| | | ///</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_MODEL" )] |
| | | public string ItemModel { get; set; } |
| | | /// <summary> |
| | | /// ä»åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_CODE" )] |
| | | public string DepotCode { get; set; } |
| | | /// <summary> |
| | | /// é¢è®¡åºè´§æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="QUANTITY" )] |
| | | public decimal? Quantity { get; set; } |
| | | /// <summary> |
| | | /// å®é
åºè´§æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUT_QUANTITY" )] |
| | | public decimal? OutQuantity { get; set; } |
| | | /// <summary> |
| | | /// åºè´§åå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUTWARE_TYPE" )] |
| | | public decimal? OutwareType { get; set; } |
| | | /// <summary> |
| | | /// åºè´§åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUTWARE_NO" )] |
| | | public string OutwareNo { get; set; } |
| | | /// <summary> |
| | | /// ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="TYPE" )] |
| | | public string Type { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="REMARKS" )] |
| | | public string Remarks { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// éå®éè´§éç¥ä¸»è¡¨ |
| | | ///</summary> |
| | | [SugarTable("MES_RETURNWARE")] |
| | | public class MesReturnware |
| | | { |
| | | /// <summary> |
| | | /// 主é®ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// éå®éè´§åå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RETURN_TYPE" )] |
| | | public decimal? ReturnType { get; set; } |
| | | /// <summary> |
| | | /// éå®éè´§åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RETURN_NO" )] |
| | | public string ReturnNo { get; set; } |
| | | /// <summary> |
| | | /// 客æ·ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CUST_NO" )] |
| | | public string CustNo { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BILL_DATE" )] |
| | | public DateTime? BillDate { get; set; } |
| | | /// <summary> |
| | | /// ä¸å¡äººå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BUSINESS_BY" )] |
| | | public string BusinessBy { get; set; } |
| | | /// <summary> |
| | | /// é¨é¨ç¼ç (å·¥ä½ä¸å¿) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )] |
| | | public string WorkshopCenterCode { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="REMARKS" )] |
| | | public string Remarks { get; set; } |
| | | /// <summary> |
| | | /// å建人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CREATE_BY" )] |
| | | public string CreateBy { get; set; } |
| | | /// <summary> |
| | | /// å建æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CREATE_DATE" )] |
| | | public DateTime? CreateDate { 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("MES_RETURNWARE_DETAILS")] |
| | | public class MesReturnwareDetails |
| | | { |
| | | /// <summary> |
| | | /// 主é®ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID" , OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// 主表ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="PID")] |
| | | public decimal? Pid { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç (åå·) |
| | | ///</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_MODEL" )] |
| | | public string ItemModel { get; set; } |
| | | /// <summary> |
| | | /// ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="TYPE" )] |
| | | public string Type { get; set; } |
| | | /// <summary> |
| | | /// æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "QUANTITY")] |
| | | public decimal? Quantity { get; set; } |
| | | /// <summary> |
| | | /// éè´§ä»åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_CODE" )] |
| | | public string DepotCode { get; set; } |
| | | /// <summary> |
| | | /// éå®éè´§åå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RETURN_TYPE" )] |
| | | public decimal? ReturnType { get; set; } |
| | | /// <summary> |
| | | /// éå®éè´§åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RETURN_NO" )] |
| | | public string ReturnNo { get; set; } |
| | | /// <summary> |
| | | /// éå®éè´§åºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RETURN_ORDER" )] |
| | | public string ReturnOrder { get; set; } |
| | | /// <summary> |
| | | /// 订ååå« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_TYPE" )] |
| | | public decimal? OrderType { get; set; } |
| | | /// <summary> |
| | | /// 订ååºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_NUMBER" )] |
| | | public string OrderNumber { get; set; } |
| | | /// <summary> |
| | | /// 订ååå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORDER_NO" )] |
| | | public string OrderNo { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesOutwareDetailsManager : Repository<MesOutwareDetails> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesOutwareDetailsManager.cs |
| | | |
| | | |
| | | #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(MesOutwareDetails).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 MesOutwareDetails() { };//æµè¯åæ° |
| | | var insertArray = new MesOutwareDetails[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new MesOutwareDetails() { };//æµè¯åæ° |
| | | var updateArray = new MesOutwareDetails[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new MesOutwareDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new MesOutwareDetails() { };//æµè¯åæ° |
| | | 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 SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using MES.Service.Dto.webApi; |
| | | using System.Globalization; |
| | | using MES.Service.service.BasicData; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesOutwareManager : Repository<MesOutware> |
| | | { |
| | | |
| | | |
| | | private readonly MesOutwareDetailsManager outwareDetailsManager = new(); |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesOutwareManager.cs |
| | | |
| | | |
| | | |
| | | |
| | | public bool SaveList(List<ErpOut> OutWare) |
| | | { |
| | | var result = OutWare.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | public bool Save(ErpOut OutWare) |
| | | { |
| | | var OutWares = OutWare.ErpOutWares; |
| | | var mesOutWares = MapErptoMesOutware(OutWares); |
| | | var ErpOutWareDetails = MapErptoMesOutwareDetails(OutWare.ErpOutWareDetailss); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (OutWares.Type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesOutWares, ErpOutWareDetails) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | return SaveOrUpdateData(db, mesOutWares, ErpOutWareDetails) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{OutWares.Type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | } |
| | | |
| | | private bool SaveOrUpdateData(SqlSugarScope db, MesOutware mesOutware, |
| | | List<MesOutwareDetails> mesOutwareDetails) |
| | | { |
| | | |
| | | |
| | | if (mesOutware.OutwareNo != null && mesOutware.OutwareType != null) |
| | | { |
| | | |
| | | db.Deleteable<MesOutware>() |
| | | .Where(it => it.OutwareNo == mesOutware.OutwareNo && |
| | | it.OutwareType == mesOutware.OutwareType) |
| | | .ExecuteCommand(); |
| | | |
| | | }; |
| | | |
| | | |
| | | if (mesOutwareDetails.Count > 0) |
| | | { |
| | | |
| | | // var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002, CAB003 = s.Cab003 }).ToList(); |
| | | var mesOutwareDetail = mesOutwareDetails.Select(s => new { OutwareNo = s.OutwareNo, OutwareType = s.OutwareType }).ToList(); |
| | | |
| | | |
| | | /*db.Deleteable<Womcab>() |
| | | .Where(it => mesWomcab |
| | | .Any(p => p.CAB001 == it.Cab001 |
| | | && p.CAB002 == it.Cab002 |
| | | && p.CAB003 == it.Cab003)) |
| | | .ExecuteCommand();*/ |
| | | db.Deleteable<MesOutwareDetails>() |
| | | .Where(it => mesOutwareDetail |
| | | .Any(p => p.OutwareNo == it.OutwareNo |
| | | && p.OutwareType == it.OutwareType)) |
| | | .ExecuteCommand(); |
| | | |
| | | }; |
| | | |
| | | |
| | | // var orUpdate = db.Insertable(mesOutware).ExecuteCommand(); |
| | | //var baOrUpdate = db.Insertable(mesOutwareDetails).ExecuteCommand(); |
| | | |
| | | |
| | | var orUpdate = base.Insert(mesOutware); |
| | | var baOrUpdate = outwareDetailsManager.InsertRange(mesOutwareDetails); |
| | | |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | |
| | | |
| | | } |
| | | |
| | | private bool UpdateData(SqlSugarScope db, MesOutware mesOutware, |
| | | List<MesOutwareDetails> mesOutwareDetails) |
| | | { |
| | | //æ ¹æ®åå«ååå·è¿è¡å é¤ |
| | | var update = db.Deleteable<MesOutware>() |
| | | .Where(it => it.OutwareNo == mesOutware.OutwareNo && |
| | | it.OutwareType == mesOutware.OutwareType) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | //var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002, CAB003 = s.Cab003 }).ToList(); |
| | | var mesOutwareDetail = mesOutwareDetails.Select(s => new { OutwareNo = s.OutwareNo, OutwareType = s.OutwareType }).ToList(); |
| | | |
| | | |
| | | |
| | | //var insertOrUpdate = db.Deleteable<Womcab>().Where(it => mesWomcab.Any(p => p.CAB001 == it.Cab001 && p.CAB002 == it.Cab002 && p.CAB003 == it.Cab003)).ExecuteCommand() > 0; |
| | | var insertOrUpdate = db.Deleteable<MesOutwareDetails>().Where(it => mesOutwareDetail.Any(p => p.OutwareNo == it.OutwareNo && p.OutwareType == it.OutwareType)).ExecuteCommand() > 0; |
| | | |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("æ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | private MesOutware MapErptoMesOutware(ErpOutWare dto) |
| | | { |
| | | |
| | | |
| | | |
| | | var entity = new MesOutware |
| | | { |
| | | OutwareType = dto.OutType, |
| | | OutwareNo = dto.OutNo, |
| | | CustNo = dto.CustNo, |
| | | |
| | | BillDate = dto.BillDate, |
| | | BusinessBy = dto.BusinessBy, |
| | | WorkshopCenterCode = dto.WorkCode, |
| | | |
| | | DeliveryCust = dto.DeliveryCust, |
| | | QuickNo = dto.QuickNo, |
| | | CheckBy = dto.CheckBy, |
| | | |
| | | CheckDate = dto.CheckDate, |
| | | CreateBy = dto.CreateBy, |
| | | CreateDate = dto.CreateDate, |
| | | |
| | | Remarks = dto.Remarks, |
| | | |
| | | DeliveryAddress = dto.DeliveryAddress, |
| | | Type = dto.Type |
| | | |
| | | |
| | | |
| | | }; |
| | | |
| | | |
| | | |
| | | return entity; |
| | | } |
| | | |
| | | private List<MesOutwareDetails> MapErptoMesOutwareDetails(List<ErpOutWareDetails> dtoList) |
| | | { |
| | | var outwareList = new List<MesOutwareDetails>(); |
| | | |
| | | foreach (var dto in dtoList) |
| | | { |
| | | var OutwareDetails = new MesOutwareDetails |
| | | { |
| | | |
| | | OrderType = dto.OrderType, |
| | | OrderNumber = dto.OrderNumber, |
| | | OrderNo = dto.OrderNo, |
| | | ItemNo = dto.ItemNo, |
| | | ItemName = dto.ItemName, |
| | | ItemModel = dto.ItemModel, |
| | | DepotCode = dto.DepotCode, |
| | | Quantity = dto.Quantity, |
| | | OutQuantity = dto.OutQuantity, |
| | | OutwareType = dto.OutType, |
| | | OutwareNo = dto.OutNo, |
| | | Type = dto.Type, |
| | | Remarks = dto.Remarks |
| | | |
| | | }; |
| | | |
| | | |
| | | |
| | | outwareList.Add(OutwareDetails); |
| | | } |
| | | |
| | | return outwareList; |
| | | } |
| | | |
| | | |
| | | public bool Delete(YFDelete data) |
| | | { |
| | | |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | var update = db.Deleteable<Womcaa>() |
| | | .Where(it => it.Caa001 == data.FBillNo && |
| | | it.SrcBillType == data.FBillTypeID) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | var insertOrUpdate = db.Deleteable<Womcab>() |
| | | .Where(it => it.Cab001 == data.FBillNo && |
| | | it.Cab002 == data.FBillTypeID) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | |
| | | if (update && insertOrUpdate) return 1; |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | }) > 0; |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesReturnwareDetailsManager : Repository<MesReturnwareDetails> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesReturnwareDetailsManager.cs |
| | | |
| | | |
| | | #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(MesReturnwareDetails).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 MesReturnwareDetails() { };//æµè¯åæ° |
| | | var insertArray = new MesReturnwareDetails[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new MesReturnwareDetails() { };//æµè¯åæ° |
| | | var updateArray = new MesReturnwareDetails[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new MesReturnwareDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new MesReturnwareDetails() { };//æµè¯åæ° |
| | | 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 SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using MES.Service.Dto.webApi; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesReturnwareManager : Repository<MesReturnware> |
| | | { |
| | | |
| | | |
| | | private readonly MesReturnwareDetailsManager ReturnwareDetailsManager = new(); |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesReturnwareManager.cs |
| | | |
| | | |
| | | public bool SaveList(List<ErpReturn> ReturnWare) |
| | | { |
| | | var result = ReturnWare.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | public bool Save(ErpReturn ReturnWare) |
| | | { |
| | | var ReturnWares = ReturnWare.ErpReturnWares; |
| | | var mesReturnWares = MapErptoMesReturnware(ReturnWares); |
| | | var ErpReturnWareDetails = MapErptoMesReturnwareDetails(ReturnWare.ErpReturnWareDetailss); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (ReturnWares.Type) |
| | | { |
| | | case "3": |
| | | return UpdateData(db, mesReturnWares, ErpReturnWareDetails) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | return SaveOrUpdateData(db, mesReturnWares, ErpReturnWareDetails) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{ReturnWares.Type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | } |
| | | |
| | | private bool SaveOrUpdateData(SqlSugarScope db, MesReturnware mesReturnware, |
| | | List<MesReturnwareDetails> mesReturnwareDetails) |
| | | { |
| | | |
| | | |
| | | if (mesReturnware.ReturnNo != null && mesReturnware.ReturnType != null) |
| | | { |
| | | |
| | | db.Deleteable<MesReturnware>() |
| | | .Where(it => it.ReturnNo == mesReturnware.ReturnNo && |
| | | it.ReturnType == mesReturnware.ReturnType) |
| | | .ExecuteCommand(); |
| | | |
| | | }; |
| | | |
| | | |
| | | if (mesReturnwareDetails.Count > 0) |
| | | { |
| | | |
| | | // var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002, CAB003 = s.Cab003 }).ToList(); |
| | | var mesReturnwareDetail = mesReturnwareDetails.Select(s => new { ReturnwareNo = s.ReturnNo, ReturnwareType = s.ReturnType }).ToList(); |
| | | |
| | | |
| | | /*db.Deleteable<Womcab>() |
| | | .Where(it => mesWomcab |
| | | .Any(p => p.CAB001 == it.Cab001 |
| | | && p.CAB002 == it.Cab002 |
| | | && p.CAB003 == it.Cab003)) |
| | | .ExecuteCommand();*/ |
| | | db.Deleteable<MesReturnwareDetails>() |
| | | .Where(it => mesReturnwareDetail |
| | | .Any(p => p.ReturnwareNo == it.ReturnNo |
| | | && p.ReturnwareType == it.ReturnType)) |
| | | .ExecuteCommand(); |
| | | |
| | | }; |
| | | |
| | | |
| | | // var orUpdate = db.Insertable(mesOutware).ExecuteCommand(); |
| | | //var baOrUpdate = db.Insertable(mesOutwareDetails).ExecuteCommand(); |
| | | |
| | | |
| | | var orUpdate = base.Insert(mesReturnware); |
| | | var baOrUpdate = ReturnwareDetailsManager.InsertRange(mesReturnwareDetails); |
| | | |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | |
| | | |
| | | } |
| | | |
| | | private bool UpdateData(SqlSugarScope db, MesReturnware mesReturnware, |
| | | List<MesReturnwareDetails> mesReturnwareDetails) |
| | | { |
| | | //æ ¹æ®åå«ååå·è¿è¡å é¤ |
| | | var update = db.Deleteable<MesReturnware>() |
| | | .Where(it => it.ReturnNo == mesReturnware.ReturnNo && |
| | | it.ReturnType == mesReturnware.ReturnType) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | //var mesWomcab = mesWomcabs.Select(s => new { CAB001 = s.Cab001, CAB002 = s.Cab002, CAB003 = s.Cab003 }).ToList(); |
| | | var mesReturnwareDetail = mesReturnwareDetails.Select(s => new { ReturnwareNo = s.ReturnNo, ReturnwareType = s.ReturnType }).ToList(); |
| | | |
| | | |
| | | |
| | | //var insertOrUpdate = db.Deleteable<Womcab>().Where(it => mesWomcab.Any(p => p.CAB001 == it.Cab001 && p.CAB002 == it.Cab002 && p.CAB003 == it.Cab003)).ExecuteCommand() > 0; |
| | | var insertOrUpdate = db.Deleteable<MesReturnwareDetails>().Where(it => mesReturnwareDetail.Any(p => p.ReturnwareNo == it.ReturnNo && p.ReturnwareType == it.ReturnType)).ExecuteCommand() > 0; |
| | | |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("æ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | private MesReturnware MapErptoMesReturnware(ErpReturnWare dto) |
| | | { |
| | | |
| | | |
| | | |
| | | var entity = new MesReturnware |
| | | { |
| | | ReturnType = dto.ReturnType, |
| | | ReturnNo = dto.ReturnNo, |
| | | CustNo = dto.CustNo, |
| | | BillDate = dto.BillDate, |
| | | BusinessBy = dto.BusinessBy, |
| | | WorkshopCenterCode = dto.WorkCode, |
| | | Remarks = dto.Remarks, |
| | | CreateBy = dto.CreateBy, |
| | | CreateDate = dto.CreateDate, |
| | | Type = dto.Type |
| | | }; |
| | | |
| | | |
| | | |
| | | return entity; |
| | | } |
| | | |
| | | private List<MesReturnwareDetails> MapErptoMesReturnwareDetails(List<ErpReturnWareDetails> dtoList) |
| | | { |
| | | var returnwareList = new List<MesReturnwareDetails>(); |
| | | |
| | | foreach (var dto in dtoList) |
| | | { |
| | | var ReturnwareDetails = new MesReturnwareDetails |
| | | { |
| | | |
| | | |
| | | ItemNo = dto.ItemNo, |
| | | ItemName = dto.ItemName, |
| | | ItemModel = dto.ItemModel, |
| | | Quantity = dto.Quantity, |
| | | Type = dto.Type, |
| | | DepotCode = dto.DepotCode, |
| | | ReturnType = dto.ReturnType, |
| | | ReturnNo = dto.ReturnNo, |
| | | ReturnOrder = dto.ReturnOrder, |
| | | OrderType = dto.OrderType, |
| | | OrderNumber = dto.OrderNumber, |
| | | OrderNo = dto.OrderNo |
| | | |
| | | }; |
| | | |
| | | |
| | | |
| | | returnwareList.Add(ReturnwareDetails); |
| | | } |
| | | |
| | | return returnwareList; |
| | | } |
| | | |
| | | |
| | | public bool Delete(YFDelete data) |
| | | { |
| | | |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | var update = db.Deleteable<Womcaa>() |
| | | .Where(it => it.Caa001 == data.FBillNo && |
| | | it.SrcBillType == data.FBillTypeID) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | var insertOrUpdate = db.Deleteable<Womcab>() |
| | | .Where(it => it.Cab001 == data.FBillNo && |
| | | it.Cab002 == data.FBillTypeID) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | |
| | | if (update && insertOrUpdate) return 1; |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | }) > 0; |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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 Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers |
| | | { |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class MesOutwareController : ControllerBase |
| | | { |
| | | |
| | | private readonly MessageCenterManager _manager = new(); |
| | | private MesOutwareManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "MES_OUTWARE"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/MesOutware/"; |
| | | |
| | | |
| | | |
| | | // |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(ErpOut OutWare) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.PageName = OutWare.ErpOutWares.OutType + "-" + OutWare.ErpOutWares.OutNo; //åå«ååå·çæ¼æ¥ |
| | | entity.Title = "éå®åºè´§éç¥å"; |
| | | entity.Data = JsonConvert.SerializeObject(OutWare); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(OutWare); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | entity.DealWith = 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<ErpOut> 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); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <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] MesOutware 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] MesOutware 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] MesOutware 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); |
| | | } |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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 Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers |
| | | { |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class MesReturnwareController : ControllerBase |
| | | { |
| | | |
| | | private readonly MessageCenterManager _manager = new(); |
| | | private MesReturnwareManager m = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "MES_RETURNWARE"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/MesReturnware/"; |
| | | |
| | | |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(ErpReturn ReturnWare) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.PageName = ReturnWare.ErpReturnWares.ReturnType + "-" + ReturnWare.ErpReturnWares.ReturnNo; //åå«ååå·çæ¼æ¥ |
| | | entity.Title = "éå®éè´§éç¥å"; |
| | | entity.Data = JsonConvert.SerializeObject(ReturnWare); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(ReturnWare); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | entity.DealWith = 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<ErpReturn> 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); |
| | | } |
| | | } |
| | | |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <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] MesReturnware 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] MesReturnware 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] MesReturnware 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); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.Add(MES.Service.Modes.MesOutware)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.InsertReturnIdentity(MES.Service.Modes.MesOutware)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesOutwareController.Update(MES.Service.Modes.MesOutware)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.Add(MES.Service.Modes.MesReturnware)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.InsertReturnIdentity(MES.Service.Modes.MesReturnware)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesReturnwareController.Update(MES.Service.Modes.MesReturnware)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.QC.MesLineUserController.GetList"> |
| | | <summary> |
| | | è·åææ |