public void LayTenLoaiHang() { try { cmbLoaihang.Items.Clear(); client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.LoaiHangHoa nh = new Entities.LoaiHangHoa(); nh = new Entities.LoaiHangHoa("Select"); networkStream = client.SerializeObj(this.tcpClient, "LoaiHangHoa", nh); nh1 = new Entities.LoaiHangHoa[1]; nh1 = (Entities.LoaiHangHoa[])client.DeserializeHepper1(networkStream, nh1); if (nh1.Length > 0) { int sl = nh1.Length; for (int i = 0; i < sl; i++) { if (nh1[i].Deleted == false) { cmbLoaihang.Items.Add(nh1[i].TenLoaiHang); } } } } catch { } }
public void checkConflict() { Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhanVien", nh); nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (nh1 != null) { for (int j = 0; j < nh1.Length; j++) { if (nh1[j].MaNhomHang == txtMaNhomHang.Text) { MessageBox.Show("Thất bại"); chck = "No"; txtMaNhomHang.Text = new Common.Utilities().ProcessID(txtMaNhomHang.Text); break; } else chck = "Yes"; } } }
//Check Sửa public void CheckConflictUpdate() { try { kt1 = true; cl = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] pt1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); pt1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (pt1 != null) { for (int j = 0; j < pt1.Length; j++) { if (pt1[j].MaNhomHang == manhomhang) { kt1 = Check(pt1[j]); break; } else { kt1 = true; } } } } catch (Exception ex) { kt1 = false; } finally { } }
//Thêm private void tssThem_Click(object sender, EventArgs e) { try { if (KiemTra() == true) { CheckConflictInsert(); if (kt1 == true) { Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text); nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)client.DeserializeHepper(networkStream, kt); if (kt == true) { this.Close(); } else { MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo"); } } } } catch { } }
//Check Thêm public void CheckConflictInsert() { try { kt1 = true; Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (nh1 != null) { for (int j = 0; j < nh1.Length; j++) { if (nh1[j].MaLoaiHang == cmbLoaihang.Text) { MessageBox.Show("Cập nhật mã hàng hóa", "Hệ thống cảnh báo"); kt1 = false; manhomhang = txtMaNhomHang.Text = ProID("NhomHang"); break; } else { kt1 = true; } } } } catch (Exception ex) { kt1 = false; } }
//Lấy dữ liệu từ Database public void SelectData() { try { dgvNhomHang.RowHeadersVisible = false; Server_Client.Client cl = new Server_Client.Client(); this.tcpClient = cl.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh); nh1 = (Entities.NhomHang[])cl.DeserializeHepper1(networkStream, nh1); if (nh1 == null) { tssXoa.Enabled = false; tssSua.Enabled = false; hienthi = new Entities.NhomHang[0]; dgvNhomHang.DataSource = new Entities.NhomHang[0]; return; } Entities.NhomHang[] pt2 = new Entities.NhomHang[nh1.Length]; int sotang = 0; for (int j = 0; j < nh1.Length; j++) { if (nh1[j].Deleted == false) { pt2[sotang] = nh1[j]; sotang++; } } hienthi = new Entities.NhomHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; } } else { hienthi = new Entities.NhomHang[0]; dgvNhomHang.DataSource = new Entities.NhomHang[0]; tssXoa.Enabled = false; tssSua.Enabled = false; return; } tssXoa.Enabled = true; tssSua.Enabled = true; dgvNhomHang.DataSource = hienthi; dgvNhomHang.Rows[0].Selected = true; } catch (Exception) { } finally { fix(); } }
public void checkConflict() { Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhanVien", nh); nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (nh1 != null) { for (int j = 0; j < nh1.Length; j++) { if (nh1[j].MaNhomHang == txtMaNhomHang.Text) { MessageBox.Show("Thất bại"); chck = "No"; txtMaNhomHang.Text = new Common.Utilities().ProcessID(txtMaNhomHang.Text); break; } else { chck = "Yes"; } } } }
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(); } }
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.NhomHang nh = new Entities.NhomHang(); nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, txtMaLoaiHang.Text, txtTenNhomHangHoa.Text, txtGhiChu.Text, false); networkStream = client.SerializeObj(this.tcpClient, "NhomHangHoa", nh); bool kt = false; kt = (bool)client.DeserializeHepper(networkStream, kt); if (kt == true) { MessageBox.Show("Thành công"); } this.Close(); }
public void SelectNhomHang() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.NhomHang ctxh = new Entities.NhomHang("Select"); clientstrem = cl.SerializeObj(this.client1, "NhomHang", ctxh); nh = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nh); if (nh == null) { nh = new Entities.NhomHang[0]; return; } } catch { } }
//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 && !(new Common.Utilities().CheckQuyen(this.Name, 3))) { MessageBox.Show("Bạn không có quyền vào", "Hệ thống cảnh báo"); return; } if (new Check().CheckReference("NhomHang", dgvNhomHang["MaNhomHang", i].Value.ToString()) == false) { MessageBox.Show("Nhóm hàng này đang có giao dịch không thể xóa", "Hệ thống cảnh báo"); return; } System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn Xóa không?", "Hệ Thống Cảnh 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.NhomHang nh = new Entities.NhomHang(); nh = new Entities.NhomHang("Delete", int.Parse(dgvNhomHang.CurrentRow.Cells["NhomHangID"].Value.ToString()), Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)cl.DeserializeHepper(networkStream, kt); if (kt == true) { } else { MessageBox.Show("thất bại - xin hãy kiểm tra lại", "Hệ thống cảnh báo"); } SelectData(); } } } catch { } }
public bool Check(Entities.NhomHang nh) { bool gt = true; if (loaihanghoa != nh.MaLoaiHang) { loaihanghoa = nh.MaLoaiHang; cmbLoaihang.Text = LayTenLoaiHang(loaihanghoa); gt = false; } if (tennhomhang != nh.TenNhomHang) { tennhomhang = txtTenNhomHang.Text = nh.TenNhomHang; gt = false; } if (ghichu != nh.GhiChu) { ghichu = txtGhiChu.Text = nh.GhiChu; gt = false; } return(gt); }
//Check Thêm public void CheckConflictInsert() { try { kt1 = true; Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (nh1 != null) { for (int j = 0; j < nh1.Length; j++) { if (nh1[j].MaLoaiHang == cmbLoaihang.Text) { MessageBox.Show("Cập nhật mã hàng hóa", "Hệ thống cảnh báo"); kt1 = false; manhomhang = txtMaNhomHang.Text = ProID("NhomHang"); break; } else kt1 = true; } } } catch (Exception ex) { kt1 = false; } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dgvNhomHang.DataSource = new Entities.NhomHang[0]; return; } int soluong = 0; if (rdbtimkiem1.Checked == true) { for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dgvNhomHang.DataSource = new Entities.NhomHang[0]; return; } Entities.NhomHang[] hienthitheoid = new Entities.NhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoid[soluong] = hienthi[i]; soluong++; } } dgvNhomHang.DataSource = hienthitheoid; } if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dgvNhomHang.DataSource = new Entities.NhomHang[0]; return; } Entities.NhomHang[] hienthitheoma = new Entities.NhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthi[i]; soluong++; } } dgvNhomHang.DataSource = hienthitheoma; } } finally { fix(); } }
public Entities.BCNhapHangTheoNhomHang Select() { Entities.BCNhapHangTheoNhomHang list = null; try { list = new Entities.BCNhapHangTheoNhomHang(); ////Lấy hóa đơn nhập //con = new Connection(); //cn = con.openConnection(); //List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>(); //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap"; //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //while (dr.Read()) //{ // Entities.HoaDonNhap row = new Entities.HoaDonNhap(); // row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString(); // row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); // HoaDonNhap.Add(row); //} //list.HoaDonNhap = HoaDonNhap; //cmd.Connection.Dispose(); //cn.Close(); //con.closeConnection(); //Lấy chi tiết hóa đơn nhập con = new Connection(); cn = con.openConnection(); List <Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List <Entities.ChiTietHoaDonNhap>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap(); row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); ChiTietHoaDonNhap.Add(row); } list.ChiTietHoaDonNhap = ChiTietHoaDonNhap; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); ////Lấy khách hàng trả lại //con = new Connection(); //cn = con.openConnection(); //List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>(); //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai"; //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //while (dr.Read()) //{ // Entities.KhachHangTraLai row = new Entities.KhachHangTraLai(); // row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString(); // row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); // KhachHangTraLai.Add(row); //} //list.KhachHangTraLai = KhachHangTraLai; //cmd.Connection.Dispose(); //cn.Close(); //con.closeConnection(); //Lấy chi tiết khách hàng trả lại con = new Connection(); cn = con.openConnection(); List <Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List <Entities.ChiTietKhachHangTraLai>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai(); row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); ChiTietKhachHangTraLai.Add(row); } list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy hàng hóa nhóm hàng con = new Connection(); cn = con.openConnection(); List <Entities.HangHoa> HangHoa = new List <Entities.HangHoa>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.HangHoa row = new Entities.HangHoa(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.TenHangHoa = dr["TenHangHoa"].ToString(); row.MaNhomHangHoa = dr["MaNhomHang"].ToString(); row.TenNhomHangHoa = dr["TenNhomHang"].ToString(); HangHoa.Add(row); } list.HangHoa = HangHoa; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy nhóm hàng con = new Connection(); cn = con.openConnection(); List <Entities.NhomHang> NhomHang = new List <Entities.NhomHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.NhomHang row = new Entities.NhomHang(); row.MaNhomHang = dr["MaNhomHang"].ToString(); row.TenNhomHang = dr["TenNhomHang"].ToString(); NhomHang.Add(row); } list.NhomHang = NhomHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy gói hàng con = new Connection(); cn = con.openConnection(); List <Entities.GoiHang> GoiHang = new List <Entities.GoiHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.MaGoiHang = dr["MaGoiHang"].ToString(); GoiHang.Add(row); } list.GoiHang = GoiHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy chi tiết gói hàng con = new Connection(); cn = con.openConnection(); List <Entities.ChiTietGoiHang> ChiTietGoiHang = new List <Entities.ChiTietGoiHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang(); row.MaGoiHang = dr["MaGoiHang"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); ChiTietGoiHang.Add(row); } list.ChiTietGoiHang = ChiTietGoiHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } catch { return(null); } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return(list); }
public Entities.BCNhapHangTheoNhomHang Select() { Entities.BCNhapHangTheoNhomHang list = null; try { list = new Entities.BCNhapHangTheoNhomHang(); ////Lấy hóa đơn nhập //con = new Connection(); //cn = con.openConnection(); //List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>(); //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap"; //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //while (dr.Read()) //{ // Entities.HoaDonNhap row = new Entities.HoaDonNhap(); // row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString(); // row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); // HoaDonNhap.Add(row); //} //list.HoaDonNhap = HoaDonNhap; //cmd.Connection.Dispose(); //cn.Close(); //con.closeConnection(); //Lấy chi tiết hóa đơn nhập con = new Connection(); cn = con.openConnection(); List<Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List<Entities.ChiTietHoaDonNhap>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap(); row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); ChiTietHoaDonNhap.Add(row); } list.ChiTietHoaDonNhap = ChiTietHoaDonNhap; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); ////Lấy khách hàng trả lại //con = new Connection(); //cn = con.openConnection(); //List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>(); //cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); //cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai"; //dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //while (dr.Read()) //{ // Entities.KhachHangTraLai row = new Entities.KhachHangTraLai(); // row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString(); // row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); // KhachHangTraLai.Add(row); //} //list.KhachHangTraLai = KhachHangTraLai; //cmd.Connection.Dispose(); //cn.Close(); //con.closeConnection(); //Lấy chi tiết khách hàng trả lại con = new Connection(); cn = con.openConnection(); List<Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List<Entities.ChiTietKhachHangTraLai>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai(); row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString()); ChiTietKhachHangTraLai.Add(row); } list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy hàng hóa nhóm hàng con = new Connection(); cn = con.openConnection(); List<Entities.HangHoa> HangHoa = new List<Entities.HangHoa>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.HangHoa row = new Entities.HangHoa(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.TenHangHoa = dr["TenHangHoa"].ToString(); row.MaNhomHangHoa = dr["MaNhomHang"].ToString(); row.TenNhomHangHoa = dr["TenNhomHang"].ToString(); HangHoa.Add(row); } list.HangHoa = HangHoa; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy nhóm hàng con = new Connection(); cn = con.openConnection(); List<Entities.NhomHang> NhomHang = new List<Entities.NhomHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.NhomHang row = new Entities.NhomHang(); row.MaNhomHang = dr["MaNhomHang"].ToString(); row.TenNhomHang = dr["TenNhomHang"].ToString(); NhomHang.Add(row); } list.NhomHang = NhomHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy gói hàng con = new Connection(); cn = con.openConnection(); List<Entities.GoiHang> GoiHang = new List<Entities.GoiHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.MaGoiHang = dr["MaGoiHang"].ToString(); GoiHang.Add(row); } list.GoiHang = GoiHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); //Lấy chi tiết gói hàng con = new Connection(); cn = con.openConnection(); List<Entities.ChiTietGoiHang> ChiTietGoiHang = new List<Entities.ChiTietGoiHang>(); cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang"; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang(); row.MaGoiHang = dr["MaGoiHang"].ToString(); row.MaHangHoa = dr["MaHangHoa"].ToString(); row.SoLuong = int.Parse(dr["SoLuong"].ToString()); ChiTietGoiHang.Add(row); } list.ChiTietGoiHang = ChiTietGoiHang; cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } catch { return null; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return list; }
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.NhomHang nh = new Entities.NhomHang(); nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, txtMaLoaiHang.Text, txtTenNhomHang.Text, txtGhiChu.Text, false); networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)client.DeserializeHepper(networkStream, kt); if (kt == true) { MessageBox.Show("Thành công"); } this.Close(); }
//Lấy Mã Nhóm Hàng Hóa public void LayMaNhomHangHoa(string maLH) { client = new Server_Client.Client(); this.client1 = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang(); nh = new Entities.NhomHang("Select"); clientstrem = client.SerializeObj(this.client1, "NhomHang", nh); Entities.NhomHang[] nh1 = new Entities.NhomHang[1]; nh1 = (Entities.NhomHang[])client.DeserializeHepper1(clientstrem, nh1); if (nh1 != null) { int count = 0; for (int i = 0; i < nh1.Length; i++) { if (nh1[i].MaLoaiHang == maLH) { count++; } } Entities.NhomHang[] nhomhang = new Entities.NhomHang[count]; count = 0; for (int i = 0; i < nh1.Length; i++) { if (nh1[i].MaLoaiHang == maLH) { nhomhang[count] = nh1[i]; count++; } } cmbMaNhomHangHoa.DataSource = nhomhang; cmbMaNhomHangHoa.DisplayMember = "TenNhomHang"; } }
public void LayTenLoaiHang() { try { cmbLoaihang.Items.Clear(); client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.LoaiHangHoa nh = new Entities.LoaiHangHoa(); nh = new Entities.LoaiHangHoa("Select"); networkStream = client.SerializeObj(this.tcpClient, "LoaiHangHoa", nh); nh1 = new Entities.LoaiHangHoa[1]; nh1 = (Entities.LoaiHangHoa[])client.DeserializeHepper1(networkStream, nh1); if (nh1.Length > 0) { int sl = nh1.Length; for (int i = 0; i < sl; i++) { if (nh1[i].Deleted == false) cmbLoaihang.Items.Add(nh1[i].TenLoaiHang); } } } catch { } }
public int cbbLoaiHangHoa_sua(string maNH) { client = new Server_Client.Client(); this.client1 = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh1 = new Entities.NhomHang(); nh1 = new Entities.NhomHang("Select"); clientstrem = client.SerializeObj(this.client1, "NhomHang", nh1); Entities.NhomHang[] nh = new Entities.NhomHang[1]; nh = (Entities.NhomHang[])client.DeserializeHepper1(clientstrem, nh); string maloaihang = ""; if (nh != null) { for (int i = 0; i < nh.Length; i++) { if (nh[i].MaNhomHang == maNH) { maloaihang = nh[i].MaLoaiHang; break; } } Entities.LoaiHangHoa[] pb = (Entities.LoaiHangHoa[])cbbLoaiHangHoa.DataSource; for (int i = 0; i < pb.Length; i++) { if (pb[i].MaLoaiHang == maloaihang) { return i; } } return -1; } return -1; }
//Check Sửa public void CheckConflictUpdate() { try { kt1 = true; cl = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nh = new Entities.NhomHang("Select"); Entities.NhomHang[] pt1 = new Entities.NhomHang[1]; networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); pt1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1); if (pt1 != null) { for (int j = 0; j < pt1.Length; j++) { if (pt1[j].MaNhomHang == manhomhang) { kt1 = Check(pt1[j]); break; } else kt1 = true; } } } catch (Exception ex) { kt1 = false; } finally { } }
private void tssXoa_Click(object sender, EventArgs e) { try { if (!Common.Utilities.User.Administrator && !(new Common.Utilities().CheckQuyen(this.Name, 3))) { MessageBox.Show("Bạn không có quyền vào", "Hệ thống cảnh báo"); return; } if (new Check().CheckReference("NhomHang", dgvNhomHang["MaNhomHang", i].Value.ToString()) == false) { MessageBox.Show("Nhóm hàng này đang có giao dịch không thể xóa", "Hệ thống cảnh báo"); return; } System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn Xóa không?", "Hệ Thống Cảnh 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.NhomHang nh = new Entities.NhomHang(); nh = new Entities.NhomHang("Delete", int.Parse(dgvNhomHang.CurrentRow.Cells["NhomHangID"].Value.ToString()),Common.Utilities.User.NhanVienID,Common.Utilities.User.TenDangNhap); networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)cl.DeserializeHepper(networkStream, kt); if (kt == true) { } else MessageBox.Show("thất bại - xin hãy kiểm tra lại", "Hệ thống cảnh báo"); SelectData(); } } } catch { } }
private void txtGhiChu_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (str == "Insert") { try { if (KiemTra() == true) { CheckConflictInsert(); if (kt1 == true) { Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text); nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)client.DeserializeHepper(networkStream, kt); if (kt == true) { this.Close(); } else { MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo"); } } } } catch { } } else { try { if (KiemTra() == true) { CheckConflictUpdate(); if (kt1 == true) { Server_Client.Client client = new Server_Client.Client(); this.tcpClient = client.Connect(Luu.IP, Luu.Ports); nh = new Entities.NhomHang(); string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text); nh = new Entities.NhomHang("Update", int.Parse(id), txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh); bool kt = false; kt = (bool)client.DeserializeHepper(networkStream, kt); if (kt == true) { this.Close(); } else { MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo"); } } else { MessageBox.Show("Dữ liệu đã bị thay đổi - kiểm tra lại", "Hệ thống cảnh báo"); } } } catch { } } } }
/// <summary> /// lấy mã nhóm hàng /// </summary> public void LayMaNhomHang() { try { cbbnhomhangcaptren.Items.Clear(); cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.NhomHang nhh = new Entities.NhomHang(); nhh = new Entities.NhomHang("Select"); clientstrem = cl.SerializeObj(this.client1, "NhomHang", nhh); nhh1 = new Entities.NhomHang[1]; nhh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nhh1); if (nhh1.Length > 0) { int sl = nhh1.Length; for (int i = 0; i < sl; i++) { if (nhh1[i].Deleted == false) cbbnhomhangcaptren.Items.Add(nhh1[i].TenNhomHang); } } } catch { } }