1.期初入库优化 2.巡检查询优化

南骏 池

2025-09-24 c428da6d72fb39873882c2c57ffa3b77026d0438

1.期初入库优化
2.巡检查询优化

 Controllers/QC/IpqcController.cs

@@ -10,7 +10,7 @@

[Route("api/[controller]")]
[ApiController]
public class IpqcController : ControllerBase
public class IpqcController : BaseController
{
    IpqcService m = new IpqcService();

@@ -80,7 +80,7 @@
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var (item, totalCount) = m.getPageXj(queryObj);
            var (item, totalCount) = m.getPageXj(queryObj, RequestInfo);
            var tbBillList =
                resultInfos.tbBillList = item;
            return new ResponseResult

 service/QC/IpqcService.cs

@@ -91,7 +91,7 @@
    }


    public (List<VIpqcXj> item, int TotalCount) getPageXj(XJPageResult queryObj)
    public (List<VIpqcXj> item, int TotalCount) getPageXj(XJPageResult queryObj,dynamic requestInfo)
    {


@@ -105,7 +105,9 @@
                throw new ApplicationException("GUID转换错误");
        }

        var sql = string.Format(@"EXEC prc_pda_ipqc_GetXjList '{0}'", parsedGuid);
        string orgId = requestInfo.OrgId;

        var sql = string.Format(@"EXEC prc_pda_ipqc_GetXjList '{0}','{1}','{2}'", parsedGuid, queryObj.keyword, orgId);

        var pageList = Db.Ado.SqlQuery<VIpqcXj>(sql).ToList();


 service/Warehouse/InventoryManager.cs

@@ -226,7 +226,8 @@
                WorkNo = c_mes_inv_item_barcodes.WorkNo,
                WorkLine = c_mes_inv_item_barcodes.WorkLine,
                SuppNo = c_mes_inv_item_barcodes.SuppNo,
                ItemId = c_mes_inv_item_barcodes.ItemId
                ItemId = c_mes_inv_item_barcodes.ItemId,
                Description = "期初入库"
            }).IgnoreColumns(true).ExecuteCommand();

            // 插入库存信息
@@ -255,6 +256,8 @@
                ItemId = c_mes_inv_item_barcodes.ItemId,
                IndepUserCode = c_user,
                StockOrgId = depotSection.FSubsidiary,
                OwnerId = depotSection.FSubsidiary,
                OwnerType = "BD_OwnerOrg",
                // Fsubsidiary = c_organize
            }).IgnoreColumns(true).ExecuteCommand();