public Entities.HangHoaGoiHang Select(Entities.HangHoaGoiHang values) { Entities.HangHoaGoiHang data = null; try { Entities.QuyDoiDonViTinh[] quydoi = new BizLogic.QuyDoiDonViTinh().Select(); if (quydoi != null) { for (int k = 0; k < quydoi.Length; k++) { if (quydoi[k].MaHangQuyDoi.ToUpper() == values.MaHang.ToUpper()) { this.HangHoa(quydoi[k].MaHangDuocQuyDoi); data = new Entities.HangHoaGoiHang(); data.TenHang = quydoi[k].TenHangDuocQuyDoi; data.MaHang = quydoi[k].MaHangDuocQuyDoi; data.SoLuong = quydoi[k].SoLuongDuocQuyDoi.ToString(); data.GiaNhap = this.gianhap; data.GiaBanBuon = this.giabanbuon; data.GiaBanLe = this.giabanle; data.Thue = this.thue; break; } } } } catch (Exception ex) { string s = ex.Message.ToString(); data = null; } return(data); }
public Entities.HangHoaGoiHang Select(Entities.HangHoaGoiHang values) { Entities.HangHoaGoiHang data = null; try { Entities.QuyDoiDonViTinh[] quydoi = new BizLogic.QuyDoiDonViTinh().Select(); if (quydoi!=null) { for (int k = 0; k < quydoi.Length; k++) { if (quydoi[k].MaHangQuyDoi.ToUpper() == values.MaHang.ToUpper()) { this.HangHoa(quydoi[k].MaHangDuocQuyDoi); data = new Entities.HangHoaGoiHang(); data.TenHang = quydoi[k].TenHangDuocQuyDoi; data.MaHang = quydoi[k].MaHangDuocQuyDoi; data.SoLuong = quydoi[k].SoLuongDuocQuyDoi.ToString(); data.GiaNhap = this.gianhap; data.GiaBanBuon = this.giabanbuon; data.GiaBanLe = this.giabanle; data.Thue = this.thue; break; } } } } catch (Exception ex) { string s = ex.Message.ToString(); data = null; } return data; }
public Entities.QuyDoiDonViTinh[] QuyDoiDonViTinh() { Entities.QuyDoiDonViTinh[] nkh1 = new BizLogic.QuyDoiDonViTinh().Select(); if (nkh1 == null) { nkh1 = new Entities.QuyDoiDonViTinh[0]; } return(nkh1); }
private void tsslbl_Click(object sender, EventArgs e) { string maKH = dgvHienThi.Rows[i].Cells["MaQuyDoiDonViTinh"].Value.ToString(); if (!frmDangNhap.User.Administrator && !CheckQuyen(this.Name, 3)) { MessageBox.Show("Bạn Không có quyền vào chức năng này."); return; } if (new Check().CheckReference("QD", maKH)) { DialogResult dlgResult = MessageBox.Show("Bạn Có Chắc Chắn muốn Xóa Quy Đổi này không?", "Đồng ý?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.QuyDoiDonViTinh kh = new Entities.QuyDoiDonViTinh(); kh = new Entities.QuyDoiDonViTinh("Delete", int.Parse(dgvHienThi.Rows[i].Cells["QuyDoiDonViTinhID"].Value.ToString()), Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap); clientstrem = cl.SerializeObj(this.client1, "QuyDoiDonViTinh", kh); bool kt = false; kt = (bool)cl.DeserializeHepper(clientstrem, kt); if (kt == true) { } //} else { MessageBox.Show("Mã Quy Đổi này đã bị xóa"); } SelectData(); } catch (Exception ex) { } } } else { MessageBox.Show("mã quy đổi này này không thể xóa! Hiện tại đang có giao dịch"); } }
public void Xuly_Select(NetworkStream clientStream) { Entities.CheckRefer nv = (Entities.CheckRefer)formatter.Deserialize(clientStream); switch (nv.TenTruong) { case "BCTraLaiNCC": { Entities.SelectAll temp = new BizLogic.SelectAll().BCTraLaiNCC(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "BCXuatHuyHangHoa": { Entities.SelectAll temp = new BizLogic.SelectAll().BCXuatHuyHangHoa(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "BCKhachHangTraHang": { Entities.SelectAll temp = new BizLogic.SelectAll().BCKhachHangTraHang(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "BCXuatNhapTonNhomHang": { Entities.SelectAll temp = new BizLogic.SelectAll().BCXuatNhapTonNhomHang(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "frmBCXuatHangTheoTungKho": { Entities.SelectAll temp = new BizLogic.SelectAll().frmBCXuatHangTheoTungKho(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "SoQuy": { Entities.SelectAll temp = new BizLogic.SelectAll().SoQuy(); formatter.Serialize(clientStream, temp); break; } case "BCDoanhThuMatHang": { Entities.SelectAll temp = new BizLogic.SelectAll().BCDoanhThuMatHang(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "BCDoanhThuNhomHang": { Entities.SelectAll temp = new BizLogic.SelectAll().BCDoanhThuNhomHang(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "TimKiemChungTu": { Entities.SelectAll temp = new BizLogic.SelectAll().TimKiemChungTu(); formatter.Serialize(clientStream, temp); break; } case "BCCongNoNhaCungCap": { Entities.SelectAll temp = new BizLogic.SelectAll().BCCongNoNhaCungCap(); formatter.Serialize(clientStream, temp); break; } case "BanBuon": { Entities.SelectAll temp = new BizLogic.SelectAll().BanBuon(); formatter.Serialize(clientStream, temp); break; } case "BCCongNoKhachHang": { Entities.SelectAll temp = new BizLogic.SelectAll().BCCongNoKhachHang(); formatter.Serialize(clientStream, temp); break; } case "BCThue": { Entities.SelectAll temp = new BizLogic.SelectAll().BCThue(nv.MaTruong); formatter.Serialize(clientStream, temp); break; } case "PXH": { Entities.PhieuXuatHuy[] nv1 = new BizLogic.CheckRefer().PhieuXuatHuy(); formatter.Serialize(clientStream, nv1); break; } case "CTPXH": { Entities.ChiTietXuatHuy[] nv1 = new BizLogic.CheckRefer().ChiTietXuatHuy(); formatter.Serialize(clientStream, nv1); break; } case "DDH": { Entities.DonDatHang[] nv1 = new BizLogic.CheckRefer().DonDatHang(); formatter.Serialize(clientStream, nv1); break; } case "PT": { Entities.PhieuThu[] nv1 = new BizLogic.CheckRefer().PhieuThu(); formatter.Serialize(clientStream, nv1); break; } case "PTTCKH": { Entities.PhieuTTCuaKH[] nv1 = new BizLogic.CheckRefer().PhieuTTCuaKH(); formatter.Serialize(clientStream, nv1); break; } case "CTPTTCKH": { Entities.ChiTietPhieuTTCuaKH[] nv1 = new BizLogic.CheckRefer().ChiTietPhieuTTCuaKH(); formatter.Serialize(clientStream, nv1); break; } case "PTTNCC": { Entities.PhieuTTNCC[] nv1 = new BizLogic.CheckRefer().PhieuTTNCC(); formatter.Serialize(clientStream, nv1); break; } case "CTPTTNCC": { Entities.ChiTietPhieuTTNCC[] nv1 = new BizLogic.CheckRefer().ChiTietPhieuTTNCC(); formatter.Serialize(clientStream, nv1); break; } case "CTDDH": { Entities.ChiTietDonDatHang[] nv1 = new BizLogic.CheckRefer().ChiTietDonDatHang(); formatter.Serialize(clientStream, nv1); break; } case "HDBH": { Entities.HDBanHang[] nv1 = new BizLogic.CheckRefer().HDBanHang(); formatter.Serialize(clientStream, nv1); break; } case "CTHDBH": { Entities.ChiTietHDBanHang[] nv1 = new BizLogic.CheckRefer().ChiTietHDBanHang(); formatter.Serialize(clientStream, nv1); break; } case "PDCKNB": { Entities.PhieuDieuChuyenKhoNoiBo[] nv1 = new BizLogic.CheckRefer().PhieuDieuChuyenKhoNoiBo(); formatter.Serialize(clientStream, nv1); break; } case "CTPDCKNB": { Entities.ChiTietPhieuDieuChuyenKho[] nv1 = new BizLogic.CheckRefer().ChiTietPhieuDieuChuyenKho(); formatter.Serialize(clientStream, nv1); break; } case "TLNCC": { Entities.TraLaiNCC[] nv1 = new BizLogic.CheckRefer().TraLaiNCC(); formatter.Serialize(clientStream, nv1); break; } case "CTTLNCC": { Entities.ChiTietTraLaiNhaCungCap[] nv1 = new BizLogic.CheckRefer().ChiTietTraLaiNCC(); formatter.Serialize(clientStream, nv1); break; } case "HDN": { Entities.HoaDonNhap[] nv1 = new BizLogic.CheckRefer().HoaDonNhap(); formatter.Serialize(clientStream, nv1); break; } case "CTHDN": { Entities.ChiTietHoaDonNhap[] nv1 = new BizLogic.CheckRefer().ChiTietHoaDonNhap(); formatter.Serialize(clientStream, nv1); break; } case "KHTL": { Entities.KhachHangTraLai[] nv1 = new BizLogic.CheckRefer().KhachHangTraLai(); formatter.Serialize(clientStream, nv1); break; } case "CTKHTL": { Entities.ChiTietKhachHangTraLai[] nv1 = new BizLogic.CheckRefer().ChiTietKhachHangTraLai(); formatter.Serialize(clientStream, nv1); break; } case "LH": { Entities.LoaiHangHoa[] nv1 = new BizLogic.CheckRefer().LoaiHangHoa(); formatter.Serialize(clientStream, nv1); break; } case "HH": { Entities.HangHoa[] nv1 = new BizLogic.CheckRefer().HangHoa(); formatter.Serialize(clientStream, nv1); break; } case "NH": { Entities.NhomHang[] nv1 = new BizLogic.CheckRefer().NhomHang(); formatter.Serialize(clientStream, nv1); break; } case "KH": { Entities.KhoHang[] nv1 = new BizLogic.CheckRefer().KhoHang(); formatter.Serialize(clientStream, nv1); break; } case "CTKH": { Entities.ChiTietKhoHangTheoHoaHonNhap[] nv1 = new BizLogic.CheckRefer().ChiTietKhoHang(); formatter.Serialize(clientStream, nv1); break; } case "GH": { Entities.GoiHang[] nv1 = new BizLogic.GoiHang().Select(); formatter.Serialize(clientStream, nv1); break; } case "CTGH": { Entities.ChiTietGoiHang[] nv1 = new BizLogic.ChiTietGoiHang().Select(); formatter.Serialize(clientStream, nv1); break; } case "QD": { Entities.QuyDoiDonViTinh[] nv1 = new BizLogic.QuyDoiDonViTinh().Select(); formatter.Serialize(clientStream, nv1); break; } default: break; } }
public void XuLy_QuyDoiDonViTinh(NetworkStream clientStream) { Entities.QuyDoiDonViTinh nkh = (Entities.QuyDoiDonViTinh)formatter.Deserialize(clientStream); switch (nkh.HanhDong) { case "Insert": { int msg = new BizLogic.QuyDoiDonViTinh().InsertUpdate(nkh); if (msg == 1) { new BizLogic.LogFile().GhiFile(new Entities.LogFile(nkh.MaNhanVien, nkh.TenDangNhap, nkh.HanhDong, DateTime.Now.ToString(), "Thêm quy đổi đơn vị tính: " + nkh.MaQuyDoiDonViTinh)); } formatter.Serialize(clientStream, msg); break; } case "Update": { int msg = new BizLogic.QuyDoiDonViTinh().InsertUpdate(nkh); if (msg == 1) { new BizLogic.LogFile().GhiFile(new Entities.LogFile(nkh.MaNhanVien, nkh.TenDangNhap, nkh.HanhDong, DateTime.Now.ToString(), "Sửa quy đổi đơn vị tính: " + nkh.MaQuyDoiDonViTinh)); } formatter.Serialize(clientStream, msg); break; } case "Delete": { new BizLogic.QuyDoiDonViTinh().Delete(nkh); bool kt = true; formatter.Serialize(clientStream, kt); break; } case "Select": { Entities.QuyDoiDonViTinh[] nkh1 = new BizLogic.QuyDoiDonViTinh().Select(); formatter.Serialize(clientStream, nkh1); break; } default: break; } }
/// <summary> /// select dữ liệu từ server /// </summary> public void SelectData() { try { i = 0; dgvHienThi.RowHeadersVisible = false; cl = new Server_Client.Client(); // gán TCPclient this.client1 = cl.Connect(Luu.IP, Luu.Ports); // khởi tạo biến truyền vào với hàm khởi tạo Entities.QuyDoiDonViTinh kh = new Entities.QuyDoiDonViTinh(); // truyền HanhDong kh = new Entities.QuyDoiDonViTinh("Select"); // khởi tạo mảng đối tượng để hứng giá trị kh1 = new Entities.QuyDoiDonViTinh[1]; clientstrem = cl.SerializeObj(this.client1, "QuyDoiDonViTinh", kh); // đổ mảng đối tượng vào datagripview kh1 = (Entities.QuyDoiDonViTinh[])cl.DeserializeHepper1(clientstrem, kh1); // lbltongs.Text = kh1.Length.ToString(); if (kh1 == null) { toolStripStatus_Xoa.Enabled = false; hienthi = new Entities.QuyDoiDonViTinh[0]; dgvHienThi.DataSource = new Entities.QuyDoiDonViTinh[0]; return; } toolStripStatus_Xoa.Enabled = true; Entities.QuyDoiDonViTinh[] pt2 = new Entities.QuyDoiDonViTinh[kh1.Length]; int sotang = 0; for (int j = 0; j < kh1.Length; j++) { if (kh1[j].Deleted == false) { pt2[sotang] = kh1[j]; sotang++; } } hienthi = new Entities.QuyDoiDonViTinh[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; } } else { dgvHienThi.DataSource = new Entities.QuyDoiDonViTinh[0]; return; } dgvHienThi.DataSource = hienthi; new Common.Utilities().CountDatagridview(dgvHienThi); dgvHienThi.Rows[0].Selected = true; } finally { try { for (int j = 1; j < dgvHienThi.ColumnCount; j++) { dgvHienThi.Columns[j].Visible = false; } dgvHienThi.Columns[0].Visible = true; dgvHienThi.Columns[0].HeaderText = "STT"; dgvHienThi.Columns["MaQuyDoiDonViTinh"].HeaderText = "Mã Quy Đổi Đơn Vị Tính"; dgvHienThi.Columns["MaHangQuyDoi"].HeaderText = "Mã Hàng Quy Đổi"; dgvHienThi.Columns["TenHangQuyDoi"].HeaderText = "Tên Hàng Quy Đổi"; dgvHienThi.Columns["MaHangDuocQuyDoi"].HeaderText = "Mã Hàng Được Quy Đổi"; dgvHienThi.Columns["TenHangDuocQuyDoi"].HeaderText = "Tên Hàng Được Quy Đổi"; dgvHienThi.Columns["MaQuyDoiDonViTinh"].Visible = true; dgvHienThi.Columns["MaHangQuyDoi"].Visible = true; dgvHienThi.Columns["TenHangQuyDoi"].Visible = true; dgvHienThi.Columns["MaHangDuocQuyDoi"].Visible = true; dgvHienThi.Columns["TenHangDuocQuyDoi"].Visible = true; dgvHienThi.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvHienThi.AllowUserToAddRows = false; dgvHienThi.AllowUserToDeleteRows = false; dgvHienThi.AllowUserToResizeRows = false; dgvHienThi.RowHeadersVisible = false; } catch { } } }
public Entities.QuyDoiDonViTinh[] QuyDoiDonViTinh() { Entities.QuyDoiDonViTinh[] nkh1 = new BizLogic.QuyDoiDonViTinh().Select(); if (nkh1 == null) nkh1 = new Entities.QuyDoiDonViTinh[0]; return nkh1; }