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)));
}
