增加 页面查询

schangxiang@126.com

2025-09-02 4813bf5781140ecd5c2c7a75d36bf0a2d45a50f4

 wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs

@@ -1026,6 +1026,111 @@
            return msg;
        }

        /// <summary>查找出入库记录明细给MES [EditBy shaocx,2025-09-01]
        /// 
        /// </summary>
        /// <param name="page">分页</param>
        /// <returns></returns>
        public resMsg<Wms_outInStockRecord_Details_V2_Mes> findOutInStockRecord_Details_V2_Mes_Page(paging page, Wms_outInStockRecord_Details_V2_Mes value)
        {
            resMsg<Wms_outInStockRecord_Details_V2_Mes> msg = new resMsg<Wms_outInStockRecord_Details_V2_Mes>();
            msg.status = 400;
            try
            {
                using (dbmodel mod = new dbmodel())
                {
                    string sql = "SELECT * FROM [LA20025].[dbo].[Wms_outInStockRecord_Details_V2_Mes]  ";
                    sql = sql + " WHERE 1=1 ";

                    if (!string.IsNullOrEmpty(value.containerCode))//托盘号
                    {
                        sql = sql + " and containerCode like '%" + value.containerCode + "%'";
                    }
                    if (!string.IsNullOrEmpty(value.productCode))//物料编号
                    {
                        sql = sql + " and productCode like '%" + value.productCode + "%'";
                    }
                    if (!string.IsNullOrEmpty(value.productName))//物料名称
                    {
                        sql = sql + " and  productName like '%" + value.productName + "%' ";
                    }
                    if (!string.IsNullOrEmpty(value.serialNumber))//流水号
                    {
                        sql = sql + " and  serialNumber like '%" + value.serialNumber + "%' ";
                    }

                    if (page.startDateTime != DateTime.Parse("1900-01-01 0:00:00") && page.startDateTime != DateTime.Parse("0001-01-01 0:00:00"))//起始时间
                    {
                        sql = sql + " and CreateTime >'" + page.startDateTime + "'";
                    }
                    if (page.endDateTime != DateTime.Parse("1900-01-01 0:00:00") && page.endDateTime != DateTime.Parse("0001-01-01 0:00:00"))//截止时间
                    {
                        sql = sql + " and CreateTime <'" + page.endDateTime + "'";
                    }

                    sql = sql + " order by CreateTime desc";
                    List<Wms_outInStockRecord_Details_V2_Mes> dataList = mod.Database.SqlQuery<Wms_outInStockRecord_Details_V2_Mes>(sql).ToList();

                    if (dataList.Count > 0)
                    {
                        //msg.quantity = (int)dataList.Sum(x => x.quantity);
                        msg.totalNum = dataList.Count;
                        msg.dateAll = dataList;
                        //分页计算
                        List<Wms_outInStockRecord_Details_V2_Mes> fenyeRerult = new List<Wms_outInStockRecord_Details_V2_Mes>();
                        msg.status = 200;

                        //假如每页数量 大于盘点数据
                        if (page.pagesize > dataList.Count)
                        {
                            msg.date = dataList;
                            msg.total = 1;
                        }
                        else
                        {
                            #region 分页计算
                            int a = page.pagesize;
                            int b = page.pagenum;
                            int c = (int)Math.Ceiling((double)dataList.Count / a);
                            msg.total = c;
                            int d = dataList.Count % a;
                            int e = 0;
                            int f = a * (b - 1);
                            if (d != 0 && b == c)
                            {
                                e = d + f;
                            }
                            else
                            {
                                e = a + f;
                            }
                            for (int i = f; i < e; i++)
                            {
                                fenyeRerult.Add(dataList[i]);
                            }

                            msg.date = fenyeRerult;
                            #endregion
                        }

                    }
                    else
                    {
                        msg.status = 200;
                        msg.msg = "查找数据为0,请更换查询条件";
                    }

                }
            }
            catch (Exception ex)
            {
                msg.msg = "查询失败";
                WZ.Useful.Commons.LogTextHelper.WriteLine("IyunneiWcf", "Wms_outInStockRecord_Details_V2_Mes", ex.ToString());
            }

            return msg;
        }


        /// <summary>查找入库单流水号
        ///