物流检验报表接口开发

yl

2023-04-25 6b91eea8f3a54269a61d0626efb879cc7da5b4bf

 VueWebApi/DLL/DAL/ReportManagerDAL.cs

@@ -1360,5 +1360,129 @@
            return mes;
        }
        #endregion


        #region[物流检验记录查询]
        public static ToMessage LogisticsCheckSearch(string checktypecode, string partcode, string partname, string partspec, string labcode, string customercode, string batchno, string checkuser, string opencheckdate, string closecheckdate, int startNum, int endNum, string prop, string order)
        {
            var dynamicParams = new DynamicParameters();
            string search = "";
            try
            {
                if (checktypecode != "" && checktypecode != null)
                {
                    search += "and A.check_type=@checktypecode ";
                    dynamicParams.Add("@checktypecode", checktypecode);
                }
                if (partcode != "" && partcode != null)
                {
                    search += "and M.partcode like '%'+@partcode+'%' ";
                    dynamicParams.Add("@partcode", partcode);
                }
                if (partname != "" && partname != null)
                {
                    search += "and M.partname like '%'+@partname+'%' ";
                    dynamicParams.Add("@partname", partname);
                }
                if (partspec != "" && partspec != null)
                {
                    search += "and M.partspec like '%'+@partspec+'%' ";
                    dynamicParams.Add("@partspec", partspec);
                }
                if (labcode != "" && labcode != null)
                {
                    search += "and A.hbarcode like '%'+@labcode+'%' ";
                    dynamicParams.Add("@labcode", labcode);
                }
                if (customercode != "" && customercode != null)
                {
                    search += "and A.customer_code=@customercode ";
                    dynamicParams.Add("@customercode", customercode);
                }
                if (batchno != "" && batchno != null)
                {
                    search += "and R.hbatchno like '%'+@batchno+'%' ";
                    dynamicParams.Add("@batchno", labcode);
                }
                if (checkuser != "" && checkuser != null)
                {
                    search += "and U.usercode like '%'+@checkuser+'%' ";
                    dynamicParams.Add("@checkuser", checkuser);
                }        
                if (opencheckdate != "" && opencheckdate != null)
                {
                    search += "and A.lm_date between @opencheckdate and @closecheckdate ";
                    dynamicParams.Add("@opencheckdate", opencheckdate + " 00:00:00");
                    dynamicParams.Add("@closecheckdate", closecheckdate + " 23:59:59");
                }
                if (search == "")
                {
                    search = "and 1=1 ";
                }
                search = search.Substring(3);//截取索引2后面的字符
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.check_type,A.check_typename,A.sampmethod,M.partcode,M.partname,M.partspec,R.hbatchno, 
                            A.hbarcode,A.customer_code,C.name as customer_name,U.usercode,U.username,A.lm_date,A.check_result 
                            from TStepCheckRecord A
                            inner join TStepCheckRecordSub B on A.id=B.m_id
                            left  join TMateriel_Info M on A.partcode=M.partcode
                            left  join T_BarCodeBill R on A.hbarcode=R.hbarcode
                            left  join TCustomer C on A.customer_code=C.code
                            left  join TUser U on A.check_user=U.usercode
                            where " + search;
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
                mes.count = total;
                mes.data = data.ToList();
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion

        #region[物流检验，查看检验明细]
        public static ToMessage LogisticsCheckSubSearch(string checkid)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                //存储过程名
                sql = @"h_p_IFCLD_WuLiuCheckSubSelect";
                dynamicParams.Add("@checkid", checkid);
                DataTable dt = DapperHelper.selectProcedure(sql, dynamicParams);
                if (dt.Rows.Count > 0)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "查询成功!";
                    mes.data = dt;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "无检验明细数据!";
                    mes.data = null;
                }
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}