private void btnTimmakhachhang_Click(object sender, EventArgs e) { try { Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = lay; fixDatagridview(); ResetTool(); TraCuuMa(); } catch (Exception ex) { string s = ex.Message; } }
private void TimChungTuKhachHang() { GiaTriCanLuu.Giatri = loaihoadon(rdoBanbuon, rdoBanle); if (GiaTriCanLuu.Giatri == "BanBuon") { if (txtMakhachhang.Text != "<F4 - Tra cứu>" && txtMakhachhang.Text.Length > 0) { Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = lay; fixDatagridview(); ResetTool(); string makho = cbxKhoHang.SelectedValue.ToString(); frmTraCuu fr = new frmTraCuu("HangTraLai_KhachHangTraLai_MaDonHang", "HoaDonBanHang", txtMakhachhang.Text, makho, ""); fr.ShowDialog(); Binding(); } else { MessageBox.Show("Nhập khách hàng"); txtMakhachhang.Focus(); } } else { string makh = ""; if (txtMakhachhang.Text == "<F4 - Tra cứu>" || txtMakhachhang.Text.Length <= 0) makh = ""; else makh = txtMakhachhang.Text; Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = lay; fixDatagridview(); ResetTool(); string makho = cbxKhoHang.SelectedValue.ToString(); frmTraCuu fr = new frmTraCuu("HangTraLai_KhachHangTraLai_MaDonHang", "HoaDonBanHang", makh, makho, ""); fr.ShowDialog(); Binding(); } }
private void TimChungTuNhaCungCap() { if (txtMakhachhang.Text != "<F4 - Tra cứu>" && txtMakhachhang.Text.Length > 0) { Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = lay; fixDatagridview(); ResetTool(); string makho = cbxKhoHang.SelectedValue.ToString(); frmTraCuu fr = new frmTraCuu("HangTraLai_DonDatHangNhaCungCap", "TimHoaDonNhapTheoMa", txtMakhachhang.Text, makho, ""); fr.ShowDialog(); Binding(); } else { MessageBox.Show("Nhập nhà cung cấp"); txtMakhachhang.Focus(); } }
private void NewRow(string hanhdong) { try { if (txtMakhachhang.Text != "") { try { QuyDoi(toolStrip_txtTracuu.Text.ToUpper()); } catch { } Entities.LayHangHoaTheoMaKhachHangTraLai add = new Entities.LayHangHoaTheoMaKhachHangTraLai(); add.Mahanghoa = toolStrip_txtTracuu.Text; string thongbao = KiemTraMa(add); add.Tenhanghoa = toolStrip_txtTenhang.Text; add.Soluong = int.Parse(toolStrip_txtSoluong.Text); add.Giaban = toolStrip_txtGiagoc.Text; add.Phantramchietkhau = Double.Parse(0 + toolStrip_txtChietkhauphantram.Text).ToString(); add.Chietkhau = Double.Parse(0 + toolStrip_Chietkhau.Text).ToString(); add.Tongtien = Double.Parse(0 + toolStrip_txtTongTien.Text).ToString(); add.Thuegiatrigiatang = thue; if (thongbao == "NO") { MessageBox.Show("Mã hàng không đúng"); toolStrip_txtTracuu.Focus(); toolStrip_txtTracuu.Text = ""; return; } else { LayGiaTri(dgvXemthongtin, add); ResetTool(); } } else { ResetTool(); MessageBox.Show("Chọn nhà cung cấp"); return; } } catch (Exception ex) { string s = ex.ToString(); } }
private void rdoBanle_CheckedChanged(object sender, EventArgs e) { try { if (hanhDong == "Sua_KhachHangTraLai") { if (rdoBanle.Checked == true) { txtChungtugoc.Text = "<F4 - Tra cứu>"; dgvXemthongtin.DataSource = null; Entities.LayHangHoaTheoMaKhachHangTraLai[] row = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = row; fixDatagridview(); capnhat(); ResetTool(); toolStripLabel5.Text = "GBL"; toolStripLabel5.ToolTipText = "Giá bán lẻ"; txtThanhtoanngay.Text = "0"; txtTongtienthanhtoan.Text = "0"; txtSodu.Text = "0"; } } } catch (Exception ex) { string s = ex.Message; } }
private void LayHangHoaTheoMaTraLaiNhaCungCap(string matralainhacungcap) { try { string loai = loaihoadon(rdoBanbuon, rdoBanle); Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri("Select", matralainhacungcap); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaTraLaiNhaCungCap", dat); Entities.LayHangHoaTheoMaKhachHangTraLai[] ddh = new Entities.LayHangHoaTheoMaKhachHangTraLai[1]; ddh = (Entities.LayHangHoaTheoMaKhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh); client.Close(); clientstrem.Close(); if (ddh.Length <= 0) { dgvXemthongtin.DataSource = null; Entities.LayHangHoaTheoMaKhachHangTraLai[] hay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = hay; } else { dgvXemthongtin.DataSource = ddh; } fixDatagridview(); TinhToan(); } catch (Exception ex) { string s = ex.Message.ToString(); dgvXemthongtin.DataSource = null; Entities.LayHangHoaTheoMaKhachHangTraLai[] hay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = hay; } }
private void LayHangHoaTheoMaHoaDonNhap(string ma) { try { Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri("Select", "", ma); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "TimHangHoaTheoMaHoaDonNhap", dat); Entities.LayHangHoaTheoMaKhachHangTraLai[] ddh = new Entities.LayHangHoaTheoMaKhachHangTraLai[1]; ddh = (Entities.LayHangHoaTheoMaKhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh); dgvXemthongtin.DataSource = ddh; dgvXemthongtin.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvXemthongtin.SelectionMode = DataGridViewSelectionMode.FullRowSelect; client.Close(); clientstrem.Close(); } catch (Exception ex) { string s = ex.Message.ToString(); } }
public void LayGiaTri(DataGridView dgv, Entities.LayHangHoaTheoMaKhachHangTraLai themmoi) { try { ArrayList arr = new ArrayList(); Entities.LayHangHoaTheoMaKhachHangTraLai[] list = null; if (dgv.RowCount > 0) { int count = dgv.RowCount; list = new Entities.LayHangHoaTheoMaKhachHangTraLai[count]; Boolean check = false; for (int i = 0; i < count; i++) { string sl = "1"; Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai(); row.Mahanghoa = dgv.Rows[i].Cells[0].Value.ToString(); row.Tenhanghoa = dgv.Rows[i].Cells[1].Value.ToString(); if (dgv.Rows[i].Cells[0].Value.ToString() == themmoi.Mahanghoa) { sl = (Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString()) + themmoi.Soluong).ToString(); row.Phantramchietkhau = dgv.Rows[i].Cells[4].Value.ToString(); row.Chietkhau = (Convert.ToDouble(dgv.Rows[i].Cells[5].Value.ToString()) + Convert.ToDouble(toolStrip_Chietkhau.Text)).ToString(); row.Tongtien = (Convert.ToDouble(dgv.Rows[i].Cells[6].Value.ToString()) + Convert.ToDouble(toolStrip_txtTongTien.Text)).ToString(); row.Thuegiatrigiatang = dgv.Rows[i].Cells[7].Value.ToString(); check = true; } else { sl = (Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString())).ToString(); row.Phantramchietkhau = dgv.Rows[i].Cells[4].Value.ToString(); row.Chietkhau = dgv.Rows[i].Cells[5].Value.ToString(); row.Tongtien = dgv.Rows[i].Cells[6].Value.ToString(); row.Thuegiatrigiatang = dgv.Rows[i].Cells[7].Value.ToString(); } row.Soluong = int.Parse(sl); row.Giaban = dgv.Rows[i].Cells[3].Value.ToString(); arr.Add(row); } if (check == false) { Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai(); row.Mahanghoa = themmoi.Mahanghoa; row.Tenhanghoa = themmoi.Tenhanghoa; row.Soluong = themmoi.Soluong; row.Giaban = themmoi.Giaban; row.Phantramchietkhau = themmoi.Phantramchietkhau; row.Chietkhau = themmoi.Chietkhau; row.Tongtien = themmoi.Tongtien; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; arr.Add(row); check = true; } } else { list = new Entities.LayHangHoaTheoMaKhachHangTraLai[1]; Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai(); row.Mahanghoa = themmoi.Mahanghoa; row.Tenhanghoa = themmoi.Tenhanghoa; row.Soluong = themmoi.Soluong; row.Giaban = themmoi.Giaban; row.Phantramchietkhau = themmoi.Phantramchietkhau; row.Chietkhau = themmoi.Chietkhau; row.Tongtien = themmoi.Tongtien; row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang; arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.LayHangHoaTheoMaKhachHangTraLai[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[i]; } if (list.Length > 0) { dgv.DataSource = list; fixDatagridview(); } else { Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgv.DataSource = lay; fixDatagridview(); } } catch (Exception ex) { string s = ex.Message; Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgv.DataSource = lay; fixDatagridview(); } }
private void getDataTableNhaCungCap(DataGridView dgv) { try { ArrayList arr = new ArrayList(); Entities.LayHangHoaTheoMaKhachHangTraLai[] list = null; if (dgv.RowCount > 0 && i >= 0) { toolStrip_txtTracuu.Text = dgv[0, i].Value.ToString(); toolStrip_txtTenhang.Text = dgv[1, i].Value.ToString(); toolStrip_txtSoluong.Text = dgv[2, i].Value.ToString(); toolStrip_txtGiagoc.Text = dgv[3, i].Value.ToString(); toolStrip_txtChietkhauphantram.Text = "0"; toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtSoluong.Text) * Double.Parse(toolStrip_txtGiagoc.Text)).ToString(); toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtSoluong.Text) * Double.Parse(toolStrip_txtGiagoc.Text)).ToString(); thue = dgv[7, i].Value.ToString(); for (int j = 0; j < dgv.RowCount; j++) { if (dgv[0, j].Value.ToString() != dgv[0, i].Value.ToString()) { Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai(); row.Mahanghoa = dgv.Rows[j].Cells[0].Value.ToString(); row.Tenhanghoa = "" + dgv.Rows[j].Cells[1].Value.ToString(); row.Soluong = int.Parse(dgv.Rows[j].Cells[2].Value.ToString()); row.Giaban = dgv.Rows[j].Cells[3].Value.ToString(); row.Phantramchietkhau = dgv.Rows[j].Cells[4].Value.ToString(); row.Chietkhau = dgv.Rows[j].Cells[5].Value.ToString(); row.Tongtien = dgv.Rows[j].Cells[6].Value.ToString(); row.Thuegiatrigiatang = dgv.Rows[j].Cells[7].Value.ToString(); arr.Add(row); } else { continue; } } int n = arr.Count; if (n == 0) { arr = null; } list = new Entities.LayHangHoaTheoMaKhachHangTraLai[n]; for (int x = 0; x < n; x++) { list[x] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[x]; } dgv.DataSource = list; } else { list = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; arr = null; dgv.DataSource = list; fixDatagridview(); } } catch (Exception ex) { string s = ex.Message; } }
private void format() { if (dgvXemthongtin.RowCount <= 0) { dgvXemthongtin.DataSource = null; Entities.LayHangHoaTheoMaKhachHangTraLai[] row = new Entities.LayHangHoaTheoMaKhachHangTraLai[0]; dgvXemthongtin.DataSource = row; } toolStrip_txtTracuu.Text = ""; toolStrip_txtSoluong.Text = "1"; toolStrip_txtChietkhauphantram.Text = "0"; toolStrip_txtTenhang.Text = ""; toolStrip_txtGiagoc.Text = "0"; }