public DataTable GetBoxByPalletNoWithNoPass(string PalletNo) { BArrangeBillBoxBB arrangeBillBoxBB = new BArrangeBillBoxBB(); try { DataTable dt = new DataTable(); dt = arrangeBillBoxBB.GetNoPassBox("PalletNo='" + PalletNo + "'").Tables[0]; return dt; } finally { arrangeBillBoxBB.Dispose(); } }