/// <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()));
}
/// <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()));
}
/// <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()));
}
/// <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()));
}