Example #1
0
        //=========================================

        internal DataTable FindDeliveryAvailableCell()
        {
            string sql = @"SELECT WMS_WAREHOUSE.WH_CODE,WMS_WAREHOUSE.WH_NAME,
                            WMS_WH_AREA.AREACODE,WMS_WH_AREA.AREANAME,
                            WMS_WH_SHELF.SHELFCODE,WMS_WH_SHELF.SHELFNAME,
                            WMS_WH_CELL.CELL_ID,WMS_WH_CELL.CELLCODE,WMS_WH_CELL.CELLNAME,WMS_WH_CELL.LAYER_NO,
                            WMS_WH_CELL.AREATYPE,-- WMS_WH_AREA.ENTRYALLOTORDER,
                            WMS_WH_CELL.ASSIGNEDPRODUCT,WMS_WH_CELL.CURRENTPRODUCT,WMS_PRODUCT.PRODUCTNAME,CONVERT(NVARCHAR(10),WMS_WH_CELL.INPUTDATE,120) INPUTDATE,
                            WMS_WH_CELL.UNITCODE,WMS_UNIT.UNITNAME,WMS_WH_CELL.MAX_QUANTITY,WMS_WH_CELL.QUANTITY,
                            WMS_WH_CELL.QUANTITY-WMS_WH_CELL.FROZEN_OUT_QTY AS AVAILABLE,0.00 AS ALLOTQUANTITY,
                            '' AS TASKID,'' AS BILLNO, 0.00 AS DETAILID,
                            '' AS PALLETID,'' AS NEWPALLETID
                            FROM WMS_WH_CELL 
                            LEFT JOIN WMS_WH_SHELF ON WMS_WH_SHELF.SHELFCODE = WMS_WH_CELL.SHELFCODE 
                            LEFT JOIN WMS_WH_AREA ON WMS_WH_SHELF.AREACODE = WMS_WH_AREA.AREACODE
                            LEFT JOIN WMS_WAREHOUSE ON WMS_WAREHOUSE.WH_CODE = WMS_WH_AREA.WH_CODE
                            LEFT JOIN WMS_UNIT ON WMS_UNIT.UNITCODE = WMS_WH_CELL.UNITCODE
                            LEFT JOIN WMS_PRODUCT ON WMS_PRODUCT.PRODUCTCODE = WMS_WH_CELL.CURRENTPRODUCT
                            WHERE WMS_WH_CELL.ISACTIVE = '1'                                                            --储位是否可用
                              AND WMS_WH_CELL.ISLOCKED='0'																--储位是否冻结
                              AND ((WMS_WH_CELL.CURRENTPRODUCT !='' AND WMS_WH_CELL.CURRENTPRODUCT IS NOT NULL) OR WMS_WH_CELL.FROZEN_IN_QTY = 0) 
                            --AND QUANTITY>0																			--储位库存量
                            --AND QUANTITY>FROZEN_OUT_QTY																--储位可出库量
                            --AND WMS_WH_AREA.ENTRYALLOTORDER != 0 
                            ORDER BY -- WMS_WH_AREA.ENTRYALLOTORDER,
                            CONVERT(NVARCHAR(10),WMS_WH_CELL.INPUTDATE,120),WMS_WH_CELL.QUANTITY";

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                return dao.GetData(sql).Tables[0];
            }
        }
