public void HDBanHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hdbanhang = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang);
if (hdbanhang == null)
{
hdbanhang = new Entities.HDBanHang[0];
return;
}
int st = 0;
Entities.HDBanHang[] temp = new Entities.HDBanHang[hdbanhang.Length];
for (int i = 0; i < hdbanhang.Length; i++)
{
temp[st] = hdbanhang[i];
st++;
}
hdbanhang = new Entities.HDBanHang[st];
for (int i = 0; i < st; i++)
{
hdbanhang[i] = temp[i];
}
}
catch
{
}
}
public void PhieuXuatHuy()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("PXH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
phieuxuathuy = (Entities.PhieuXuatHuy[])cl.DeserializeHepper1(clientstrem, phieuxuathuy);
if (phieuxuathuy == null)
{
phieuxuathuy = new Entities.PhieuXuatHuy[0];
return;
}
int soluong = 0;
Entities.PhieuXuatHuy[] temp = new Entities.PhieuXuatHuy[phieuxuathuy.Length];
for (int i = 0; i < phieuxuathuy.Length; i++)
{
if (phieuxuathuy[i].TrangThai == true)
{
temp[soluong] = phieuxuathuy[i];
soluong++;
}
}
phieuxuathuy = new Entities.PhieuXuatHuy[soluong];
for (int i = 0; i < soluong; i++)
{
phieuxuathuy[i] = temp[i];
}
}
catch
{
}
}
public void LayHDNhap()
{
try
{
List <Entities.HoaDonNhap> listTemp = new List <Entities.HoaDonNhap>();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
//
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
listTemp.Add(HDN[i]);
}
}
//
HoaDonNhap = listTemp.ToArray();
}
catch
{
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCXuatNhapTonNhomHang", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
phieuxuathuy = selectall.PhieuXuatHuy;
chitietxuathuy = selectall.ChiTietXuatHuy;
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hoadonnhap = selectall.HoaDonNhap;
chitiethoadonnhap = selectall.ChiTietHoaDonNhap;
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hanghoa = selectall.HangHoa;
nhomhang = selectall.NhomHang;
khohang = selectall.KhoHang;
sodukho = selectall.SoDuKho;
goihang = selectall.GoiHang;
chitietgoihang = selectall.ChiTietGoiHang;
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("TimKiemChungTu");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
phieuxuathuy = selectall.PhieuXuatHuy;
chitietxuathuy = selectall.ChiTietXuatHuy;
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hoadonnhap = selectall.HoaDonNhap;
chitiethoadonnhap = selectall.ChiTietHoaDonNhap;
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
phieudieuchuyenkhonoibo = selectall.PhieuDieuChuyenKhoNoiBo;
chitietphieudieuchuyenkho = selectall.ChiTietPhieuDieuChuyenKho;
phieuthu = selectall.PhieuThu;
phieuttcuakh = selectall.PhieuTTCuaKH;
chitietphieuttcuakh = selectall.ChiTietPhieuTTCuaKH;
phieuttncc = selectall.PhieuTTNCC;
chitietphieuttncc = selectall.ChiTietPhieuTTNCC;
hanghoa = selectall.HangHoa;
nhomhang = selectall.NhomHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
}
public void Select()
{
try
{
dtgvHienThi.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("NH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.NhomHang[] kh1 = new Entities.NhomHang[0];
kh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] ncc2 = new Entities.NhomHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
ncc2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
dtgvHienThi.DataSource = hienthi;
dtgvHienThi.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
public static DateTime Date()
{
Server_Client.Client cl = new Server_Client.Client();
client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer pt = new Entities.CheckRefer();
clientstrem = cl.SerializeObj(client1, "Datetime", pt);
DateTime dt = new DateTime();
dt = (DateTime)cl.DeserializeHepper(clientstrem, dt);
return dt;
}
public void Select()
{
try
{
dtgvHienThi.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("NH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.NhomHang[] kh1 = new Entities.NhomHang[0];
kh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] ncc2 = new Entities.NhomHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
ncc2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
dtgvHienThi.DataSource = hienthi;
dtgvHienThi.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCXuatHuyHangHoa", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
hanghoa = selectall.HangHoaTheoKho;
phieuxuathuy = selectall.PhieuXuatHuy;
chitietphieuxuathuy = selectall.ChiTietXuatHuy;
}
List <Entities.QuyDoiDonViTinh> bangquydoidonvitinh()
{
// quy đổi đơn vị tính
Server_Client.Client cl = new Server_Client.Client();
TcpClient client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("QD");
clientstrem = cl.SerializeObj(client1, "Select", ctxh);
Entities.QuyDoiDonViTinh[] quidoidvt = new Entities.QuyDoiDonViTinh[0];
return(((Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, quidoidvt)).ToList());
}
public static DateTime Date()
{
Server_Client.Client cl = new Server_Client.Client();
client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer pt = new Entities.CheckRefer();
clientstrem = cl.SerializeObj(client1, "Datetime", pt);
DateTime dt = new DateTime();
dt = (DateTime)cl.DeserializeHepper(clientstrem, dt);
return(dt);
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCTraLaiNCC", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
thue = selectall.Thue;
hanghoa = selectall.HangHoaTheoKho;
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCKhachHangTraHang", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
thue = selectall.Thue;
hanghoa = selectall.HangHoaTheoKho;
hdbanhang = selectall.HDBanHang;
}
void SelectAll()
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCDoanhThuMatHang", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
goihang = selectall.GoiHang;
chitietgoihang = selectall.ChiTietGoiHang;
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
nv = selectall.HangHoaTheoKho;
thue = selectall.Thue;
}
public void ChiTietHoaDonNhap()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDN");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitiethoadonnhap = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, chitiethoadonnhap);
if (chitiethoadonnhap == null)
{
chitiethoadonnhap = new Entities.ChiTietHoaDonNhap[0];
return;
}
}
catch { }
}
public bool CheckReference(string tenTruong, string maTruong)
{
try
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer pt = new Entities.CheckRefer(tenTruong, maTruong);
bool kt = false;
clientstrem = cl.SerializeObj(this.client1, "CheckRefer", pt);
kt = (bool)cl.DeserializeHepper(clientstrem, kt);
return(kt);
}
catch
{
return(false);
}
}
public void ChiTietKhachHangTraLai()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTKHTL");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietkhachhangtralai = (Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper1(clientstrem, chitietkhachhangtralai);
if (chitietkhachhangtralai == null)
{
chitietkhachhangtralai = new Entities.ChiTietKhachHangTraLai[0];
return;
}
}
catch { }
}
public void ChiTietPhieuDieuChuyenKho()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTPDCKNB");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietphieudieuchuyenkho = (Entities.ChiTietPhieuDieuChuyenKho[])cl.DeserializeHepper1(clientstrem, chitietphieudieuchuyenkho);
if (chitietphieudieuchuyenkho == null)
{
chitietphieudieuchuyenkho = new Entities.ChiTietPhieuDieuChuyenKho[0];
return;
}
}
catch { }
}
public void NhomHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("NH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
nhomhang = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nhomhang);
if (nhomhang == null)
{
nhomhang = new Entities.NhomHang[0];
return;
}
}
catch { }
}
public void ChiTietGoiHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTGH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietgoihang = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, chitietgoihang);
if (chitietgoihang == null)
{
chitietgoihang = new Entities.ChiTietGoiHang[0];
return;
}
}
catch { }
}
public void HangHoa()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hanghoa = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, hanghoa);
if (hanghoa == null)
{
hanghoa = new Entities.HangHoa[0];
return;
}
}
catch { }
}
public bool CheckReference(string tenTruong, string maTruong)
{
try
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer pt = new Entities.CheckRefer(tenTruong, maTruong);
bool kt = false;
clientstrem = cl.SerializeObj(this.client1, "CheckRefer", pt);
kt = (bool)cl.DeserializeHepper(clientstrem, kt);
return kt;
}
catch
{
return false;
}
}
public void LayBangHangHoa()
{
Entities.CheckRefer Checkrefer;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Checkrefer = new Entities.CheckRefer("HH", "");
clientstrem = cl.SerializeObj(this.client, "Select", Checkrefer);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper(clientstrem, hh1);
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
public void LayChiTietHoaDonNhap()
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
ctHDN1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, ctHDN1);
if (ctHDN1 == null)
{
ctHDN = new Entities.ChiTietHoaDonNhap[0];
return;
}
else
{
ctHDN = ctHDN1;
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCThue", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
thue = selectall.Thue;
hanghoa = selectall.HangHoaTheoKho;
if (thue.Length != 0)
{
cbbThue.DataSource = thue;
cbbThue.DisplayMember = "GiaTriThue";
cbbThue.ValueMember = "MaThue";
cbbThue.SelectedIndex = -1;
}
}
public void ChiTietTraLaiNCC()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTTLNCC");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitiettralaincc = (Entities.ChiTietTraLaiNhaCungCap[])cl.DeserializeHepper1(clientstrem, chitiettralaincc);
if (chitiettralaincc == null)
{
chitiettralaincc = new Entities.ChiTietTraLaiNhaCungCap[0];
return;
}
}
catch
{
}
}
public void ChiTietXuatHuy()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTPXH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietxuathuy = (Entities.ChiTietXuatHuy[])cl.DeserializeHepper1(clientstrem, chitietxuathuy);
if (chitietxuathuy == null)
{
chitietxuathuy = new Entities.ChiTietXuatHuy[0];
return;
}
}
catch
{
}
}
public void ChiTietHDBanHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDBH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitiethdbanhang = (Entities.ChiTietHDBanHang[])cl.DeserializeHepper1(clientstrem, chitiethdbanhang);
if (chitiethdbanhang == null)
{
chitiethdbanhang = new Entities.ChiTietHDBanHang[0];
return;
}
}
catch
{
}
}
public void HDBanHang1()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hdbanhang = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang);
if (hdbanhang == null)
{
hdbanhang = new Entities.HDBanHang[0];
return;
}
}
catch
{
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCCongNoKhachHang");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
kh = selectall.KhachHang;
bb = selectall.HDBanHang;
soducongno = selectall.SoDuCongNo;
khtl = selectall.KhachHangTraLai;
phieuttcuakh = selectall.PhieuTTCuaKH;
chitietphieuttcuakh = selectall.ChiTietPhieuTTCuaKH;
phieuThuChi = selectall.PhieuThu;
SelectKhachHang();
SelectKHTL();
SelectBanBuonLe();
SelectPhieuTTCuaKH();
SelectChiTietPhieuTTCuaKH();
SelectSoDuCongNo();
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCCongNoNhaCungCap");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
hienthi1 = selectall.SoDuCongNo;
ncc = selectall.NhaCungCap;
hdn = selectall.HoaDonNhap;
tl = selectall.TraLaiNCC;
phieuttncc = selectall.PhieuTTNCC;
chitietphieuttncc = selectall.ChiTietPhieuTTNCC;
phieuThuChi = selectall.PhieuThu;
SelectNhaCungCap();
SelectNhapKho();
SelectTLNCC();
SelectPhieuTTNCC();
SelectChiTietPhieuTTNCC();
SelectSoDuCongNo();
}
public void LayCTKHTL()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTKHTL");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.ChiTietKhachHangTraLai[] HDN = new Entities.ChiTietKhachHangTraLai[0];
HDN = (Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
CTKHTL = new Entities.ChiTietKhachHangTraLai[0];
return;
}
CTKHTL = HDN;
}
catch
{
}
}
void SelectSoQuy()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("SoQuy");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
// gói hàng
sodu = selectall.SoDuSoQuy;
// chi tiết gói hàng
thuchi = selectall.PhieuThu;
if (thuchi == null)
{
thuchi = pt = pc = new Entities.PhieuThu[0];
}
SelectPhieuThuChi(); //Chọn phiếu thu chi
SelectPhieuThanhToan(); //Chọn phiếu thanh toán
buonle = selectall.HDBanHang;
if (buonle == null)
{
buonle = bb = bl = new Entities.HDBanHang[0];
return;
}
SelectBanBuonLe(); //Hóa đơn bán buôn bán lẻ
hdn = selectall.HoaDonNhap; //Hóa đơn nhập
kh = selectall.KhachHangTraLai; //Khách hàng trả lại
tl = selectall.TraLaiNCC; //Trả lại NCC
SelectNhapKho();
SelectKHTL();
SelectTLNCC();
}
catch { MessageBox.Show("Có lỗi xảy ra, có thể do đường truyền mạng, xin vui lòng thử lại!"); }
}
////////////////////////////////////////MRK FIX
List<Entities.QuyDoiDonViTinh> bangquydoidonvitinh()
{
// quy đổi đơn vị tính
Server_Client.Client cl = new Server_Client.Client();
TcpClient client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("QD");
clientstrem = cl.SerializeObj(client1, "Select", ctxh);
Entities.QuyDoiDonViTinh[] quidoidvt = new Entities.QuyDoiDonViTinh[0];
return ((Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, quidoidvt)).ToList();
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCTraLaiNCC", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
thue = selectall.Thue;
hanghoa = selectall.HangHoaTheoKho;
}
/// <summary>
///
/// </summary>
/// <param name="isBanLe"></param>
public void SelectData(bool isBanLe)
{
try
{
ArrayList array = new ArrayList();
dtgvKH.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa("SelectTheoKho", maKho);
Entities.HangHoa[] kh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
// gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, goihang);
if (goihang == null)
{
goihang = new Entities.GoiHang[0];
return;
}
// chi tiết gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("CTGH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietgoihang = new Entities.ChiTietGoiHang[0];
chitietgoihang = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, chitietgoihang);
if (chitietgoihang == null)
{
chitietgoihang = new Entities.ChiTietGoiHang[0];
return;
}
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
foreach (Entities.HangHoa item in kh1)
{
if (item.Deleted == false)
array.Add(item);
}
if (array.Count != 0)
{
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang((Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa)), goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
hienthi = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch
{
}
finally
{
if (isBanLe)
fixBL();
else
fixBB();
}
}
/// <summary>
/// select dữ liệu từ server
/// </summary>
public void SelectData()
{
try
{
ArrayList array = new ArrayList();
dtgvKH.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa("SelectTheoKho", maKho);
Entities.HangHoa[] kh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
// gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, goihang);
if (goihang == null)
{
goihang = new Entities.GoiHang[0];
return;
}
// chi tiết gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("CTGH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietgoihang = new Entities.ChiTietGoiHang[0];
chitietgoihang = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, chitietgoihang);
if (chitietgoihang == null)
{
chitietgoihang = new Entities.ChiTietGoiHang[0];
return;
}
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
foreach (Entities.HangHoa item in kh1)
{
if (item.Deleted == false)
{
array.Add(item);
}
}
if (array.Count != 0)
{
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang((Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa)), goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
hienthi = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
void SelectDataKH()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCCongNoKhachHang");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
kh = selectall.KhachHang;
bb = selectall.HDBanHang;
hienthi1 = selectall.SoDuCongNo;
khtl = selectall.KhachHangTraLai;
phieuttcuakh = selectall.PhieuTTCuaKH;
chitietphieuttcuakh = selectall.ChiTietPhieuTTCuaKH;
phieuThuChi = selectall.PhieuThu;
SelectKhachHang();
SelectKHTL();
SelectPhieuTTCuaKH();
SelectChiTietPhieuTTCuaKH();
phieuttncc = new Entities.PhieuTTNCC[0];
chitietphieuttncc = new Entities.ChiTietPhieuTTNCC[0];
ncc = new Entities.NhaCungCap[0];
hdn = new Entities.HoaDonNhap[0];
tl = new Entities.TraLaiNCC[0];
mangchitiet = new List<Entities.SoDuCongNo>();
}
public void LayBangHangHoa()
{
try
{
Entities.CheckRefer Checkrefer;
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Checkrefer = new Entities.CheckRefer("HH", "");
clientstrem = cl.SerializeObj(this.client1, "Select", Checkrefer);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper(clientstrem, hh1);
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
catch
{
}
}
public void PhieuXuatHuy()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("PXH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
phieuxuathuy = (Entities.PhieuXuatHuy[])cl.DeserializeHepper1(clientstrem, phieuxuathuy);
if (phieuxuathuy == null)
{
phieuxuathuy = new Entities.PhieuXuatHuy[0];
return;
}
}
catch
{
}
}
public void PhieuXuatHuy()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("PXH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
phieuxuathuy = (Entities.PhieuXuatHuy[])cl.DeserializeHepper1(clientstrem, phieuxuathuy);
if (phieuxuathuy == null)
{
phieuxuathuy = new Entities.PhieuXuatHuy[0];
return;
}
int soluong = 0;
Entities.PhieuXuatHuy[] temp = new Entities.PhieuXuatHuy[phieuxuathuy.Length];
for (int i = 0; i < phieuxuathuy.Length; i++)
{
if (phieuxuathuy[i].TrangThai == true)
{
temp[soluong] = phieuxuathuy[i];
soluong++;
}
}
phieuxuathuy = new Entities.PhieuXuatHuy[soluong];
for (int i = 0; i < soluong; i++)
{
phieuxuathuy[i] = temp[i];
}
}
catch
{
}
}
public void KhoHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("KH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
khohang = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, khohang);
if (khohang == null)
{
khohang = new Entities.KhoHang[0];
return;
}
}
catch
{
}
}
public void PhieuDieuChuyenKhoNoiBo()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("PDCKNB");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
phieudieuchuyenkhonoibo = (Entities.PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, phieudieuchuyenkhonoibo);
if (phieudieuchuyenkhonoibo == null)
{
phieudieuchuyenkhonoibo = new Entities.PhieuDieuChuyenKhoNoiBo[0];
return;
}
}
catch
{
}
}
public void KhachHangTraLai()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("KHTL");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
khachhangtralai = (Entities.KhachHangTraLai[])cl.DeserializeHepper1(clientstrem, khachhangtralai);
if (khachhangtralai == null)
{
khachhangtralai = new Entities.KhachHangTraLai[0];
return;
}
}
catch
{
}
}
public void HoaDonNhap()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hoadonnhap = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, hoadonnhap);
if (hoadonnhap == null)
{
hoadonnhap = new Entities.HoaDonNhap[0];
return;
}
}
catch
{
}
}
public void HangHoa()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hanghoa = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, hanghoa);
if (hanghoa == null)
{
hanghoa = new Entities.HangHoa[0];
return;
}
}
catch
{
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCXuatHuyHangHoa", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
hanghoa = selectall.HangHoaTheoKho;
phieuxuathuy = selectall.PhieuXuatHuy;
chitietphieuxuathuy = selectall.ChiTietXuatHuy;
}
public void TraLaiNCC()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("TLNCC");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
tralaincc = (Entities.TraLaiNCC[])cl.DeserializeHepper1(clientstrem, tralaincc);
if (tralaincc == null)
{
tralaincc = new Entities.TraLaiNCC[0];
return;
}
}
catch
{
}
}
public void HDBanHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
hdbanhang = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang);
if (hdbanhang == null)
{
hdbanhang = new Entities.HDBanHang[0];
return;
}
int st = 0;
Entities.HDBanHang[] temp = new Entities.HDBanHang[hdbanhang.Length];
for (int i = 0; i < hdbanhang.Length; i++)
{
temp[st] = hdbanhang[i];
st++;
}
hdbanhang = new Entities.HDBanHang[st];
for (int i = 0; i < st; i++)
{
hdbanhang[i] = temp[i];
}
}
catch
{
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCXuatNhapTonNhomHang", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
phieuxuathuy = selectall.PhieuXuatHuy;
chitietxuathuy = selectall.ChiTietXuatHuy;
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hoadonnhap = selectall.HoaDonNhap;
chitiethoadonnhap = selectall.ChiTietHoaDonNhap;
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hanghoa = selectall.HangHoa;
nhomhang = selectall.NhomHang;
khohang = selectall.KhoHang;
sodukho = selectall.SoDuKho;
goihang = selectall.GoiHang;
chitietgoihang = selectall.ChiTietGoiHang;
}
private void frmXuLy_KiemKeKho_Load(object sender, EventArgs e)
{
try
{
//
Entities.CheckRefer ctxh;
Entities.ThongTinKiemKeKho[] lay = new Entities.ThongTinKiemKeKho[0];
dgvInsertOrder.DataSource = lay;
fixDatagridview();
string ngay = DateServer.Date().ToString("dd/MM/yyyy");
makNgaychungtu.Text = ngay;
LayKhoHang();
if (hanhdong == "Insert")
{
toolStripStatus_Ghilai.Enabled = false;
getID("KiemKeKho");
txtSochungtu.Text = makiemke;
btnPDF.Enabled = false;
// quy đổi đơn vị tính
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("QD");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
quidoidvt = new Entities.QuyDoiDonViTinh[0];
quidoidvt = (Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, quidoidvt);
if (quidoidvt == null)
{
quidoidvt = new Entities.QuyDoiDonViTinh[0];
return;
}
}
if (hanhdong == "Update")
{
toolStripStatus_Themmoi.Enabled = false;
DoDuLieu(this.kk);
if (txtSochungtu.Text.Length <= 0)
{ MessageBox.Show("Không tìm thấy mã kiểm kê cần sửa"); this.Close(); }
btnPDF.Enabled = true;
// quy đổi đơn vị tính
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("QD");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
quidoidvt = new Entities.QuyDoiDonViTinh[0];
quidoidvt = (Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, quidoidvt);
if (quidoidvt == null)
{
quidoidvt = new Entities.QuyDoiDonViTinh[0];
return;
}
}
// Lay Hang hoa hoa trong kho
string maKho = cbxKhoban.SelectedValue.ToString().ToUpper();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.TruyenGiaTri dh = new Entities.TruyenGiaTri("Select", maKho);
clientstrem = cl.SerializeObj(this.client, "LayBang_HangHoaTheoMaKhoHang", dh);
hangHoaTrongKho = new Entities.ThongTinDatHang[1];
hangHoaTrongKho = (Entities.ThongTinDatHang[])cl.DeserializeHepper(clientstrem, hangHoaTrongKho);
}
catch (Exception ex)
{
string s = ex.Message; if (txtSochungtu.Text == "")
{ txtSochungtu.Text = "KK_0001"; }
}
}
public void LayHDNhap()
{
try
{
List<Entities.HoaDonNhap> listTemp = new List<Entities.HoaDonNhap>();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
//
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
listTemp.Add(HDN[i]);
}
}
//
HoaDonNhap = listTemp.ToArray();
}
catch
{
}
}
public void SelectData()
{
try
{
dgvHangHoa.RowHeadersVisible = false;
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa("Select");
networkStream = cl.SerializeObj(this.tcpClient, "HangHoa", hh);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper1(networkStream, hh1);
// goi hang
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
networkStream = cl.SerializeObj(this.tcpClient, "Select", ctxh);
Entities.GoiHang[] goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(networkStream, goihang);
if (hh1 == null && goihang == null)
{
dgvHangHoa.DataSource = new Entities.HangHoa[0];
return;
}
List<Entities.HangHoa> listHangHoa = new List<Entities.HangHoa>();
// for hang hoa
foreach (Entities.HangHoa hanghoa in hh1)
{
if (hanghoa != null && hanghoa.Deleted == false && hanghoa.MaNhomHangHoa.Equals(manhomhang))
{
listHangHoa.Add(hanghoa);
}
}
// for goi hang
foreach (Entities.GoiHang gh in goihang)
{
if (gh != null && gh.Deleted == false && gh.MaNhomHang.Equals(manhomhang))
{
Entities.HangHoa hanghoa = new Entities.HangHoa();
hanghoa.MaHangHoa = gh.MaGoiHang;
hanghoa.TenHangHoa = gh.TenGoiHang;
hanghoa.MaNhomHangHoa = gh.MaNhomHang;
hanghoa.GiaNhap = gh.GiaNhap;
hanghoa.GiaBanBuon = gh.GiaBanBuon;
hanghoa.GiaBanLe = gh.GiaBanLe;
listHangHoa.Add(hanghoa);
}
}
dgvHangHoa.DataSource = (Entities.HangHoa[])listHangHoa.ToArray();
dgvHangHoa.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix1();
}
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("TimKiemChungTu");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
phieuxuathuy = selectall.PhieuXuatHuy;
chitietxuathuy = selectall.ChiTietXuatHuy;
hdbanhang = selectall.HDBanHang;
chitiethdbanhang = selectall.ChiTietHDBanHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
hoadonnhap = selectall.HoaDonNhap;
chitiethoadonnhap = selectall.ChiTietHoaDonNhap;
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
phieudieuchuyenkhonoibo = selectall.PhieuDieuChuyenKhoNoiBo;
chitietphieudieuchuyenkho = selectall.ChiTietPhieuDieuChuyenKho;
phieuthu = selectall.PhieuThu;
phieuttcuakh = selectall.PhieuTTCuaKH;
chitietphieuttcuakh = selectall.ChiTietPhieuTTCuaKH;
phieuttncc = selectall.PhieuTTNCC;
chitietphieuttncc = selectall.ChiTietPhieuTTNCC;
hanghoa = selectall.HangHoa;
nhomhang = selectall.NhomHang;
tralaincc = selectall.TraLaiNCC;
chitiettralaincc = selectall.ChiTietTraLaiNhaCungCap;
}
private void NapQuyDoiVaGoiHang()
{
// gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, goihang);
if (goihang == null)
{
goihang = new Entities.GoiHang[0];
return;
}
// chi tiết gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("CTGH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietgoihang = new Entities.ChiTietGoiHang[0];
chitietgoihang = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, chitietgoihang);
if (chitietgoihang == null)
{
chitietgoihang = new Entities.ChiTietGoiHang[0];
return;
}
// quy đổi đơn vị tính
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("QD");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
this.quidoidvt = new Entities.QuyDoiDonViTinh[0];
this.quidoidvt = (Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, this.quidoidvt);
if (quidoidvt == null)
{
quidoidvt = new Entities.QuyDoiDonViTinh[0];
return;
}
}
public void LayCTKHTL()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTKHTL");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.ChiTietKhachHangTraLai[] HDN = new Entities.ChiTietKhachHangTraLai[0];
HDN = (Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
CTKHTL = new Entities.ChiTietKhachHangTraLai[0];
return;
}
CTKHTL = HDN;
}
catch
{
}
}
public void LayChiTietHoaDonNhap()
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTHDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.ChiTietHoaDonNhap[] ctHDN1 = new Entities.ChiTietHoaDonNhap[0];
ctHDN1 = (Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper1(clientstrem, ctHDN1);
if (ctHDN1 == null)
{
ctHDN = new Entities.ChiTietHoaDonNhap[0];
return;
}
else
ctHDN = ctHDN1;
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCCongNoNhaCungCap");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
hienthi1 = selectall.SoDuCongNo;
ncc = selectall.NhaCungCap;
hdn = selectall.HoaDonNhap;
tl = selectall.TraLaiNCC;
phieuttncc = selectall.PhieuTTNCC;
chitietphieuttncc = selectall.ChiTietPhieuTTNCC;
phieuThuChi = selectall.PhieuThu;
SelectNhaCungCap();
SelectNhapKho();
SelectTLNCC();
SelectPhieuTTNCC();
SelectChiTietPhieuTTNCC();
SelectSoDuCongNo();
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCKhachHangTraHang", new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen);
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
khachhangtralai = selectall.KhachHangTraLai;
chitietkhachhangtralai = selectall.ChiTietKhachHangTraLai;
thue = selectall.Thue;
hanghoa = selectall.HangHoaTheoKho;
hdbanhang = selectall.HDBanHang;
}
void SelectData()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("BCCongNoKhachHang");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
selectall = (Entities.SelectAll)cl.DeserializeHepper(clientstrem, selectall);
kh = selectall.KhachHang;
bb = selectall.HDBanHang;
soducongno = selectall.SoDuCongNo;
khtl = selectall.KhachHangTraLai;
phieuttcuakh = selectall.PhieuTTCuaKH;
chitietphieuttcuakh = selectall.ChiTietPhieuTTCuaKH;
phieuThuChi = selectall.PhieuThu;
SelectKhachHang();
SelectKHTL();
SelectBanBuonLe();
SelectPhieuTTCuaKH();
SelectChiTietPhieuTTCuaKH();
SelectSoDuCongNo();
}
