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;
}
}
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
{
}
}
/// <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)
{
}
}
