private void getDataTable(DataGridView dgv)
{
if (dgv.RowCount > 1)
{
toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString();
toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString();
toolStrip_txtSoluong.Text = Double.Parse(dgv[3, i].Value.ToString()).ToString();
toolStrip_txtGiagoc.Text = Double.Parse(dgv[4, i].Value.ToString()).ToString();
toolStrip_txtChietkhauphantram.Text = Double.Parse(dgv[5, i].Value.ToString()).ToString();
toolStrip_txtGianhap.Text = Double.Parse(dgv[6, i].Value.ToString()).ToString();
toolStrip_txtChietkhau.Text = Double.Parse(dgv[7, i].Value.ToString()).ToString();
Entities.HienThi_ChiTiet_DonDatHang[] hh = new Entities.HienThi_ChiTiet_DonDatHang[dgv.RowCount - 1];
int so = 0;
for (int j = 0; j < dgv.RowCount; j++)
{
if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString())
{
hh[so] = new Entities.HienThi_ChiTiet_DonDatHang("" + dgv[1, j].Value.ToString(), "" + dgv[2, j].Value.ToString(), int.Parse(0 + dgv[3, j].Value.ToString()), "" + dgv[4, j].Value.ToString(), "" + dgv[5, j].Value.ToString(), "" + dgv[6, j].Value.ToString(), "" + dgv[7, j].Value.ToString(), "" + dgv[8, j].Value.ToString());
so++;
}
}
if (hh.Length <= 0)
{
dgv.DataSource = null; DoiTen(dgv);
}
else
{
dgv.DataSource = null; dgv.DataSource = hh; DoiTen(dgv);
}
}
else
{
dgv.DataSource = null;
}
}
/// <summary>
/// tim chi tiet hang hoa theo ma
/// </summary>
/// <param name="MaHang"></param>
private void LayHangHoaTheoMa(string MaHang)
{
Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang);
clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm);
Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang();
tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra);
if (tra == null)
{
MessageBox.Show("Mã bạn nhập không tồn tại");
}
else
{
timerRun.Stop();
run = 0;
toolStrip_txtTracuu.Text = tra.MaHangHoa;
toolStrip_txtTenhang.Text = tra.TenHangHoa;
toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString();
toolStrip_txtGiagoc.Text = tra.GiaGoc;
toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau;
toolStrip_txtGianhap.Text = tra.GiaNhap;
toolStrip_txtChietkhau.Text = tra.ChietKhau;
}
}
/// <summary>
/// do du lieu vao dgv
/// </summary>
private void HienThi_ChiTiet_DonDatHang()
{
try
{
Entities.DonDatHang dat = new Entities.DonDatHang();
dat.Hanhdong = "Select";
dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
DoiTen(dgvInsertOrder);
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
private void HienThi_ChiTiet_HoaDonNhap(string MaDonHang)
{
try
{
Entities.HienThi_ChiTiet_DonDatHang dat = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaDonHang);
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_HoaDonNhap", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
//hien thi
DoiTen(dgvInsertOrder);
string tong = new Common.Utilities().TongTien(dgvInsertOrder);
txtTienhang.Text = tong;
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
private void LayHangHoaTheoMa(string MaHang)
{
try
{
Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang);
clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm);
Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang();
tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra);
if (tra.MaHangHoa == null || tra == null)
{
ResetTool();
MessageBox.Show("Hàng hóa không tồn tại");
toolStrip_txtTracuu.Focus();
toolStrip_txtTracuu.Text = "";
}
else
{
GiaTriCanLuu.Ma = tra.MaHangHoa;
GiaTriCanLuu.Ten = tra.TenHangHoa;
GiaTriCanLuu.Giatri = tra.GiaGoc;
GiaTriCanLuu.Giatri2 = tra.SoLuongDat.ToString();
GiaTriCanLuu.giatrigiatang = tra.Thuegiatrigiatang;
GiaTriCanLuu.makhachhang = tra.SoLuongDat.ToString();
if (tenForm == "KhachHangTraLai")
{
toolStrip_txtTracuu.Text = GiaTriCanLuu.Ma;
toolStrip_txtTenhang.Text = GiaTriCanLuu.Ten;
toolStrip_txtGiagoc.Text = GiaTriCanLuu.Giatri;
toolStrip_txtSoluong.Text = GiaTriCanLuu.Giatri2;
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString();
toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString();
thue = GiaTriCanLuu.giatrigiatang;
}
if (tenForm == "TraLaiNhaCungCap")
{
toolStrip_txtTracuu.Text = GiaTriCanLuu.Ma;
toolStrip_txtTenhang.Text = GiaTriCanLuu.Ten;
toolStrip_txtGiagoc.Text = GiaTriCanLuu.Giatri;
toolStrip_txtSoluong.Text = GiaTriCanLuu.makhachhang;
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString();
toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtGiagoc.Text) * Double.Parse(toolStrip_txtSoluong.Text)).ToString();
thue = GiaTriCanLuu.giatrigiatang;
}
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
}
private void check_loaidathang_CheckedChanged(object sender, EventArgs e)
{
try
{
if (check_loaidathang.Checked == true)
{ lblKhohang.Text = "Cho kho hàng: "; }
if (check_loaidathang.Checked == false)
{ lblKhohang.Text = "Trong kho: "; }
txtManhacungcap.Text = "<F4-Tra cứu>";
lblTennhacungcap.Text = "";
checkData();
Entities.HienThi_ChiTiet_DonDatHang[] row = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = row;
DoiTen(dgvInsertOrder);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = lay;
DoiTen(dgvInsertOrder);
}
}
/// <summary>
/// xu ly du lieu
/// </summary>
/// <param name="chitiet"></param>
private void XuLyChiTietDonDatHang(Entities.HienThi_ChiTiet_DonDatHang[] chitiet)
{
try
{
if (chitiet.Length > 0)
{
Entities.HienThi_ChiTiet_DonDatHang[] giatri = null;
ArrayList arr = new ArrayList();
for (int i = 0; i < chitiet.Length; i++)
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = chitiet[i].MaHangHoa;
row.TenHangHoa = chitiet[i].TenHangHoa;
row.SoLuongDat = chitiet[i].SoLuongDat;
row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc));
row.Giabanbuon = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].Giabanbuon));
row.Giabanle = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].Giabanle));
string phantram = chitiet[i].PhanTramChietKhau;
string gianhap = "0";
if (phantram == "0")
{
gianhap = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString()));
}
else
{
gianhap = new Common.Utilities().FormatMoney((Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString())) - ((Double.Parse(chitiet[i].PhanTramChietKhau) / 100 * Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString()))));
}
row.PhanTramChietKhau = phantram;
row.Thuegiatrigiatang = chitiet[i].Thuegiatrigiatang;
row.GiaNhap = gianhap;
row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(chitiet[i].GiaGoc) * Double.Parse(chitiet[i].SoLuongDat.ToString()));
arr.Add(row);
}
int n = arr.Count;
if (n == 0) { giatri = null; }
giatri = new Entities.HienThi_ChiTiet_DonDatHang[n];
for (int i = 0; i < n; i++)
{
giatri[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i];
}
dgvInsertOrder.DataSource = null;
dgvInsertOrder.DataSource = giatri;
DoiTen(dgvInsertOrder);
}
else
{
dgvInsertOrder.DataSource = chitiet;
DoiTen(dgvInsertOrder);
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); MessageBox.Show(s); }
}
private void txtManhacungcap_TextChanged(object sender, EventArgs e)
{
try
{
if (txtManhacungcap.Text == "")
{
ResetTool();
Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = lay;
DoiTen(dgvInsertOrder);
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void NewRow()
{
try
{
if (txtManhacungcap.Text != "")
{
try
{
QuyDoi(toolStrip_txtTracuu.Text.ToUpper());
}
catch
{ }
Entities.HienThi_ChiTiet_DonDatHang add = new Entities.HienThi_ChiTiet_DonDatHang();
add.MaHangHoa = toolStrip_txtTracuu.Text.ToUpper();
add.TenHangHoa = toolStrip_txtTenhang.Text;
add.SoLuongDat = int.Parse(0 + toolStrip_txtSoluong.Text);
add.GiaGoc = toolStrip_txtGiagoc.Text;
add.PhanTramChietKhau = Double.Parse(0 + toolStrip_txtChietkhauphantram.Text).ToString();
add.Thuegiatrigiatang = toolStrip_txtThuegiatrigiatang.Text;
add.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(0 + toolStrip_txtGianhap.Text));
add.ChietKhau = toolStrip_Chietkhau.Text;
add.TongTien = new Common.Utilities().FormatMoney(Double.Parse(toolStrip_txtGiagoc.Text) * int.Parse(0 + toolStrip_txtSoluong.Text));
if (Double.Parse(toolStrip_txtSoluong.Text) >= 1)
{
string thongbao = KiemTraMa(add);
if (thongbao == "OK")
{
if (Double.Parse(toolStrip_txtGianhap.Text) > 0)
{
LayGiaTri(dgvInsertOrder, add);
DoiTen(dgvInsertOrder);
ResetTool();
}
else
{
MessageBox.Show("Giá nhập của hàng không đúng");
}
}
else
{
toolStrip_txtTracuu.Focus();
MessageBox.Show("Mã hàng không đúng");
return;
}
}
else
{ MessageBox.Show("Số lượng nhập không đúng"); }
}
else
{
MessageBox.Show("Chọn nhà cung cấp");
}
}
catch (Exception ex)
{
string s = ex.ToString();
}
}
private void getDataTable(DataGridView dgv)
{
if (dgv.RowCount > 1)
{
toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString();
toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString();
toolStrip_txtSoluong.Text = Double.Parse(dgv[3, i].Value.ToString()).ToString();
toolStrip_txtGiagoc.Text = Double.Parse(dgv[4, i].Value.ToString()).ToString();
toolStrip_txtChietkhauphantram.Text = Double.Parse(dgv[5, i].Value.ToString()).ToString();
toolStrip_txtGianhap.Text = Double.Parse(dgv[6, i].Value.ToString()).ToString();
toolStrip_txtChietkhau.Text = Double.Parse(dgv[7, i].Value.ToString()).ToString();
Entities.HienThi_ChiTiet_DonDatHang[] hh = new Entities.HienThi_ChiTiet_DonDatHang[dgv.RowCount-1];
int so = 0;
for (int j = 0; j < dgv.RowCount; j++)
{
if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString())
{
hh[so] = new Entities.HienThi_ChiTiet_DonDatHang("" + dgv[1, j].Value.ToString(), "" + dgv[2, j].Value.ToString(), int.Parse(0 + dgv[3, j].Value.ToString()), "" + dgv[4, j].Value.ToString(), "" + dgv[5, j].Value.ToString(), "" + dgv[6, j].Value.ToString(), "" + dgv[7, j].Value.ToString(), "" + dgv[8, j].Value.ToString());
so++;
}
}
if (hh.Length <= 0)
{ dgv.DataSource = null; DoiTen(dgv); }
else
{ dgv.DataSource = null; dgv.DataSource = hh; DoiTen(dgv); }
}
else
{
dgv.DataSource = null;
}
}
/// <summary>
/// do du lieu vao dgv
/// </summary>
private void HienThi_ChiTiet_DonDatHang()
{
try
{
Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri();
dat.Hanhdong = "Select";
dat.Giatritruyen = txtSodonhang.Text;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh.Length > 0)
{
XuLyChiTietDonDatHang(ddh);
}
else
{
Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = lay;
DoiTen(dgvInsertOrder);
}
client.Close();
clientstrem.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = lay;
DoiTen(dgvInsertOrder);
}
}
private void getDataTable(DataGridView dgv)
{
try
{
ArrayList arr = new ArrayList();
Entities.HienThi_ChiTiet_DonDatHang[] list = null;
if (dgv.RowCount > 0 && i >= 0)
{
toolStrip_txtTracuu.Text = dgv[1, i].Value.ToString();
toolStrip_txtTenhang.Text = dgv[2, i].Value.ToString();
toolStrip_txtGiagoc.Text = dgv[4, i].Value.ToString();
toolStrip_txtThuegiatrigiatang.Text = dgv[8, i].Value.ToString();
giatrigiatang = dgv[8, i].Value.ToString();
toolStrip_Chietkhau.Text = "0";
toolStrip_txtGianhap.Text = (Double.Parse(0 + dgv[4, i].Value.ToString()) * int.Parse(0 + dgv[3, i].Value.ToString())).ToString();
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_txtSoluong.Text = int.Parse(0 + dgv[3, i].Value.ToString()).ToString();
for (int j = 0; j < dgv.RowCount; j++)
{
if (dgv[1, j].Value.ToString() != dgv[1, i].Value.ToString())
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = dgv.Rows[j].Cells[1].Value.ToString();
row.TenHangHoa = dgv.Rows[j].Cells[2].Value.ToString();
row.SoLuongDat = int.Parse(0 + dgv.Rows[j].Cells[3].Value.ToString());
row.GiaGoc = dgv.Rows[j].Cells[4].Value.ToString();
row.PhanTramChietKhau = dgv.Rows[j].Cells[7].Value.ToString();
row.Thuegiatrigiatang = dgv.Rows[j].Cells[8].Value.ToString();
row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[j].Cells[9].Value.ToString()));
row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[j].Cells[11].Value.ToString()));
arr.Add(row);
}
}
int n = arr.Count;
if (n == 0) { arr = null; }
list = new Entities.HienThi_ChiTiet_DonDatHang[n];
for (int x = 0; x < n; x++)
{
list[x] = (Entities.HienThi_ChiTiet_DonDatHang)arr[x];
}
dgv.DataSource = list;
}
else
{
list = new Entities.HienThi_ChiTiet_DonDatHang[0];
arr = null;
dgv.DataSource = list;
DoiTen(dgv);
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// ham main
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmXuLy_DonDatHang_Load(object sender, EventArgs e)
{
try
{
datesv = DateServer.Date();
Entities.HienThi_ChiTiet_DonDatHang[] row = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgvInsertOrder.DataSource = row;
DoiTen(dgvInsertOrder);
//doc du lieu dong
makNgaydonhang.Text = DateServer.Date().ToString("dd/MM/yyyy"); ;
makNgaynhapdukien.Text = DateServer.Date().ToString("dd/MM/yyyy");
this.cbxHinhthucthanhtoan.Items.AddRange(new object[] { "Tiền mặt", "ATM" });
cbxHinhthucthanhtoan.SelectedIndex = 0;
this.txtTrangthaidonhang.Text = "Đang mở";
txtPhuongthucvanchuyen.Text = "Tự vận chuyển";
//fig cung combox
frmXuLyDonDatHang fr = new frmXuLyDonDatHang();
if (this.HanhDong == "Insert")
{
btnTimnhacungcap.Enabled = true;
toolStripStatus_Them.Enabled = true;
toolStripStatus_Ghilai.Enabled = false;
Application.OpenForms[fr.Name].Text = "Thêm Mới - F4 Thêm Hàng Hóa F5 Nhập Phí Vận Chuyển F6 Sửa Hàng Hóa F7 Nhập Phí Khác";
txtTrangthaidonhang.ReadOnly = true;
getID("DonDatHang");
txtSodonhang.Text = makiemtra;
checkData();
toolStripStatusLabel3.Enabled = false;
}
//LayKhoHang();
///lay kho hang trong xml
new Common.Utilities().ComboxKhoHang(cbxMaKho);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
Entities.KiemTraChung g = new Entities.KiemTraChung();
Common.Utilities com = new Common.Utilities();
g.Khoachinh = Common.Utilities.User.NhanVienID;
g.Giatri = Common.Utilities.User.TenNhanVien;
tt[0] = g;
com.BindingCombobox(tt, cbxNhanvien, "giatri", "khoachinh");
//LayNhanVien();
LayTenTT();
txtGiatien.Text = tigia[0].Giatri2.ToString();
cbxTiente_Tygia.SelectedIndex = 0;
cbxTiente_Tygia.Enabled = false;
//danh cho update
if (this.HanhDong == "Update")
{
if (this.dathang.DonDatHangID > 0)
{
btnTimnhacungcap.Enabled = false;
toolStripStatus_Them.Enabled = false;
toolStripStatus_Ghilai.Enabled = true;
Application.OpenForms[fr.Name].Text = "Quản lý đơn đặt hàng - Xem Chi Tiết Đơn";
DoDuLieu(this.dathang);
if (txtTrangthaidonhang.Text == "Đã thành công")
{
toolStripStatus_Ghilai.Enabled = false;
toolStripStatusLabel3.Enabled = false;
toolStripStatusLabel4.Enabled = true;
btnTimnhacungcap.Enabled = false;
}
if (dgvInsertOrder.RowCount <= 0)
{
txtChietkhau.Text = "0";
txtTienhang.Text = "0";
txtGiatrigiatang.Text = "0";
txtPhivanchuyen.Text = "0";
txtPhikhac.Text = "0";
txtTongtien.Text = "0";
}
check_loaidathang.Enabled = false;
TinhToan();
}
else
{ MessageBox.Show("Không tìm thấy mã đơn đặt hàng cần sửa !"); this.Close(); }
toolStripStatusLabel3.Enabled = true;
}
}
catch (Exception ex)
{
string s = ex.Message;
if (txtSodonhang.Text == "")
{
txtSodonhang.Text = makhachhang;
}
}
}
/// <summary>
/// tim chi tiet hang hoa theo ma
/// </summary>
/// <param name="MaHang"></param>
private void LayHangHoaTheoMa(string MaHang)
{
Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang);
clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm);
Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang();
tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra);
if (tra == null)
{
MessageBox.Show("Mã bạn nhập không tồn tại");
}
else
{
timerRun.Stop();
run = 0;
toolStrip_txtTracuu.Text = tra.MaHangHoa;
toolStrip_txtTenhang.Text = tra.TenHangHoa;
toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString();
toolStrip_txtGiagoc.Text = tra.GiaGoc;
toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau;
toolStrip_txtGianhap.Text = tra.GiaNhap;
toolStrip_txtChietkhau.Text = tra.ChietKhau;
}
}
private void HienThi_ChiTiet_HoaDonNhap(string MaDonHang)
{
try
{
Entities.HienThi_ChiTiet_DonDatHang dat = new Entities.HienThi_ChiTiet_DonDatHang( "Select",MaDonHang);
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_HoaDonNhap", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
//hien thi
DoiTen(dgvInsertOrder);
string tong = new Common.Utilities().TongTien(dgvInsertOrder);
txtTienhang.Text = tong;
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
public void LayGiaTri(DataGridView dgv, Entities.HienThi_ChiTiet_DonDatHang themmoi)
{
ArrayList arr = new ArrayList();
Entities.HienThi_ChiTiet_DonDatHang[] list = null;
if (dgv.RowCount > 0)
{
int count = dgv.RowCount;
list = new Entities.HienThi_ChiTiet_DonDatHang[count];
Boolean check = false;
for (int i = 0; i < count; i++)
{
string sl = "1";
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = dgv.Rows[i].Cells[1].Value.ToString();
row.TenHangHoa = dgv.Rows[i].Cells[2].Value.ToString();
if (dgv.Rows[i].Cells[1].Value.ToString() == themmoi.MaHangHoa)
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[3].Value.ToString()) + themmoi.SoLuongDat).ToString();
check = true;
}
else
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[3].Value.ToString())).ToString();
check = false;
}
row.SoLuongDat = int.Parse(sl);
row.GiaGoc = dgv.Rows[i].Cells[4].Value.ToString();
row.Giabanbuon = dgv.Rows[i].Cells[5].Value.ToString();
row.Giabanle = dgv.Rows[i].Cells[6].Value.ToString();
row.PhanTramChietKhau = dgv.Rows[i].Cells[7].Value.ToString();
row.Thuegiatrigiatang = Double.Parse(0 + dgv.Rows[i].Cells[8].Value.ToString()).ToString();
row.GiaNhap = dgv.Rows[i].Cells[9].Value.ToString();
row.TongTien = dgv.Rows[i].Cells[11].Value.ToString();
arr.Add(row);
}
if (check == false)
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = themmoi.MaHangHoa;
row.TenHangHoa = themmoi.TenHangHoa;
row.SoLuongDat = themmoi.SoLuongDat;
row.GiaGoc = themmoi.GiaGoc;
row.Giabanbuon = themmoi.Giabanbuon;
row.Giabanle = themmoi.Giabanle;
row.PhanTramChietKhau = themmoi.PhanTramChietKhau;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
row.GiaNhap = themmoi.GiaNhap;
row.TongTien = themmoi.TongTien;
arr.Add(row);
}
}
else
{
list = new Entities.HienThi_ChiTiet_DonDatHang[1];
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = themmoi.MaHangHoa;
row.TenHangHoa = themmoi.TenHangHoa;
row.SoLuongDat = themmoi.SoLuongDat;
row.GiaGoc = themmoi.GiaGoc;
row.Giabanbuon = themmoi.Giabanbuon;
row.Giabanle = themmoi.Giabanle;
row.PhanTramChietKhau = themmoi.PhanTramChietKhau;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
row.GiaNhap = themmoi.GiaNhap;
row.TongTien = themmoi.TongTien;
arr.Add(row);
}
int n = arr.Count;
if (n == 0) { list = null; }
list = new Entities.HienThi_ChiTiet_DonDatHang[n];
for (int i = 0; i < n; i++)
{
list[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i];
}
dgv.DataSource = null;
dgv.DataSource = list;
}
/// <summary>
/// do du lieu vao dgv
/// </summary>
private void HienThi_ChiTiet_TheoMa()
{
try
{
Entities.DonDatHang dat = new Entities.DonDatHang();
dat.Hanhdong = "Select";
dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_TheoMa", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvXemthongtin.DataSource = ddh;
new Common.Utilities().CountDatagridview(dgvXemthongtin);
dgvXemthongtin.Columns[0].HeaderText = "STT";
dgvXemthongtin.RowHeadersVisible = false;
dgvXemthongtin.Columns[1].HeaderText = "Mã hàng";
dgvXemthongtin.Columns[2].HeaderText = "Tên hàng";
dgvXemthongtin.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvXemthongtin.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// tim chi tiet hang hoa theo ma
/// </summary>
/// <param name="MaHang"></param>
private void LayHangHoaTheoMa(string MaHang)
{
try
{
Entities.HienThi_ChiTiet_DonDatHang ktm = new Entities.HienThi_ChiTiet_DonDatHang();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.HienThi_ChiTiet_DonDatHang("Select", MaHang);
clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaHangHoa", ktm);
Entities.HienThi_ChiTiet_DonDatHang tra = new Entities.HienThi_ChiTiet_DonDatHang();
tra = (Entities.HienThi_ChiTiet_DonDatHang)cl.DeserializeHepper(clientstrem, tra);
if (tra.MaHangHoa == null || tra == null)
{
toolStrip_txtTracuu.Focus();
frmXuLyHangHoa frm = new frmXuLyHangHoa("ThemNhapKho", toolStrip_txtTracuu.Text);
frm.ShowDialog();
ResetTool();
toolStrip_txtTracuu.Text = GiaTriCanLuu.mahanghoa;
}
else
{
toolStrip_txtTracuu.Text = tra.MaHangHoa;
toolStrip_txtTenhang.Text = tra.TenHangHoa;
toolStrip_txtSoluong.Text = tra.SoLuongDat.ToString();
toolStrip_txtGiagoc.Text = tra.GiaGoc;
banbuon = tra.Giabanbuon;
banle = tra.Giabanle;
giatrigiatang = tra.Thuegiatrigiatang;
toolStrip_txtChietkhauphantram.Text = tra.PhanTramChietKhau;
//toolStrip_txtSoluong.Text = "";
toolStrip_txtSoluong.Focus();
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
}
/// <summary>
/// do du lieu vao dgv
/// </summary>
private void HienThi_ChiTiet_DonDatHang()
{
try
{
Entities.DonDatHang dat = new Entities.DonDatHang();
dat.Hanhdong = "Select";
dat.MaNhaCungCap = GiaTriCanLuu.Ma.ToString().ToUpper();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HienThi_ChiTiet_DonDatHang", dat);
Entities.HienThi_ChiTiet_DonDatHang[] ddh = new Entities.HienThi_ChiTiet_DonDatHang[1];
ddh = (Entities.HienThi_ChiTiet_DonDatHang[])cl.DeserializeHepper(clientstrem, ddh);
dgvInsertOrder.DataSource = ddh;
DoiTen(dgvInsertOrder);
}
catch (Exception)
{ }
client.Close();
clientstrem.Close();
}
/// <summary>
/// hungvv them moi row ==============================================================================
/// </summary>
public void LayGiaTri(DataGridView dgv, Entities.HienThi_ChiTiet_DonDatHang themmoi)
{
try
{
ArrayList arr = new ArrayList();
Entities.HienThi_ChiTiet_DonDatHang[] list = null;
if (dgv.RowCount > 0)
{
int count = dgv.RowCount;
list = new Entities.HienThi_ChiTiet_DonDatHang[count];
Boolean check = false;
for (int i = 0; i < count; i++)
{
string sl = "1";
string gn = "0";
string tong = "0";
string thue = "0";
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = dgv.Rows[i].Cells[1].Value.ToString();
row.TenHangHoa = dgv.Rows[i].Cells[2].Value.ToString();
thue = dgv.Rows[i].Cells[8].Value.ToString();
if (dgv.Rows[i].Cells[1].Value.ToString() == themmoi.MaHangHoa)
{
sl = (int.Parse(dgv.Rows[i].Cells[3].Value.ToString()) + themmoi.SoLuongDat).ToString();
tong = new Common.Utilities().FormatMoney(Double.Parse(sl) * Double.Parse(dgv.Rows[i].Cells[4].Value.ToString()));
if (Double.Parse(dgv.Rows[i].Cells[7].Value.ToString()) == 0)
{
gn = new Common.Utilities().FormatMoney((Double.Parse(tong)));
}
else
{
gn = new Common.Utilities().FormatMoney(Double.Parse(tong) - ((Double.Parse(dgv.Rows[i].Cells[7].Value.ToString()) / 100 * Double.Parse(dgv.Rows[i].Cells[4].Value.ToString())) * Double.Parse(sl)));
}
check = true;
}
else
{
sl = dgv.Rows[i].Cells[3].Value.ToString();
tong = dgv.Rows[i].Cells[11].Value.ToString();
gn = dgv.Rows[i].Cells[9].Value.ToString();
}
row.SoLuongDat = int.Parse(sl);
row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(dgv.Rows[i].Cells[4].Value.ToString()));
row.PhanTramChietKhau = dgv.Rows[i].Cells[7].Value.ToString();
row.Thuegiatrigiatang = thue;
row.GiaNhap = gn;
row.TongTien = tong;
arr.Add(row);
}
if (check == false)
{
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = themmoi.MaHangHoa;
row.TenHangHoa = themmoi.TenHangHoa;
row.SoLuongDat = themmoi.SoLuongDat;
row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaGoc));
row.PhanTramChietKhau = themmoi.PhanTramChietKhau;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaNhap));
row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(themmoi.TongTien));
arr.Add(row);
}
}
else
{
list = new Entities.HienThi_ChiTiet_DonDatHang[1];
Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang();
row.MaHangHoa = themmoi.MaHangHoa;
row.TenHangHoa = themmoi.TenHangHoa;
row.SoLuongDat = themmoi.SoLuongDat;
row.GiaGoc = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaGoc));
row.PhanTramChietKhau = themmoi.PhanTramChietKhau;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
row.GiaNhap = new Common.Utilities().FormatMoney(Double.Parse(themmoi.GiaNhap));
row.TongTien = new Common.Utilities().FormatMoney(Double.Parse(themmoi.TongTien));
arr.Add(row);
}
int n = arr.Count;
if (n == 0) { list = null; }
list = new Entities.HienThi_ChiTiet_DonDatHang[n];
for (int i = 0; i < n; i++)
{
list[i] = (Entities.HienThi_ChiTiet_DonDatHang)arr[i];
}
dgv.DataSource = null;
dgv.DataSource = list;
DoiTen(dgvInsertOrder);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HienThi_ChiTiet_DonDatHang[] lay = new Entities.HienThi_ChiTiet_DonDatHang[0];
dgv.DataSource = lay;
DoiTen(dgvInsertOrder);
}
}
