/// <summary>
/// Thêm thông tin Phiếu Xuất Bán Sỉ
/// </summary>
/// <param name="PhieuXuat">
/// MaPhieuXuat nvarchar(10)
/// NgayXuat smalldatetime
/// MaNhanVienBanHang nvarchar(10)
/// TongTien float
/// DaTra float
/// KhachHang nvarchar(255)
/// LoaiPhieuXuat nvarchar(100)
/// TrangThai int
/// </param>
public int Them(clsPhieuXuatBanSiDTO PhieuXuatBanSi)
{
int i = -1;
string sql = "sp_InsertPhieuXuatBanSi";
string[] ParameterColection = new string[7];
Object[] valueofParameter = new Object[7];
ParameterColection[0] = "@MaPhieuXuat";
valueofParameter[0] = PhieuXuatBanSi.MaPhieuXuat;
ParameterColection[1] = "@NgayXuat";
valueofParameter[1] = PhieuXuatBanSi.NgayXuat;
ParameterColection[2] = "@MaNhanVienBanHang";
valueofParameter[2] = PhieuXuatBanSi.NhanVien.MaNhanVien.ToString();
ParameterColection[3] = "@TongTien";
valueofParameter[3] = PhieuXuatBanSi.TongTien;
ParameterColection[4] = "@DaTra";
valueofParameter[4] = PhieuXuatBanSi.DaTra;
ParameterColection[5] = "@MaKhachHang";
valueofParameter[5] = PhieuXuatBanSi.KhachHang.MaKhachHang;
ParameterColection[6] = "@LoaiPhieuXuat";
valueofParameter[6] = "Xuất bán sỉ";
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
if (i != -1)
{
for (int k = 0; k < PhieuXuatBanSi.DS_ChiTietPhieuXuat.Count; k++)
{
i = ChiTietPhieuXuatDAO.Them(PhieuXuatBanSi.DS_ChiTietPhieuXuat[k]);
}
}
return(i);
}
/// <summary>
/// Lấy thông tin phiếu xuất bán sỉ
/// </summary>
/// <param name="PhieuThu">
/// MaPhieuXuat nvarchar(10)
/// NgayXuat smalldatetime
/// MaNhanVienBanHang nvarchar(10)
/// TongTien float
/// DaTra float
/// KhachHang nvarchar(255)
/// LoaiPhieuXuat nvarchar(100)
/// TrangThai int
/// </param>
public clsPhieuXuatBanSiDTO LayThongTinTheoPhieuNhap(string MaPhieuXuat)
{
string sql = "sp_GetInfoPhieuXuatBanSi";
string[] ParameterColection = new string[1];
Object[] valueofParameter = new Object[1];
ParameterColection[0] = "@MaPhieuXuat";
valueofParameter[0] = MaPhieuXuat;
DataTable table = sqlServer.readData(sql, ParameterColection, valueofParameter);
clsPhieuXuatBanSiDTO PhieuXuat = ChuyenDoiTheoPhieuNhap(table);
return(PhieuXuat);
}
/// <summary>
/// chuyển từ một dòng sang đối tượng PhieuXuatBanSiDTO
/// </summary>
private clsPhieuXuatBanSiDTO ChuyenDoiTheoPhieuNhap(DataTable table)
{
clsPhieuXuatBanSiDTO PhieuXuat = new clsPhieuXuatBanSiDTO();
if (table.Rows.Count == 1)
{
DataRow Dong = table.Rows[0];
PhieuXuat.MaPhieuXuat = Dong["MaPhieuXuat"].ToString();
PhieuXuat.NgayXuat = DateTime.Parse(Dong["NgayXuat"].ToString());
PhieuXuat.NhanVien.MaNhanVien = Dong["MaNhanVienBanHang"].ToString();
PhieuXuat.TongTien = Double.Parse(Dong["TongTien"].ToString());
PhieuXuat.DaTra = Double.Parse(Dong["DaTra"].ToString());
//PhieuXuat.KhachHang = Dong["KhachBanLe"].ToString();
PhieuXuat.KhachHang.MaKhachHang = Dong["MaKhachHang"].ToString();
PhieuXuat.KhachHang.TenKhachHang = Dong["TenKhachhang"].ToString();
PhieuXuat.TrangThai = int.Parse(Dong["TrangThai"].ToString());
//Đọc chi tiết Phiếu Xuất Bán Sỉ
PhieuXuat.DS_ChiTietPhieuXuat = ChiTietPhieuXuatDAO.LayDanhSachTheoPhieuNhap(PhieuXuat.MaPhieuXuat);
return(PhieuXuat);
}
return(null);
}
/// <summary>
/// Sửa thông tin phiếu xuất bán Sỉ
/// </summary>
/// <param name="PhieuXuat">
/// MaPhieuXuat nvarchar(10)
/// NgayXuat smalldatetime
/// MaNhanVienBanHang nvarchar(10)
/// TongTien float
/// DaTra float
/// KhachHang nvarchar(255)
/// LoaiPhieuXuat nvarchar(100)
/// TrangThai int
/// </param>
public int Sua(clsPhieuXuatBanSiDTO PhieuXuatBanSi)
{
int i = -1;
string sql = "sp_UpdatePhieuXuatBanSi";
string[] ParameterColection = new string[6];
Object[] valueofParameter = new Object[6];
ParameterColection[0] = "@MaPhieuXuat";
valueofParameter[0] = PhieuXuatBanSi.MaPhieuXuat;
ParameterColection[1] = "@NgayXuat";
valueofParameter[1] = PhieuXuatBanSi.NgayXuat;
ParameterColection[2] = "@MaNhanVienBanHang";
valueofParameter[2] = PhieuXuatBanSi.NhanVien.MaNhanVien.ToString();
ParameterColection[3] = "@TongTien";
valueofParameter[3] = PhieuXuatBanSi.TongTien;
ParameterColection[4] = "@DaTra";
valueofParameter[4] = PhieuXuatBanSi.DaTra;
ParameterColection[5] = "@KhachHang";
valueofParameter[5] = PhieuXuatBanSi.KhachHang.MaKhachHang;
i = sqlServer.writeData(sql, ParameterColection, valueofParameter);
//Thêm mới từng chi tiết phiếu xuất
if (i != -1)
{
for (int k = 0; k < PhieuXuatBanSi.DS_ChiTietPhieuXuat.Count; k++)
{
if (i != -1)
{
i = ChiTietPhieuXuatDAO.Them(PhieuXuatBanSi.DS_ChiTietPhieuXuat[k]);
}
else
{
break;
}
}
}
return(i);
}
/// <summary>
/// Sửa thông tin phiếu xuất bán sỉ
/// </summary>
/// <param name="PhieuXuat">
/// MaPhieuXuat nvarchar(10)
/// NgayXuat smalldatetime
/// MaNhanVienBanHang nvarchar(10)
/// TongTien float
/// DaTra float
/// KhachHang nvarchar(255)
/// LoaiPhieuXuat nvarchar(100)
/// TrangThai int
/// </param>
public int Sua(clsPhieuXuatBanSiDTO PhieuXuatBanLe)
{
return(PhieuXuatBanSiDAO.Sua(PhieuXuatBanLe));
}
public int Them(clsPhieuXuatBanSiDTO PhieuXuatBanLe)
{
return(PhieuXuatBanSiDAO.Them(PhieuXuatBanLe));
}