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