/// <summary>
/// Lấy nhân viên
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayNhanVien()
{
try
{
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "NhanVien", "MaNhanVien", "TenNhanVien");
networkStream = cl.SerializeObj(this.tcpClient, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(networkStream, tt);
tcpClient.Close();
networkStream.Close();
if (tt.Length > 0)
{
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxMaNhanVien, "giatri", "khoachinh");
}
else
{
frmXuly_NhanVien frm = new frmXuly_NhanVien();
frm.ShowDialog();
}
}
catch (Exception ex)
{
cbxMaNhanVien.Items.Clear();
string s = ex.Message.ToString();
}
}
private void LayKhoHang()
{
try
{
cbxMaKho.Items.Clear();
Entities.KiemTraChung kh = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
kh = new Entities.KiemTraChung("Select", "KhoHang", "MaKho", "TenKho");
clientstrem = cl.SerializeObj(this.client, "LayCombox", kh);
Entities.KiemTraChung[] ddh = new Entities.KiemTraChung[1];
ddh = (Entities.KiemTraChung[])cl.DeserializeHepper(clientstrem, ddh);
client.Close();
clientstrem.Close();
if (ddh.Length > 0)
{
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(ddh, cbxMaKho, "giatri", "khoachinh");
}
else
{
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
}
/// <summary>
/// hungvv --------------------kiem tra ma hang khi them chi tiet hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(string ID)
{
string kt = null;
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", ID);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
kt = tra.Hanhdong;
return(kt);
}
/// <summary>
/// add giatri vao combox
/// </summary>
/// <param name="hanhdong"></param>
#endregion
#region Binding combox======================================================================================================================
/// <summary>
/// Lấy Kho Hàng
/// </summary>
private void LayKhoHang()
{
try
{
cbxKhoHang.Items.Clear();
Entities.KiemTraChung kh = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
kh = new Entities.KiemTraChung("Select", "KhoHang", "MaKho", "TenKho");
clientstrem = cl.SerializeObj(this.client, "LayCombox", kh);
Entities.KiemTraChung[] ddh = new Entities.KiemTraChung[1];
ddh = (Entities.KiemTraChung[])cl.DeserializeHepper(clientstrem, ddh);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(ddh, cbxKhoHang, "giatri", "khoachinh");
this.cbxKhoHang.Text = "Chọn kho hàng";
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// Lấy nhân viên
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayNhanVien()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "NhanVien", "MaNhanVien", "TenNhanVien");
clientstrem = cl.SerializeObj(this.client, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxNhanvien, "giatri", "khoachinh");
cbxNhanvien.Text = "Chọn nhân viên";
}
catch (Exception)
{
cbxNhanvien.Items.Clear();
}
client.Close();
clientstrem.Close();
}
/// <summary>
/// Lấy tên tiền tệ
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayTenTT()
{
try
{
cbxTiente_Tygia.Items.Clear();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "TienTe", "MaTienTe", "TenTienTe");
clientstrem = cl.SerializeObj(this.client, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxTiente_Tygia, "giatri", "khoachinh");
cbxTiente_Tygia.Text = "Chọn tiền tệ";
}
catch
{
cbxTiente_Tygia.Items.Clear();
cbxTiente_Tygia.Text = "";
}
client.Close();
clientstrem.Close();
}
/// <summary>
/// Lấy Kho Hàng
/// </summary>
private void LayKhoHang()
{
try
{
cbxMaKho.Items.Clear();
Entities.KiemTraChung kh = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
kh = new Entities.KiemTraChung("Select", "KhoHang", "MaKho", "TenKho");
clientstrem = cl.SerializeObj(this.client, "LayCombox", kh);
Entities.KiemTraChung[] ddh = new Entities.KiemTraChung[1];
ddh = (Entities.KiemTraChung[])cl.DeserializeHepper(clientstrem, ddh);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(ddh, cbxMaKho, "giatri", "khoachinh");
this.cbxMaKho.Text = "Chọn kho hàng";
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// hungvv --------------------kiem tra ma hang khi them chi tiet hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(string ID)
{
string kt = null;
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", ID);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
kt = tra.Hanhdong;
return kt;
}
/// hungvv --------------------kiem tra ma hang khi them chi tiet hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(Entities.ThongTinKiemKeKho lay)
{
string kt = null;
try
{
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", lay.Mahang, lay.Tenhang);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
if (tra.Hanhdong.Length > 0)
{
kt = tra.Hanhdong;
}
else
{ kt = null; }
}
catch (Exception ex)
{ string s = ex.Message; }
return kt;
}
private void LayTenTT()
{
try
{
cbxTiente_Tygia.Items.Clear();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select");
clientstrem = cl.SerializeObj(this.client, "LayThongTinTienTe", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
tigia = tt;
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxTiente_Tygia, "giatri", "khoachinh");
client.Close();
clientstrem.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
}
private string KiemTraMa(Entities.LayHangHoaTheoMaKhachHangTraLai lay)
{
string kt = null;
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", lay.Mahanghoa);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
kt = tra.Hanhdong;
return kt;
}
/// <summary>
/// hungvv --------------------kiem tra ma hang khi them chi tiet hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(Entities.HienThi_ChiTiet_DonDatHang lay)
{
string kt = null;
try
{
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", lay.MaHangHoa, lay.TenHangHoa);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
if (tra.Hanhdong != null)
{
kt = tra.Hanhdong;
}
else
{ kt = null; }
}
catch (Exception ex)
{ string s = ex.Message; kt = null; }
return kt;
}
/// <summary>
/// Lấy nhân viên
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayNhanVien()
{
try
{
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "NhanVien", "MaNhanVien", "TenNhanVien");
networkStream = cl.SerializeObj(this.tcpClient, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(networkStream, tt);
tcpClient.Close();
networkStream.Close();
if (tt.Length > 0)
{
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxMaNhanVien, "giatri", "khoachinh");
}
else
{
frmXuly_NhanVien frm = new frmXuly_NhanVien();
frm.ShowDialog();
}
}
catch (Exception ex)
{
cbxMaNhanVien.Items.Clear();
string s = ex.Message.ToString();
}
}
/// <summary>
///
/// </summary>
private void LayNhomHang(string tenbang, string cotID, string cotTen)
{
try
{
Entities.KiemTraChung kh = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
kh = new Entities.KiemTraChung("Select", tenbang, cotID, cotTen);
clientstrem = cl.SerializeObj(this.client, "LayCombox", kh);
nhom = new Entities.KiemTraChung[1];
nhom = (Entities.KiemTraChung[])cl.DeserializeHepper(clientstrem, kt);
client.Close();
clientstrem.Close();
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
}
/// <summary>
/// Lấy nhân viên
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayNhanVien()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "NhanVien", "MaNhanVien", "TenNhanVien");
clientstrem = cl.SerializeObj(this.client, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxNhanvien, "giatri", "khoachinh");
cbxNhanvien.Text = "Chọn nhân viên";
}
catch (Exception)
{
cbxNhanvien.Items.Clear();
}
client.Close();
clientstrem.Close();
}
/// <summary>
/// Lấy tên tiền tệ
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LayTenTT()
{
try
{
cbxTiente_Tygia.Items.Clear();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select", "TienTe", "MaTienTe", "TenTienTe");
clientstrem = cl.SerializeObj(this.client, "LayCombox", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxTiente_Tygia, "giatri", "khoachinh");
cbxTiente_Tygia.Text = "Chọn tiền tệ";
}
catch
{
cbxTiente_Tygia.Items.Clear();
cbxTiente_Tygia.Text = "";
}
client.Close();
clientstrem.Close();
}
/// <summary>
/// ham main
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmXuLy_DonDatHang_Load(object sender, EventArgs e)
{
try
{
datesv = DateServer.Date();
Entities.HienThi_ChiTiet_DonDatHang[] row = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = row;
DoiTen(dgvInsertOrder);
//doc du lieu dong
makNgaydonhang.Text = DateServer.Date().ToString("dd/MM/yyyy"); ;
makNgaynhapdukien.Text = DateServer.Date().ToString("dd/MM/yyyy");
this.cbxHinhthucthanhtoan.Items.AddRange(new object[] { "Tiền mặt", "ATM" });
cbxHinhthucthanhtoan.SelectedIndex = 0;
this.txtTrangthaidonhang.Text = "Đang mở";
txtPhuongthucvanchuyen.Text = "Tự vận chuyển";
//fig cung combox
frmXuLyDonDatHang fr = new frmXuLyDonDatHang();
if (this.HanhDong == "Insert")
{
btnTimnhacungcap.Enabled = true;
toolStripStatus_Them.Enabled = true;
toolStripStatus_Ghilai.Enabled = false;
Application.OpenForms[fr.Name].Text = "Thêm Mới - F4 Thêm Hàng Hóa F5 Nhập Phí Vận Chuyển F6 Sửa Hàng Hóa F7 Nhập Phí Khác";
txtTrangthaidonhang.ReadOnly = true;
getID("DonDatHang");
txtSodonhang.Text = makiemtra;
checkData();
toolStripStatusLabel3.Enabled = false;
}
//LayKhoHang();
///lay kho hang trong xml
new Common.Utilities().ComboxKhoHang(cbxMaKho);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
Entities.KiemTraChung g = new Entities.KiemTraChung();
Common.Utilities com = new Common.Utilities();
g.Khoachinh = Common.Utilities.User.NhanVienID;
g.Giatri = Common.Utilities.User.TenNhanVien;
tt[0] = g;
com.BindingCombobox(tt, cbxNhanvien, "giatri", "khoachinh");
//LayNhanVien();
LayTenTT();
txtGiatien.Text = tigia[0].Giatri2.ToString();
cbxTiente_Tygia.SelectedIndex = 0;
cbxTiente_Tygia.Enabled = false;
//danh cho update
if (this.HanhDong == "Update")
{
if (this.dathang.DonDatHangID > 0)
{
btnTimnhacungcap.Enabled = false;
toolStripStatus_Them.Enabled = false;
toolStripStatus_Ghilai.Enabled = true;
Application.OpenForms[fr.Name].Text = "Quản lý đơn đặt hàng - Xem Chi Tiết Đơn";
DoDuLieu(this.dathang);
if (txtTrangthaidonhang.Text == "Đã thành công")
{
toolStripStatus_Ghilai.Enabled = false;
toolStripStatusLabel3.Enabled = false;
toolStripStatusLabel4.Enabled = true;
btnTimnhacungcap.Enabled = false;
}
if (dgvInsertOrder.RowCount <= 0)
{
txtChietkhau.Text = "0";
txtTienhang.Text = "0";
txtGiatrigiatang.Text = "0";
txtPhivanchuyen.Text = "0";
txtPhikhac.Text = "0";
txtTongtien.Text = "0";
}
check_loaidathang.Enabled = false;
TinhToan();
}
else
{ MessageBox.Show("Không tìm thấy mã đơn đặt hàng cần sửa !"); this.Close(); }
toolStripStatusLabel3.Enabled = true;
}
}
catch (Exception ex)
{
string s = ex.Message;
if (txtSodonhang.Text == "")
{
txtSodonhang.Text = makhachhang;
}
}
}
