Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }