public string IDAuto() { return(Convert.ToString(ConnectionDB.ExecScalar("select dbo.SetAutoIdBANGKE_PHIEUTHUTIEN()"))); }
public int DeletePhieuThu(string maPhieu) { string sql = string.Format("DELETE FROM [BANGKE_PHIEUTHUTIEN] WHERE MaPhieuBangKe = '{0}'", maPhieu); return(ConnectionDB.ExcuteNonQuery(sql)); }
public string IDAuto() { return(Convert.ToString(ConnectionDB.ExecScalar("select dbo.SetAutoIdDVT()"))); }
public DataTable loadDKThanhToan() { string sql = "SELECT * FROM DIEUKHOAN_THANHOAN"; return(ConnectionDB.getData(sql)); }
public string IDAuto() { return(Convert.ToString(ConnectionDB.ExecScalar("select dbo.SetAutoIdThongTin_PhieuBanHang()"))); }
public int checkMaHangTrongTonKho(string maHang) { string sql = string.Format("SELECT 1 FROM TONKHO where MaHang = '{0}' and Soluongton >= {1} ", maHang, 1); return(Convert.ToInt32(ConnectionDB.ExcuteQuery(sql))); }
public int InsertCurrent(CurrencyDTO cur) { string sql = string.Format("INSERT INTO TIENTE VALUES('{0}', N'{1}', {2}, {3})", cur.iMaTT, cur.iTenTT, cur.iTGQD, 1); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int checkMaPhieuBan(string maPhieu) { string sql = string.Format("SELECT 1 FROM THONGTIN_PHIEU_BANHANG WHERE MaPhieu = '{0}'", maPhieu); return(Convert.ToInt32(ConnectionDB.ExcuteQuery(sql))); }
public int XoaNguoiDung(string tendangnhap) { string sql = string.Format("delete from NGUOIDUNG where TenDangNhap = '{0}'", tendangnhap); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int TonTaiDangNhap(string tendangnhap, string pass) { string sql = string.Format("select count(*) from NGUOIDUNG where TenDangNhap='{0}' and Password='******'", tendangnhap, pass); return(ConnectionDB.LaySoDong(sql)); }
public int XoaVTCN(string mavt) { string sql = "delete from VAITRO_CHUCNANG where MaVaiTro = '" + mavt + "'"; return(ConnectionDB.ExcuteNonQuery(sql)); }
public DataTable loadPTThanhToan() { string sql = "SELECT * FROM PHUONGTHUCTHANHTOAN"; return(ConnectionDB.getData(sql)); }
public string getLastMaKV() { string sql = "select top 1 * from KHUVUC order by MaKV DESC"; return(ConnectionDB.GetIDLast(sql)); }
public int InsertPhieuThuTien(PhieuThuTien ptTien) { string sql = string.Format("INSERT INTO [BANGKE_PHIEUTHUTIEN] VALUES('{0}', '{1}', '{2}', '{3}', N'{4}', {5},N'{6}' ,N'{7}')", ptTien.MaPhieu, ptTien.MaChungTu, ptTien.NgayLap, ptTien.MaKH, ptTien.TenKH, ptTien.SoTien, ptTien.TenNV, ptTien.GhiChu); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int Delete(string ma) { string sql = string.Format("DELETE FROM TIENTE WHERE maTT = '{0}'", ma); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int checkMaChungTuInPhieuThu(string maChungTu) { string sql = string.Format("SELECT 1 FROM BANGKE_PHIEUTHUTIEN WHERE MAPHIEUXUAT = '{0}'", maChungTu); return(Convert.ToInt32(ConnectionDB.ExcuteQuery(sql))); }
public int UpdateCur(CurrencyDTO cu) { string sql = string.Format("Update TIENTE SET Active = '{0}', TenTT = N'{1}', TGQD = {2} where MaTT = '{3}'", cu.iActive, cu.iTenTT, cu.iTGQD, cu.iMaTT); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int UpdateTien(string maPhieu, float thanhTien, float thanhToan) { string sql = string.Format("UPDATE THONGTIN_PHIEU_BANHANG SET Tongtienban = {0}, TongTienNhan = {1} WHERE MaPhieu = '{2}'", thanhTien, thanhToan, maPhieu); return(ConnectionDB.ExcuteNonQuery(sql)); }
public string getMaKHLast() { string sql = "select top 1 * from KhachHang order by MaKH DESC"; return(ConnectionDB.GetIDLast(sql)); }
public int deleteChiTietHoaDonAo() { string sql = string.Format("Delete from [HIENTHI_PHIEUXUAT]"); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int DeleteDetailTransWarehouse(string maPhieu) { string sql = string.Format("DELETE FROM CT_ChUYENKHO WHERE MaPhieuChuyen = '{0}'", maPhieu); return(ConnectionDB.ExcuteNonQuery(sql)); }
public string getMaNCCLast() { string sql = "select top 1 * from NCC order by MaNCC DESC"; return(ConnectionDB.GetIDLast(sql)); }
public DataTable LayDuLieuNV(string sql) { return(ConnectionDB.LayDuLieuBang(sql)); }
public int checkMaHang(string MaHang, string maPhieu) { string sql = string.Format("Select 1 from [CT_PHIEUNHAP] where MaHang = '{0}' and MaPhieu = '{1}' ", MaHang, maPhieu); return(Convert.ToInt32(ConnectionDB.ExcuteQuery(sql))); }
public int checkMaChungTuInPhieuChi(string maChungTu) { string sql = string.Format("SELECT 1 FROM [BANGKE_PHIEUCHITIEN] WHERE MAPHIEUCHI = '{0}'", maChungTu); return(Convert.ToInt32(ConnectionDB.ExcuteQuery(sql))); }