public bool KiemTraHangHoa(Entities.ChiTietDonDatHang chitietdonhang)
{
bool kiemtra = false;
Entities.HangHoa[] hh = new BizLogic.HangHoa().Select();
for (int i = 0; i < hh.Length; i++)
{
if (hh[i].MaHangHoa == chitietdonhang.MaHangHoa)
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = chitietdonhang.MaHangHoa;
row.TenHangHoa = hh[i].TenHangHoa;
row.SoLuongDat = chitietdonhang.SoLuong;
row.GiaGoc = chitietdonhang.DonGia;
row.Giabanbuon = hh[i].GiaBanBuon;
row.Giabanle = hh[i].GiaBanLe;
row.PhanTramChietKhau = chitietdonhang.PhanTramChietKhau;
row.Thuegiatrigiatang = chitietdonhang.Thue;
ar.Add(row);
kiemtra = true;
break;
}
}
return(kiemtra);
}
private void HangHoa(string MaHangHoa)
{
try
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (hanghoa != null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaHangHoa == MaHangHoa)
{
thue = Thue(hanghoa[k].MaThueGiaTriGiaTang);
giabanbuon = hanghoa[k].GiaBanBuon;
giabanle = hanghoa[k].GiaBanLe;
gianhap = hanghoa[k].GiaNhap;
break;
}
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
}
public Entities.HienThi_ChiTiet_DonDatHang Select(string mahang)
{
Entities.HienThi_ChiTiet_DonDatHang data = null;
try
{
Entities.GoiHang[] goi = new BizLogic.GoiHang().Select();
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (goi != null)
{
for (int k = 0; k < goi.Length; k++)
{
if (goi[k].MaGoiHang.ToUpper() == mahang.ToUpper())
{
data = new Entities.HienThi_ChiTiet_DonDatHang();
data.MaHangHoa = goi[k].MaGoiHang;
data.TenHangHoa = goi[k].TenGoiHang;
data.SoLuongDat = 1;
data.GiaGoc = goi[k].GiaNhap;
data.GiaNhap = goi[k].GiaNhap;
data.Giabanbuon = goi[k].GiaBanBuon;
data.Giabanle = goi[k].GiaBanLe;
data.PhanTramChietKhau = "0";
data.Thuegiatrigiatang = "0";
data.ChietKhau = "0";
break;
}
}
}
if (hanghoa != null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaHangHoa.ToUpper() == mahang.ToUpper())
{
data = new Entities.HienThi_ChiTiet_DonDatHang();
data.MaHangHoa = hanghoa[k].MaHangHoa;
data.TenHangHoa = hanghoa[k].TenHangHoa;
data.SoLuongDat = 1;
data.GiaGoc = hanghoa[k].GiaNhap;
data.GiaNhap = hanghoa[k].GiaNhap;
data.Giabanbuon = hanghoa[k].GiaBanBuon;
data.Giabanle = hanghoa[k].GiaBanLe;
data.PhanTramChietKhau = "0";
data.Thuegiatrigiatang = Thue(hanghoa[k].MaThueGiaTriGiaTang);
data.ChietKhau = "0";
break;
}
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
data = null;
}
return(data);
}
public Entities.HangHoa[] HangHoaTheoKho(string makho)
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().SelectHHTheoKho(makho);
if (hanghoa == null)
{
hanghoa = new Entities.HangHoa[0];
}
return(hanghoa);
}
public Entities.HangHoaGoiHang[] Select()
{
Entities.HangHoaGoiHang[] data = null;
try
{
ArrayList list = new ArrayList();
Entities.GoiHang[] goi = new BizLogic.GoiHang().Select();
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (goi != null)
{
for (int k = 0; k < goi.Length; k++)
{
Entities.HangHoaGoiHang row = new Entities.HangHoaGoiHang();
row.TenHang = goi[k].TenGoiHang;
row.MaHang = goi[k].MaGoiHang;
row.GiaNhap = goi[k].GiaNhap;
row.GiaBanBuon = goi[k].GiaBanBuon;
row.GiaBanLe = goi[k].GiaBanLe;
row.Thue = "0";
list.Add(row);
}
}
if (hanghoa != null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
Entities.HangHoaGoiHang row = new Entities.HangHoaGoiHang();
row.TenHang = hanghoa[k].TenHangHoa;
row.MaHang = hanghoa[k].MaHangHoa;
row.GiaNhap = hanghoa[k].GiaNhap;
row.GiaBanBuon = hanghoa[k].GiaBanBuon;
row.GiaBanLe = hanghoa[k].GiaBanLe;
row.Thue = Thue(hanghoa[k].MaThueGiaTriGiaTang);
list.Add(row);
}
}
int n = list.Count;
if (n == 0)
{
data = null;
}
data = new Entities.HangHoaGoiHang[n];
for (int i = 0; i < n; i++)
{
data[i] = (Entities.HangHoaGoiHang)list[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
data = null;
}
return(data);
}
public void LayBangHangHoa()
{
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = new BizLogic.HangHoa().Select();
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
public Entities.HangHoaGoiHang[] Select()
{
Entities.HangHoaGoiHang[] data = null;
try
{
ArrayList list = new ArrayList();
Entities.GoiHang[] goi = new BizLogic.GoiHang().Select();
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (goi!= null)
{
for (int k = 0; k < goi.Length; k++)
{
Entities.HangHoaGoiHang row = new Entities.HangHoaGoiHang();
row.TenHang = goi[k].TenGoiHang;
row.MaHang = goi[k].MaGoiHang;
row.GiaNhap = goi[k].GiaNhap;
row.GiaBanBuon = goi[k].GiaBanBuon;
row.GiaBanLe = goi[k].GiaBanLe;
row.Thue = "0";
list.Add(row);
}
}
if (hanghoa!=null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
Entities.HangHoaGoiHang row = new Entities.HangHoaGoiHang();
row.TenHang = hanghoa[k].TenHangHoa;
row.MaHang = hanghoa[k].MaHangHoa;
row.GiaNhap = hanghoa[k].GiaNhap;
row.GiaBanBuon = hanghoa[k].GiaBanBuon;
row.GiaBanLe = hanghoa[k].GiaBanLe;
row.Thue =Thue(hanghoa[k].MaThueGiaTriGiaTang);
list.Add(row);
}
}
int n = list.Count;
if (n == 0) { data = null; }
data = new Entities.HangHoaGoiHang[n];
for (int i = 0; i < n; i++)
{
data[i] = (Entities.HangHoaGoiHang)list[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
data = null;
}
return data;
}
public Entities.HienThi_ChiTiet_DonDatHang Select(string mahang)
{
Entities.HienThi_ChiTiet_DonDatHang data = null;
try
{
Entities.GoiHang[] goi = new BizLogic.GoiHang().Select();
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (goi!=null)
{
for (int k = 0; k < goi.Length; k++)
{
if (goi[k].MaGoiHang.ToUpper() == mahang.ToUpper())
{
data = new Entities.HienThi_ChiTiet_DonDatHang();
data.MaHangHoa = goi[k].MaGoiHang;
data.TenHangHoa = goi[k].TenGoiHang;
data.SoLuongDat = 1;
data.GiaGoc = goi[k].GiaNhap;
data.GiaNhap = goi[k].GiaNhap;
data.Giabanbuon = goi[k].GiaBanBuon;
data.Giabanle = goi[k].GiaBanLe;
data.PhanTramChietKhau = "0";
data.Thuegiatrigiatang = "0";
data.ChietKhau = "0";
break;
}
}
}
if (hanghoa!=null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaHangHoa.ToUpper() == mahang.ToUpper())
{
data = new Entities.HienThi_ChiTiet_DonDatHang();
data.MaHangHoa = hanghoa[k].MaHangHoa;
data.TenHangHoa = hanghoa[k].TenHangHoa;
data.SoLuongDat = 1;
data.GiaGoc = hanghoa[k].GiaNhap;
data.GiaNhap = hanghoa[k].GiaNhap;
data.Giabanbuon = hanghoa[k].GiaBanBuon;
data.Giabanle = hanghoa[k].GiaBanLe;
data.PhanTramChietKhau = "0";
data.Thuegiatrigiatang = Thue(hanghoa[k].MaThueGiaTriGiaTang);
data.ChietKhau = "0";
break;
}
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
data = null;
}
return data;
}
public void LayBangHangHoa()
{
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = new BizLogic.HangHoa().Select();
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
private void HangHoa(string MaHangHoa)
{
try
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().Select();
if (hanghoa!=null)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaHangHoa == MaHangHoa)
{
thue = Thue(hanghoa[k].MaThueGiaTriGiaTang);
giabanbuon = hanghoa[k].GiaBanBuon;
giabanle = hanghoa[k].GiaBanLe;
gianhap = hanghoa[k].GiaNhap;
break;
}
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
}
public bool KiemTraHangHoa(Entities.ChiTietDonDatHang chitietdonhang)
{
bool kiemtra = false;
Entities.HangHoa[] hh = new BizLogic.HangHoa().Select();
for (int i = 0; i < hh.Length; i++)
{
if (hh[i].MaHangHoa == chitietdonhang.MaHangHoa)
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = chitietdonhang.MaHangHoa;
row.TenHangHoa = hh[i].TenHangHoa;
row.SoLuongDat = chitietdonhang.SoLuong;
row.GiaGoc = chitietdonhang.DonGia;
row.Giabanbuon = hh[i].GiaBanBuon;
row.Giabanle = hh[i].GiaBanLe;
row.PhanTramChietKhau = chitietdonhang.PhanTramChietKhau;
row.Thuegiatrigiatang = chitietdonhang.Thue;
ar.Add(row);
kiemtra = true;
break;
}
}
return kiemtra;
}
public void XuLy_HangHoa(NetworkStream clientStream)
{
Entities.HangHoa hh = (Entities.HangHoa)formatter.Deserialize(clientStream);
switch (hh.HanhDong)
{
case "Insert":
{
int kt1 = new BizLogic.HangHoa().InsertUpdate(hh);
bool kt = kt1 == 1;
if (kt)
new BizLogic.LogFile().GhiFile(new Entities.LogFile(hh.NhanVienID, hh.TenDangNhap, hh.HanhDong, DateTime.Now.ToString(), "Thêm Hàng Hóa: " + hh.MaHangHoa));
formatter.Serialize(clientStream, kt);
break;
}
case "Update":
{
int kt1 = new BizLogic.HangHoa().InsertUpdate(hh);
bool kt = kt1 == 1;
if (kt)
new BizLogic.LogFile().GhiFile(new Entities.LogFile(hh.NhanVienID, hh.TenDangNhap, hh.HanhDong, DateTime.Now.ToString(), "Sửa Hàng Hóa: " + hh.MaHangHoa));
formatter.Serialize(clientStream, kt);
break;
}
case "Delete":
{
int kt1 = new BizLogic.HangHoa().Delete(hh);
bool kt = kt1 == 1;
if (kt)
new BizLogic.LogFile().GhiFile(new Entities.LogFile(hh.NhanVienID, hh.TenDangNhap, hh.HanhDong, DateTime.Now.ToString(), "Xóa Hàng Hóa: " + hh.MaHangHoa));
formatter.Serialize(clientStream, kt);
break;
}
case "Select":
{
Entities.HangHoa[] hhoa = new BizLogic.HangHoa().SelectAll();
formatter.Serialize(clientStream, hhoa);
break;
}
case "SelectAll":
{
Entities.HangHoa[] hhoa = new BizLogic.HangHoa().SelectAll();
formatter.Serialize(clientStream, hhoa);
break;
}
case "SelectHangHoa_Theo_MaHangHoa":
{
Entities.HangHoa[] hhoa = new BizLogic.HangHoa().SelectHangHoa_Theo_MaHangHoa(hh.MaHangHoa);
formatter.Serialize(clientStream, hhoa);
break;
}
case "SearchTheoKho":
{
Entities.HangHoa[] kh1 = new BizLogic.HangHoa().Select(hh.Cot, hh.Kieu, hh.GiaTri, hh.MaKho);
formatter.Serialize(clientStream, kh1);
break;
}
case "Search":
{
Entities.HangHoa[] kh1 = new BizLogic.HangHoa().Select(hh.Cot, hh.Kieu, hh.GiaTri);
formatter.Serialize(clientStream, kh1);
break;
}
case "SelectTheoKho":
{
Entities.HangHoa[] hhoa = new BizLogic.HangHoa().SelectHHTheoKho(hh.MaKho);
formatter.Serialize(clientStream, hhoa);
break;
}
}
}
public Entities.HangHoa[] HangHoaTheoKho(string makho)
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().SelectHHTheoKho(makho);
if (hanghoa == null)
hanghoa = new Entities.HangHoa[0];
return hanghoa;
}
