private void getDataTable(DataGridView dgv) { if (dgv.RowCount > 1) { toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString(); toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString(); toolStrip_txtSoluong.Text = Double.Parse(dgv[3, i].Value.ToString()).ToString(); toolStrip_txtGiagoc.Text = Double.Parse(dgv[4, i].Value.ToString()).ToString(); toolStrip_txtChietkhauphantram.Text = Double.Parse(dgv[5, i].Value.ToString()).ToString(); toolStrip_txtGianhap.Text = Double.Parse(dgv[6, i].Value.ToString()).ToString(); toolStrip_txtChietkhau.Text = Double.Parse(dgv[7, i].Value.ToString()).ToString(); Entities.HienThi_ChiTiet_DonDatHang[] hh = new Entities.HienThi_ChiTiet_DonDatHang[dgv.RowCount - 1]; int so = 0; for (int j = 0; j < dgv.RowCount; j++) { if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString()) { hh[so] = new Entities.HienThi_ChiTiet_DonDatHang("" + dgv[1, j].Value.ToString(), "" + dgv[2, j].Value.ToString(), int.Parse(0 + dgv[3, j].Value.ToString()), "" + dgv[4, j].Value.ToString(), "" + dgv[5, j].Value.ToString(), "" + dgv[6, j].Value.ToString(), "" + dgv[7, j].Value.ToString(), "" + dgv[8, j].Value.ToString()); so++; } } if (hh.Length <= 0) { dgv.DataSource = null; DoiTen(dgv); } else { dgv.DataSource = null; dgv.DataSource = hh; DoiTen(dgv); } } else { dgv.DataSource = null; } }
/// <summary> /// tim chi tiet hang hoa theo ma /// </summary> /// <param name="MaHang"></param> private void LayHangHoaTheoMa(string MaHang) { Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang); clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm); Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang(); tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra); if (tra == null) { MessageBox.Show("Mã bạn nhập không tồn tại"); } else { timerRun.Stop(); run = 0; toolStrip_txtTracuu.Text = tra.MaHangHoa; toolStrip_txtTenhang.Text = tra.TenHangHoa; toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString(); toolStrip_txtGiagoc.Text = tra.GiaGoc; toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau; toolStrip_txtGianhap.Text = tra.GiaNhap; toolStrip_txtChietkhau.Text = tra.ChietKhau; } }
/// <summary> /// do du lieu vao dgv /// </summary> private void HienThi_ChiTiet_DonDatHang() { try { Entities.DonDatHang dat = new Entities.DonDatHang(); dat.Hanhdong = "Select"; dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); dgvInsertOrder.DataSource = ddh; DoiTen(dgvInsertOrder); } catch (Exception) { } client.Close(); clientstrem.Close(); }
private void HienThi_ChiTiet_HoaDonNhap(string MaDonHang) { try { Entities.HienThi_ChiTiet_DonDatHang dat = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaDonHang); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_HoaDonNhap", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); dgvInsertOrder.DataSource = ddh; //hien thi DoiTen(dgvInsertOrder); string tong = new Common.Utilities().TongTien(dgvInsertOrder); txtTienhang.Text = tong; } catch (Exception) { } client.Close(); clientstrem.Close(); }
private void LayHangHoaTheoMa(string MaHang) { try { Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang); clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm); Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang(); tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra); if (tra.MaHangHoa == null || tra == null) { ResetTool(); MessageBox.Show("Hàng hóa không tồn tại"); toolStrip_txtTracuu.Focus(); toolStrip_txtTracuu.Text = ""; } else { GiaTriCanLuu.Ma = tra.MaHangHoa; GiaTriCanLuu.Ten = tra.TenHangHoa; GiaTriCanLuu.Giatri = tra.GiaGoc; GiaTriCanLuu.Giatri2 = tra.SoLuongDat.ToString(); GiaTriCanLuu.giatrigiatang = tra.Thuegiatrigiatang; GiaTriCanLuu.makhachhang = tra.SoLuongDat.ToString(); if (tenForm == "KhachHangTraLai") { toolStrip_txtTracuu.Text = GiaTriCanLuu.Ma; toolStrip_txtTenhang.Text = GiaTriCanLuu.Ten; toolStrip_txtGiagoc.Text = GiaTriCanLuu.Giatri; toolStrip_txtSoluong.Text = GiaTriCanLuu.Giatri2; toolStrip_txtChietkhauphantram.Text = "0"; toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString(); toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString(); thue = GiaTriCanLuu.giatrigiatang; } if (tenForm == "TraLaiNhaCungCap") { toolStrip_txtTracuu.Text = GiaTriCanLuu.Ma; toolStrip_txtTenhang.Text = GiaTriCanLuu.Ten; toolStrip_txtGiagoc.Text = GiaTriCanLuu.Giatri; toolStrip_txtSoluong.Text = GiaTriCanLuu.makhachhang; toolStrip_txtChietkhauphantram.Text = "0"; toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString(); toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString(); thue = GiaTriCanLuu.giatrigiatang; } } } catch (Exception ex) { string s = ex.Message.ToString(); } }
private void check_loaidathang_CheckedChanged(object sender, EventArgs e) { try { if (check_loaidathang.Checked == true) { lblKhohang.Text = "Cho kho hàng: "; } if (check_loaidathang.Checked == false) { lblKhohang.Text = "Trong kho: "; } txtManhacungcap.Text = "<F4-Tra cứu>"; lblTennhacungcap.Text = ""; checkData(); Entities.HienThi_ChiTiet_DonDatHang[] row = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgvInsertOrder.DataSource = row; DoiTen(dgvInsertOrder); } catch (Exception ex) { string s = ex.Message; Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgvInsertOrder.DataSource = lay; DoiTen(dgvInsertOrder); } }
/// <summary> /// xu ly du lieu /// </summary> /// <param name="chitiet"></param> private void XuLyChiTietDonDatHang(Entities.HienThi_ChiTiet_DonDatHang[] chitiet) { try { if (chitiet.Length > 0) { Entities.HienThi_ChiTiet_DonDatHang[] giatri = null; ArrayList arr = new ArrayList(); for (int i = 0; i < chitiet.Length; i++) { Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = chitiet[i].MaHangHoa; row.TenHangHoa = chitiet[i].TenHangHoa; row.SoLuongDat = chitiet[i].SoLuongDat; row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc)); row.Giabanbuon = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].Giabanbuon)); row.Giabanle = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].Giabanle)); string phantram = chitiet[i].PhanTramChietKhau; string gianhap = "0"; if (phantram == "0") { gianhap = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString())); } else { gianhap = new Common.Utilities().FormatMoney((Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString())) - ((Double.Parse(chitiet[i].PhanTramChietKhau) / 100 * Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString())))); } row.PhanTramChietKhau = phantram; row.Thuegiatrigiatang = chitiet[i].Thuegiatrigiatang; row.GiaNhap = gianhap; row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString())); arr.Add(row); } int n = arr.Count; if (n == 0) { giatri = null; } giatri = new Entities.HienThi_ChiTiet_DonDatHang[n]; for (int i = 0; i < n; i++) { giatri[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i]; } dgvInsertOrder.DataSource = null; dgvInsertOrder.DataSource = giatri; DoiTen(dgvInsertOrder); } else { dgvInsertOrder.DataSource = chitiet; DoiTen(dgvInsertOrder); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show(s); } }
private void txtManhacungcap_TextChanged(object sender, EventArgs e) { try { if (txtManhacungcap.Text == "") { ResetTool(); Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgvInsertOrder.DataSource = lay; DoiTen(dgvInsertOrder); } } catch (Exception ex) { string s = ex.Message; } }
private void NewRow() { try { if (txtManhacungcap.Text != "") { try { QuyDoi(toolStrip_txtTracuu.Text.ToUpper()); } catch { } Entities.HienThi_ChiTiet_DonDatHang add = new Entities.HienThi_ChiTiet_DonDatHang(); add.MaHangHoa = toolStrip_txtTracuu.Text.ToUpper(); add.TenHangHoa = toolStrip_txtTenhang.Text; add.SoLuongDat = int.Parse(0 + toolStrip_txtSoluong.Text); add.GiaGoc = toolStrip_txtGiagoc.Text; add.PhanTramChietKhau = Double.Parse(0 + toolStrip_txtChietkhauphantram.Text).ToString(); add.Thuegiatrigiatang = toolStrip_txtThuegiatrigiatang.Text; add.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(0 + toolStrip_txtGianhap.Text)); add.ChietKhau = toolStrip_Chietkhau.Text; add.TongTien = new Common.Utilities().FormatMoney(Double.Parse(toolStrip_txtGiagoc.Text) * int.Parse(0 + toolStrip_txtSoluong.Text)); if (Double.Parse(toolStrip_txtSoluong.Text) >= 1) { string thongbao = KiemTraMa(add); if (thongbao == "OK") { if (Double.Parse(toolStrip_txtGianhap.Text) > 0) { LayGiaTri(dgvInsertOrder, add); DoiTen(dgvInsertOrder); ResetTool(); } else { MessageBox.Show("Giá nhập của hàng không đúng"); } } else { toolStrip_txtTracuu.Focus(); MessageBox.Show("Mã hàng không đúng"); return; } } else { MessageBox.Show("Số lượng nhập không đúng"); } } else { MessageBox.Show("Chọn nhà cung cấp"); } } catch (Exception ex) { string s = ex.ToString(); } }
private void getDataTable(DataGridView dgv) { if (dgv.RowCount > 1) { toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString(); toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString(); toolStrip_txtSoluong.Text = Double.Parse(dgv[3, i].Value.ToString()).ToString(); toolStrip_txtGiagoc.Text = Double.Parse(dgv[4, i].Value.ToString()).ToString(); toolStrip_txtChietkhauphantram.Text = Double.Parse(dgv[5, i].Value.ToString()).ToString(); toolStrip_txtGianhap.Text = Double.Parse(dgv[6, i].Value.ToString()).ToString(); toolStrip_txtChietkhau.Text = Double.Parse(dgv[7, i].Value.ToString()).ToString(); Entities.HienThi_ChiTiet_DonDatHang[] hh = new Entities.HienThi_ChiTiet_DonDatHang[dgv.RowCount-1]; int so = 0; for (int j = 0; j < dgv.RowCount; j++) { if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString()) { hh[so] = new Entities.HienThi_ChiTiet_DonDatHang("" + dgv[1, j].Value.ToString(), "" + dgv[2, j].Value.ToString(), int.Parse(0 + dgv[3, j].Value.ToString()), "" + dgv[4, j].Value.ToString(), "" + dgv[5, j].Value.ToString(), "" + dgv[6, j].Value.ToString(), "" + dgv[7, j].Value.ToString(), "" + dgv[8, j].Value.ToString()); so++; } } if (hh.Length <= 0) { dgv.DataSource = null; DoiTen(dgv); } else { dgv.DataSource = null; dgv.DataSource = hh; DoiTen(dgv); } } else { dgv.DataSource = null; } }
/// <summary> /// do du lieu vao dgv /// </summary> private void HienThi_ChiTiet_DonDatHang() { try { Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri(); dat.Hanhdong = "Select"; dat.Giatritruyen = txtSodonhang.Text; cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); if (ddh.Length > 0) { XuLyChiTietDonDatHang(ddh); } else { Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgvInsertOrder.DataSource = lay; DoiTen(dgvInsertOrder); } client.Close(); clientstrem.Close(); } catch (Exception ex) { string s = ex.Message.ToString(); Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgvInsertOrder.DataSource = lay; DoiTen(dgvInsertOrder); } }
private void getDataTable(DataGridView dgv) { try { ArrayList arr = new ArrayList(); Entities.HienThi_ChiTiet_DonDatHang[] list = null; if (dgv.RowCount > 0 && i >= 0) { toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString(); toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString(); toolStrip_txtGiagoc.Text = dgv[4, i].Value.ToString(); toolStrip_txtThuegiatrigiatang.Text = dgv[8, i].Value.ToString(); giatrigiatang = dgv[8, i].Value.ToString(); toolStrip_Chietkhau.Text = "0"; toolStrip_txtGianhap.Text = (Double.Parse(0 + dgv[4, i].Value.ToString()) * int.Parse(0 + dgv[3, i].Value.ToString())).ToString(); toolStrip_txtChietkhauphantram.Text = "0"; toolStrip_txtSoluong.Text = int.Parse(0 + dgv[3, i].Value.ToString()).ToString(); for (int j = 0; j < dgv.RowCount; j++) { if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString()) { Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = dgv.Rows[j].Cells[1].Value.ToString(); row.TenHangHoa = dgv.Rows[j].Cells[2].Value.ToString(); row.SoLuongDat = int.Parse(0 + dgv.Rows[j].Cells[3].Value.ToString()); row.GiaGoc = dgv.Rows[j].Cells[4].Value.ToString(); row.PhanTramChietKhau = dgv.Rows[j].Cells[7].Value.ToString(); row.Thuegiatrigiatang = dgv.Rows[j].Cells[8].Value.ToString(); row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[j].Cells[9].Value.ToString())); row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[j].Cells[11].Value.ToString())); arr.Add(row); } } int n = arr.Count; if (n == 0) { arr = null; } list = new Entities.HienThi_ChiTiet_DonDatHang[n]; for (int x = 0; x < n; x++) { list[x] = (Entities.HienThi_ChiTiet_DonDatHang)arr[x]; } dgv.DataSource = list; } else { list = new Entities.HienThi_ChiTiet_DonDatHang[0]; arr = null; dgv.DataSource = list; DoiTen(dgv); } } catch (Exception ex) { string s = ex.Message; } }
/// <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; } } }
/// <summary> /// tim chi tiet hang hoa theo ma /// </summary> /// <param name="MaHang"></param> private void LayHangHoaTheoMa(string MaHang) { Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang); clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm); Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang(); tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra); if (tra == null) { MessageBox.Show("Mã bạn nhập không tồn tại"); } else { timerRun.Stop(); run = 0; toolStrip_txtTracuu.Text = tra.MaHangHoa; toolStrip_txtTenhang.Text = tra.TenHangHoa; toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString(); toolStrip_txtGiagoc.Text = tra.GiaGoc; toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau; toolStrip_txtGianhap.Text = tra.GiaNhap; toolStrip_txtChietkhau.Text = tra.ChietKhau; } }
private void HienThi_ChiTiet_HoaDonNhap(string MaDonHang) { try { Entities.HienThi_ChiTiet_DonDatHang dat = new Entities.HienThi_ChiTiet_DonDatHang( "Select",MaDonHang); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_HoaDonNhap", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); dgvInsertOrder.DataSource = ddh; //hien thi DoiTen(dgvInsertOrder); string tong = new Common.Utilities().TongTien(dgvInsertOrder); txtTienhang.Text = tong; } catch (Exception) { } client.Close(); clientstrem.Close(); }
public void LayGiaTri(DataGridView dgv, Entities.HienThi_ChiTiet_DonDatHang themmoi) { ArrayList arr = new ArrayList(); Entities.HienThi_ChiTiet_DonDatHang[] list = null; if (dgv.RowCount > 0) { int count = dgv.RowCount; list = new Entities.HienThi_ChiTiet_DonDatHang[count]; Boolean check = false; for (int i = 0; i < count; i++) { string sl = "1"; Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = dgv.Rows[i].Cells[1].Value.ToString(); row.TenHangHoa = dgv.Rows[i].Cells[2].Value.ToString(); if (dgv.Rows[i].Cells[1].Value.ToString() == themmoi.MaHangHoa) { sl = (Convert.ToInt32(dgv.Rows[i].Cells[3].Value.ToString()) + themmoi.SoLuongDat).ToString(); check = true; } else { sl = (Convert.ToInt32(dgv.Rows[i].Cells[3].Value.ToString())).ToString(); check = false; } row.SoLuongDat = int.Parse(sl); row.GiaGoc = dgv.Rows[i].Cells[4].Value.ToString(); row.Giabanbuon = dgv.Rows[i].Cells[5].Value.ToString(); row.Giabanle = dgv.Rows[i].Cells[6].Value.ToString(); row.PhanTramChietKhau = dgv.Rows[i].Cells[7].Value.ToString(); row.Thuegiatrigiatang = Double.Parse(0 + dgv.Rows[i].Cells[8].Value.ToString()).ToString(); row.GiaNhap = dgv.Rows[i].Cells[9].Value.ToString(); row.TongTien = dgv.Rows[i].Cells[11].Value.ToString(); arr.Add(row); } if (check == false) { Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = themmoi.MaHangHoa; row.TenHangHoa = themmoi.TenHangHoa; row.SoLuongDat = themmoi.SoLuongDat; row.GiaGoc = themmoi.GiaGoc; row.Giabanbuon = themmoi.Giabanbuon; row.Giabanle = themmoi.Giabanle; row.PhanTramChietKhau = themmoi.PhanTramChietKhau; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; row.GiaNhap = themmoi.GiaNhap; row.TongTien = themmoi.TongTien; arr.Add(row); } } else { list = new Entities.HienThi_ChiTiet_DonDatHang[1]; Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = themmoi.MaHangHoa; row.TenHangHoa = themmoi.TenHangHoa; row.SoLuongDat = themmoi.SoLuongDat; row.GiaGoc = themmoi.GiaGoc; row.Giabanbuon = themmoi.Giabanbuon; row.Giabanle = themmoi.Giabanle; row.PhanTramChietKhau = themmoi.PhanTramChietKhau; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; row.GiaNhap = themmoi.GiaNhap; row.TongTien = themmoi.TongTien; arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.HienThi_ChiTiet_DonDatHang[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i]; } dgv.DataSource = null; dgv.DataSource = list; }
/// <summary> /// do du lieu vao dgv /// </summary> private void HienThi_ChiTiet_TheoMa() { try { Entities.DonDatHang dat = new Entities.DonDatHang(); dat.Hanhdong = "Select"; dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_TheoMa", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); dgvXemthongtin.DataSource = ddh; new Common.Utilities().CountDatagridview(dgvXemthongtin); dgvXemthongtin.Columns[0].HeaderText = "STT"; dgvXemthongtin.RowHeadersVisible = false; dgvXemthongtin.Columns[1].HeaderText = "Mã hàng"; dgvXemthongtin.Columns[2].HeaderText = "Tên hàng"; dgvXemthongtin.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvXemthongtin.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } catch (Exception) { } client.Close(); clientstrem.Close(); }
/// <summary> /// tim chi tiet hang hoa theo ma /// </summary> /// <param name="MaHang"></param> private void LayHangHoaTheoMa(string MaHang) { try { Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang); clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm); Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang(); tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra); if (tra.MaHangHoa == null || tra == null) { toolStrip_txtTracuu.Focus(); frmXuLyHangHoa frm = new frmXuLyHangHoa("ThemNhapKho", toolStrip_txtTracuu.Text); frm.ShowDialog(); ResetTool(); toolStrip_txtTracuu.Text = GiaTriCanLuu.mahanghoa; } else { toolStrip_txtTracuu.Text = tra.MaHangHoa; toolStrip_txtTenhang.Text = tra.TenHangHoa; toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString(); toolStrip_txtGiagoc.Text = tra.GiaGoc; banbuon = tra.Giabanbuon; banle = tra.Giabanle; giatrigiatang = tra.Thuegiatrigiatang; toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau; //toolStrip_txtSoluong.Text = ""; toolStrip_txtSoluong.Focus(); } } catch (Exception ex) { string s = ex.Message.ToString(); } }
/// <summary> /// do du lieu vao dgv /// </summary> private void HienThi_ChiTiet_DonDatHang() { try { Entities.DonDatHang dat = new Entities.DonDatHang(); dat.Hanhdong = "Select"; dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat); Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1]; ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh); dgvInsertOrder.DataSource = ddh; DoiTen(dgvInsertOrder); } catch (Exception) { } client.Close(); clientstrem.Close(); }
/// <summary> /// hungvv them moi row ============================================================================== /// </summary> public void LayGiaTri(DataGridView dgv, Entities.HienThi_ChiTiet_DonDatHang themmoi) { try { ArrayList arr = new ArrayList(); Entities.HienThi_ChiTiet_DonDatHang[] list = null; if (dgv.RowCount > 0) { int count = dgv.RowCount; list = new Entities.HienThi_ChiTiet_DonDatHang[count]; Boolean check = false; for (int i = 0; i < count; i++) { string sl = "1"; string gn = "0"; string tong = "0"; string thue = "0"; Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = dgv.Rows[i].Cells[1].Value.ToString(); row.TenHangHoa = dgv.Rows[i].Cells[2].Value.ToString(); thue = dgv.Rows[i].Cells[8].Value.ToString(); if (dgv.Rows[i].Cells[1].Value.ToString() == themmoi.MaHangHoa) { sl = (int.Parse(dgv.Rows[i].Cells[3].Value.ToString()) + themmoi.SoLuongDat).ToString(); tong = new Common.Utilities().FormatMoney(Double.Parse(sl) * Double.Parse(dgv.Rows[i].Cells[4].Value.ToString())); if (Double.Parse(dgv.Rows[i].Cells[7].Value.ToString()) == 0) { gn = new Common.Utilities().FormatMoney((Double.Parse(tong))); } else { gn = new Common.Utilities().FormatMoney(Double.Parse(tong) - ((Double.Parse(dgv.Rows[i].Cells[7].Value.ToString()) / 100 * Double.Parse(dgv.Rows[i].Cells[4].Value.ToString())) * Double.Parse(sl))); } check = true; } else { sl = dgv.Rows[i].Cells[3].Value.ToString(); tong = dgv.Rows[i].Cells[11].Value.ToString(); gn = dgv.Rows[i].Cells[9].Value.ToString(); } row.SoLuongDat = int.Parse(sl); row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[i].Cells[4].Value.ToString())); row.PhanTramChietKhau = dgv.Rows[i].Cells[7].Value.ToString(); row.Thuegiatrigiatang = thue; row.GiaNhap = gn; row.TongTien = tong; arr.Add(row); } if (check == false) { Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = themmoi.MaHangHoa; row.TenHangHoa = themmoi.TenHangHoa; row.SoLuongDat = themmoi.SoLuongDat; row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaGoc)); row.PhanTramChietKhau = themmoi.PhanTramChietKhau; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaNhap)); row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(themmoi.TongTien)); arr.Add(row); } } else { list = new Entities.HienThi_ChiTiet_DonDatHang[1]; Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = themmoi.MaHangHoa; row.TenHangHoa = themmoi.TenHangHoa; row.SoLuongDat = themmoi.SoLuongDat; row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaGoc)); row.PhanTramChietKhau = themmoi.PhanTramChietKhau; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaNhap)); row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(themmoi.TongTien)); arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.HienThi_ChiTiet_DonDatHang[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i]; } dgv.DataSource = null; dgv.DataSource = list; DoiTen(dgvInsertOrder); } catch (Exception ex) { string s = ex.Message; Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0]; dgv.DataSource = lay; DoiTen(dgvInsertOrder); } }