示例#1
0
        public static TaiLieuVanBanCollection SelectAll()
        {
            TaiLieuVanBanCollection List = new TaiLieuVanBanCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTaiLieuVanBan_Select_SelectAll_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
示例#2
0
        public static TaiLieuVanBanCollection SelectByVanBan(string VB_ID)
        {
            TaiLieuVanBanCollection List = new TaiLieuVanBanCollection();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("VB_ID", VB_ID);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTaiLieuVanBan_Select_SelectByVanBan_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }