예제 #1
0
        /// <summary>
        /// 获取条码库存信息
        /// </summary>
        public DataSet Get_TM_KCList()
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append(" select T.CK AS TM_CK,T.WLH AS TM_WLH,T.WLMC AS TM_WLMC,T.GG AS TM_GG,T.PH AS TM_PH,t.PCH AS TM_PCH,(CASE T2.ZPDJBZ         WHEN '1' THEN 'DP' ELSE T.SX END) AS TM_SX,count(1) AS TM_COU,sum(T.ZL) AS TM_ZL,t.vfree1 AS TM_ZYX1,t.vfree2 AS TM_ZYX2,t.vfree3 AS TM_ZYX3  FROM WMS_BMS_INV_INFO T INNER JOIN WMS_BMS_REC_WGD T2 ON T.WGDH = T2.WGDH where T.CK is not null group by T.CK, T.WLH, T.WLMC, T.GG, T.PH, t.PCH, t.vfree1, t.vfree2, t.vfree3, (CASE T2.ZPDJBZ WHEN '1' THEN 'DP' ELSE T.SX END) ");
            return(DbHelper_SQL.Query(strSql.ToString()));
        }
예제 #2
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet Get_PD_ITEM_List(string YSDH)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT YSDH,BARCODE,PCH,SX,ZCSL,ZCZL,SPSL,SPZL,JLDW,PDCY,SHBZ,ZLDW,vfree0,vfree1,vfree2,vfree3,vfree4 FROM      WMS_CHE_PDDNC_DETAIL where YSDH = '" + YSDH + "'");

            return(DbHelper_SQL.Query(strSql.ToString()));
        }
예제 #3
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet Get_PD_List()
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select ysdh from SeZJB_PDD_FINISHED WHERE ZJBstatus=0 ");

            return(DbHelper_SQL.Query(strSql.ToString()));
        }
예제 #4
0
        /// <summary>
        /// 获取条码库存信息
        /// </summary>
        /// <param name="Barcode">钢卷唯一码</param>
        /// <param name="CK">仓库</param>
        /// <param name="HW">货位</param>
        /// <param name="WGDH">完工单号</param>
        /// <param name="PH">批号</param>
        /// <param name="GH">钩号</param>
        /// <param name="GZ">钢种</param>
        /// <returns>条码库存信息</returns>
        public DataSet Get_TM_List(string PCH)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT T1.PCH, T1.GH, T1.ZL ");

            strSql.Append(" FROM WMS_BMS_INV_INFO T1 WHERE T1.PCH='" + PCH + "'  ");

            return(DbHelper_SQL.Query(strSql.ToString()));
        }