sql server版本的
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
快乐的昕的电脑
2025-09-03 ff811781abc0e854c4a7dad7da8f533939a001a0 
 service/Warehouse/MesItemBlManager.cs


@@ -5,6 +5,7 @@


using NewPdaSqlServer.entity.Base;


using NewPdaSqlServer.util;


using SqlSugar;


using System.Text;




namespace NewPdaSqlServer.service.Warehouse;




@@ -16,15 +17,22 @@


    ///     获取生产补料单号列表


    /// </summary>


    /// <returns>补料单号列表</returns>


    public List<string> GetSCBLBillNo(WarehouseQuery query)


    public List<string> GetSCBLBillNo(dynamic query, dynamic RequestInfo)


    {


        var list = Db.Queryable<MesItemBl>()


            .Where(s => (s.Bl018 ?? false) == true


                        //&& (s.Bl019 ?? false) == false


                        && s.Bl008 == query.Type)


            .OrderByDescending(s => s.Bl006)


            .Select(s => s.BlNo)


            .ToList();


        var orgId = RequestInfo.OrgId;


        var sqlParams = new List<SugarParameter>


        {


            new("@orgId", orgId),


            new("@type", query.type),


            new("@dateTime", query.dateTime == "" ? null : query.dateTime),


            new("@lineNo", query.lineNo)




        };


        var sql2 = new StringBuilder("exec prc_pda_itemBl_billNoList @type,@orgId,@dateTime,@lineNo");




        var LineInfo = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);




        var list = LineInfo.Select(s => (string)s.bl_no).ToList();


        return list;


    }




@@ -68,7 +76,7 @@


        //    .ToList();




        //return (mesItemBl.Bl001, blDetails);


        var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.BLD007 FQty,A.BLD008 SQty,A.BLD007 - A.BLD008 DSQty,


        var sql = string.Format(@"SELECT c.id as ItemId,c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.BLD007 FQty,A.BLD008 SQty,A.BLD007 - A.BLD008 DSQty,


       dbo.F_QX_GETRECODEPOTSE(A.bld012,'','','') as RecoKw,D.daa001


fROM MES_ITEM_BL_DETAIL A


         LEFT JOIN MES_ITEM_BL B ON A.MID = B.ID


@@ -150,7 +158,7 @@


            .First();




        if (mesItemBl == null)


            throw new Exception($"申请单 {query.blNo} 已撤回！");


            throw new Exception($"申请单 {query.blNo} 不存在！");




        if (mesItemBl.Bl018 != true)


            throw new Exception($"申请单 {query.blNo} 未审核！");


@@ -288,7 +296,7 @@


            // 检查并更新出库单物料明细


            var itemCount = db.Queryable<MesInvItemOutItems>()


                .Where(i =>


                    i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId && i.DepotId == stockBarcode.DepotsId.ToString())


                    i.ItemOutId == outId && i.ItemDabid == blDetail.Id && i.ItemId == stockBarcode.ItemId && i.DepotId == stockBarcode.DepotId.ToString())


                .Count();




            if (itemCount > 0)


@@ -297,7 +305,7 @@


                    .SetColumns(i =>


                        i.TlQty == i.TlQty + stockBarcode.Quantity)


                    .Where(i =>


                        i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId && i.DepotId == stockBarcode.DepotsId.ToString())


                        i.ItemOutId == outId && i.ItemDabid == blDetail.Id && i.ItemId == stockBarcode.ItemId && i.DepotId == stockBarcode.DepotId.ToString())


                    .ExecuteCommand();


            else


                // 插入新的物料明细记录


@@ -306,7 +314,7 @@


                    Guid = Guid.NewGuid(),


                    ItemOutId = outId,


                    ItemNo = blDetail.Bld002,


                    Quantity = stockBarcode.Quantity,


                    Quantity = blDetail.Bld007,


                    TlQty = stockBarcode.Quantity,


                    CreateBy = query.userName,


                    CreateDate = DateTime.Now,


@@ -995,6 +1003,21 @@


        return dto;


    }




    // 获取产线列表


    public dynamic GetLineInfo(dynamic unity, dynamic RequestInfo)


    {


        var orgId = RequestInfo.OrgId;


        var sqlParams = new List<SugarParameter>


        {


            new("@orgId", orgId)


        };




        var sql2 = new StringBuilder("exec prc_pda_itemBl_lineInfo @orgId");




        var LineInfo = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);




        return LineInfo;


    }


    #endregion




    #region 生产超领


@@ -1317,7 +1340,7 @@


                PbillNo = query.billNo,


                ItemId = blDetail.Bld012,


                Unit = blDetail.Bld009,


                DepotId = (int)stockBarcode.DepotsId,


                DepotId = (int)stockBarcode.DepotId,


                Dabid = womdab.Guid,


            }).IgnoreColumns(true).ExecuteCommand();




@@ -1508,7 +1531,7 @@


                    EpFlag = stockBarcode.EpFlag,


                    CustomerNo = stockBarcode.CustomerNo,


                    DepotsCode = stockBarcode.DepotsCode,


                    DepotsId = stockBarcode.DepotsId,


                    DepotsId = stockBarcode.DepotId,


                    DepotSectionsCode = stockBarcode.DepotSectionsCode,


                    CheckDate = stockBarcode.CheckDate,


                    ItemType = stockBarcode.ItemType,


@@ -1720,7 +1743,7 @@


                PbillNo = query.billNo,


                ItemId = blDetail.Bld012,


                Unit = blDetail.Bld009,


                DepotId = (int)stockBarcode.DepotsId,


                DepotId = (int)stockBarcode.DepotId,


                LineK3id = workOrderDetail.Erpid,


                EbelnK3id = workOrderDetail.Eid


            }).IgnoreColumns(true).ExecuteCommand();