public Entities.ChiTietXuatHuy[] LayChiTiet_XuatHuy_TheoMaPhieu(string maPXuatHuy) { try { if (ctPXuatHuy == null) { ctPXuatHuy = new Entities.ChiTietXuatHuy[0]; } List <Entities.ChiTietXuatHuy> listTemp = new List <Entities.ChiTietXuatHuy>(); for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy.ToUpper().Equals(maPXuatHuy.ToUpper())) { listTemp.Add(ctPXuatHuy[i]); } } return(listTemp.ToArray()); } catch { Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return(ctPXuatHuy1); } }
public Entities.ChiTietXuatHuy[] SelectChiTiet(string maPhieuXuatHuy) { try { i = 0; 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.ChiTietXuatHuy ctxh = new Entities.ChiTietXuatHuy("Select", maPhieuXuatHuy); // khởi tạo mảng đối tượng để hứng giá trị Entities.ChiTietXuatHuy[] pt1 = new Entities.ChiTietXuatHuy[1]; clientstrem = cl.SerializeObj(this.client1, "ChiTietXuatHuy", ctxh); // đổ mảng đối tượng vào datagripview pt1 = (Entities.ChiTietXuatHuy[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { pt1 = new Entities.ChiTietXuatHuy[0]; return(pt1); } Entities.ChiTietXuatHuy[] pt2 = new Entities.ChiTietXuatHuy[pt1.Length]; int sotang = 0; for (int j = 0; j < pt1.Length; j++) { if (pt1[j].Deleted == false) { if (pt1[j].MaPhieuXuatHuy == maPhieuXuatHuy) { pt2[sotang] = pt1[j]; sotang++; } } } hhht = new Entities.ChiTietXuatHuy[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hhht[j] = pt2[j]; } return(hhht); } else { hhht = new Entities.ChiTietXuatHuy[0]; return(hhht); } } catch (Exception ex) { return(new Entities.ChiTietXuatHuy[0]); } }
public void LayChiTiet_XuatHuy() { try { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietXuatHuy ctxh = new Entities.ChiTietXuatHuy("SelectSon"); clientstrem = cl.SerializeObj(this.client, "ChiTietXuatHuy", ctxh); ctPXuatHuy = new Entities.ChiTietXuatHuy[0]; ctPXuatHuy = (Entities.ChiTietXuatHuy[])cl.DeserializeHepper1(clientstrem, ctPXuatHuy); if (ctPXuatHuy == null) { ctPXuatHuy = new Entities.ChiTietXuatHuy[0]; return; } } catch { } }
public Entities.ChiTietXuatHuy[] LayChiTiet_XuatHuy_TheoMaPhieu(string maPXuatHuy) { try { int count = 0; for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy == maPXuatHuy) { count++; } } Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[count]; count = 0; for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy == maPXuatHuy) { ctPXuatHuy1[count] = ctPXuatHuy[i]; count++; } } if (ctPXuatHuy1 == null) { ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return(ctPXuatHuy1); } return(ctPXuatHuy1); } catch { Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return(ctPXuatHuy1); } }
public Entities.ChiTietXuatHuy[] SelectChiTiet(string maPhieuXuatHuy) { try { i = 0; 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.ChiTietXuatHuy ctxh = new Entities.ChiTietXuatHuy("Select", maPhieuXuatHuy); // khởi tạo mảng đối tượng để hứng giá trị Entities.ChiTietXuatHuy[] pt1 = new Entities.ChiTietXuatHuy[1]; clientstrem = cl.SerializeObj(this.client1, "ChiTietXuatHuy", ctxh); // đổ mảng đối tượng vào datagripview pt1 = (Entities.ChiTietXuatHuy[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { pt1 = new Entities.ChiTietXuatHuy[0]; return pt1; } Entities.ChiTietXuatHuy[] pt2 = new Entities.ChiTietXuatHuy[pt1.Length]; int sotang = 0; for (int j = 0; j < pt1.Length; j++) { if (pt1[j].Deleted == false) { if (pt1[j].MaPhieuXuatHuy == maPhieuXuatHuy) { pt2[sotang] = pt1[j]; sotang++; } } } hhht = new Entities.ChiTietXuatHuy[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { hhht[j] = pt2[j]; } return hhht; } else { hhht = new Entities.ChiTietXuatHuy[0]; return hhht; } } catch (Exception ex) { return new Entities.ChiTietXuatHuy[0]; } }
public Entities.ChiTietXuatHuy[] LayChiTiet_XuatHuy_TheoMaPhieu(string maPXuatHuy) { try { int count = 0; for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy == maPXuatHuy) { count++; } } Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[count]; count = 0; for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy == maPXuatHuy) { ctPXuatHuy1[count] = ctPXuatHuy[i]; count++; } } if (ctPXuatHuy1 == null) { ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return ctPXuatHuy1; } return ctPXuatHuy1; } catch { Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return ctPXuatHuy1; } }
public Entities.ChiTietXuatHuy[] LayChiTiet_XuatHuy_TheoMaPhieu(string maPXuatHuy) { try { if (ctPXuatHuy == null) ctPXuatHuy = new Entities.ChiTietXuatHuy[0]; List<Entities.ChiTietXuatHuy> listTemp = new List<Entities.ChiTietXuatHuy>(); for (int i = 0; i < ctPXuatHuy.Length; i++) { if (ctPXuatHuy[i].MaPhieuXuatHuy.ToUpper().Equals(maPXuatHuy.ToUpper())) { listTemp.Add(ctPXuatHuy[i]); } } return listTemp.ToArray(); } catch { Entities.ChiTietXuatHuy[] ctPXuatHuy1 = new Entities.ChiTietXuatHuy[0]; return ctPXuatHuy1; } }
/// <summary> /// select dữ liệu từ server /// </summary> public void SelectData() { Entities.HangHoaHienThi[] hhht = new Entities.HangHoaHienThi[0]; try { i = 0; 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.ChiTietXuatHuy ctxh = new Entities.ChiTietXuatHuy("Select", sochungtu); // khởi tạo mảng đối tượng để hứng giá trị pt1 = new Entities.ChiTietXuatHuy[1]; clientstrem = cl.SerializeObj(this.client1, "ChiTietXuatHuy", ctxh); // đổ mảng đối tượng vào datagripview pt1 = (Entities.ChiTietXuatHuy[])cl.DeserializeHepper1(clientstrem, pt1); if (pt1 == null) { dtgvsanpham.DataSource = new Entities.HangHoaHienThi[0]; return; } Entities.ChiTietXuatHuy[] pt2 = new Entities.ChiTietXuatHuy[pt1.Length]; int sotang = 0; for (int j = 0; j < pt1.Length; j++) { if (pt1[j].Deleted == false) { if (pt1[j].MaPhieuXuatHuy == sochungtu) { pt2[sotang] = pt1[j]; sotang++; } } } hhht = new Entities.HangHoaHienThi[sotang]; if (sotang != 0) { SelectHangHoa(); for (int j = 0; j < sotang; j++) { string tongtien = (Convert.ToDouble(LayGiaSanPham(pt2[j].MaHangHoa)) * Convert.ToDouble(pt2[j].SoLuong.ToString())).ToString(); hhht[j] = new Entities.HangHoaHienThi(pt2[j].MaPhieuXuatHuy, pt2[j].MaHangHoa, LayTenSanPham(pt2[j].MaHangHoa), new TienIch().FormatMoney(LayGiaSanPham(pt2[j].MaHangHoa)), pt2[j].SoLuong.ToString(), new TienIch().FormatMoney(tongtien)); } } else { dtgvsanpham.DataSource = new Entities.HangHoaHienThi[0]; return; } dtgvsanpham.DataSource = hhht; dtgvsanpham.Rows[0].Selected = true; } catch { } finally { try { fix(); } catch { } } }
/// <summary> /// kiểm tra dữ liệu trong datagridview để insert /// </summary> /// <param name="dgv"></param> public void CheckDataGridInsert(DataGridView dgv) { try { if (dgv.RowCount != 0) { Entities.ChiTietXuatHuy[] ctxh2 = new Entities.ChiTietXuatHuy[dgv.RowCount]; for (int j = 0; j < ctxh2.Length; j++) { ctxh2[j] = new Entities.ChiTietXuatHuy("InsertUpdate", txtsochungtu.Text, dgv[1, j].Value.ToString(), int.Parse(dgv[4, j].Value.ToString()), "", false); } InsertMang(ctxh2); } } catch (Exception ex) { } }
/// <summary> /// kiểm tra dữ liệu trong datagridview để update /// </summary> /// <param name="dgv"></param> public void CheckDataGirdUpdate(DataGridView dgv) { try { int slnew = 0; int sl = dgv.RowCount; string hd = ""; int sotang = 0; if (pt1 == null) if (sl == 0) { MessageBox.Show("không có dữ liệu"); return; } if (dgv.RowCount != 0) { if (sl > pt1.Length) slnew = sl; else slnew = pt1.Length; Entities.ChiTietXuatHuy[] ctxh1 = new Entities.ChiTietXuatHuy[slnew]; for (int k = 0; k < pt1.Length; k++) { for (int j = 0; j < sl; j++) { if (dgv[1, j].Value.ToString() == pt1[k].MaHangHoa) { hd = "ok"; break; } } if (hd == "") { ctxh1[sotang] = new Entities.ChiTietXuatHuy("Delete", pt1[k].MaPhieuXuatHuy, pt1[k].MaHangHoa); sotang++; } else hd = ""; } if (sotang != 0) { Entities.ChiTietXuatHuy[] ctxh2 = new Entities.ChiTietXuatHuy[sotang]; for (int j = 0; j < ctxh2.Length; j++) { ctxh2[j] = ctxh1[j]; } DeleteMang(ctxh2); } else return; } else { Entities.ChiTietXuatHuy[] ctxh2 = new Entities.ChiTietXuatHuy[pt1.Length]; for (int j = 0; j < pt1.Length; j++) { ctxh2[j] = new Entities.ChiTietXuatHuy("Delete", pt1[j].MaPhieuXuatHuy, pt1[j].MaHangHoa); } DeleteMang(ctxh2); } } catch (Exception ex) { } }