/// <summary>
/// Cập nhật khách hàng
/// </summary>
public int Sua(clsKhachHangDTO KhachHang)
{
int i = -1;
string sql = "sp_UpdateKhachHang";
string[] ParameterColection = new string[10];
Object[] valueofParameter = new Object[10];
ParameterColection[0] = "@MaKhachHang";
valueofParameter[0] = KhachHang.MaKhachHang;
ParameterColection[1] = "@TenKhachHang";
valueofParameter[1] = KhachHang.TenKhachHang;
ParameterColection[2] = "@DienThoai";
valueofParameter[2] = KhachHang.DienThoai;
ParameterColection[3] = "@DiaChi";
valueofParameter[3] = KhachHang.DiaChi;
ParameterColection[4] = "@Fax";
valueofParameter[4] = KhachHang.Fax;
ParameterColection[5] = "@MaSoThue";
valueofParameter[5] = KhachHang.MaSoThue;
ParameterColection[6] = "@BaoGia";
valueofParameter[6] = KhachHang.BaoGia;
ParameterColection[7] = "@ChietKhau";
valueofParameter[7] = KhachHang.ChietKhau;
ParameterColection[8] = "@NoDauKy";
valueofParameter[8] = KhachHang.NoDauKy;
ParameterColection[9] = "@TenNguoiLienHe";
valueofParameter[9] = KhachHang.TenNguoiLienHe;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Cập nhật nhà cung cấp
/// </summary>
public int Sua(clsNhaCungCapDTO NhaCungCap)
{
int i = -1;
string sql = "sp_UpdateNhaCungCap";
string[] ParameterColection = new string[8];
Object[] valueofParameter = new Object[8];
ParameterColection[0] = "@MaNhaCungCap";
valueofParameter[0] = NhaCungCap.MaNhaCungCap;
ParameterColection[1] = "@TenNhaCungCap";
valueofParameter[1] = NhaCungCap.TenNhaCungCap;
ParameterColection[2] = "@DienThoai";
valueofParameter[2] = NhaCungCap.DienThoai;
ParameterColection[3] = "@DiaChi";
valueofParameter[3] = NhaCungCap.DiaChi;
ParameterColection[4] = "@Fax";
valueofParameter[4] = NhaCungCap.Fax;
ParameterColection[5] = "@MaSoThue";
valueofParameter[5] = NhaCungCap.MaSoThue;
ParameterColection[6] = "@NoDauKy";
valueofParameter[6] = NhaCungCap.NoDauKy;
ParameterColection[7] = "@TenNguoiLienHe";
valueofParameter[7] = NhaCungCap.TenNguoiLienHe;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Cập nhật khách hàng
/// </summary>
public int Sua(clsCongTyDTO CongTy)
{
int i = -1;
string sql = "sp_UpdateCongTy";
string[] ParameterColection = new string[9];
Object[] valueofParameter = new Object[9];
ParameterColection[0] = "@MaCongTy";
valueofParameter[0] = CongTy.MaCongTy;
ParameterColection[1] = "@TenCongTy";
valueofParameter[1] = CongTy.TenCongTy;
ParameterColection[2] = "@DiaChi";
valueofParameter[2] = CongTy.DiaChi;
ParameterColection[3] = "@DienThoai";
valueofParameter[3] = CongTy.DienThoai;
ParameterColection[4] = "@MaSoThue";
valueofParameter[4] = CongTy.MaSoThue;
ParameterColection[5] = "@Fax";
valueofParameter[5] = CongTy.Fax;
ParameterColection[6] = "@Email";
valueofParameter[6] = CongTy.Email;
ParameterColection[7] = "@Website";
valueofParameter[7] = CongTy.Website;
ParameterColection[8] = "@Logo";
valueofParameter[8] = CongTy.Logo;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin phiếu nhập
/// </summary>
/// <param name="PhieuNhap">
/// MaPhieuNhap nvarchar(10)
/// NgayNhap smalldatetime
/// MaNhaCungCap nvarchar(50)
/// TongTien float
/// ConNo float
/// TragThai int
/// </param>
public int Them(clsPhieuNhapDTO PhieuNhap)
{
int i = -1;
string sql = "sp_InsertPhieuNhap";
string[] ParameterColection = new string[7];
Object[] valueofParameter = new Object[7];
ParameterColection[0] = "@MaPhieuNhap";
valueofParameter[0] = PhieuNhap.MaPhieuNhap;
ParameterColection[1] = "@NgayNhap";
valueofParameter[1] = PhieuNhap.NgayNhap;
ParameterColection[2] = "@MaNhaCungCap";
valueofParameter[2] = PhieuNhap.NhaCungCap.MaNhaCungCap;
ParameterColection[3] = "@TongTien";
valueofParameter[3] = PhieuNhap.TongTien;
ParameterColection[4] = "@ConNo";
valueofParameter[4] = PhieuNhap.ConNo;
ParameterColection[5] = "@TrangThai";
valueofParameter[5] = PhieuNhap.TrangThai;
ParameterColection[6] = "@MaNhanVien";
valueofParameter[6] = PhieuNhap.NguoiNhap;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
if (i != -1)
{
for (int k = 0; k < PhieuNhap.DS_ChiTietPhieuNhap.Count; k++)
{
i = ChihTietPhieuNhapDAO.Them(PhieuNhap.DS_ChiTietPhieuNhap[k]);
}
}
return(i);
}
/// <summary>
/// Cập nhật Nhân viên
/// </summary>
public int Sua(clsNhanVienDTO NhanVien)
{
int i = -1;
string sql = "sp_UpdateNhanVien";
string[] ParameterColection = new string[8];
Object[] valueofParameter = new Object[8];
ParameterColection[0] = "@MaNhanVien";
valueofParameter[0] = NhanVien.MaNhanVien;
ParameterColection[1] = "@TenNhanVien";
valueofParameter[1] = NhanVien.TenNhanVien;
ParameterColection[2] = "@DienThoai";
valueofParameter[2] = NhanVien.DienThoai;
ParameterColection[3] = "@DiaChi";
valueofParameter[3] = NhanVien.DiaChi;
ParameterColection[4] = "@GhiChu";
valueofParameter[4] = NhanVien.GhiChu;
ParameterColection[5] = "@QuyenHan";
valueofParameter[5] = NhanVien.QuyenHan.MaQuyenHan;
ParameterColection[6] = "@TenNguoiDung";
valueofParameter[6] = NhanVien.TenNguoiDung;
ParameterColection[7] = "@MatKhau";
valueofParameter[7] = NhanVien.MatKhau;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin chi tiết phiếu xuất
/// </summary>
/// <param name="ChiTietPhieuXuất">
/// MaPhieuXuat nvarchar(10)
/// MaMatHang nvarchar(10)
/// SoLuong int
/// DonGia float
/// ChietKhau float
/// ThanhTien float
/// ThueVAT float
/// </param>
public int Them(clsChiTietPhieuXuatDTO ChiTietPhieuXuat)
{
int i = -1;
string sql = "sp_InsertChiTietPhieuXuat";
string[] ParameterColection = new string[8];
Object[] valueofParameter = new Object[8];
ParameterColection[0] = "@MaPhieuXuat";
valueofParameter[0] = ChiTietPhieuXuat.MaPhieuXuat;
ParameterColection[1] = "@MaMatHang";
valueofParameter[1] = ChiTietPhieuXuat.MatHang.MaMatHang;
ParameterColection[2] = "@MaPhieuNhap";
valueofParameter[2] = ChiTietPhieuXuat.MaPhieuNhap;
ParameterColection[3] = "@SoLuong";
valueofParameter[3] = ChiTietPhieuXuat.SoLuong;
ParameterColection[4] = "@DonGia";
valueofParameter[4] = ChiTietPhieuXuat.DonGia;
ParameterColection[5] = "@ChietKhau";
valueofParameter[5] = ChiTietPhieuXuat.ChietKhau;
ParameterColection[6] = "@ThanhTien";
valueofParameter[6] = ChiTietPhieuXuat.ThanhTien;
ParameterColection[7] = "@ThueVAT";
valueofParameter[7] = ChiTietPhieuXuat.ThueVAT;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// Thêm chức năng
/// </summary>
/// <param name="ChucNang"></param>
/// <returns></returns>
public int Them(clsChucNangDTO ChucNang)
{
int i = -1;
string sql = "sp_InsertChucNang";
string[] ParameterColection = new string[1];
Object[] valueofParameter = new Object[1];
ParameterColection[0] = "@TenChucNang";
valueofParameter[0] = ChucNang.TenChucNang;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin loại mặt hàng
/// </summary>
/// <param name="DonViTinh">
/// MaDonViTinh nvarchar(10)
/// TenDonViTinh nvarchar(255)
/// DienGiai ntext
/// NgayTao smalldatetime
/// TrangThai int
/// </param>
public int Them(clsDonViTinhDTO DonViTinh)
{
int i = -1;
string sql = "sp_InsertDonViTinh";
string[] ParameterColection = new string[2];
Object[] valueofParameter = new Object[2];
ParameterColection[0] = "@MaDonViTinh";
valueofParameter[0] = DonViTinh.MaDonViTinh;
ParameterColection[1] = "@TenDonViTinh";
valueofParameter[1] = DonViTinh.TenDonViTinh;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin loại mặt hàng
/// </summary>
/// <param name="NuocSanXuat">
/// MaNuocSanXuat nvarchar(10)
/// TenNuocSanXuat nvarchar(255)
/// DienGiai ntext
/// NgayTao smalldatetime
/// TrangThai int
/// </param>
public int Them(clsNuocSanXuatDTO NuocSanXuat)
{
int i = -1;
string sql = "sp_InsertNuocSanXuat";
string[] ParameterColection = new string[2];
Object[] valueofParameter = new Object[2];
ParameterColection[0] = "@MaNuocSanXuat";
valueofParameter[0] = NuocSanXuat.MaNuocSanXuat;
ParameterColection[1] = "@TenNuocSanXuat";
valueofParameter[1] = NuocSanXuat.TenNuocSanXuat;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm một phân quyền chức năng
/// </summary>
/// <param name="PhanQuyenChucNang">
/// MaQuyenHan nvarchar(10)
/// MaPhieuXuat nvarchar(10)
/// SoTien int
/// </param>
public int Them(clsPhanQuyenChucNangDTO PhanQuyenChucNang)
{
int i = -1;
string sql = "sp_InsertPhanQuyenChucNang";
string[] ParameterColection = new string[2];
Object[] valueofParameter = new Object[2];
ParameterColection[0] = "@MaQuyenHan";
valueofParameter[0] = PhanQuyenChucNang.MaQuyenHan;
ParameterColection[1] = "@MaChucNang";
valueofParameter[1] = PhanQuyenChucNang.ChucNang.MaChucNang;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin chi tiết phiếu chi
/// </summary>
/// <param name="ChiTietPhieuChi">
/// MaPhieuChi nvarchar(10)
/// MaPhieuChi nvarchar(10)
/// SoTien int
/// </param>
public int Them(clsChiTietPhieuChiDTO ChiTietPhieuChi)
{
int i = -1;
string sql = "sp_InsertChiTietPhieuChi";
string[] ParameterColection = new string[3];
Object[] valueofParameter = new Object[3];
ParameterColection[0] = "@MaPhieuChi";
valueofParameter[0] = ChiTietPhieuChi.MaPhieuChi;
ParameterColection[1] = "@MaPhieuNhap";
valueofParameter[1] = ChiTietPhieuChi.PhieuNhap.MaPhieuNhap;
ParameterColection[2] = "@SoTien";
valueofParameter[2] = ChiTietPhieuChi.SoTien;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin loại mặt hàng
/// </summary>
/// <param name="LoaiMatHang">
/// MaLoaiMatHang nvarchar(10)
/// TenLoaiMatHang nvarchar(255)
/// DienGiai ntext
/// NgayTao smalldatetime
/// TrangThai int
/// </param>
public int Them(clsLoaiMatHangDTO LoaiMatHang)
{
int i = -1;
string sql = "sp_InsertLoaiMatHang";
string[] ParameterColection = new string[3];
Object[] valueofParameter = new Object[3];
ParameterColection[0] = "@MaLoaiMatHang";
valueofParameter[0] = LoaiMatHang.MaLoaiMatHang;
ParameterColection[1] = "@TenLoaiMatHang";
valueofParameter[1] = LoaiMatHang.TenLoaiMatHang;
ParameterColection[2] = "@DienGiai";
valueofParameter[2] = LoaiMatHang.DienGiai;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin chi tiết phiếu thu
/// </summary>
/// <param name="ChiTietPhieuThu">
/// MaPhieuThu nvarchar(10)
/// MaPhieuXuat nvarchar(10)
/// SoTien int
/// </param>
public int Them(clsChiTietPhieuThuDTO ChiTietPhieuThu)
{
int i = -1;
string sql = "sp_InsertChiTietPhieuThu";
string[] ParameterColection = new string[3];
Object[] valueofParameter = new Object[3];
ParameterColection[0] = "@MaPhieuThu";
valueofParameter[0] = ChiTietPhieuThu.MaPhieuThu;
ParameterColection[1] = "@MaPhieuXuat";
valueofParameter[1] = ChiTietPhieuThu.PhieuXuat.MaPhieuXuat;
ParameterColection[2] = "@SoTien";
valueofParameter[2] = ChiTietPhieuThu.SoTien;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm thông tin mặt hàng
/// </summary>
/// <param name="MatHang">
/// MaMatHang
/// TenMatHang
/// </param>
public int Them(clsMatHangDTO MatHang)
{
int i = -1;
string sql = "sp_InsertMatHang";
string[] ParameterColection = new string[18];
Object[] valueofParameter = new Object[18];
ParameterColection[0] = "@MaMatHang";
valueofParameter[0] = MatHang.MaMatHang;
ParameterColection[1] = "@TenMatHang";
valueofParameter[1] = MatHang.TenMatHang;
ParameterColection[2] = "@MaLoaiMatHang";
valueofParameter[2] = MatHang.LoaiMatHang.MaLoaiMatHang;
ParameterColection[3] = "@DonViTinh";
valueofParameter[3] = MatHang.DonViTinh;
ParameterColection[4] = "@DonGia";
valueofParameter[4] = MatHang.DonGia;
ParameterColection[5] = "@GiaMua";
valueofParameter[5] = MatHang.GiaMua;
ParameterColection[6] = "@GiaBanSi";
valueofParameter[6] = MatHang.GiaBanSi;
ParameterColection[7] = "@GiaBanLe";
valueofParameter[7] = MatHang.GiaBanLe;
ParameterColection[8] = "@PT_GiaBanSi";
valueofParameter[8] = MatHang.PT_GiaBanSi;
ParameterColection[9] = "@PT_GiaBanLe";
valueofParameter[9] = MatHang.PT_GiaBanLe;
ParameterColection[10] = "@LuongMin";
valueofParameter[10] = MatHang.LuongMin;
ParameterColection[11] = "@LuongMax";
valueofParameter[11] = MatHang.LuongMax;
ParameterColection[12] = "@SoLuongTon";
valueofParameter[12] = MatHang.SoLuongTon;
ParameterColection[13] = "@ThueVAT";
valueofParameter[13] = MatHang.ThueVAT;
ParameterColection[14] = "@XuatXu";
valueofParameter[14] = MatHang.XuatXu;
ParameterColection[15] = "@DienGiai";
valueofParameter[15] = MatHang.DienGiai;
ParameterColection[16] = "@MaVach";
valueofParameter[16] = MatHang.MaVach;
ParameterColection[17] = "@TrangThai";
valueofParameter[17] = MatHang.TrangThai;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Hủy thông tin phiếu xuất
/// </summary>
/// <param name="MaPhieuXuat">MaPhieuXuat string</param>
public int Huy(string MaPhieuXuat)
{
int i = -1;
string sql = "sp_RemovePhieuXuat";
string[] ParameterColection = new string[1];
Object[] valueofParameter = new Object[1];
ParameterColection[0] = "@MaPhieuXuat";
valueofParameter[0] = MaPhieuXuat;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
return(i);
}
/// <summary>
/// Thêm quyền hạn
/// </summary>
/// <param name="QuyenHan"></param>
/// <returns></returns>
public int Them(clsQuyenHanDTO QuyenHan)
{
int i = -1;
string sql = "sp_InsertQuyenHan";
string[] ParameterColection = new string[1];
Object[] valueofParameter = new Object[1];
ParameterColection[0] = "@TenQuyenHan";
valueofParameter[0] = QuyenHan.TenQuyenHan;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
if (i != -1)
{
QuyenHan.MaQuyenHan = i;
for (int k = 0; k < QuyenHan.DS_PhanQuyenChucNang.Count; k++)
{
QuyenHan.DS_PhanQuyenChucNang[k].MaQuyenHan = QuyenHan.MaQuyenHan;
i = PhanQuyenChucNangDAO.Them(QuyenHan.DS_PhanQuyenChucNang[k]);
}
}
return(i);
}