Example #2
0
        /// <summary>
        /// zys_2011-06-21
        /// 张青龙 2011-07-18 加入WMS_WH_CELL.LAYER_NO
        /// </summary>
        /// <returns></returns>
        internal DataTable FindAvailableCell()
        {
            string sql = @"SELECT WMS_WAREHOUSE.WH_CODE,WMS_WAREHOUSE.WH_NAME,
                            WMS_WH_AREA.AREACODE,WMS_WH_AREA.AREANAME,
                            WMS_WH_SHELF.SHELFCODE,WMS_WH_SHELF.SHELFNAME,
                            WMS_WH_CELL.CELL_ID,WMS_WH_CELL.CELLCODE,WMS_WH_CELL.CELLNAME, 
                            WMS_WH_CELL.AREATYPE,WMS_WH_CELL.LAYER_NO,-- WMS_WH_AREA.ENTRYALLOTORDER,
                            WMS_WH_CELL.ASSIGNEDPRODUCT,WMS_WH_CELL.CURRENTPRODUCT,
                            WMS_WH_CELL.UNITCODE CELLUNITCODE,WMS_UNIT.UNITNAME CELLUNITNAME,WMS_WH_CELL.MAX_QUANTITY,
                            WMS_WH_CELL.MAX_QUANTITY-WMS_WH_CELL.FROZEN_IN_QTY-WMS_WH_CELL.QUANTITY AS AVAILABLE,
                            '' AS BILLNO,0.00 AS DETAILID,'' AS PRODUCTCODE,'' AS PRODUCTNAME,
                            '' AS UNITCODE,'' AS UNITNAME,0.00 AS ALLOTQUANTITY
                            FROM WMS_WH_CELL 
                            LEFT JOIN WMS_WH_SHELF ON WMS_WH_SHELF.SHELFCODE = WMS_WH_CELL.SHELFCODE 
                            LEFT JOIN WMS_WH_AREA ON WMS_WH_SHELF.AREACODE = WMS_WH_AREA.AREACODE
                            LEFT JOIN WMS_WAREHOUSE ON WMS_WAREHOUSE.WH_CODE = WMS_WH_AREA.WH_CODE
                            LEFT JOIN WMS_UNIT ON WMS_UNIT.UNITCODE = WMS_WH_CELL.UNITCODE
                            WHERE WMS_WH_CELL.ISACTIVE = '1'                                                            --储位是否可用
                                  AND WMS_WH_CELL.ISLOCKED='0'                                                          --储位是否冻结
                                  AND WMS_WH_CELL.MAX_QUANTITY - WMS_WH_CELL.QUANTITY - WMS_WH_CELL.FROZEN_IN_QTY > 0   --储位可入库量
                                  AND ((WMS_WH_CELL.CURRENTPRODUCT !='' AND WMS_WH_CELL.CURRENTPRODUCT IS NOT NULL) OR WMS_WH_CELL.FROZEN_IN_QTY = 0)                                                   --入库未入数量
                            --      AND WMS_WH_AREA.ENTRYALLOTORDER != 0 
                            ORDER BY -- WMS_WH_AREA.ENTRYALLOTORDER,
                            WMS_WH_CELL.AREATYPE,WMS_WH_CELL.SHELFCODE,WMS_WH_CELL.CELLCODE";

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                return dao.GetData(sql).Tables[0];
            }
        }
Example #3
0
        /// <summary>
        /// zys_2011-06-21
        /// </summary>
        /// <param name="productCode"></param>
        /// <returns></returns>
        internal string FindProductBarUnitCode(string productCode)
        {
            string sql = @"SELECT U.UNITCODE FROM WMS_UNIT U 
                               LEFT JOIN WMS_PRODUCT P ON U.UNITCODE= P.TIAOCODE WHERE P.PRODUCTCODE='{0}'";
            sql = string.Format(sql, productCode);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                return dao.ExecScaler(sql).ToString();
            }
        }
Example #4
0
        /// <summary>
        /// zys_2011-06-21
        /// </summary>
        /// <param name="unitCode"></param>
        /// <returns></returns>
        internal string FindUnitName(string unitCode)
        {
            string sql = @"SELECT UNITNAME FROM WMS_UNIT WHERE UNITCODE='{0}'";
            sql = string.Format(sql, unitCode);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                string returnVal = dao.ExecScaler(sql).ToString();
                return returnVal;
            }
        }
