private void XuLyKhoHang(string hanhdong)
{
try
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang(hanhdong, ID, txtMaKho.Text, txtTenKho.Text, txtDiaChi.Text, txtSoDienThoai.Text, cbxMaNhanVien.SelectedValue.ToString(), txtGhiChu.Text, false);
kh.Manhanvien = Common.Utilities.User.NhanVienID;
kh.Tendangnhap = Common.Utilities.User.TenDangNhap;
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
Entities.KhoHang k = new Entities.KhoHang();
k = (Entities.KhoHang)client.DeserializeHepper(networkStream, k);
if (k.GhiChu == "OK")
{
frmQuanLyKhoHang.BaoDong = "";
this.Close();
}
else
{
MessageBox.Show("Thất bại");
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
public frmXuLyKhoHang(string hanhdong, DataGridViewRow dgvr, Entities.KhoHang kho)
{
InitializeComponent();
this.hanhDong = hanhdong;
this.dgv = dgvr;
this.khohang = kho;
}
/// <summary>
/// kiem tra ma khi them moi kho --------------------------------------------------------check--------------------
/// </summary>
public void CheckConflictInsert()
{
try
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang nh = new Entities.KhoHang("Select");
Entities.KhoHang[] nh1 = new Entities.KhoHang[1];
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", nh);
nh1 = (Entities.KhoHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaKho == txtMaKho.Text)
{
MessageBox.Show("Cập nhật mã hàng hóa");
kt = "ko";
txtMaKho.Text = new Common.Utilities().ProcessID(txtMaKho.Text);
break;
}
else
{
kt = "ok";
}
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
}
public void LayKhoHang(ComboBox cbb, string str)
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Select");
clientstrem = cl.SerializeObj(this.client1, "KhoHang", kh);
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
int index = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaKho == str)
{
index = i;
break;
}
}
cbb.DataSource = kh1;
cbb.DisplayMember = "TenKho";
cbb.SelectedIndex = index;
}
}
public frmXuLyKhoHang(string hanhdong, DataGridViewRow dgvr, Entities.KhoHang kho)
{
InitializeComponent();
this.hanhDong = hanhdong;
this.dgv = dgvr;
this.khohang = kho;
}
//Hiển thị form Sửa Kho Hàng
private void toolStripStatus_Sua_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 2))
{
return;
}
if (dgvKhoHang.RowCount > 0)
{
frmXuLyKhoHang skh = new frmXuLyKhoHang("Update", dgvKhoHang.CurrentRow, getData());
skh.ShowDialog();
SelectData();
}
else
{
MessageBox.Show("Không có kho nào để sửa");
}
}
catch (Exception ex)
{
string s = ex.Message; Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
//Lấy dữ liệu từ Database
private void SelectData()
{
try
{
dgvKhoHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(networkStream, kh1);
if (kh1.Length > 0 && kh1 != null)
{
search = new Entities.KhoHang[kh1.Length];
search = kh1;
dgvKhoHang.DataSource = search;
rdoTatca.Checked = true;
fix();
}
else
{
CapNhat(dgvKhoHang);
fix();
}
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] lay = new Entities.KhoHang[0];
dgvKhoHang.DataSource = lay;
CapNhat(dgvKhoHang);
fix();
}
}
public void checkConflict()
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])client.DeserializeHepper1(networkStream, kh1);
if (kh1 != null)
{
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].MaKho == txtMaKho.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaKho.Text = new Common.Utilities().ProcessID(txtMaKho.Text);
break;
}
else
{
chck = "Yes";
}
}
}
}
public void HienThi()
{
try
{
bool kt = false;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "SoDuKho", new Entities.SoDuKho("Select"));
ddh = new Entities.SoDuKho[1];
ddh = (Entities.SoDuKho[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh == null)
{
toolStrip1.Enabled = true;
dgvsodukhohang.DataSource = new Entities.SoDuKho[0];
FixDatagridview();
return;
}
Entities.KhoHang kh = (Entities.KhoHang)cbbkhohang.SelectedItem;
List <Entities.SoDuKho> L = new List <Entities.SoDuKho>();
DateTime SoSanh = new DateTime(int.Parse(cbbnam.Text), int.Parse(cbbthang.Text), 1);
foreach (Entities.SoDuKho item in ddh)
{
if ((item.TrangThai && !kt) || (!kt && (item.NgayKetChuyen.Month == SoSanh.Month - 1) && (item.NgayKetChuyen.Year == SoSanh.Year) && (item.MaKho.ToUpper().Equals(kh.MaKho.ToUpper()))))
{
kt = item.TrangThai;
}
if ((item.NgayKetChuyen.Month == SoSanh.Month) && (item.NgayKetChuyen.Year == SoSanh.Year) && (item.MaKho.ToUpper().Equals(kh.MaKho.ToUpper())))
{
L.Add(item);
}
}
if (L.Count == 0)
{
lbltrangthai.Text = "";
toolStrip1.Enabled = true;
dgvsodukhohang.DataSource = new Entities.SoDuKho[0];
FixDatagridview();
return;
}
if (L[0].TrangThai)
{
lbltrangthai.ForeColor = Color.Red;
lbltrangthai.Text = "Kỳ Đã Khóa";
toolStrip1.Enabled = false;
}
else
{
lbltrangthai.ForeColor = Color.Green;
lbltrangthai.Text = "Kỳ Chưa Khóa";
toolStrip1.Enabled = true;
}
dgvsodukhohang.DataSource = L.ToArray();
FixDatagridview();
if (kt)
{
toolStrip1.Enabled = false;
}
}
catch { }
}
public void checkConflict()
{
Server_Client.Client client= new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])client.DeserializeHepper1(networkStream, kh1);
if (kh1 != null)
{
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].MaKho == txtMaKho.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaKho.Text = new Common.Utilities().ProcessID(txtMaKho.Text);
break;
}
else
chck = "Yes";
}
}
}
//Xóa Data trên Data Grid View
#region Xử lý khi Delete
private void tssXoa_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 3))
{
return;
}
if (dgvKhoHang.RowCount > 0)
{
Boolean check = new Check().CheckReference("KhoHang", dgvKhoHang.CurrentRow.Cells[2].Value.ToString());
if (check == true)
{
System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn xóa không ?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo);
{
if (giatri == System.Windows.Forms.DialogResult.Yes)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Delete", int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString()));
kh.Manhanvien = Common.Utilities.User.MaNV;
kh.Tendangnhap = Common.Utilities.User.TenDangNhap;
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
int kt = 0;
kt = (int)cl.DeserializeHepper(networkStream, kt);
if (kt >= 1)
{
SelectData();
fix();
if (dgvKhoHang.RowCount <= 0)
{
search = null;
}
}
else
{
MessageBox.Show("Thất bại");
}
}
else
{
}
}
}
else
{
MessageBox.Show("Kho hàng này không thể xóa");
}
}
else
{
search = null;
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void CapNhat(DataGridView dgv)
{
try
{
Entities.KhoHang[] lay = new Entities.KhoHang[0];
dgv.DataSource = lay;
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
bool kt1 = true;
for (int i = 0; i < dgvsodukhohang.RowCount; i++)
{
if (dgvsodukhohang.Rows[i].Cells["MaHangHoa"].Value.ToString() == tsslma.Text)
{
kt1 = false;
break;
}
}
if (kt1)
{
string ma = LayID("SoDuKho");
Entities.KhoHang kh = (Entities.KhoHang)cbbkhohang.SelectedItem;
string makho = kh.MaKho;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.SoDuKho sodukho = new Entities.SoDuKho("Insert", 1, ma, makho, tsslma.Text, Convert.ToInt32(tsslsodudauky.Text), 0, datesv, 0, 0, false);
clientstrem = cl.SerializeObj(this.client, "SoDuKho", sodukho);
bool msg = true;
msg = (bool)cl.DeserializeHepper(clientstrem, msg);
if (msg)
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietKhoHangTheoHoaHonNhap[] ctkho = new Entities.ChiTietKhoHangTheoHoaHonNhap[1];
ctkho[0] = new Entities.ChiTietKhoHangTheoHoaHonNhap();
ctkho[0].Hanhdong = "UpdateCong";
ctkho[0].Makho = makho;
ctkho[0].Mahanghoa = tsslma.Text;
ctkho[0].Soluong = Convert.ToInt32(tsslsodudauky.Text);
clientstrem = cl.SerializeObj(this.client, "ThemChiTietKhoHang", ctkho);
int i = 0;
i = (int)cl.DeserializeHepper(clientstrem, i);
HienThi();
tsslma.Text = "<F4>-tra cứu";
tsslsodudauky.Text = "0";
tsslten.Text = "";
}
else
{
MessageBox.Show("Insert thất Bại");
}
}
else
{
MessageBox.Show("Hàng Hóa đã được nhập số dư đầu kỳ - Không thể thêm mới");
}
}
private void tsslma_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F4)
{
Entities.KhoHang kho = (Entities.KhoHang)cbbkhohang.SelectedItem;
frmTraCuuHDNhap fr = new frmTraCuuHDNhap("HangHoa", kho.MaKho);
fr.ShowDialog();
if (sdkho != null)
{
tsslma.Text = sdkho.MaHangHoa;
tsslten.Text = sdkho.TenHangHoa;
}
}
}
private void toolStripStatusLabel1_Click(object sender, EventArgs e)
{
try
{
SelectData();
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
private void frmHienThi_KhoHang_Load(object sender, EventArgs e)
{
try
{
SelectData();
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
//Xóa Data trên Data Grid View
#region Xử lý khi Delete
private void tssXoa_Click(object sender, EventArgs e)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Delete", int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString()));
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
SelectData();
}
//Xử Lý Thêm
#region Xử lý Thêm
private void tssThem_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Insert", 0, txtMaKho.Text, txtTenKho.Text, txtDiaChi.Text, txtSoDienThoai.Text, cmbMaNhanVien.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
void LayKhoHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang ctxh = new Entities.KhoHang("Select");
KHOHANG = new Entities.KhoHang[1];
clientstrem = cl.SerializeObj(this.client1, "KhoHang", ctxh);
KHOHANG = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, KHOHANG);
if (KHOHANG == null)
{
KHOHANG = new Entities.KhoHang[0];
}
}
catch { }
}
public void KhoHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang ctxh = new Entities.KhoHang("Select");
khohang = new Entities.KhoHang[1];
clientstrem = cl.SerializeObj(this.client1, "KhoHang", ctxh);
khohang = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, khohang);
if (khohang == null)
{
khohang = new Entities.KhoHang[0];
}
}
catch { }
}
/// <summary>
/// lay hang khi sua
/// </summary>
/// <returns></returns>
private Entities.KhoHang getData()
{
Entities.KhoHang data = new Entities.KhoHang();
try
{
data.KhoHangID = int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString());
data.MaKho = dgvKhoHang.CurrentRow.Cells[2].Value.ToString();
data.TenKho = dgvKhoHang.CurrentRow.Cells[3].Value.ToString();
data.DiaChi = dgvKhoHang.CurrentRow.Cells[4].Value.ToString();
data.DienThoai = dgvKhoHang.CurrentRow.Cells[5].Value.ToString();
data.MaNhanVien = dgvKhoHang.CurrentRow.Cells[6].Value.ToString();
data.GhiChu = dgvKhoHang.CurrentRow.Cells[7].Value.ToString();
data.Deleted = Boolean.Parse(dgvKhoHang.CurrentRow.Cells[8].Value.ToString());
}
catch (Exception ex)
{ string s = ex.Message; data = null; }
return(data);
}
/// <summary>
/// hungvv =======================lay du lieu moi checkfix===========================
/// </summary>
private Entities.KhoHang ConfilickData(string table, string values)
{
Entities.KhoHang ddh = null;
try
{
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.TruyenGiaTri gitri = new Entities.TruyenGiaTri("Select", table, values);
networkStream = cl.SerializeObj(this.tcpClient, "CheckKhoHang", gitri);
ddh = new Entities.KhoHang();
ddh = (Entities.KhoHang)cl.DeserializeHepper(networkStream, ddh);
}
catch (Exception ex)
{
string s = ex.Message.ToString();
ddh = null;
}
return(ddh);
}
private void tsslXacNhan_Click(object sender, EventArgs e)
{
if (check_Xacnhan.Checked == true)
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kho1 = (Entities.KhoHang)cbxTukho.SelectedItem;
Entities.KhoHang kho2 = (Entities.KhoHang)cbxDenkho.SelectedItem;
Entities.PhieuDieuChuyenKhoNoiBo nv = new Entities.PhieuDieuChuyenKhoNoiBo("Update", PDCKID, txtSochungtu.Text, ConvertDatetime(makNgaychungtu.Text), kho1.MaKho, "", kho2.MaKho, "", maHDNhap, check_Xacnhan.Checked, ghichu, false);
clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", nv);
int msg = 0;
msg = (int)cl.DeserializeHepper(clientstrem, msg);
if (msg == 1)
{
// tru so luong tu kho
Entities.KhoHang khoh = (Entities.KhoHang)cbxTukho.SelectedItem;
CheckDataGridTruSL(dgvInsertOrder, khoh.MaKho);
// Update so luong khi co hang hoa tong tai trong kho den
Entities.KhoHang khoDen = (Entities.KhoHang)cbxDenkho.SelectedItem;
CheckDataGridCongSL1(dgvInsertOrder, khoDen.MaKho);
// Insert so luong kho ko co hang hoa do
CheckDataGridCongSL(dgvInsertOrder, khoDen.MaKho);
}
else
{
MessageBox.Show("Update that bai");
return;
}
this.Close();
}
else
{
if (check_Xacnhan.Checked == false)
{
MessageBox.Show("Chưa xác nhận vào checkbox xác nhận ", "Hệ Thống Cảnh Báo");
}
}
}
private void dgvKhoHang_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvKhoHang.RowCount > 0)
{
frmXuLyKhoHang skh = new frmXuLyKhoHang("Update", dgvKhoHang.CurrentRow, getData());
skh.ShowDialog();
SelectData();
}
else
{
}
}
catch (Exception ex)
{
string s = ex.Message; Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
//Lấy dữ liệu từ Database
public void SelectData()
{
try
{
dgvKhoHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(networkStream, kh1);
lbhienthitongso.Text = kh1.Length.ToString();
dgvKhoHang.DataSource = kh1;
dgvKhoHang.Columns[0].Visible = false;
dgvKhoHang.Rows[0].Selected = true;
}
catch (Exception)
{
MessageBox.Show("Kết nối server thất bại");
}
}
//Lấy dữ liệu từ Database
public void SelectData()
{
try
{
dgvKhoHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(networkStream, kh1);
lbhienthitongso.Text = kh1.Length.ToString();
dgvKhoHang.DataSource = kh1;
dgvKhoHang.Columns[0].Visible = false;
dgvKhoHang.Rows[0].Selected = true;
}
catch (Exception)
{
MessageBox.Show("Kết nối server thất bại");
}
}
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim)
{
try
{
if (search.Length > 0)
{
ArrayList list = new ArrayList();
Entities.KhoHang[] getData = null;
if (rdoMa.Checked == true)
{
if (giatritim != "")
{
for (int i = 0; i < search.Length; i++)
{
string layma = search[i].MaKho.ToLower();
if (layma.Length > 0)
{
int index = layma.IndexOf(giatritim.ToLower());
if (index >= 0)
{
list.Add(search[i]);
}
}
else
{
continue;
}
}
int n = list.Count;
if (n == 0)
{
getData = null;
}
getData = new Entities.KhoHang[n];
for (int i = 0; i < n; i++)
{
getData[i] = (Entities.KhoHang)list[i];
}
dgv.DataSource = null;
dgv.DataSource = getData;
}
else
{
CapNhat(dgv);
}
}
if (rdoNgay.Checked == true)
{
if (giatritim != "")
{
for (int i = 0; i < search.Length; i++)
{
string layma = search[i].TenKho.ToString().ToLower();
if (layma.Length > 0)
{
int index = layma.IndexOf(giatritim.ToLower());
if (index >= 0)
{
list.Add(search[i]);
}
}
else
{
continue;
}
}
int n = list.Count;
if (n == 0)
{
getData = null;
}
getData = new Entities.KhoHang[n];
for (int i = 0; i < n; i++)
{
getData[i] = (Entities.KhoHang)list[i];
}
dgv.DataSource = null;
dgv.DataSource = getData;
}
else
{
CapNhat(dgv);
}
}
if (rdoTatca.Checked == true)
{
dgv.DataSource = null;
dgv.DataSource = search;
}
}
else
{
CapNhat(dgv);
}
fix();
}
catch (Exception ex)
{
string s = ex.Message;
CapNhat(dgv);
fix();
}
}
private void toolStripStatusLabel1_Click(object sender, EventArgs e)
{
try
{
SelectData();
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
//Hiển thị form Sửa Kho Hàng
private void toolStripStatus_Sua_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 2))
{ return; }
if (dgvKhoHang.RowCount > 0)
{
frmXuLyKhoHang skh = new frmXuLyKhoHang("Update", dgvKhoHang.CurrentRow, getData());
skh.ShowDialog();
SelectData();
}
else
{ MessageBox.Show("Không có kho nào để sửa"); }
}
catch (Exception ex)
{
string s = ex.Message; Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
private void tssXoa_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 3))
{ return; }
if (dgvKhoHang.RowCount > 0)
{
Boolean check = new Check().CheckReference("KhoHang",dgvKhoHang.CurrentRow.Cells[2].Value.ToString());
if (check == true)
{
System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn xóa không ?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo);
{
if (giatri == System.Windows.Forms.DialogResult.Yes)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Delete", int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString()));
kh.Manhanvien = Common.Utilities.User.MaNV;
kh.Tendangnhap = Common.Utilities.User.TenDangNhap;
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
int kt = 0;
kt = (int)cl.DeserializeHepper(networkStream, kt);
if (kt >= 1)
{
SelectData();
fix();
if (dgvKhoHang.RowCount <= 0)
{ search = null; }
}
else
{ MessageBox.Show("Thất bại"); }
}
else
{ }
}
}
else
{ MessageBox.Show("Kho hàng này không thể xóa"); }
}
else
{ search = null; }
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
int soluong = 0;
if (khohang != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].MaKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
Entities.KhoHang[] hienthitheoid = new Entities.KhoHang[soluong];
soluong = 0;
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].MaKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = khohang[i];
soluong++;
}
}
dtgvhienthi.DataSource = hienthitheoid;
}
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].TenKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
Entities.KhoHang[] hienthitheoma = new Entities.KhoHang[soluong];
soluong = 0;
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].TenKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = khohang[i];
soluong++;
}
}
dtgvhienthi.DataSource = hienthitheoma;
}
if (dtgvhienthi.RowCount > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
}
finally
{
fix();
}
}
/// <summary>
/// kiem tra
/// </summary>
/// <param name="gitri"></param>
/// <param name="sosanh"></param>
/// <returns></returns>
private Boolean checkconflictUpdate(Entities.KhoHang gitri, Entities.KhoHang sosanh)
{
Boolean kiemtra = false;
try
{
int count = 0;
if (gitri.KhoHangID != sosanh.KhoHangID)
{
kiemtra = false; ID = sosanh.KhoHangID;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.MaKho != sosanh.MaKho)
{
kiemtra = false; txtMaKho.Text = sosanh.MaKho;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.TenKho != sosanh.TenKho)
{
kiemtra = false; txtTenKho.Text = sosanh.TenKho;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.DiaChi != sosanh.DiaChi)
{
kiemtra = false; txtDiaChi.Text = sosanh.DiaChi;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.DienThoai != sosanh.DienThoai)
{
kiemtra = false; txtSoDienThoai.Text = sosanh.DienThoai;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.MaNhanVien != sosanh.MaNhanVien)
{
kiemtra = false; cbxMaNhanVien.SelectedValue = sosanh.MaNhanVien;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.GhiChu != sosanh.GhiChu)
{
kiemtra = false; txtGhiChu.Text = sosanh.GhiChu;
}
else
{
kiemtra = true; count = count + 1;
}
if (gitri.Deleted != sosanh.Deleted)
{
kiemtra = false;
}
else
{
kiemtra = true; count = count + 1;
}
if (count < 8)
{
kiemtra = false;
}
else
{
kiemtra = true; count = 0;
}
}
catch (Exception ex)
{ string s = ex.Message; kiemtra = false; }
return(kiemtra);
}
private void tssSua_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Update", int.Parse(dgvr1.Cells[1].Value.ToString()), txtMaKho.Text, txtTenKho.Text,txtDiaChi.Text,txtSoDienThoai.Text,cmbMaNhanVien.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
public void LayKhoHang(ComboBox cbb, string str)
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Select");
clientstrem = cl.SerializeObj(this.client1, "KhoHang", kh);
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
int index = 0;
for (int i = 0; i < kh1.Length; i++)
{
if (kh1[i].MaKho == str)
{
index = i;
break;
}
}
cbb.DataSource = kh1;
cbb.DisplayMember = "TenKho";
cbb.SelectedIndex = index;
}
}
//Lấy dữ liệu từ Database
private void SelectData()
{
try
{
dgvKhoHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang("Select");
Entities.KhoHang[] kh1 = new Entities.KhoHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(networkStream, kh1);
if (kh1.Length > 0 && kh1 != null)
{
search = new Entities.KhoHang[kh1.Length];
search = kh1;
dgvKhoHang.DataSource = search;
rdoTatca.Checked = true;
fix();
}
else
{
CapNhat(dgvKhoHang);
fix();
}
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] lay = new Entities.KhoHang[0];
dgvKhoHang.DataSource = lay;
CapNhat(dgvKhoHang);
fix();
}
}
private void tssXoa_Click(object sender, EventArgs e)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Delete", int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString()));
networkStream = cl.SerializeObj(this.tcpClient, "KhoHang", kh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
SelectData();
}
private void XuLyKhoHang(string hanhdong)
{
try
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang(hanhdong, ID, txtMaKho.Text, txtTenKho.Text, txtDiaChi.Text, txtSoDienThoai.Text, cbxMaNhanVien.SelectedValue.ToString(), txtGhiChu.Text, false);
kh.Manhanvien = Common.Utilities.User.NhanVienID;
kh.Tendangnhap = Common.Utilities.User.TenDangNhap;
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", kh);
Entities.KhoHang k = new Entities.KhoHang();
k = (Entities.KhoHang)client.DeserializeHepper(networkStream, k);
if (k.GhiChu == "OK")
{
frmQuanLyKhoHang.BaoDong = "";
this.Close();
}
else
{
MessageBox.Show("Thất bại");
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void frmHienThi_KhoHang_Load(object sender, EventArgs e)
{
try
{
SelectData();
}
catch (Exception ex)
{
string s = ex.Message;
Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim)
{
try
{
if (search.Length > 0)
{
ArrayList list = new ArrayList();
Entities.KhoHang[] getData = null;
if (rdoMa.Checked == true)
{
if (giatritim != "")
{
for (int i = 0; i < search.Length; i++)
{
string layma = search[i].MaKho.ToLower();
if (layma.Length > 0)
{
int index = layma.IndexOf(giatritim.ToLower());
if (index >= 0)
{
list.Add(search[i]);
}
}
else
{ continue; }
}
int n = list.Count;
if (n == 0) { getData = null; }
getData = new Entities.KhoHang[n];
for (int i = 0; i < n; i++)
{
getData[i] = (Entities.KhoHang)list[i];
}
dgv.DataSource = null;
dgv.DataSource = getData;
}
else
{ CapNhat(dgv); }
}
if (rdoNgay.Checked == true)
{
if (giatritim != "")
{
for (int i = 0; i < search.Length; i++)
{
string layma = search[i].TenKho.ToString().ToLower();
if (layma.Length > 0)
{
int index = layma.IndexOf(giatritim.ToLower());
if (index >= 0)
{
list.Add(search[i]);
}
}
else
{ continue; }
}
int n = list.Count;
if (n == 0) { getData = null; }
getData = new Entities.KhoHang[n];
for (int i = 0; i < n; i++)
{
getData[i] = (Entities.KhoHang)list[i];
}
dgv.DataSource = null;
dgv.DataSource = getData;
}
else
{ CapNhat(dgv); }
}
if (rdoTatca.Checked == true)
{
dgv.DataSource = null;
dgv.DataSource = search;
}
}
else
{ CapNhat(dgv); }
fix();
}
catch (Exception ex)
{
string s = ex.Message;
CapNhat(dgv);
fix();
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
int soluong = 0;
if (khohang != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].MaKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
Entities.KhoHang[] hienthitheoid = new Entities.KhoHang[soluong];
soluong = 0;
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].MaKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = khohang[i];
soluong++;
}
}
dtgvhienthi.DataSource = hienthitheoid;
}
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].TenKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.KhoHang[0];
return;
}
Entities.KhoHang[] hienthitheoma = new Entities.KhoHang[soluong];
soluong = 0;
for (int i = 0; i < khohang.Length; i++)
{
int kiemtra = khohang[i].TenKho.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = khohang[i];
soluong++;
}
}
dtgvhienthi.DataSource = hienthitheoma;
}
if (dtgvhienthi.RowCount > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
}
finally
{
fix();
}
}
/// <summary>
/// lay hang khi sua
/// </summary>
/// <returns></returns>
private Entities.KhoHang getData()
{
Entities.KhoHang data = new Entities.KhoHang();
try
{
data.KhoHangID = int.Parse(dgvKhoHang.CurrentRow.Cells[1].Value.ToString());
data.MaKho =dgvKhoHang.CurrentRow.Cells[2].Value.ToString();
data.TenKho = dgvKhoHang.CurrentRow.Cells[3].Value.ToString();
data.DiaChi = dgvKhoHang.CurrentRow.Cells[4].Value.ToString();
data.DienThoai = dgvKhoHang.CurrentRow.Cells[5].Value.ToString();
data.MaNhanVien = dgvKhoHang.CurrentRow.Cells[6].Value.ToString();
data.GhiChu = dgvKhoHang.CurrentRow.Cells[7].Value.ToString();
data.Deleted = Boolean.Parse(dgvKhoHang.CurrentRow.Cells[8].Value.ToString());
}
catch (Exception ex)
{ string s = ex.Message; data = null; }
return data;
}
public void KhoHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang ctxh = new Entities.KhoHang("Select");
khohang = new Entities.KhoHang[1];
clientstrem = cl.SerializeObj(this.client1, "KhoHang", ctxh);
khohang = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, khohang);
if (khohang == null)
khohang = new Entities.KhoHang[0];
}
catch { }
}
void LayKhoHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang ctxh = new Entities.KhoHang("Select");
KHOHANG = new Entities.KhoHang[1];
clientstrem = cl.SerializeObj(this.client1, "KhoHang", ctxh);
KHOHANG = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, KHOHANG);
if (KHOHANG == null)
KHOHANG = new Entities.KhoHang[0];
}
catch { }
}
private void CapNhat(DataGridView dgv)
{
try
{
Entities.KhoHang[] lay = new Entities.KhoHang[0];
dgv.DataSource = lay;
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// kiem tra ma khi them moi kho --------------------------------------------------------check--------------------
/// </summary>
public void CheckConflictInsert()
{
try
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang nh = new Entities.KhoHang("Select");
Entities.KhoHang[] nh1 = new Entities.KhoHang[1];
networkStream = client.SerializeObj(this.tcpClient, "KhoHang", nh);
nh1 = (Entities.KhoHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaKho == txtMaKho.Text)
{
MessageBox.Show("Cập nhật mã hàng hóa");
kt = "ko";
txtMaKho.Text = new Common.Utilities().ProcessID(txtMaKho.Text);
break;
}
else
kt = "ok";
}
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
}
/// <summary>
/// select kho hàng
/// </summary>
public void LayKhoHang()
{
try
{
cbbkhohang.Items.Clear();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.KhoHang kh = new Entities.KhoHang();
kh = new Entities.KhoHang("Select");
clientstrem = cl.SerializeObj(this.client1, "KhoHang", kh);
kh1 = new Entities.KhoHang[1];
kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1.Length > 0)
{
int sl = kh1.Length;
for (int i = 0; i < sl; i++)
{
if (kh1[i].Deleted == false)
cbbkhohang.Items.Add(kh1[i].TenKho);
}
}
}
catch (Exception ex)
{
cbbkhohang.Items.Clear();
cbbkhohang.Text = "";
}
finally
{
}
}
/// <summary>
/// hungvv =======================lay du lieu moi checkfix===========================
/// </summary>
private Entities.KhoHang ConfilickData(string table, string values)
{
Entities.KhoHang ddh = null;
try
{
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.TruyenGiaTri gitri = new Entities.TruyenGiaTri("Select", table, values);
networkStream = cl.SerializeObj(this.tcpClient, "CheckKhoHang", gitri);
ddh = new Entities.KhoHang();
ddh = (Entities.KhoHang)cl.DeserializeHepper(networkStream, ddh);
}
catch (Exception ex)
{
string s = ex.Message.ToString();
ddh = null;
}
return ddh;
}
private void dgvKhoHang_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvKhoHang.RowCount > 0)
{
frmXuLyKhoHang skh = new frmXuLyKhoHang("Update", dgvKhoHang.CurrentRow, getData());
skh.ShowDialog();
SelectData();
}
else
{ }
}
catch (Exception ex)
{
string s = ex.Message; Entities.KhoHang[] k = new Entities.KhoHang[0];
dgvKhoHang.DataSource = k;
fix();
}
}
