/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void Select_ChiTietDonDatHang()
{
try
{
Entities.ChiTietDonDatHang ctdh = new Entities.ChiTietDonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.ChiTietDonDatHang("Select");
clientstrem = cl.SerializeObj(this.client, "ChiTietDonDatHang", ctdh);
Entities.ChiTietDonDatHang[] ddh = new Entities.ChiTietDonDatHang[1];
ddh = (Entities.ChiTietDonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
//dgvInsertOrder.Columns[1].Visible = false;
dgvInsertOrder.Columns[0].HeaderText = "STT";
new Common.Utilities().CountDatagridview(dgvInsertOrder);
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// add ban ghi --------------------------------hungvv-----------------------------
/// </summary>
/// <param name="dgv"></param>
public Entities.ChiTietDonDatHang[] LuuChiTietKhoHang(DataGridView dgv, string hanhdong, string madondathang)
{
ArrayList arr = new ArrayList();
int i = dgv.RowCount;
Entities.ChiTietDonDatHang[] mangBanghi = null;
if (i > 0)
{
for (int x = 0; x < i; x++)
{
Entities.ChiTietDonDatHang banghi = new Entities.ChiTietDonDatHang();
banghi.Hanhdong = hanhdong;
banghi.MaDonDatHang = madondathang.ToUpper();
banghi.MaHangHoa = dgv.Rows[x].Cells[1].Value.ToString();
banghi.SoLuong = System.Convert.ToInt32(dgv.Rows[x].Cells[3].Value.ToString());
banghi.PhanTramChietKhau = dgv.Rows[x].Cells[5].Value.ToString();
banghi.GhiChu = dgv.Rows[x].Cells[2].Value.ToString();
banghi.Deleted = false;
arr.Add(banghi);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
mangBanghi = new Entities.ChiTietDonDatHang[n];
for (int j = 0; j < n; j++)
{
mangBanghi[j] = (Entities.ChiTietDonDatHang)arr[j];
}
}
else
{
mangBanghi = null;
mangBanghi = null;
}
return(mangBanghi);
}
/// <summary>
/// add ban ghi --------------------------------hungvv-----------------------------
/// </summary>
/// <param name="dgv"></param>
public Entities.ChiTietDonDatHang[] LuuChiTietKhoHang(DataGridView dgv, string hanhdong, string madondathang)
{
ArrayList arr = new ArrayList();
int i = dgv.RowCount;
Entities.ChiTietDonDatHang[] mangBanghi = null;
if (i > 0)
{
for (int x = 0; x < i; x++)
{
Entities.ChiTietDonDatHang banghi = new Entities.ChiTietDonDatHang();
banghi.Hanhdong = hanhdong;
banghi.MaDonDatHang = madondathang.ToUpper();
banghi.MaHangHoa = dgv.Rows[x].Cells[1].Value.ToString();
banghi.SoLuong = System.Convert.ToInt32(dgv.Rows[x].Cells[3].Value.ToString());
banghi.PhanTramChietKhau = dgv.Rows[x].Cells[5].Value.ToString();
banghi.GhiChu = dgv.Rows[x].Cells[2].Value.ToString();
banghi.Deleted = false;
arr.Add(banghi);
}
int n = arr.Count;
if (n == 0) { return null; }
mangBanghi = new Entities.ChiTietDonDatHang[n];
for (int j = 0; j < n; j++)
{
mangBanghi[j] = (Entities.ChiTietDonDatHang)arr[j];
}
}
else
{
mangBanghi = null;
mangBanghi = null;
}
return mangBanghi;
}
/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void Select_ChiTietDonDatHang()
{
try
{
Entities.ChiTietDonDatHang ctdh = new Entities.ChiTietDonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.ChiTietDonDatHang("Select");
clientstrem = cl.SerializeObj(this.client, "ChiTietDonDatHang", ctdh);
Entities.ChiTietDonDatHang[] ddh = new Entities.ChiTietDonDatHang[1];
ddh = (Entities.ChiTietDonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
//dgvInsertOrder.Columns[1].Visible = false;
dgvInsertOrder.Columns[0].HeaderText = "STT";
new Common.Utilities().CountDatagridview(dgvInsertOrder);
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// tinh tong tien
/// </summary>
/// <param name="dgv"></param>
/// <returns></returns>
public string TongTien(DataGridView dgv)
{
string giatri = "0";
if (dgv.RowCount > 0)
{
int count = dgv.RowCount;
Entities.ChiTietDonDatHang[] chitiet = new Entities.ChiTietDonDatHang[count];
for (int i = 0; i < count; i++)
{
string lay = dgv.Rows[i].Cells[7].Value.ToString();
giatri = (float.Parse(lay) + float.Parse(giatri)).ToString();
}
}
return giatri;
}
/// <summary>
/// hungvv ==============================================================================
/// </summary>
public DataTable LayGiaTri(DataGridView dgv, string ma, string ten, int soluong, float gia, float chietkhau, float phantram)
{
DataTable tb = new DataTable();
tb.Columns.Add("ID", typeof(string));
tb.Columns.Add("Name", typeof(string));
tb.Columns.Add("SoLuong", typeof(int));
tb.Columns.Add("Gia", typeof(float));
tb.Columns.Add("PhanTram", typeof(string));
tb.Columns.Add("ChietKhau", typeof(string));
tb.Columns.Add("TongTien", typeof(string));
DataRow row = tb.NewRow();
if (dgv.RowCount > 0)
{
DataRow row2 = tb.NewRow();
Boolean k = false;
int count = dgv.RowCount;
Entities.ChiTietDonDatHang[] chitiet = new Entities.ChiTietDonDatHang[count];
for (int i = 0; i < count; i++)
{
row["ID"] = dgv.Rows[i].Cells[0].Value.ToString();
row["Name"] = dgv.Rows[i].Cells[1].Value.ToString();
int sl = 0;
if (dgv.Rows[i].Cells[0].Value.ToString() == ma)
{
sl = Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString()) + soluong;
k = true;
}
if (dgv.Rows[i].Cells[0].Value.ToString() != ma)
{
sl = Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString());
k = false;
}
row["SoLuong"] = sl.ToString();
row["Gia"] = dgv.Rows[i].Cells[3].Value.ToString();
row["PhanTram"] = 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();
tb.Rows.Add(row.ItemArray);
tb.AcceptChanges();
}
if (k == false)
{
row2["ID"] = ma;
row2["Name"] = ten;
row2["SoLuong"] = soluong;
row2["Gia"] = gia;
row2["PhanTram"] = phantram;
row2["ChietKhau"] = chietkhau;
row2["TongTien"] = gia * soluong;
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
}
else
{
DataRow row2 = tb.NewRow();
row2["ID"] = ma;
row2["Name"] = ten;
row2["SoLuong"] = soluong;
row2["Gia"] = gia;
row2["PhanTram"] = phantram;
row2["ChietKhau"] = chietkhau;
row2["TongTien"] = gia * soluong;
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
return tb;
}
/// <summary>
/// hungvv =======================khong su dung ham nay===========================
/// </summary>
private void Select_ChiTietDonDatHang()
{
try
{
Entities.ChiTietDonDatHang ctdh = new Entities.ChiTietDonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.ChiTietDonDatHang("Select");
clientstrem = cl.SerializeObj(this.client, "ChiTietDonDatHang", ctdh);
Entities.ChiTietDonDatHang[] ddh = new Entities.ChiTietDonDatHang[1];
ddh = (Entities.ChiTietDonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
client.Close();
clientstrem.Close();
if (ddh.Length > 0)
{
dgvInsertOrder.DataSource = ddh;
}
else
{
Entities.ChiTietDonDatHang[] lay = new Entities.ChiTietDonDatHang[0];
dgvInsertOrder.DataSource = lay;
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// add ban ghi --------------------------------hungvv-----------------------------
/// </summary>
/// <param name="dgv"></param>
private Entities.ChiTietDonDatHang[] LuuChiTietHangHoaTheoDonDatHang(DataGridView dgv, string hanhdong, string madondathang)
{
Entities.ChiTietDonDatHang[] mangBanghi = null;
ArrayList arr = new ArrayList();
try
{
int i = dgv.RowCount;
if (i > 0)
{
for (int x = 0; x < i; x++)
{
Entities.ChiTietDonDatHang banghi = new Entities.ChiTietDonDatHang();
banghi.Hanhdong = hanhdong;
banghi.MaDonDatHang = madondathang.ToUpper();
banghi.MaHangHoa = dgv.Rows[x].Cells[1].Value.ToString();
banghi.TenHangHoa = dgv.Rows[x].Cells["TenHangHoa"].Value.ToString();
banghi.SoLuong = int.Parse(0 + dgv.Rows[x].Cells[3].Value.ToString());
banghi.DonGia = (0 + dgv.Rows[x].Cells["GiaGoc"].Value.ToString()).ToString();
banghi.Thue = (0 + dgv.Rows[x].Cells["Thuegiatrigiatang"].Value.ToString()).ToString();
banghi.PhanTramChietKhau = int.Parse(0 + dgv.Rows[x].Cells[7].Value.ToString()).ToString();
banghi.GhiChu = "" + txtDiengiai.Text.ToString();
banghi.Deleted = false;
arr.Add(banghi);
}
int n = arr.Count;
if (n == 0) { return null; }
mangBanghi = new Entities.ChiTietDonDatHang[n];
for (int j = 0; j < n; j++)
{
mangBanghi[j] = (Entities.ChiTietDonDatHang)arr[j];
}
}
else
{
mangBanghi = null;
}
}
catch (Exception ex)
{ string s = ex.Message; mangBanghi = null; }
return mangBanghi;
}
/// <summary>
/// hungvv ==============================================================================
/// </summary>
private DataTable LayGiaTri(DataGridView dgv, string ma, string ten, int tonsosach, int tonthucte, int chechlech, string lydo, string giavon, string giachenhlech)
{
DataTable tb = new DataTable();
tb.Columns.Add("STT", typeof(string));
tb.Columns.Add("ID", typeof(string));
tb.Columns.Add("Name", typeof(string));
tb.Columns.Add("SoSach", typeof(string));
tb.Columns.Add("ThucTe", typeof(string));
tb.Columns.Add("ChenhLech", typeof(string));
tb.Columns.Add("LyDo", typeof(string));
tb.Columns.Add("GiaVon", typeof(string));
tb.Columns.Add("GiaChenhLech", typeof(string));
if (dgv.RowCount > 0)
{
Boolean k = false;
DataRow row2 = tb.NewRow();
int count = dgv.RowCount;
Entities.ChiTietDonDatHang[] chitiet = new Entities.ChiTietDonDatHang[count];
for (int i = 0; i < count; i++)
{
DataRow row = tb.NewRow();
row["ID"] = dgv.Rows[i].Cells[1].Value.ToString();
row["Name"] = dgv.Rows[i].Cells[2].Value.ToString();
string sl = "1";
if (dgv.Rows[i].Cells[1].Value.ToString() == ma)
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[4].Value.ToString()) + tonthucte).ToString();
k = true;
}
else
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[4].Value.ToString())).ToString();
k = false;
}
row["SoSach"] = dgv.Rows[i].Cells[3].Value.ToString();
row["ThucTe"] = sl.ToString();
row["ChenhLech"] = dgv.Rows[i].Cells[5].Value.ToString();
row["LyDo"] = dgv.Rows[i].Cells[6].Value.ToString();
row["GiaVon"] = dgv.Rows[i].Cells[7].Value.ToString();
row["GiaChenhLech"] = dgv.Rows[i].Cells[8].Value.ToString();
tb.Rows.Add(row.ItemArray);
tb.AcceptChanges();
}
if (k == false)
{
row2["ID"] = ma.ToUpper();
row2["Name"] = ten.ToString();
row2["SoSach"] = tonsosach.ToString();
row2["ThucTe"] = tonthucte.ToString();
row2["ChenhLech"] = chechlech.ToString();
row2["LyDo"] = lydo;
row2["GiaVon"] = giavon.ToString();
row2["GiaChenhLech"] = giachenhlech.ToString();
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
}
else
{
DataRow row2 = tb.NewRow();
row2["ID"] = ma.ToUpper();
row2["Name"] = ten.ToString();
row2["SoSach"] = tonsosach.ToString();
row2["ThucTe"] = tonthucte.ToString();
row2["ChenhLech"] = chechlech.ToString();
row2["LyDo"] = lydo;
row2["GiaVon"] = giavon.ToString();
row2["GiaChenhLech"] = giachenhlech.ToString();
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
return(tb);
}
/// <summary>
/// hungvv ==============================================================================
/// </summary>
private DataTable LayGiaTri(DataGridView dgv, string ma, string ten, int tonsosach, int tonthucte, int chechlech, string lydo, string giavon,string giachenhlech)
{
DataTable tb = new DataTable();
tb.Columns.Add("STT", typeof(string));
tb.Columns.Add("ID", typeof(string));
tb.Columns.Add("Name", typeof(string));
tb.Columns.Add("SoSach", typeof(string));
tb.Columns.Add("ThucTe", typeof(string));
tb.Columns.Add("ChenhLech", typeof(string));
tb.Columns.Add("LyDo", typeof(string));
tb.Columns.Add("GiaVon", typeof(string));
tb.Columns.Add("GiaChenhLech", typeof(string));
if (dgv.RowCount > 0)
{
Boolean k = false;
DataRow row2 = tb.NewRow();
int count = dgv.RowCount;
Entities.ChiTietDonDatHang[] chitiet = new Entities.ChiTietDonDatHang[count];
for (int i = 0; i < count; i++)
{
DataRow row = tb.NewRow();
row["ID"] = dgv.Rows[i].Cells[1].Value.ToString();
row["Name"] = dgv.Rows[i].Cells[2].Value.ToString();
string sl = "1";
if (dgv.Rows[i].Cells[1].Value.ToString() == ma)
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[4].Value.ToString()) + tonthucte).ToString();
k = true;
}
else
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[4].Value.ToString())).ToString();
k = false;
}
row["SoSach"] = dgv.Rows[i].Cells[3].Value.ToString();
row["ThucTe"] = sl.ToString();
row["ChenhLech"] = dgv.Rows[i].Cells[5].Value.ToString();
row["LyDo"] = dgv.Rows[i].Cells[6].Value.ToString();
row["GiaVon"] = dgv.Rows[i].Cells[7].Value.ToString();
row["GiaChenhLech"] = dgv.Rows[i].Cells[8].Value.ToString();
tb.Rows.Add(row.ItemArray);
tb.AcceptChanges();
}
if (k == false)
{
row2["ID"] = ma.ToUpper();
row2["Name"] = ten.ToString();
row2["SoSach"] = tonsosach.ToString();
row2["ThucTe"] = tonthucte.ToString();
row2["ChenhLech"] = chechlech.ToString();
row2["LyDo"] = lydo;
row2["GiaVon"] = giavon.ToString();
row2["GiaChenhLech"] = giachenhlech.ToString();
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
}
else
{
DataRow row2 = tb.NewRow();
row2["ID"] = ma.ToUpper();
row2["Name"] = ten.ToString();
row2["SoSach"] = tonsosach.ToString();
row2["ThucTe"] = tonthucte.ToString();
row2["ChenhLech"] = chechlech.ToString();
row2["LyDo"] = lydo;
row2["GiaVon"] = giavon.ToString();
row2["GiaChenhLech"] = giachenhlech.ToString();
tb.Rows.Add(row2.ItemArray);
tb.AcceptChanges();
}
return tb;
}