public static XuatNhapChiTietCollection SelectAll() { var List = new XuatNhapChiTietCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static XuatNhapChiTietCollection SelectByTV_ID(string TV_ID) { var obj = new SqlParameter[1]; obj[0] = new SqlParameter("TV_ID", TV_ID); var List = new XuatNhapChiTietCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblXuatNhapChiTiet_Select_SelectByTV_ID_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }