private void SelectDataHDNhap(string maKho) { try { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", new Entities.HoaDonNhap("Select", "", maKho, 1)); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); if (ddh == null) { return; } List <Entities.HoaDonNhap> L = new List <Entities.HoaDonNhap>(); foreach (Entities.HoaDonNhap item in ddh) { if (item.MaKho.ToUpper().Equals(maKho.ToUpper())) { L.Add(item); } } dgvHienThi.DataSource = L.ToArray(); FixDataGridView(); } catch { } }
public void SelectData(string str) { try { Entities.HoaDonNhap ctdh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.HoaDonNhap("Select"); clientstrem = cl.SerializeObj(this.client1, "HDN", ctdh); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); if (ddh == null) { hienthi = new Entities.HoaDonNhap[0]; dtgvKH.DataSource = hienthi; return; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[ddh.Length]; int sotang = 0; for (int j = 0; j < ddh.Length; j++) { if (ddh[j].Deleted == false && ddh[j].MaNhaCungCap == str) { double ttn = Convert.ToDouble(ddh[j].ThanhToanNgay); double ttnklp = Convert.ToDouble(ddh[j].ThanhToanSauKhiLapPhieu); double tt = Convert.ToDouble(ddh[j].TongTien); if ((ttn + ttnklp) != tt) { pt2[sotang] = ddh[j]; sotang++; } } } hienthi = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; } } else { hienthi = new Entities.HoaDonNhap[0]; dtgvKH.DataSource = hienthi; return; } dtgvKH.DataSource = hienthi; dtgvKH.Rows[0].Selected = true; } catch (Exception ex) { } finally { fix(); } }
public void LayHDNhap() { try { List <Entities.HoaDonNhap> listTemp = new List <Entities.HoaDonNhap>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", ""); clientstrem = cl.SerializeObj(this.client, "Select", ctxh); Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } // for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { listTemp.Add(HDN[i]); } } // HoaDonNhap = listTemp.ToArray(); } catch { } }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.HoaDonNhap getDatagridview() { Entities.HoaDonNhap dathang = new Entities.HoaDonNhap(); int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; dathang.MaHoaDonNhap = "" + dgvHienThi.Rows[vitri].Cells[2].Value.ToString().ToUpper(); dathang.NgayNhap = DateTime.Parse("" + dgvHienThi.Rows[vitri].Cells[3].Value.ToString()); dathang.MaNhaCungCap = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString().ToUpper(); dathang.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); dathang.NguoiGiaoHang = "" + dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); dathang.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells[7].Value.ToString(); dathang.MaKho = "" + dgvHienThi.Rows[vitri].Cells[8].Value.ToString().ToUpper(); dathang.DieuKienThanhToan = "" + dgvHienThi.Rows[vitri].Cells[9].Value.ToString(); dathang.MaDonDatHang = "" + dgvHienThi.Rows[vitri].Cells[11].Value.ToString().ToUpper(); dathang.HanThanhToan = DateTime.Parse(dgvHienThi.Rows[vitri].Cells[10].Value.ToString()); dathang.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells[12].Value.ToString().ToUpper(); dathang.ChietKhau = dgvHienThi.Rows[vitri].Cells[13].Value.ToString(); dathang.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells[14].Value.ToString(); dathang.ThueGTGT = dgvHienThi.Rows[vitri].Cells[15].Value.ToString(); dathang.TongTien = dgvHienThi.Rows[vitri].Cells[16].Value.ToString(); dathang.GhiChu = "" + dgvHienThi.Rows[vitri].Cells[17].Value.ToString(); } return(dathang); }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { string month1 = hdn[j].NgayNhap.Month.ToString(); string year1 = hdn[j].NgayNhap.Year.ToString(); if (hdn[j].Deleted == false && month1 == month && year == year1 && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else { hdn = new Entities.HoaDonNhap[0]; } } catch { } }
private void toolStripStatus_ThemMoi_Click(object sender, EventArgs e) { try { if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 4)) { return; } for (int j = 0; j < 100; j++) { if (BaoDong == "") { frmXuLyNhapKho fr = new frmXuLyNhapKho("Insert"); fr.ShowDialog(); Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri(); tra = new Common.Utilities().CaiDatKho("View", "", ""); Entities.HoaDonNhap nhap = new Entities.HoaDonNhap(); nhap.Hanhdong = "Select"; nhap.MaHoaDonNhap = ""; nhap.MaKho = tra.Giatritruyen; SelectData(nhap); } else { BaoDong = ""; break; } } } catch (Exception ex) { string s = ex.Message; } }
/// <summary> /// hungvv kiem tra dinh dang khi them moi hoa don /// </summary> /// <param name="maDonDatHang"></param> private Boolean CheckData(Entities.HoaDonNhap dat) { if (dat.MaHoaDonNhap.Length <= 0) { txtSodonhang.Focus(); System.Windows.Forms.MessageBox.Show("Hãy nhập mã hóa đơn"); return(false); } else { if (dat.MaNhaCungCap.Length <= 0) { txtManhacungcap.Focus(); MessageBox.Show("Kiểm tra mã nhà cung cấp"); return(false); } else { if (dat.DieuKienThanhToan.Length <= 0) { cbxDieuKienThanhToan.Focus(); MessageBox.Show("Chọn điều kiện thanh toán"); return(false); } else { if (dat.MaKho.Length <= 0) { cbxKhoHang.Focus(); MessageBox.Show("Chọn mã kho"); return(false); } else { if (dat.MaTienTe.Length <= 0) { cbxTienTe_TyGia.Focus(); MessageBox.Show("Loại tiền tệ không đúng"); return(false); } else { if (dat.MaDonDatHang.Length <= 0 && chekChonLoai.Checked == true) { txtMadondathang.Text = ""; txtMadondathang.Focus(); System.Windows.Forms.MessageBox.Show("Hãy nhập mã đơn đặt hàng"); return(false); } else { return(true); } } } } } } }
/// <summary> /// hungvv =======================giao tiep voi server=========================== /// </summary> private void Select_ChiTietHoaDonNhap(string hanhdong) { Entities.HoaDonNhap pt = new Entities.HoaDonNhap(); pt = new Entities.HoaDonNhap(hanhdong); Entities.ChiTietHoaDonNhap[] pt1 = new Entities.ChiTietHoaDonNhap[10]; clientstrem = cl.SerializeObj(this.client, "ChiTietHoaDonNhap", pt); Binding((Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper(clientstrem, pt1)); }
public Entities.HoaDonNhap[] HoaDonNhap() { Entities.HoaDonNhap[] hdn = new BizLogic.HoaDonNhap().Select(); if (hdn == null) { hdn = new Entities.HoaDonNhap[0]; } return(hdn); }
private Entities.HoaDonNhap HanThanhToanNhoNhat(List <Entities.HoaDonNhap> l) { Entities.HoaDonNhap kq = new Entities.HoaDonNhap(); int temp = 31; foreach (Entities.HoaDonNhap item in l) { temp = item.HanThanhToan.Day; kq = item; } return(kq); }
private void toolStripStatusLabel2_Click(object sender, EventArgs e) { try { Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri(); tra = new Common.Utilities().CaiDatKho("View", "", ""); Entities.HoaDonNhap nhap = new Entities.HoaDonNhap(); nhap.Hanhdong = "Select"; nhap.MaHoaDonNhap = ""; nhap.MaKho = tra.Giatritruyen; SelectData(nhap); } catch (Exception ex) { string s = ex.Message; } }
private void txtTimkiem_TextChanged(object sender, EventArgs e) { try { SearchData(rdbMa, rdbNgay, rdoTatca, dgvHienThi, txtTimkiem.Text, hoadonnhap); } catch (Exception ex) { string s = ex.Message; Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgvHienThi.DataSource = k; FixDatagridview(dgvHienThi); count = 1; } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dtgvKH.DataSource = new Entities.HoaDonNhap[0]; return; } int soluong = 0; if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvKH.DataSource = new Entities.HoaDonNhap[0]; return; } Entities.HoaDonNhap[] hienthitheoma = new Entities.HoaDonNhap[soluong]; soluong = 0; for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthi[i]; soluong++; } } dtgvKH.DataSource = hienthitheoma; } } finally { fix(); } }
/// <summary> /// hungvv =======================giao tiep voi server=========================== /// </summary> private void SelectData() { dgvHienThi.DataSource = null; ctdh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.HoaDonNhap("Select"); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); dgvHienThi.DataSource = ddh; dgvHienThi.Columns[1].Visible = false; dgvHienThi.Columns[0].HeaderText = "STT"; new Common.Utilities().CountDatagridview(dgvHienThi); client.Close(); clientstrem.Close(); }
public void LayHDNhap() { try { Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = new BizLogic.HoaDonNhap().Select(); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } int count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { count++; } } Entities.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { HoaDonNhap1[count] = HDN[i]; count++; } } if (HoaDonNhap1.Length == 0) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } else { HoaDonNhap = HoaDonNhap1; } } catch { } }
private void XuLy_Xoa_HoaDonNhap(string hanhdong, string mahoadonnhap) { Entities.HoaDonNhap them = new Entities.HoaDonNhap(); them = new Entities.HoaDonNhap(hanhdong, mahoadonnhap); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", them); //hứng giá trị trả về int trave; Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1]; trave = (int)cl.DeserializeHepper(clientstrem, tralai); //thong bao if (trave == 1) { MessageBox.Show("Thành công !"); } else { MessageBox.Show("Thất bại !"); } }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { if (hdn == null || hdn.Length == 0) { hdn = new Entities.HoaDonNhap[0]; return; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { DateTime hientai = hdn[j].NgayNhap; if (hdn[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date&& hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else { hdn = new Entities.HoaDonNhap[0]; } } catch (Exception ex) { } finally { } }
/// <summary> /// hungvv =======================Xoa =========================== /// </summary> private void DeleteData(string ID) { ctdh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.HoaDonNhap("Delete",ID); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh); int trave = 0; trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave)); client.Close(); clientstrem.Close(); if (trave == 1) { SelectData(); MessageBox.Show("Thành công !"); } if (trave == 0) { MessageBox.Show("Thất bại !"); } }
/// <summary> /// hungvv =================do du lieu vao txt=========================== /// </summary> /// <param name="dat"></param> private void DoDuLieu(Entities.HoaDonNhap dat) { Common.Utilities com = new Common.Utilities(); txtSodonhang.Text = dat.MaHoaDonNhap; txtManhacungcap.Text = dat.MaNhaCungCap; GiaTriCanLuu.Ma = dat.MaNhaCungCap; makNgaydonhang.Text = com.XuLy(2, dat.NgayNhap.ToString()); makHanthanhtoan.Text = com.XuLy(2, dat.HanThanhToan.ToString()); txtNohienthoi.Text = dat.NoHienThoi.ToString(); txtnguoigiaohang.Text = dat.NguoiGiaoHang; cbxHinhthucthanhtoan.SelectedItem = dat.HinhThucThanhToan; cbxKhoHang.SelectedValue = dat.MaKho; cbxDieuKienThanhToan.SelectedItem = dat.DieuKienThanhToan; txtMadondathang.Text = dat.MaDonDatHang; cbxTienTe_TyGia.SelectedValue = dat.MaTienTe; txtChietkhau.Text = dat.ChietKhau.ToString(); txtThanhtoanngay.Text = dat.ThanhToanNgay.ToString(); txtGiatrigiatang.Text = dat.ThueGTGT.ToString(); txtTongtien.Text = dat.TongTien.ToString(); txtDiengiai.Text = dat.GhiChu; //HienThi_ChiTiet_HoaDonNhap(); }
/// <summary> /// hungvv =======================Xoa =========================== /// </summary> private void DeleteData(string ID) { ctdh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.HoaDonNhap("Delete", ID); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh); int trave = 0; trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave)); client.Close(); clientstrem.Close(); if (trave == 1) { SelectData(); MessageBox.Show("Thành công !"); } if (trave == 0) { MessageBox.Show("Thất bại !"); } }
private void SelectData(Entities.HoaDonNhap nhap) { try { dgvHienThi.DataSource = null; cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", nhap); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); client.Close(); clientstrem.Close(); if (ddh.Length > 0) { hoadonnhap = new Entities.HoaDonNhap[ddh.Length]; hoadonnhap = ddh; dgvHienThi.DataSource = null; dgvHienThi.DataSource = hoadonnhap; } else { dgvHienThi.DataSource = null; Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgvHienThi.DataSource = lay; hoadonnhap = null; } FixDatagridview(dgvHienThi); } catch (Exception ex) { string s = ex.Message; Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgvHienThi.DataSource = lay; FixDatagridview(dgvHienThi); hoadonnhap = null; } }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.HoaDonNhap getDatagridview() { Entities.HoaDonNhap dathang = new Entities.HoaDonNhap(); int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; dathang.MaHoaDonNhap = "" + dgvHienThi.Rows[vitri].Cells[2].Value.ToString().ToUpper(); dathang.NgayNhap = DateTime.Parse("" + dgvHienThi.Rows[vitri].Cells[3].Value.ToString()); dathang.MaNhaCungCap = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString().ToUpper(); dathang.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); dathang.NguoiGiaoHang = ""+dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); dathang.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells[7].Value.ToString(); dathang.MaKho = "" + dgvHienThi.Rows[vitri].Cells[8].Value.ToString().ToUpper(); dathang.DieuKienThanhToan = "" + dgvHienThi.Rows[vitri].Cells[9].Value.ToString(); dathang.MaDonDatHang = "" + dgvHienThi.Rows[vitri].Cells[11].Value.ToString().ToUpper(); dathang.HanThanhToan = DateTime.Parse(dgvHienThi.Rows[vitri].Cells[10].Value.ToString()); dathang.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells[12].Value.ToString().ToUpper(); dathang.ChietKhau = dgvHienThi.Rows[vitri].Cells[13].Value.ToString(); dathang.ThanhToanNgay =dgvHienThi.Rows[vitri].Cells[14].Value.ToString(); dathang.ThueGTGT = dgvHienThi.Rows[vitri].Cells[15].Value.ToString(); dathang.TongTien = dgvHienThi.Rows[vitri].Cells[16].Value.ToString(); dathang.GhiChu = "" + dgvHienThi.Rows[vitri].Cells[17].Value.ToString(); } return dathang; }
public void LayHDNhap() { try { Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = new BizLogic.HoaDonNhap().Select(); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } int count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { count++; } } Entities.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { HoaDonNhap1[count] = HDN[i]; count++; } } if (HoaDonNhap1.Length == 0) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } else HoaDonNhap = HoaDonNhap1; } catch { } }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { if (hdn == null || hdn.Length == 0) { hdn = new Entities.HoaDonNhap[0]; return; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { string month1 = hdn[j].NgayNhap.Month.ToString(); string year1 = hdn[j].NgayNhap.Year.ToString(); if (hdn[j].Deleted == false && month1 == month && year1 == year) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else hdn = new Entities.HoaDonNhap[0]; } catch { } }
private void SelectDataHDNhap(string maKho) { try { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", new Entities.HoaDonNhap("Select", "", maKho, 1)); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); if (ddh == null) { return; } List<Entities.HoaDonNhap> L = new List<Entities.HoaDonNhap>(); foreach (Entities.HoaDonNhap item in ddh) { if (item.MaKho.ToUpper().Equals(maKho.ToUpper())) { L.Add(item); } } dgvHienThi.DataSource = L.ToArray(); FixDataGridView(); } catch { } }
public void LayHDNhap() { try { List<Entities.HoaDonNhap> listTemp = new List<Entities.HoaDonNhap>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", ""); clientstrem = cl.SerializeObj(this.client, "Select", ctxh); Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } // for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { listTemp.Add(HDN[i]); } } // HoaDonNhap = listTemp.ToArray(); } catch { } }
public frmXuLy_HoaDonNhap(string hanhdong, Entities.HoaDonNhap hoa) { InitializeComponent(); this.hanhdong = hanhdong; this.hoadon = hoa; }
/// <summary> /// them moi, sua thong tin don dat hang /// </summary> /// <param name="hanhdong"></param> private void XuLy_HoaDonNhap(string hanhdong) { try { Entities.HoaDonNhap don = new Entities.HoaDonNhap(); string thoigian_1 = null; thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text); string thoigian_2 = null; thoigian_2 = new Common.Utilities().MyDateConversion(makHanthanhtoan.Text); if (thoigian_1 != null && thoigian_2 != null) { don.NgayNhap = DateTime.Parse(thoigian_1); thoigian_1 = null; don.HanThanhToan = DateTime.Parse(thoigian_2); thoigian_2 = null; don.Hanhdong = hanhdong; don.MaHoaDonNhap = "" + txtSodonhang.Text.ToUpper(); don.MaNhaCungCap = "" + txtManhacungcap.Text.ToUpper(); don.NoHienThoi = 0+txtNohienthoi.Text; don.NguoiGiaoHang = "" + txtnguoigiaohang.Text; don.HinhThucThanhToan = "" + cbxHinhthucthanhtoan.SelectedItem.ToString(); don.MaKho = "" + cbxKhoHang.SelectedValue.ToString().ToUpper(); don.DieuKienThanhToan = "" + cbxDieuKienThanhToan.SelectedItem.ToString(); string MaDonDatHang = txtMadondathang.Text.ToUpper(); if (MaDonDatHang == "<F4 -TRA CỨU>" || MaDonDatHang.Length <= 0) { MaDonDatHang = "NULL"; } don.MaDonDatHang = MaDonDatHang; don.MaTienTe = "" + cbxTienTe_TyGia.SelectedValue.ToString().ToUpper(); don.ChietKhau = 0+txtChietkhau.Text; don.ThanhToanNgay = 0+txtThanhtoanngay.Text; don.ThueGTGT = 0+txtGiatrigiatang.Text; don.TongTien = 0+txtTongtien.Text; don.GhiChu = txtDiengiai.Text; don.Deleted = false; if (dgvInsertOrder.RowCount > 0) { if (CheckData(don) == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", don); Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave == 1) { LuuChiTietDonHang(); //cap nhat trang thai don dat hang CapNhatTrangThaiDonDatHang("Update",MaDonDatHang,"Đã thành công"); MessageBox.Show("Thành công"); frmHienThi_HoaDonNhap.BaoDong = ""; this.Close(); } else { MessageBox.Show("Thất bại"); } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { if (hdn == null || hdn.Length == 0) { hdn = new Entities.HoaDonNhap[0]; return; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { DateTime hientai = hdn[j].NgayNhap; if (hdn[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date && hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else hdn = new Entities.HoaDonNhap[0]; } catch (Exception ex) { } finally { } }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { string month1 = hdn[j].NgayNhap.Month.ToString(); string year1 = hdn[j].NgayNhap.Year.ToString(); if (hdn[j].Deleted == false && month1 == month && year == year1 && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else hdn = new Entities.HoaDonNhap[0]; } catch { } }
public frmXuLy_HoaDonNhap(string hanhdong,Entities.HoaDonNhap hoa) { InitializeComponent(); this.hanhdong = hanhdong; this.hoadon = hoa; }
//Entities.HDBanHang[] hienthi; public void SelectDatancc() { try { DateTime dateSerVer = DateServer.Date(); 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.HoaDonNhap pt = new Entities.HoaDonNhap("Select"); // khởi tạo mảng đối tượng để hứng giá trị pt1 = new Entities.HoaDonNhap[1]; clientstrem = cl.SerializeObj(this.client1, "HDN", pt); // đổ mảng đối tượng vào datagripview pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) pt1 = new Entities.HoaDonNhap[0]; if (int.Parse(duno) != 0) { List<Entities.HoaDonNhap> l = new List<Entities.HoaDonNhap>(); for (int j = 0; j < pt1.Length; j++) { double noHienThoi = 0; double thanhToanNgay = 0; double tongTien = 0; double thanhToanNgayKhiLapPhieu = 0; DateTime hanThanhToan = pt1[j].HanThanhToan; int YY = dateSerVer.Year; int MM = dateSerVer.Month; int DD = dateSerVer.Day; if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay)) thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay); if (!string.IsNullOrEmpty(pt1[j].TongTien)) tongTien = double.Parse(pt1[j].TongTien); if (!string.IsNullOrEmpty(pt1[j].ThanhToanSauKhiLapPhieu)) thanhToanNgayKhiLapPhieu = double.Parse(pt1[j].ThanhToanSauKhiLapPhieu); noHienThoi = thanhToanNgay + thanhToanNgayKhiLapPhieu - tongTien; if (pt1[j].MaNhaCungCap.Equals(mancc) && YY == hanThanhToan.Year && MM == hanThanhToan.Month && (hanThanhToan.Day - DD) <= 3 && (hanThanhToan.Day - DD) >= 0 && (noHienThoi != 0)) { l.Add(pt1[j]); } } Entities.HoaDonNhap hdn = HanThanhToanNhoNhat(l); if (hdn != null && !string.IsNullOrEmpty(hdn.MaHoaDonNhap)) label1.Text = "Sắp tới hạn thanh toán với nhà cung cấp " + hdn.HanThanhToan.ToString("dd/MM/yyyy"); } } catch { } }
/// <summary> /// kiểm tra dtgv trước khi update /// </summary> /// <param name="dgv"></param> public bool CheckDataGridUpdate(DataGridView dgv) { bool kkt = false; try { if (dgv.RowCount != 0) { Entities.HoaDonNhap[] cthdbh = new Entities.HoaDonNhap[dgv.RowCount]; for (int j = 0; j < cthdbh.Length; j++) { double tongtien = Convert.ToDouble(dgv[1, j].Value.ToString()); double sotienno = Convert.ToDouble(dgv[2, j].Value.ToString()); double sothanhtoan = Convert.ToDouble(dgv[3, j].Value.ToString()); double thanhtoankhilap = Convert.ToDouble(dgv[4, j].Value.ToString()); string sotiendathanhtoan = (sothanhtoan + thanhtoankhilap).ToString(); cthdbh[j] = new Entities.HoaDonNhap("Update", dgv[0, j].Value.ToString(), sotiendathanhtoan); } kkt = InsertMang(cthdbh); return kkt; } return kkt; } catch { return false; } }
//Entities.HDBanHang[] hienthi; public void SelectDatancc() { try { DateTime dateSerVer = DateServer.Date(); 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.HoaDonNhap pt = new Entities.HoaDonNhap("Select"); // khởi tạo mảng đối tượng để hứng giá trị pt1 = new Entities.HoaDonNhap[1]; clientstrem = cl.SerializeObj(this.client1, "HDN", pt); // đổ mảng đối tượng vào datagripview pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { pt1 = new Entities.HoaDonNhap[0]; } if (int.Parse(duno) != 0) { List <Entities.HoaDonNhap> l = new List <Entities.HoaDonNhap>(); for (int j = 0; j < pt1.Length; j++) { double noHienThoi = 0; double thanhToanNgay = 0; double tongTien = 0; double thanhToanNgayKhiLapPhieu = 0; DateTime hanThanhToan = pt1[j].HanThanhToan; int YY = dateSerVer.Year; int MM = dateSerVer.Month; int DD = dateSerVer.Day; if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay)) { thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay); } if (!string.IsNullOrEmpty(pt1[j].TongTien)) { tongTien = double.Parse(pt1[j].TongTien); } if (!string.IsNullOrEmpty(pt1[j].ThanhToanSauKhiLapPhieu)) { thanhToanNgayKhiLapPhieu = double.Parse(pt1[j].ThanhToanSauKhiLapPhieu); } noHienThoi = thanhToanNgay + thanhToanNgayKhiLapPhieu - tongTien; if (pt1[j].MaNhaCungCap.Equals(mancc) && YY == hanThanhToan.Year && MM == hanThanhToan.Month && (hanThanhToan.Day - DD) <= 3 && (hanThanhToan.Day - DD) >= 0 && (noHienThoi != 0)) { l.Add(pt1[j]); } } Entities.HoaDonNhap hdn = HanThanhToanNhoNhat(l); if (hdn != null && !string.IsNullOrEmpty(hdn.MaHoaDonNhap)) { label1.Text = "Sắp tới hạn thanh toán với nhà cung cấp " + hdn.HanThanhToan.ToString("dd/MM/yyyy"); } } } catch { } }
/// <summary> /// select nhập kho /// </summary> private void SelectNhapKho() { try { Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length]; int sotang = 0; for (int j = 0; j < hdn.Length; j++) { if (hdn[j].Deleted == false && batDau <= hdn[j].NgayNhap && hdn[j].NgayNhap <= ketThuc && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0) { pt2[sotang] = hdn[j]; sotang++; } } hdn = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hdn[j] = pt2[j]; } } else hdn = new Entities.HoaDonNhap[0]; } catch (Exception ex) { } finally { } }
/// <summary> /// them moi, sua thong tin don dat hang /// </summary> /// <param name="hanhdong"></param> private void XuLy_HoaDonNhap(string hanhdong) { try { Entities.HoaDonNhap don = new Entities.HoaDonNhap(); string thoigian_1 = null; thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text); string thoigian_2 = null; thoigian_2 = new Common.Utilities().MyDateConversion(makHanthanhtoan.Text); if (thoigian_1 != null && thoigian_2 != null) { don.NgayNhap = DateTime.Parse(thoigian_1); thoigian_1 = null; don.HanThanhToan = DateTime.Parse(thoigian_2); thoigian_2 = null; don.Hanhdong = hanhdong; don.MaHoaDonNhap = "" + txtSodonhang.Text.ToUpper(); don.MaNhaCungCap = "" + txtManhacungcap.Text.ToUpper(); don.NoHienThoi = 0 + txtNohienthoi.Text; don.NguoiGiaoHang = "" + txtnguoigiaohang.Text; don.HinhThucThanhToan = "" + cbxHinhthucthanhtoan.SelectedItem.ToString(); don.MaKho = "" + cbxKhoHang.SelectedValue.ToString().ToUpper(); don.DieuKienThanhToan = "" + cbxDieuKienThanhToan.SelectedItem.ToString(); string MaDonDatHang = txtMadondathang.Text.ToUpper(); if (MaDonDatHang == "<F4 -TRA CỨU>" || MaDonDatHang.Length <= 0) { MaDonDatHang = "NULL"; } don.MaDonDatHang = MaDonDatHang; don.MaTienTe = "" + cbxTienTe_TyGia.SelectedValue.ToString().ToUpper(); don.ChietKhau = 0 + txtChietkhau.Text; don.ThanhToanNgay = 0 + txtThanhtoanngay.Text; don.ThueGTGT = 0 + txtGiatrigiatang.Text; don.TongTien = 0 + txtTongtien.Text; don.GhiChu = txtDiengiai.Text; don.Deleted = false; if (dgvInsertOrder.RowCount > 0) { if (CheckData(don) == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", don); Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave == 1) { LuuChiTietDonHang(); //cap nhat trang thai don dat hang CapNhatTrangThaiDonDatHang("Update", MaDonDatHang, "Đã thành công"); MessageBox.Show("Thành công"); frmHienThi_HoaDonNhap.BaoDong = ""; this.Close(); } else { MessageBox.Show("Thất bại"); } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim, Entities.HoaDonNhap[] mangtim) { try { if (giatritim.Length > 0) { if (mangtim.Length > 0) { if (rdoNgay.Checked == true) { if (mangtim == null) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { Boolean check = false; List <Entities.HoaDonNhap> tt1_search = new List <Entities.HoaDonNhap>(); for (int i = 0; i < mangtim.Length; i++) { int index = -1; index = mangtim[i].NgayNhap.ToString().ToLower().IndexOf(giatritim.ToLower()); if (index >= 0) { check = true; tt1_search.Add(mangtim[i]); } } if (check == false) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { dgv.DataSource = tt1_search.ToArray(); tt1_search = null; } } } if (rdoMa.Checked == true) { if (mangtim == null) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { Boolean check = false; List <Entities.HoaDonNhap> tt1_search = new List <Entities.HoaDonNhap>(); for (int i = 0; i < mangtim.Length; i++) { int index = -1; index = mangtim[i].MaHoaDonNhap.ToString().ToLower().IndexOf(giatritim.ToLower()); if (index >= 0) { check = true; tt1_search.Add(mangtim[i]); } } if (check == false) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { dgv.DataSource = tt1_search.ToArray(); tt1_search = null; } } } if (rdoTatca.Checked == true) { if (mangtim != null) { dgv.DataSource = mangtim; } else { Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; } } } else { Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; } } else { if (rdoTatca.Checked == true) { dgv.DataSource = mangtim; } } FixDatagridview(dgv); } catch (Exception ex) { string s = ex.Message; Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; FixDatagridview(dgv); count = 1; } }
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim, Entities.HoaDonNhap[] mangtim) { try { if (giatritim.Length > 0) { if (mangtim.Length > 0) { if (rdoNgay.Checked == true) { if (mangtim == null) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { Boolean check = false; List<Entities.HoaDonNhap> tt1_search = new List<Entities.HoaDonNhap>(); for (int i = 0; i < mangtim.Length; i++) { int index = -1; index = mangtim[i].NgayNhap.ToString().ToLower().IndexOf(giatritim.ToLower()); if (index >= 0) { check = true; tt1_search.Add(mangtim[i]); } } if (check == false) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { dgv.DataSource = tt1_search.ToArray(); tt1_search = null; } } } if (rdoMa.Checked == true) { if (mangtim == null) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { Boolean check = false; List<Entities.HoaDonNhap> tt1_search = new List<Entities.HoaDonNhap>(); for (int i = 0; i < mangtim.Length; i++) { int index = -1; index = mangtim[i].MaHoaDonNhap.ToString().ToLower().IndexOf(giatritim.ToLower()); if (index >= 0) { check = true; tt1_search.Add(mangtim[i]); } } if (check == false) { Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0]; dgv.DataSource = lay; } else { dgv.DataSource = tt1_search.ToArray(); tt1_search = null; } } } if (rdoTatca.Checked == true) { if (mangtim != null) { dgv.DataSource = mangtim; } else { Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; } } } else { Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; } } else { if (rdoTatca.Checked == true) { dgv.DataSource = mangtim; } } FixDatagridview(dgv); } catch (Exception ex) { string s = ex.Message; Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0]; dgv.DataSource = k; FixDatagridview(dgv); count = 1; } }
private Entities.HoaDonNhap HanThanhToanNhoNhat(List<Entities.HoaDonNhap> l) { Entities.HoaDonNhap kq = new Entities.HoaDonNhap(); int temp = 31; foreach (Entities.HoaDonNhap item in l) { temp = item.HanThanhToan.Day; kq = item; } return kq; }
/// <summary> /// select hóa đơn nhập /// </summary> public void SelectHoaDonNhap() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.HoaDonNhap pt = new Entities.HoaDonNhap("Select"); Entities.HoaDonNhap[] pt1 = new Entities.HoaDonNhap[1]; clientstrem = cl.SerializeObj(this.client1, "HDN", pt); pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { hienthi = new Entities.HoaDonNhap[0]; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[pt1.Length]; int sotang = 0; for (int j = 0; j < pt1.Length; j++) { if (pt1[j].Deleted == false) { pt2[sotang] = pt1[j]; sotang++; } } hienthi = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; } } } catch (Exception ex) { } finally { } }
public void SelectData(string str) { try { Entities.HoaDonNhap ctdh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.HoaDonNhap("Select"); clientstrem = cl.SerializeObj(this.client1, "HDN", ctdh); Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1]; ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh); if (ddh == null) { hienthi = new Entities.HoaDonNhap[0]; dtgvKH.DataSource = hienthi; return; } Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[ddh.Length]; int sotang = 0; for (int j = 0; j < ddh.Length; j++) { if (ddh[j].Deleted == false && ddh[j].MaNhaCungCap==str) { double ttn = Convert.ToDouble(ddh[j].ThanhToanNgay); double ttnklp = Convert.ToDouble(ddh[j].ThanhToanSauKhiLapPhieu); double tt = Convert.ToDouble(ddh[j].TongTien); if ((ttn + ttnklp) != tt) { pt2[sotang] = ddh[j]; sotang++; } } } hienthi = new Entities.HoaDonNhap[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; } } else { hienthi = new Entities.HoaDonNhap[0]; dtgvKH.DataSource = hienthi; return; } dtgvKH.DataSource = hienthi; dtgvKH.Rows[0].Selected = true; } catch (Exception ex) { } finally { fix(); } }
public Entities.HoaDonNhap[] HoaDonNhap() { Entities.HoaDonNhap[] hdn = new BizLogic.HoaDonNhap().Select(); if (hdn == null) hdn = new Entities.HoaDonNhap[0]; return hdn; }