Beispiel #1
0
        public DataSet ThongTinNhapSP(PhieuNhap pn)
        {
            CtPhieuNhapService1 dal = new CtPhieuNhapService1();
            string mapn             = pn.MaPhieuNhap.ToString();
            string sql = "";
            bool   kt  = dal.KiemTraMaPhieuNhap(mapn);

            if (kt == true)
            {
                sql = string.Format("select SP_ID,TenSP,NhaSX_ID from SanPham where NhaSX_ID=@NhaSX_ID"
                                    + " and SP_ID not in"
                                    + " (select ct_pn.SP_ID from SanPham sp, PhieuNhap pn, CT_PhieuNhap ct_pn"
                                    + " where pn.MaPhieuNhap=ct_pn.MaPhieuNhap and ct_pn.SP_ID=sp.SP_ID"
                                    + " and ct_pn.MaPhieuNhap='{0}')", mapn);
            }
            else
            {
                sql = "select SP_ID,TenSP,NhaSX_ID from SanPham where NhaSX_ID=@NhaSX_ID";
            }
            SqlParameter nhasxid = new SqlParameter("@NhaSX_ID", pn.NhaSX_ID);

            return(SqlDatabase.ExecuteQueryWithDataSet(sql, CommandType.Text, nhasxid));
        }
 public DataSet ThongTinNhapSP(PhieuNhap pn)
 {
     CtPhieuNhapService1 dal = new CtPhieuNhapService1();
     string mapn = pn.MaPhieuNhap.ToString();
     string sql = "";
     bool kt = dal.KiemTraMaPhieuNhap(mapn);
     if (kt == true)
     {
        sql = string.Format("select SP_ID,TenSP,NhaSX_ID from SanPham where NhaSX_ID=@NhaSX_ID"
               + " and SP_ID not in"
                   + " (select ct_pn.SP_ID from SanPham sp, PhieuNhap pn, CT_PhieuNhap ct_pn"
                    + " where pn.MaPhieuNhap=ct_pn.MaPhieuNhap and ct_pn.SP_ID=sp.SP_ID"
                    + " and ct_pn.MaPhieuNhap='{0}')", mapn);
     }
     else
        {
        sql = "select SP_ID,TenSP,NhaSX_ID from SanPham where NhaSX_ID=@NhaSX_ID";
        }
     SqlParameter nhasxid = new SqlParameter("@NhaSX_ID", pn.NhaSX_ID);
     return SqlDatabase.ExecuteQueryWithDataSet(sql, CommandType.Text, nhasxid);
 }