public void LaySoDuKho()
{
Entities.SoDuKho[] ddh = new Entities.SoDuKho[1];
ddh = new BizLogic.SoDuKho().Select();
if (ddh != null)
{
sdk = ddh;
}
else
{
sdk = new Entities.SoDuKho[0];
}
}
public void LaySoDuKho()
{
Entities.SoDuKho[] ddh = new Entities.SoDuKho[1];
ddh = new BizLogic.SoDuKho().Select();
if (ddh != null)
{
sdk = ddh;
}
else
{
sdk = new Entities.SoDuKho[0];
}
}
/// <summary>
/// Business
/// </summary>
/// <param name="clientStream"></param>
/// <param name="objectName"></param>
/// <returns></returns>
private bool Bussiness(NetworkStream clientStream, string objectName)
{
bool isSuccessfuly = false;
try
{
switch (objectName)
{
#region Server Của Sơn
case "NhanVien":
{
Xuly_NhanVien(clientStream);
}
break;
case "PhongBan":
{
Xuly_PhongBan(clientStream);
}
break;
case "TienTe":
{
Xuly_TienTe(clientStream);
}
break;
case "NhomTKKeToan":
{
Xuly_NhomTKKeToan(clientStream);
}
break;
case "TKKeToan":
{
Xuly_TKKeToan(clientStream);
}
break;
case "TKNganHang":
{
Xuly_TKNganHang(clientStream);
}
break;
case "KMThuChi":
{
Xuly_KMThuChi(clientStream);
}
break;
case "PhieuDieuCHuyenKhoNoiBo":
{
Xuly_PhieuDieuChuyenKho(clientStream);
}
break;
case "ChiTietPhieuDieuCHuyenKhoNoiBo":
{
Xuly_ChiTietPhieuDieuChuyenKho(clientStream);
}
break;
case "ChiTietKho":
{
Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkho = (Entities.ChiTietKhoHangTheoHoaHonNhap[])new BizLogic.ChiTietKhoHangTheoHoaHonNhap().Select();
formatter.Serialize(clientStream, ctkho);
}
break;
case "ChiTietKhoTheoKho":
{
Entities.ChiTietKhoHangTheoHoaHonNhap ctKhoHang = (Entities.ChiTietKhoHangTheoHoaHonNhap)formatter.Deserialize(clientStream);
Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkho = (Entities.ChiTietKhoHangTheoHoaHonNhap[])new BizLogic.ChiTietKhoHangTheoHoaHonNhap().SelectTheoMaKho(ctKhoHang.Makho);
formatter.Serialize(clientStream, ctkho);
}
break;
case "ChiTietKhoAll":
{
Entities.ChiTietKhoHang[] ctkArr = (Entities.ChiTietKhoHang[])new BizLogic.ChiTietKhoHangTheoHoaHonNhap().SelectAll();
formatter.Serialize(clientStream, ctkArr);
}
break;
case "CapNhatGia":
{
Xuly_CapNhatGia(clientStream);
}
break;
case "SoDuKho":
{
Xuly_SoDuKho(clientStream);
}
break;
case "ThemArr":
{
Entities.SoDuKho[] nv = (Entities.SoDuKho[])formatter.Deserialize(clientStream);
bool msg = new BizLogic.SoDuKho().InsertArr(nv);
formatter.Serialize(clientStream, msg);
}
break;
case "XoaArr":
{
Entities.SoDuKho[] nv = (Entities.SoDuKho[])formatter.Deserialize(clientStream);
bool msg = new BizLogic.SoDuKho().DeleteArr(nv);
formatter.Serialize(clientStream, msg);
}
break;
#endregion
#region Server Của hòa
case "PhieuThu": XuLy_PhieuThu(clientStream); break;
case "PhieuTTCuaKH": XuLy_PhieuTTCuaKH(clientStream); break;
case "PhieuTTNCC": XuLy_PhieuTTNCC(clientStream); break;
case "PhieuXuatHuy": XuLy_PhieuXuatHuy(clientStream); break;
case "PhieuXuatHuyMang": XuLy_PhieuXuatHuyMang(clientStream); break;
case "HDBanHang": XuLy_HDBanHang(clientStream); break;
case "ChiTietHDBanHang": XuLy_ChiTietHDBanHang(clientStream); break;
case "HDBanHangMang": XuLy_HDBanHangMang(clientStream); break;
case "HoaDonNhapMang": XuLy_HoaDonNhapMang(clientStream); break;
case "ChiTietHDBanHangMang": XuLy_ChiTietHDBanHangMang(clientStream); break;
case "ChiTietXuatHuy": XuLy_ChiTietXuatHuy(clientStream); break;
case "ChiTietXuatHuyMang": XuLy_ChiTietXuatHuyMang(clientStream); break;
case "ChiTietPhieuTTNCC": XuLy_ChiTietPhieuTTNCC(clientStream); break;
case "ChiTietPhieuTTNCCMang": XuLy_ChiTietPhieuTTNCCMang(clientStream); break;
case "ChiTietPhieuTTCuaKH": XuLy_ChiTietPhieuTTCuaKH(clientStream); break;
case "ChiTietPhieuTTCuaKHMang": XuLy_ChiTietPhieuTTCuaKHMang(clientStream); break;
case "LayID": XuLy_LayID(clientStream); break;
case "QuayThuNgan": XuLy_QuayThuNgan(clientStream); break;
case "Thue": XuLy_Thue(clientStream); break;
case "SoQuy": XuLy_SoQuy(clientStream); break;
case "CongNo": XuLy_CongNo(clientStream); break;
case "HDN": { XuLy_HDN(clientStream); } break;
case "KHTL": { XuLy_KHTL(clientStream); } break;
case "TLNCC": { XuLy_TLNCC(clientStream); } break;
// Phần của Hưởng
case "BCDTTheoHangHoa": XuLy_BCDTTheoHangHoa(clientStream); break;
case "BCDTTheoNhanVien": XuLy_BCDTTheoNhanVien(clientStream); break;
case "BCDTTheoNhomHang": XuLy_BCDTTheoNhomHang(clientStream); break;
case "BCDTTheoThoiGian": XuLy_BCDTTheoThoiGian(clientStream); break;
case "BCHDBanHang": XuLy_BCHDBanHang(clientStream); break;
case "BCHDBanBuon": XuLy_BCHDBanBuon(clientStream); break;
case "BCTonKhoTheoKho": XuLy_TonKhoTheoKho(clientStream); break;
case "BCTonKhoTheoNhom": XuLy_TonKhoTheoNhom(clientStream); break;
case "CheckRefer": Xuly_CheckRefer(clientStream); break;
case "Select": Xuly_Select(clientStream); break;
case "TheGiamGia": XulyTheGiamGia(clientStream); break;
case "Datetime": DateServer(clientStream); break;
#endregion
#region Server Hương
case "GoiHang":
XuLy_GoiHang(clientStream);
break;
case "KhuyenMaiSoLuong":
XuLy_KhuyenMaiSoLuong(clientStream);
break;
case "ChiTietGoiHang":
XuLy_ChiTietGoiHang(clientStream);
break;
case "QuyDoiDonViTinh":
XuLy_QuyDoiDonViTinh(clientStream);
break;
case "KhachHang":
XuLy_KhachHang(clientStream);
break;
case "NhaCungCap":
XuLy_NhaCungCap(clientStream);
break;
case "DonHang":
{
XuLy_DonHang(clientStream);
}
break;
case "XuatHang":
{
XuLy_XuatHang(clientStream);
}
break;
case "TraLai":
{
XuLy_TraLai(clientStream);
}
break;
case "ThanhToan":
{
XuLy_ThanhToan(clientStream);
}
break;
case "LSGDHangHoa":
{
XuLy_LSGDHangHoa(clientStream);
}
break;
case "LSGDNhapMua":
{
XuLy_LSGDNhapMua(clientStream);
}
break;
case "LSGDTraLaiNCC":
{
XuLy_LSGDTraLaiNCC(clientStream);
}
break;
case "LSGDTTNCC":
{
XuLy_LSGDTTNCC(clientStream);
}
break;
case "CapNhatGiaKH":
{
XuLy_CapNhatGiaKH(clientStream);
}
break;
case "BaoCaoNhapHangTheoMatHang":
{
XuLy_BaoCaoNhapHangTheoMatHang(clientStream);
}
break;
case "BaoCaoNhapHangTheoNhomHang":
{
XuLy_BaoCaoNhapHangTheoNhomHang(clientStream);
}
break;
case "CongTy":
{
XuLy_CongTy(clientStream);
}
break;
case "DonHangNCC":
{
XuLy_DonHangNCC(clientStream);
}
break;
case "ThueH":
{
XuLy_ThueH(clientStream);
}
break;
case "BCChiTietHangHoa":
{
XuLy_BCChiTietHangHoa(clientStream);
}
break;
#endregion
#region hungvv =====================================================================================================
//=================================================hungvv===========================================================
case "DonDatHang": { XuLy_DonDatHang(clientStream); } break;
case "HoaDonNhap": { XuLy_HoaDonNhap(clientStream); } break;
case "KhachHangTraLai": { XuLy_KhachHangTraLai(clientStream); } break;
case "TraLaiNhaCungCap": { XuLy_TraLaiNhaCungCap(clientStream); } break;
case "ChiTietDonDatHang": { XuLy_ChiTietDonDatHang(clientStream); } break;
case "ChiTietHoaDonNhap": { XuLy_ChiTietHoaDonNhap(clientStream); } break;
case "ChiTietKiemKeKho": { XuLy_ChiTietKiemKeKho(clientStream); } break;
case "ChiTietKhachHangTraLai": { XuLy_ChiTietKhachHangTraLai(clientStream); } break;
case "ChiTietTraLaiNhaCungCap": { XuLy_ChiTietTraLaiNhaCungCap(clientStream); } break;
case "XoaChiTietDonDatHang": { Xoa_ChiTietDonDatHang(clientStream); } break;
case "KiemKeKho": { XuLy_KiemKeKho(clientStream); } break;
case "Lay_ID_Top_1": { Lay_ID_Top_1(clientStream); } break;
case "ThongTinTienTe": { XuLy_ThongTinTienTe(clientStream); } break;
case "ThongTinDatHang": { XuLy_ThongTinDatHang(clientStream); } break;
case "ThongTinNhaCungCap": { XuLy_ThongTinNhaCungCap(clientStream); } break;
case "ThongTinNhanVienHienThi": { XuLy_ThongTinNhanVienHienThi(clientStream); } break;
case "HienThi_ChiTiet_DonDatHang": { XuLy_HienThi_ChiTiet_DonDatHang(clientStream); } break;
case "HienThi_ChiTiet_HoaDonNhap": { XuLy_HienThi_ChiTiet_HoaDonNhap(clientStream); } break;
case "HangTraLai_KhachHangTraLai_KhachHang": { XuLy_HienThi_ChiTiet_KhachHangTraLai(clientStream); } break;
case "ThongTinKhachHang": { XuLy_HienThi_ThongTinKhachHang(clientStream); } break;
case "sp_Tim_ID_HoaDonNhap": { XuLy_sp_Tim_ID_HoaDonNhap(clientStream); } break;
case "ThongTinMaDonDatHang": { XuLy_HienThi_ThongTinMaDonDatHang(clientStream); } break;
case "sp_LayID_KhachHangTraLai": { Top_Mot(clientStream); } break;
case "KiemTraMa": { KiemTraMa(clientStream); } break;
case "LayCombox": { XuLy_LayCombox(clientStream); } break;
case "LayThongTinHoaDonNhap": { XuLy_LayThongTinHoaDonNhap(clientStream); } break;
case "ThemchiTietKiemKeKho": { ThemchiTietKiemKeKho(clientStream); } break;
case "ThongTinHoaDonBanHang": { ThongTinHoaDonBanHang(clientStream); } break;
case "LayDonDatHangNhaCungCap": { LayDonDatHangNhaCungCap(clientStream); } break;
case "LayChiTietTraLaiNhaCungCap": { LayChiTietTraLaiNhaCungCap(clientStream); } break;
case "ThemChiTietKhoHang": { ThemChiTietKhoHang(clientStream); } break;
case "CapNhatTrangThaiDonDatHang": { CapNhatTrangThaiDonDatHang(clientStream); } break;
case "LayHangHoaTheoMaHangHoa": { LayHangHoaTheoMaHangHoa(clientStream); } break;
case "LayThongTinCongty": { LayThongTinCongty(clientStream); } break;
case "BaoCaoXuatHangTheoNhomHang": { BaoCaoXuatHangTheoNhomHang(clientStream); } break;
case "BaoCaoXuatHangTheoKho": { BaoCaoXuatHangTheoKho(clientStream); } break;
case "ChiTietKhoTheoMaKho": { ChiTietKhoTheoMaKho(clientStream); } break;
case "LayThongTinTienTe": { LayThongTinTienTe(clientStream); } break;
case "ThongTinMaVachHangHoa": { ThongTinMaVachHangHoa(clientStream); } break;
case "TimHoaDonBanHangTheoMaKhachHang": { TimHoaDonBanHangTheoMaKhachHang(clientStream); } break;
case "LayHangHoaTheoMaHoaDonBanHang": { LayHangHoaTheoMaHoaDonBanHang(clientStream); } break;
case "TimHoaDonNhapTheoMaNhaCungCap": { TimHoaDonNhapTheoMaNhaCungCap(clientStream); } break;
case "TimHangHoaTheoMaHoaDonNhap": { TimHangHoaTheoMaHoaDonNhap(clientStream); } break;
case "XoaTheoHoaDon": { XoaTheoHoaDon(clientStream); } break;
case "CheckDonDatHang": { CheckDonDatHang(clientStream); } break;
case "KhoHang": { XuLy_KhoHang(clientStream); } break;
case "CheckKhoHang": { CheckKhoHang(clientStream); } break;
case "CheckKiemKeKho": { CheckKiemKeKho(clientStream); } break;
case "LayKiemKeKhoTheoMaKiemKe": { LayKiemKeKhoTheoMaKiemKe(clientStream); } break;
case "CheckHoaDonNhap": { CheckHoaDonNhap(clientStream); } break;
case "KiemTraDonDatHang": { KiemTraDonDatHang(clientStream); } break;
case "CheckKhachHangTraLai": { CheckKhachHangTraLai(clientStream); } break;
case "LayHangHoaTheoMaKhachHangTraLaiHang": { LayHangHoaTheoMaKhachHangTraLaiHang(clientStream); } break;
case "CheckTraLaiNhaCungCap": { CheckTraLaiNhaCungCap(clientStream); } break;
case "LayHangHoaTheoMaTraLaiNhaCungCap": { LayHangHoaTheoMaTraLaiNhaCungCap(clientStream); } break;
case "ChiTietKhachHangTraLaiTheoDonBanHang": { ChiTietKhachHangTraLaiTheoDonBanHang(clientStream); } break;
case "BindingKhachHangTralaiHang": { BindingKhachHangTralaiHang(clientStream); } break;
case "ThongTinTraLaiNhaCungCap": { ThongTinTraLaiNhaCungCap(clientStream); } break;
case "KiemKeHangHoa": { KiemKeHangHoa(clientStream); } break;
case "UpdateDuNo": { UpdateDuNo(clientStream); } break;
case "BaoCaoNhapHangTheoTungKhoTheoThoiGian": { BaoCaoNhapHangTheoTungKhoTheoThoiGian(clientStream); } break;
case "BaoCaoNhapHangTheoTungMatHangTheoThoiGian": { BaoCaoNhapHangTheoTungMatHangTheoThoiGian(clientStream); } break;
case "BaoCaoNhapHangTheoTungNhomHangTheoThoiGian": { BaoCaoNhapHangTheoTungNhomHangTheoThoiGian(clientStream); } break;
case "TimHangHoaTheoMaNhomHang": { TimHangHoaTheoMaNhomHang(clientStream); } break;
case "BaoCaoTraLaiNhaCungcapTheoKy": { BaoCaoTraLaiNhaCungcapTheoKy(clientStream); } break;
case "BaoCaoKhachHangTraLaiTheoKy": { BaoCaoKhachHangTraLaiTheoKy(clientStream); } break;
case "BaoCaoBanBuonBanLeTheoKy": { BaoCaoBanBuonBanLeTheoKy(clientStream); } break;
case "LaySoLuongDaTraLaiTheoHoaDonBanHang": { LaySoLuongDaTraLaiTheoHoaDonBanHang(clientStream); } break;
case "LaySoLuongDaTraLaiTheoHoaDonNhap": { LaySoLuongDaTraLaiTheoHoaDonNhap(clientStream); } break;
case "CapNhatDuNoKhachHang": { CapNhatDuNoKhachHang(clientStream); } break;
case "CapNhatDuNoNhaCungCap": { CapNhatDuNoNhaCungCap(clientStream); } break;
case "BaoCaoSoDuKho": { BaoCaoSoDuKho(clientStream); } break;
case "LaySoLuongKhachHangTraLaiTheoHoaDonBanHang": { LaySoLuongKhachHangTraLaiTheoHoaDonBanHang(clientStream); } break;
case "LaySoLuongDaMuaTheoHoaDonBanHang": { LaySoLuongDaMuaTheoHoaDonBanHang(clientStream); } break;
case "LaySoLuongTraLaiNhaCungCapTheoHoaDonNhapHang": { LaySoLuongTraLaiNhaCungCapTheoHoaDonNhapHang(clientStream); } break;
case "LaySoLuongDaNhapTheoHoaDonNhap": { LaySoLuongDaNhapTheoHoaDonNhap(clientStream); } break;
case "LayBang_HangHoaTheoMaKhoHang": { LayBang_HangHoaTheoMaKhoHang(clientStream); } break;
case "KiemTraNhomHangHoa": { KiemTraNhomHangHoa(clientStream); } break;
case "LayHangHoaGoiHang": { LayHangHoaGoiHang(clientStream); } break;
case "LayDonViTinh": { LayDonViTinh(clientStream); } break;
case "QuyDoi": { LayQuyDoi(clientStream); } break;
case "GetDateTime": { GetDateTime(clientStream); } break;
//=================================================hungvv===========================================================
#endregion
#region Hưởng
case "LogIn": LogIn(clientStream); break;
//case "LogOut": LogOut(clientStream); break;
case "DocFileLog": DocFile(clientStream); break;
case "XoaFileLog": XoaFile(clientStream); break;
case "LayTaiKhoan": selectTaiKhoan(clientStream); break;
case "LayNhomQuyen": selectQuyen(clientStream); break;
case "LayChiTietQuyen": selectChiTietQuyen(clientStream); break;
case "SuaChiTietQuyen": updateChiTietQuyen(clientStream); break;
case "ThemNhomQuyen": insertNhomQuyen(clientStream); break;
case "XoaNhomQuyen": deleteNhomQuyen(clientStream); break;
case "ThemTaiKhoan": insertTaiKhoan(clientStream); break;
case "SuaTaiKhoan": updateTaiKhoan(clientStream); break;
case "XoaTaiKhoan": deleteTaiKhoan(clientStream); break;
case "LayBackUp": LayBackUp(clientStream); break;
case "Restore": { Restore(clientStream); break; }
case "LayTheVip": { LayTheVip(clientStream); break; }
case "LayTheVipTheoMaKhachHang": { LayTheVipTheoMaKhachHang(clientStream); break; }
case "ThemTheVip": { ThemTheVip(clientStream); break; }
case "SuaTheVip": { SuaTheVip(clientStream); break; }
case "XoaTheVip": { XoaTheVip(clientStream); break; }
#endregion
#region Server Luan
case "HangHoa": XuLy_HangHoa(clientStream); break;
case "NhomHang": XuLy_NhomHang(clientStream); break;
case "LoaiHangHoa": XuLy_LoaiHangHoa(clientStream); break;
case "DVT": XuLy_DVT(clientStream); break;
case "LoaiThue": XuLy_LoaiThue(clientStream); break;
#endregion
#region Mrk
case "GiaVon_k": { THAOTAC_GiaVon_k(clientStream); break; }
case "KhachHang_k": { THAOTAC_KhachHang_k(clientStream); break; }
case "THAOTAC_InMaVachTheVip": { THAOTAC_InMaVachTheVip(clientStream); break; }
case "THAOTAC_InMaVachTheGiaTri": { THAOTAC_InMaVachTheGiaTri(clientStream); break; }
case "ThaoTac_UpdateDuNo_k": { ThaoTac_UpdateDuNo_k(clientStream); break; }
case "insertTyLeTinh": { Insert_TyLeTinh(clientStream); break; }
case "selectTyLeTinh": { Select_TyLeTinh(clientStream); break; }
case "DiemThuongKhachHang": { ThemSuaXoaDiemThuongKhachHang(clientStream); break; }
case "SelectDiemThuongKhachHang": { SelectDiemThuongKhachHang(clientStream); break; }
case "ChiTietTheGiamGia": { ThemSuaXoaChiTietTheGiamGia(clientStream); break; }
case "SelectChiTietTheGiamGia": { SelectChiTietTheGiamGia(clientStream); break; }
case "Select_sp_BCNhapHangTheoNhomHangFIX": { Select_sp_BCNhapHangTheoNhomHangFIX(clientStream); break; }
case "RunSql": { RunSql(clientStream); break; }
#endregion
#region Lamtv
case "GiaVonBanHang":
{
Xuly_GiaVonBanHang(clientStream);
}
break;
#endregion
default:
break;
}
isSuccessfuly = true;
}
catch
{
isSuccessfuly = false;
}
return isSuccessfuly;
}
public void Xuly_SoDuKho(NetworkStream clientStream)
{
Entities.SoDuKho nv = (Entities.SoDuKho)formatter.Deserialize(clientStream);
// kiểm tra hành động được gửi đến
switch (nv.HanhDong)
{
case "Insert":
{
bool msg = new BizLogic.SoDuKho().Insert(nv);
formatter.Serialize(clientStream, msg);
break;
}
case "Delete":
{
bool msg = new BizLogic.SoDuKho().Delete(nv);
formatter.Serialize(clientStream, msg);
break;
}
case "Select":
{
Entities.SoDuKho[] nv1 = new BizLogic.SoDuKho().Select();
formatter.Serialize(clientStream, nv1);
break;
}
case "Search":
{
Entities.CapNhatGia[] kh1 = new BizLogic.CapNhatGia().Select();
formatter.Serialize(clientStream, kh1);
break;
}
default:
break;
}
}
