GG_DPS/App_Mode/PositionIdQuery.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;


namespace GG_DPS.App_Mode
{
    class PositionIdQuery
    {
        /// <summary>
        /// 出库查询货位
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable GetOutPositInfo(string billId, string mno,string area)
        {
            DBClass.DBHelper db = new DBClass.DBHelper();
            string SQLString = string.Concat(" select S.positionId,S.mno,S.qty, P.row,P.list,P.layer, P.address,P.area from tblStock_DPS S left join tblStorePosition_DPS P",
                                            " on s.positionId=P.positionId  where S.positionId not in (select positionId from tblInOutPallet ",
                                            " where billid=@billId and mno=@mno) and P.Area=@area  and S.mno=@mno");
            db.SetSqlStringCommond(SQLString);
            db.AddInParameter("@billId", DbType.AnsiString, billId);
            db.AddInParameter("@mno", DbType.AnsiString, mno);
            db.AddInParameter("@area", DbType.AnsiString, area);
            return db.ExecuteDataTable();
        }
        /// <summary>
        /// 入库查询所有库货
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable GetInPositInfo()
        {
            DBClass.DBHelper db = new DBClass.DBHelper();
            string SQLString = string.Concat(" select positionId,mno,qty,row,list,layer,[address],area from V_InBillPostion_DPS order by [address] ");
            db.SetSqlStringCommond(SQLString);
            return db.ExecuteDataTable();
        }
        /// <summary>
        /// 入库查询指定料号与区域的货位
        /// </summary>
        /// <param name="mno"></param>
        /// <param name="area"></param>
        /// <returns>DataTable</returns>
        public DataTable GetInPositInfo(string mno, string area)
        {
            
            DBClass.DBHelper db = new DBClass.DBHelper();
            string SQLString = string.Concat(" select positionId,mno,qty,row,list,layer,[address],area from V_InBillPostion_DPS order by [address] ");
                                            ///" where  mno=@mno and Area=@area");
            db.SetSqlStringCommond(SQLString);
            //db.AddInParameter("@mno", DbType.AnsiString, mno);
            //db.AddInParameter("@area", DbType.AnsiString, area);
            return db.ExecuteDataTable();
        }
        public DataTable GetMateril()
        {
            DBClass.DBHelper db = new DBClass.DBHelper();
            db.SetSqlStringCommond("select mno,mname,unit from tblMaterialNo");
            return db.ExecuteDataTable();