Example #5
0
        /// <summary>
        /// zys_2011-06-21
        /// </summary>
        /// <param name="productCode"></param>
        /// <returns></returns>
        internal decimal FindProductMaxQuantity(string productCode)
        {
            string sql = @"SELECT MAXCELLPIECE FROM WMS_PRODUCT WHERE PRODUCTCODE = '{0}'";
            sql = string.Format(sql, productCode);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                decimal returnVal = 0;
                decimal.TryParse(dao.ExecScaler(sql).ToString(), out returnVal);                
                return returnVal;
            }
        }
Example #6
0
        /// <summary>
        /// zys_2011-06-21
        /// </summary>
        /// <param name="unitCode"></param>
        /// <returns></returns>
        internal decimal FindUnitStandardRate(string unitCode)
        {
            string sql = @"SELECT STANDARDRATE FROM WMS_UNIT WHERE UNITCODE='{0}'";
            sql = string.Format(sql,unitCode);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                decimal returnVal = 0;
                decimal.TryParse(dao.ExecScaler(sql).ToString(), out returnVal);
                return returnVal;
            }
        }
Example #7
0
        /// <summary>
        /// zys_2011-06-22
        /// </summary>
        /// <param name="productCode"></param>
        /// <returns></returns>
        internal string FindProductAssignedCell(string productCode)
        {
            string sql = @"SELECT SHELFCODE FROM WMS_WH_CELL 
                           WHERE ASSIGNEDPRODUCT='{0}' GROUP BY SHELFCODE";
            sql = string.Format(sql,productCode);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                DataTable shelfTable = dao.GetData(sql).Tables[0];
                string shelfList = StringUtil.StringMake(shelfTable, "SHELFCODE");
                return StringUtil.StringMake(shelfList);
            }
        }
Example #8
0
 internal DataTable GetEmptyMoveDetailTable()
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         string sql = @"SELECT ID,BILLNO,
                         PRODUCTCODE,'' AS PRODUCTNAME,
                         '' AS UNITCODE,'' AS UNITNAME,
                         OUT_CELLCODE ,'' AS OUT_CELLNAME ,
                         IN_CELLCODE,'' AS IN_CELLNAME ,QUANTITY, 
                         OPERATEPERSON , STARTTIME , FINISHTIME , STATUS  
                         FROM  WMS_MOVE_BILLDETAIL WHERE 1=0";
         AllotDao dao = new AllotDao();
         return dao.GetData(sql).Tables[0];
     }
 }
Example #9
0
 internal DataTable GetEmptyAllotmentTable(string InOrOut)
 {
     using (PersistentManager persistentManager = new PersistentManager())
     {
         string sql = @"SELECT ID,TASKID,BILLNO,DETAILID,
                         PRODUCTCODE,'' AS PRODUCTNAME,
                         '' AS UNITCODE,'' AS UNITNAME,
                         CELLCODE,'' AS CELLNAME ,QUANTITY,OUTPUTQUANTITY,
                         PALLETID ,NEWPALLETID ,OPERATEPERSON,
                         STARTTIME,FINISHTIME ,STATUS,INPUTDATE,OUTPUTDATE
                         FROM WMS_OUT_ALLOTDETAIL WHERE 1=0";
         AllotDao dao = new AllotDao();
         return dao.GetData(sql).Tables[0];
     }
 }
Example #10
0
        /// <summary>
        /// zys_2011-06-22
        /// </summary>
        /// <returns></returns>
        internal bool FindIsUseArea(string areaType)
        {
            string sql = @"SELECT * FROM WMS_WH_AREA WHERE AREATYPE = '{0}'";
            sql = string.Format(sql,areaType);

            using (PersistentManager persistentManager = new PersistentManager())
            {
                AllotDao dao = new AllotDao();
                if (dao.GetData(sql).Tables[0].Rows.Count > 0)
                {
                    return true;
                }
                return false;
            }
        }