public void HDBanHang() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.CheckRefer ctxh = new Entities.CheckRefer("HDBH"); clientstrem = cl.SerializeObj(this.client1, "Select", ctxh); hdbanhang = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, hdbanhang); if (hdbanhang == null) { hdbanhang = new Entities.HDBanHang[0]; return; } int st = 0; Entities.HDBanHang[] temp = new Entities.HDBanHang[hdbanhang.Length]; for (int i = 0; i < hdbanhang.Length; i++) { temp[st] = hdbanhang[i]; st++; } hdbanhang = new Entities.HDBanHang[st]; for (int i = 0; i < st; i++) { hdbanhang[i] = temp[i]; } } catch { } }
/// <summary> /// selec bán lẻ /// </summary> public void SelectBanLe() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { string month1 = buonle[j].NgayBan.Month.ToString(); string year1 = buonle[j].NgayBan.Year.ToString(); if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false) { if (month == month1 && year == year1) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bl = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bl[j] = pt2[j]; } } else { bl = new Entities.HDBanHang[0]; } } catch { } }
void SelectDate(DateTime batdau, DateTime ketthuc) { try { i = 0; dtgvbanbuon.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.HDBanHang pt = new Entities.HDBanHang("Select"); // khởi tạo mảng đối tượng để hứng giá trị pt1 = new Entities.HDBanHang[1]; clientstrem = cl.SerializeObj(this.client1, "HDBanHang", pt); // đổ mảng đối tượng vào datagripview pt1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { dtgvbanbuon.DataSource = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] pt2 = new Entities.HDBanHang[pt1.Length]; int sotang = 0; foreach (Entities.HDBanHang item in pt1) { if (!item.LoaiHoaDon && !item.Deleted && item.NgayBan.Date >= batdau.Date && item.NgayBan.Date <= ketthuc.Date && item.MaKho == makho) { pt2[sotang] = item; sotang++; } } hienthi = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = pt2[j]; hienthi[j].TongTienThanhToan = new Common.Utilities().FormatMoney(double.Parse(hienthi[j].TongTienThanhToan)); } } else { dtgvbanbuon.DataSource = new Entities.HDBanHang[0]; return; } dtgvbanbuon.DataSource = hienthi; //new Common.Utilities().CountDatagridview(dtgvbanbuon); dtgvbanbuon.Rows[0].Selected = true; } catch (Exception ex) { MessageBox.Show("Không kết nối được với server - thử lại sau"); dtgvbanbuon.DataSource = new Entities.HDBanHang[0]; } finally { fix(); } }
/// <summary> /// select bán buôn /// </summary> public void SelectBanBuon() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { string month1 = buonle[j].NgayBan.Month.ToString(); string year1 = buonle[j].NgayBan.Year.ToString(); if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false) { if (month == month1 && year == year1 && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else { bb = new Entities.HDBanHang[0]; } } catch { } }
/// <summary> /// select dữ liệu từ server /// </summary> public void SelectData() { try { dtgvKH.RowHeadersVisible = false; Server_Client.Client 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.HDBanHang kh = new Entities.HDBanHang("Select"); // khởi tạo mảng đối tượng để hứng giá trị Entities.HDBanHang[] kh1 = new Entities.HDBanHang[1]; clientstrem = cl.SerializeObj(this.client1, "HDBanHang", kh); // đổ mảng đối tượng vào datagripview kh1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, kh1); if (kh1 == null) { hienthi = new Entities.HDBanHang[0]; dtgvKH.DataSource = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] kh2 = new Entities.HDBanHang[kh1.Length]; int sotang = 0; for (int j = 0; j < kh1.Length; j++) { if (kh1[j].MaKhachHang == str1 && kh1[j].Deleted == false && kh1[j].LoaiHoaDon == false && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanNgay) && !kh1[j].TongTienThanhToan.Equals(kh1[j].ThanhToanKhiLapPhieu)) { kh2[sotang] = kh1[j]; sotang++; } } hienthi = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hienthi[j] = kh2[j]; } } else { hienthi = new Entities.HDBanHang[0]; dtgvKH.DataSource = new Entities.HDBanHang[0]; return; } dtgvKH.DataSource = hienthi; dtgvKH.Rows[0].Selected = true; } catch (Exception ex) { MessageBox.Show("Không kết nối được với server - thử lại sau"); } finally { fix(); } }
public Entities.HDBanHang[] HDBanHang() { Entities.HDBanHang[] hdbanhang = new BizLogic.CheckRefer().HDBanHang(); if (hdbanhang == null) { hdbanhang = new Entities.HDBanHang[0]; } return(hdbanhang); }
/// <summary> /// xử lý khi tìm kiếm /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dtgvbanbuon.DataSource = new Entities.HDBanHang[0]; return; } int soluong = 0; if (hienthi != null) { if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvbanbuon.DataSource = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] hienthitheoma = new Entities.HDBanHang[soluong]; soluong = 0; for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthi[i]; soluong++; } } dtgvbanbuon.DataSource = hienthitheoma; } if (soluong != 0) { } } } finally { fix(); } }
public void LayHDBanHang() { try { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.HDBanHang ctxh = new Entities.HDBanHang("Select"); clientstrem = cl.SerializeObj(this.client, "HDBanHang", ctxh); Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0]; HDBanHang1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, HDBanHang1); if (HDBanHang1 == null) { HDBanHang1 = new Entities.HDBanHang[0]; return; } int count = 0; for (int i = 0; i < HDBanHang1.Length; i++) { DateTime ngayban = HDBanHang1[i].NgayBan; if (ngayban >= BatDau && ngayban <= KetThuc) { count++; } } HDBanHang = new Entities.HDBanHang[count]; count = 0; for (int i = 0; i < HDBanHang1.Length; i++) { DateTime ngayban = HDBanHang1[i].NgayBan; if (ngayban >= BatDau && ngayban <= KetThuc) { HDBanHang[count] = HDBanHang1[i]; count++; } } } catch { } }
/// <summary> /// select bán buôn - bán lẻ /// </summary> public void SelectBanBuonLe() { try { i = 0; if (bb == null || bb.Length == 0) { bb = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length]; int sotang = 0; for (int j = 0; j < bb.Length; j++) { DateTime hientai = bb[j].NgayBan; if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date&& hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = bb[j]; sotang++; } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else { bb = new Entities.HDBanHang[0]; } } catch { } finally { } }
public void LayHDBanHang() { try { Entities.HDBanHang[] HDBanHang1 = new Entities.HDBanHang[0]; HDBanHang1 = new BizLogic.HDBanHang().Select(); if (HDBanHang1 == null) { HDBanHang1 = new Entities.HDBanHang[0]; return; } int count = 0; for (int i = 0; i < HDBanHang1.Length; i++) { DateTime ngayban = HDBanHang1[i].NgayBan; if (ngayban >= BatDau && ngayban <= KetThuc) { count++; } } HDBanHang = new Entities.HDBanHang[count]; count = 0; for (int i = 0; i < HDBanHang1.Length; i++) { DateTime ngayban = HDBanHang1[i].NgayBan; if (ngayban >= BatDau && ngayban <= KetThuc) { HDBanHang[count] = HDBanHang1[i]; count++; } } } catch { } }
public Entities.HDBanHang[] HDBanHang() { Entities.HDBanHang[] hdbanhang = new BizLogic.CheckRefer().HDBanHang(); if (hdbanhang == null) hdbanhang = new Entities.HDBanHang[0]; return hdbanhang; }
/// <summary> /// select bán buôn /// </summary> public void SelectBanBuon() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false) { if (batDau <= buonle[j].NgayBan && buonle[j].NgayBan <= ketThuc && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else bb = new Entities.HDBanHang[0]; } catch (Exception ex) { } }
//Entities.HDBanHang[] hienthi; public void SelectData1() { try { double duNoHoaDon = 0; 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.HDBanHang pt = new Entities.HDBanHang("Select"); // khởi tạo mảng đối tượng để hứng giá trị pt1 = new Entities.HDBanHang[1]; clientstrem = cl.SerializeObj(this.client1, "HDBanHang", pt); // đổ mảng đối tượng vào datagripview pt1 = (Entities.HDBanHang[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) pt1 = new Entities.HDBanHang[0]; List<Entities.HDBanHang> hdBanHanList = new List<Entities.HDBanHang>(); for (int j = 0; j < pt1.Length; j++) { int YY = dateServer.Year; int MM = dateServer.Month; int DD = dateServer.Day; if (pt1[j].MaKhachHang == makh) { double thanhToanNgay = 0; double thanToanKhiLapPhieu = 0; double tongTienThanhToan = 0; if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay)) thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay); if (!string.IsNullOrEmpty(pt1[j].ThanhToanKhiLapPhieu)) thanToanKhiLapPhieu = double.Parse(pt1[j].ThanhToanKhiLapPhieu); if (!string.IsNullOrEmpty(pt1[j].TongTienThanhToan)) tongTienThanhToan = double.Parse(pt1[j].TongTienThanhToan); duNoHoaDon = thanhToanNgay + thanToanKhiLapPhieu - tongTienThanhToan; DateTime hanthanhtoan = pt1[j].HanThanhToam; if (YY == hanthanhtoan.Year && MM == hanthanhtoan.Month && (hanthanhtoan.Day - DD) <= 3 && (hanthanhtoan.Day - DD) >= 0 && duNoHoaDon != 0) { hdBanHanList.Add(pt1[j]); } } } int tem = 32; Entities.HDBanHang hdTem = null; foreach (Entities.HDBanHang item in hdBanHanList) { int DD = item.HanThanhToam.Day; if (tem > DD) { tem = DD; hdTem = new Entities.HDBanHang(); hdTem = item; } } if (tem != 0 && hdTem != null && !string.IsNullOrEmpty(hdTem.MaHDBanHang)) label3.Text = "Sắp tới hạn thanh toán của khách hàng " + hdTem.HanThanhToam.ToString("dd/MM/yyyy"); } catch { } }
/// <summary> /// xử lý khi tìm kiếm /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dtgvKH.DataSource = new Entities.HDBanHang[0]; return; } int soluong = 0; if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvKH.DataSource = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] hienthitheoma = new Entities.HDBanHang[soluong]; soluong = 0; for (int i = 0; i < hienthi.Length; i++) { int kiemtra = hienthi[i].MaHDBanHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthi[i]; soluong++; } } dtgvKH.DataSource = hienthitheoma; } } finally { fix(); } }
/// <summary> /// selec bán lẻ /// </summary> public void SelectBanLe() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false) { if (batDau <= buonle[j].NgayBan && buonle[j].NgayBan <= ketThuc) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bl = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bl[j] = pt2[j]; } } else bl = new Entities.HDBanHang[0]; } catch (Exception ex) { } }
/// <summary> /// select bán buôn /// </summary> public void SelectBanBuon() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { string month1 = buonle[j].NgayBan.Month.ToString(); string year1 = buonle[j].NgayBan.Year.ToString(); if (buonle[j].LoaiHoaDon == false && buonle[j].Deleted == false) { if (month == month1 && year == year1 && Convert.ToDouble(buonle[j].ThanhToanKhiLapPhieu) != 0) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else bb = new Entities.HDBanHang[0]; } catch { } }
/// <summary> /// selec bán lẻ /// </summary> public void SelectBanLe() { try { Entities.HDBanHang[] pt2 = new Entities.HDBanHang[buonle.Length]; int sotang = 0; for (int j = 0; j < buonle.Length; j++) { string month1 = buonle[j].NgayBan.Month.ToString(); string year1 = buonle[j].NgayBan.Year.ToString(); if (buonle[j].LoaiHoaDon == true && buonle[j].Deleted == false) { if (month == month1 && year == year1) { sl++; pt2[sotang] = buonle[j]; sotang++; } } } bl = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bl[j] = pt2[j]; } } else bl = new Entities.HDBanHang[0]; } catch { } }
/// <summary> /// select bán buôn - bán lẻ /// </summary> public void SelectBanBuonLe() { try { i = 0; if (bb == null || bb.Length == 0) { bb = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length]; int sotang = 0; for (int j = 0; j < bb.Length; j++) { DateTime hientai = bb[j].NgayBan; if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date && hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = bb[j]; sotang++; } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else bb = new Entities.HDBanHang[0]; } catch { } finally { } }
/// select bán buôn - bán lẻ /// </summary> public void SelectBanBuonLe() { try { if (bb == null || bb.Length == 0) { bb = new Entities.HDBanHang[0]; return; } Entities.HDBanHang[] pt2 = new Entities.HDBanHang[bb.Length]; int sotang = 0; for (int j = 0; j < bb.Length; j++) { string month1 = bb[j].NgayBan.Month.ToString(); string year1 = bb[j].NgayBan.Year.ToString(); if (bb[j].LoaiHoaDon == false && bb[j].Deleted == false && month == month1 && year1 == year) { pt2[sotang] = bb[j]; sotang++; } } bb = new Entities.HDBanHang[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { bb[j] = pt2[j]; } } else bb = new Entities.HDBanHang[0]; } catch { } }