/// <summary>
/// ByPackNo加載該PackNo所在未關閉Lot內Pack列表
/// </summary>
/// <param name="packNo"></param>
/// <returns></returns>
public List <R_LOT_PACK> GetRLotPackByLotNo(OleExec DB, string lotNo)
{
List <R_LOT_PACK> res = new List <R_LOT_PACK>();
string strSql = $@" select * from R_LOT_PACK where LOTNO='{lotNo}' ";
DataSet ds = DB.ExecSelect(strSql);
foreach (DataRow VARIABLE in ds.Tables[0].Rows)
{
Row_R_LOT_PACK r = (Row_R_LOT_PACK)this.NewRow();
r.loadData(VARIABLE);
res.Add(r.GetDataObject());
}
return(res);
}
/// <summary>
/// ByPackNo加載該PackNo所在未關閉Lot內Pack列表
/// </summary>
/// <param name="packNo"></param>
/// <returns></returns>
public List <R_LOT_PACK> GetRLotPackWithWaitClose(OleExec DB, string packNo)
{
List <R_LOT_PACK> res = new List <R_LOT_PACK>();
string strSql = $@" select A.* from R_LOT_PACK A,R_LOT_STATUS B where A.LOTNO=B.LOT_NO AND B.CLOSED_FLAG='0' AND A.PACKNO='{packNo}' ";
DataSet ds = DB.ExecSelect(strSql);
foreach (DataRow VARIABLE in ds.Tables[0].Rows)
{
Row_R_LOT_PACK r = (Row_R_LOT_PACK)this.NewRow();
r.loadData(VARIABLE);
res.Add(r.GetDataObject());
}
return(res);
}