예제 #1
0
        public static DataTable XemTonKho()
        {
            DataProvider p = new DataProvider();

            p.Connect();

            DataTable dt = p.SL("sp_XemTonKho", CommandType.StoredProcedure);

            p.Disconnect();
            return(dt);
        }
예제 #2
0
        public static DataTable XemTonKhoTheoKho(int MaKho)
        {
            DataProvider p = new DataProvider();

            p.Connect();
            SqlParameter p1 = new SqlParameter("@MaKho", SqlDbType.Int)
            {
                Value = MaKho
            };
            DataTable dt = p.SL("sp_XemTonKhoTheoKho", CommandType.StoredProcedure, p1);

            p.Disconnect();
            return(dt);
        }