public int DeleteArea(string maKv) { string sql = string.Format("Delete from KhuVuc where MaKV = '{0}'", maKv); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateArea(string maKV, string tenKV, string ghiChu, bool active) { string sql = string.Format("Update KhuVuc set TenKV = N'{0}', GhiChu = N'{1}', Active = '{2}' where MaKV = '{3}'", tenKV, ghiChu, active, maKV); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int InsertArea(string maKV, string tenKV, string ghiChu, bool active) { string sql = string.Format("INSERT INTO KHUVUC Values(N'{0}', N'{1}', N'{2}', '{3}')", maKV, tenKV, ghiChu, active); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateTongTien(float tongTienMua, string maPhieu, float TongTienTra) { string sql = string.Format("UPDATE THONGTIN_PHIEUNHAPHANG SET TongTienMua = {0}, TongTienTra = {1} WHERE MaPhieu = '{2}'", tongTienMua, TongTienTra, maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateIsCheck(string maPhieu, int isCheck) { string sql = string.Format("UPDATE [THONGTIN_PHIEU_BANHANG] SET IsCheck = {0} WHERE MaPhieu = '{1}' ", isCheck, maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int InsertInforTranWarehouse(InforTransWarehouseDTO infor) { string sql = string.Format("INSERT INTO [THONGTIN_CHUYENKHO] VALUES('{0}', '{1}', '{2}', '{3}', N'{4}', '{5}', '{6}', N'{7}', {8})", infor.MaPhieuChuyen, infor.MaKhoXuat, infor.MaKhoNhan, infor.NgayLap, infor.GhiChu, infor.MaNVXuat, infor.MaNVNhan, infor.SoPhieuChuyenTay, infor.TongTienChuyen); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int DeleteInforDetailBuy(string maPhieu) { string sql = string.Format("DELETE FROM THONGTIN_PHIEUNHAPHANG WHERE MaPhieu = '{0}' ", maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteTonKhoHaveMaHang(string maHang) { string sql = string.Format("DELETE FROM TONKHO WHERE Mahang = '{0}'", maHang); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteDepartment(string mabp) { string sql = string.Format("Delete from BOPHAN where MaBP = '{0}'", mabp); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteListFromMa(string maNhomHang) { string sql = string.Format("Delete from [NHOMHANG] where MaNhom = '{0}'", maNhomHang); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteGood(string mahang) { string sql = string.Format("Delete from HANGHOA_DICHVU where MaHang = '{0}'", mahang); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteKhachHang(string Makh) { string sql = string.Format("Delete from KHACHHANG where MaKH = '{0}'", Makh); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int insertTonKho(TonKho tk, int sl) { string sql = string.Format("INSERT INTO TONKHO VALUES('{0}', N'{1}',{2},{3}, '{4}')", tk.MaKho, tk.MaHang, sl, 1, true); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int CapNhatMatKhau(string username, string newPass) { string sql = string.Format("update NGUOIDUNG set Password = '******' where TenDangNhap = '{1}'", newPass, username); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int DeleteSupplierFromNCC(string maNCC) { string sql = string.Format("Delete from NCC where MaNCC = '{0}'", maNCC); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteDetailSell(string maPhieu) { string sql = string.Format("DELETE FROM CT_PHIEUXUAT WHERE [MaPhieuXuat] = '{0}' ", maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateIsDeleteDetail(string maPhieu) { string sql = string.Format("UPDATE [CT_PHIEUXUAT] SET ISDELETE = {0} WHERE MaPhieu = '{1}' ", 0, maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateInforTranWarehouse(InforTransWarehouseDTO infor) { string sql = string.Format("UPDATE [THONGTIN_CHUYENKHO] SET MaKhoXuat = '{0}', MaKhoNhan = '{1}',NgayLap = '{2}', GhiChu = N'{3}', MaNVXuat = '{4}', MaNVNhan = '{5}', SoPhieuChuyenTay = '{6}', TongTienChuyen = {7} WHERE MaPhieuChuyen = '{8}'", infor.MaKhoXuat, infor.MaKhoNhan, infor.NgayLap, infor.GhiChu, infor.MaNVXuat, infor.MaNVNhan, infor.SoPhieuChuyenTay, infor.TongTienChuyen, infor.MaPhieuChuyen); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int DeleteInforDetailSell(string maPhieu) { string sql = string.Format("Delete from [THONGTIN_PHIEU_BANHANG] WHERE MaPhieu = '{0}' ", maPhieu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int DeleteEmployees(string manv) { string sql = string.Format("Delete from _NHANVIEN where MaNV = '{0}'", manv); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int InsertDetailTransWarehouse(DetailTransWarehouseDTO detailTrans) { string sql = string.Format("INSERT INTO [CT_CHUYENKHO](MAPHIEUCHUYEN, MAHANG, TENHANG, DONVI, DONGIA, SOLUONG, THANHTIEN) VALUES('{0}', '{1}', N'{2}', N'{3}', {4}, {5}, {6})", detailTrans.MaPhieuChuyen, detailTrans.MaHang, detailTrans.TenHang, detailTrans.DonVi, detailTrans.DonGia, detailTrans.SoLuong, detailTrans.ThanhTien); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int SuaVTCN(VaiTro_ChucNangDTO vtcn) { string sql = "update VAITRO_CHUCNANG " + string.Format("set TatCa={0} , TruyCap={1} , Them={2} , Xoa={3} , Sua={4} , InAn={5} , Nhap={6} , Xuat={7} where MaVaiTro ='{8}' and MaChucNang={9}", vtcn.TatCa, vtcn.TruyCap, vtcn.Them, vtcn.Xoa, vtcn.Sua, vtcn.InAn, vtcn.Nhap, vtcn.Xuat, vtcn.MaVaiTro, vtcn.MaChucNang); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int InsertDepartment(string mabp, string tenbp, string ghichu, bool active) { string id = IDAuto(); string sql = string.Format("INSERT INTO BOPHAN Values(N'{0}', N'{1}', N'{2}', '{3}')", id, tenbp, ghichu, active); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int ThemNguoiDung(NguoiDung nd) { int cql = nd.ConQuanLy == true ? 1 : 0; string sql = string.Format("insert into NGUOIDUNG values(" + "'{0}', '{1}', '{2}', '{3}', N'{4}', {5})", nd.TenDangNhap, nd.Password, nd.MaVaiTro, nd.MaNV, nd.DienGiai, cql); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int InsertDetailSell(DetailSellGoods detailSell) { string sql = string.Format("INSERT INTO CT_PHIEUXUAT VALUES('{0}', N'{1}', N'{2}', N'{3}'," + " {4}, {5}, {6}, {7}, {8})", detailSell.MaPhieuXuat, detailSell.MaHang, detailSell.TenHang, detailSell.DonVi, detailSell.SoLuong, detailSell.DonGia, detailSell.ThanhTien, detailSell.CK, detailSell.ThanhToan); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int SuaVaiTro(VaiTro vt) { int kichhoat = vt.KichHoat == true ? 1 : 0; string sql = string.Format("update VAITRO " + "set TenVaiTro = '{0}', DienGiai = N'{1}', KichHoat = {2} where MaVaiTro = '{3}'", vt.TenVaiTro, vt.DienGiai, kichhoat, vt.MaVaiTro); return(ConnectionDB.ExcuteNonQuery(sql)); }
public int InsertNhomHang(string ma, string ten, string ghichu, bool active) { string id = IDAuto(); string sql = string.Format("INSERT INTO NHOMHANG Values(N'{0}', N'{1}', N'{2}', '{3}')", ma, ten, ghichu, active); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int InsertKhachHang(CustomerDTO cusDTO) { string sql = string.Format("INSERT INTO KHACHHANG values('{0}', N'{1}', N'{2}',N'{3}', N'{4}'," + " N'{5}',N'{6}', N'{7}', N'{8}',N'{9}', N'{10}', N'{11}','{12}', N'{13}')", cusDTO.MaKH, cusDTO.TenKH, cusDTO.NguoiLienHe, cusDTO.DiaChi, cusDTO.DienThoai , cusDTO.DiDong, cusDTO.Fax, cusDTO.Email, cusDTO.Website, cusDTO.MaSoThue, cusDTO.SoTK, cusDTO.TenNganHang, cusDTO.Active, cusDTO.MaKV); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int InsertDetailBuyGoods(DetailBuyGoods detailBuy) { string sql = string.Format("INSERT INTO [CT_PHIEUNHAP](MaPhieu, MaHang, TenHang, DonVi, SoLuong, DonGia, " + "ThanhTien, GhiChu) " + "VALUES ('{0}', '{1}', N'{2}',N'{3}', {4}, {5}, {6}, N'{7}')", detailBuy.MaPhieu, detailBuy.MaHang, detailBuy.TenHang, detailBuy.DonVi, detailBuy.SoLuong, detailBuy.DonGia, detailBuy.ThanhTien, detailBuy.GhiChu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }
public int UpdateDetailBuy(DetailBuyGoods detailBuy) { string sql = string.Format("UPDATE [CT_PHIEUNHAP] set MaHang ='{1}' , TenHang = N'{2}', DonVi = N'{3}', SoLuong = {4}, DonGia = {5}, " + "ThanhTien = {6}, GhiChu = N'{7}' WHERE MaPhieu = '{0}'" , detailBuy.MaPhieu, detailBuy.MaHang, detailBuy.TenHang, detailBuy.DonVi, detailBuy.SoLuong, detailBuy.DonGia, detailBuy.ThanhTien, detailBuy.GhiChu); int check = ConnectionDB.ExcuteNonQuery(sql); return(check); }