public string KiemTraPhieu(EC_PhieuNo etpn) { return(cn.LayGiaTri("select COUNT(*) as KQ from PhieuNo where SoPhieu='" + etpn.SoPhieu + "'")); }
public void CapNhatPhieuNo(EC_PhieuNo etpn) { cn.ThucThiSQL(@"UPDATE PhieuNo SET SoTien=" + etpn.SoTien + ",IDNhaCC=" + etpn.IDNhaCC + ",GhiChu=N'" + etpn.GhiChu + "' where SoPhieu='" + etpn.SoPhieu + "'"); }
public void XoaPhieu(EC_PhieuNo etpn) { cn.ThucThiSQL("DELETE PhieuNo where SoPhieu='" + etpn.SoPhieu + "'"); }
public void ThanhToanNo(EC_PhieuNo etpn) { cn.ThucThiSQL("UPDATE PhieuNo SET ThanhToan=1 where SoPhieu='" + etpn.SoPhieu + "'"); }
public DataTable DanhSachPhieuNo(EC_PhieuNo etpn) { return(cn.LayDuLieu(@"select ROW_NUMBER() over (order by ID) as TT,SoPhieu,NgayLap,SoTien, B.TenNhaCC,B.DiaChi,B.Phone,B.Email,A.GhiChu from PhieuNo A inner join NhaCungCap B on A.IDNhaCC=B.IDNhaCC where A.ThanhToan=0")); }
public void ThemPhieuNo_BanHang(EC_PhieuNo etpn) { SQL.ThemPhieuNo_BanHang(etpn); }
public void ThemPhieuNo_BanHang(EC_PhieuNo etpn) { cn.ThucThiSQL(@"INSERT INTO PhieuNo (SoPhieu, NgayLap, SoTien, MaPhong,Loai, GhiChu) VALUES ('" + etpn.SoPhieu + "',CONVERT(datetime,GETDATE(),103)," + etpn.SoTien + "," + etpn.MaPhong + ",2,N'" + etpn.GhiChu + "')"); }
public string ThongTinNoNhaCC(EC_PhieuNo etpn) { return(SQL.ThongTinNoNhaCC(etpn)); }
public DataTable PhieuNo_Tim(EC_PhieuNo etpn) { return(SQL.PhieuNo_Tim(etpn)); }
public void XoaPhieu(EC_PhieuNo etpn) { SQL.XoaPhieu(etpn); }
public string KiemTraPhieu(EC_PhieuNo etpn) { return(SQL.KiemTraPhieu(etpn)); }
public void CapNhatPhieuNo(EC_PhieuNo etpn) { SQL.CapNhatPhieuNo(etpn); }
public DataTable DanhSachPhieuNo(EC_PhieuNo etpn) { return(SQL.DanhSachPhieuNo(etpn)); }
public void ThanhToanNo(EC_PhieuNo etpn) { SQL.ThanhToanNo(etpn); }
public string ThongTinNoNhaCC(EC_PhieuNo etpn) { return(cn.LayGiaTri("select SUM(SoTien) from PhieuNo where IDNhaCC=" + etpn.IDNhaCC + " and ThanhToan=0")); }
public void ThemPhieuNo(EC_PhieuNo etpn) { cn.ThucThiSQL(@"INSERT INTO PhieuNo (SoPhieu, NgayLap, SoTien, IDNhaCC,Loai, GhiChu) VALUES ('" + etpn.SoPhieu + "',CONVERT(datetime,GETDATE(),103)," + etpn.SoTien + "," + etpn.IDNhaCC + ",1,N'" + etpn.GhiChu + "')"); }
public DataTable PhieuNo_Tim(EC_PhieuNo etpn) { return(cn.LayDuLieu("EXEC SPU_PhieuNo_Tim '" + etpn.NgayLap + "', " + etpn.Loai)); }
public void ThemPhieuNo(EC_PhieuNo etpn) { SQL.ThemPhieuNo(etpn); }