private void btnTimmakhachhang_Click(object sender, EventArgs e)
{
try
{
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = lay;
fixDatagridview();
ResetTool();
TraCuuMa();
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void TimChungTuKhachHang()
{
GiaTriCanLuu.Giatri = loaihoadon(rdoBanbuon, rdoBanle);
if (GiaTriCanLuu.Giatri == "BanBuon")
{
if (txtMakhachhang.Text != "<F4 - Tra cứu>" && txtMakhachhang.Text.Length > 0)
{
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = lay;
fixDatagridview();
ResetTool();
string makho = cbxKhoHang.SelectedValue.ToString();
frmTraCuu fr = new frmTraCuu("HangTraLai_KhachHangTraLai_MaDonHang", "HoaDonBanHang", txtMakhachhang.Text, makho, "");
fr.ShowDialog();
Binding();
}
else
{ MessageBox.Show("Nhập khách hàng"); txtMakhachhang.Focus(); }
}
else
{
string makh = "";
if (txtMakhachhang.Text == "<F4 - Tra cứu>" || txtMakhachhang.Text.Length <= 0)
makh = "";
else
makh = txtMakhachhang.Text;
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = lay;
fixDatagridview();
ResetTool();
string makho = cbxKhoHang.SelectedValue.ToString();
frmTraCuu fr = new frmTraCuu("HangTraLai_KhachHangTraLai_MaDonHang", "HoaDonBanHang", makh, makho, "");
fr.ShowDialog();
Binding();
}
}
private void TimChungTuNhaCungCap()
{
if (txtMakhachhang.Text != "<F4 - Tra cứu>" && txtMakhachhang.Text.Length > 0)
{
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = lay;
fixDatagridview();
ResetTool();
string makho = cbxKhoHang.SelectedValue.ToString();
frmTraCuu fr = new frmTraCuu("HangTraLai_DonDatHangNhaCungCap", "TimHoaDonNhapTheoMa", txtMakhachhang.Text, makho, "");
fr.ShowDialog();
Binding();
}
else
{ MessageBox.Show("Nhập nhà cung cấp"); txtMakhachhang.Focus(); }
}
private void NewRow(string hanhdong)
{
try
{
if (txtMakhachhang.Text != "")
{
try
{
QuyDoi(toolStrip_txtTracuu.Text.ToUpper());
}
catch
{ }
Entities.LayHangHoaTheoMaKhachHangTraLai add = new Entities.LayHangHoaTheoMaKhachHangTraLai();
add.Mahanghoa = toolStrip_txtTracuu.Text;
string thongbao = KiemTraMa(add);
add.Tenhanghoa = toolStrip_txtTenhang.Text;
add.Soluong = int.Parse(toolStrip_txtSoluong.Text);
add.Giaban = toolStrip_txtGiagoc.Text;
add.Phantramchietkhau = Double.Parse(0 + toolStrip_txtChietkhauphantram.Text).ToString();
add.Chietkhau = Double.Parse(0 + toolStrip_Chietkhau.Text).ToString();
add.Tongtien = Double.Parse(0 + toolStrip_txtTongTien.Text).ToString();
add.Thuegiatrigiatang = thue;
if (thongbao == "NO")
{
MessageBox.Show("Mã hàng không đúng");
toolStrip_txtTracuu.Focus();
toolStrip_txtTracuu.Text = "";
return;
}
else
{
LayGiaTri(dgvXemthongtin, add);
ResetTool();
}
}
else
{
ResetTool();
MessageBox.Show("Chọn nhà cung cấp");
return;
}
}
catch (Exception ex)
{
string s = ex.ToString();
}
}
private void rdoBanle_CheckedChanged(object sender, EventArgs e)
{
try
{
if (hanhDong == "Sua_KhachHangTraLai")
{
if (rdoBanle.Checked == true)
{
txtChungtugoc.Text = "<F4 - Tra cứu>";
dgvXemthongtin.DataSource = null;
Entities.LayHangHoaTheoMaKhachHangTraLai[] row = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = row;
fixDatagridview();
capnhat();
ResetTool();
toolStripLabel5.Text = "GBL";
toolStripLabel5.ToolTipText = "Giá bán lẻ";
txtThanhtoanngay.Text = "0";
txtTongtienthanhtoan.Text = "0";
txtSodu.Text = "0";
}
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void LayHangHoaTheoMaTraLaiNhaCungCap(string matralainhacungcap)
{
try
{
string loai = loaihoadon(rdoBanbuon, rdoBanle);
Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri("Select", matralainhacungcap);
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "LayHangHoaTheoMaTraLaiNhaCungCap", dat);
Entities.LayHangHoaTheoMaKhachHangTraLai[] ddh = new Entities.LayHangHoaTheoMaKhachHangTraLai[1];
ddh = (Entities.LayHangHoaTheoMaKhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh);
client.Close();
clientstrem.Close();
if (ddh.Length <= 0)
{
dgvXemthongtin.DataSource = null;
Entities.LayHangHoaTheoMaKhachHangTraLai[] hay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = hay;
}
else
{
dgvXemthongtin.DataSource = ddh;
}
fixDatagridview();
TinhToan();
}
catch (Exception ex)
{
string s = ex.Message.ToString(); dgvXemthongtin.DataSource = null;
Entities.LayHangHoaTheoMaKhachHangTraLai[] hay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = hay;
}
}
private void LayHangHoaTheoMaHoaDonNhap(string ma)
{
try
{
Entities.TruyenGiaTri dat = new Entities.TruyenGiaTri("Select", "", ma);
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "TimHangHoaTheoMaHoaDonNhap", dat);
Entities.LayHangHoaTheoMaKhachHangTraLai[] ddh = new Entities.LayHangHoaTheoMaKhachHangTraLai[1];
ddh = (Entities.LayHangHoaTheoMaKhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh);
dgvXemthongtin.DataSource = ddh;
dgvXemthongtin.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvXemthongtin.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
client.Close();
clientstrem.Close();
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
}
public void LayGiaTri(DataGridView dgv, Entities.LayHangHoaTheoMaKhachHangTraLai themmoi)
{
try
{
ArrayList arr = new ArrayList();
Entities.LayHangHoaTheoMaKhachHangTraLai[] list = null;
if (dgv.RowCount > 0)
{
int count = dgv.RowCount;
list = new Entities.LayHangHoaTheoMaKhachHangTraLai[count];
Boolean check = false;
for (int i = 0; i < count; i++)
{
string sl = "1";
Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai();
row.Mahanghoa = dgv.Rows[i].Cells[0].Value.ToString();
row.Tenhanghoa = dgv.Rows[i].Cells[1].Value.ToString();
if (dgv.Rows[i].Cells[0].Value.ToString() == themmoi.Mahanghoa)
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString()) + themmoi.Soluong).ToString();
row.Phantramchietkhau = dgv.Rows[i].Cells[4].Value.ToString();
row.Chietkhau = (Convert.ToDouble(dgv.Rows[i].Cells[5].Value.ToString()) + Convert.ToDouble(toolStrip_Chietkhau.Text)).ToString();
row.Tongtien = (Convert.ToDouble(dgv.Rows[i].Cells[6].Value.ToString()) + Convert.ToDouble(toolStrip_txtTongTien.Text)).ToString();
row.Thuegiatrigiatang = dgv.Rows[i].Cells[7].Value.ToString();
check = true;
}
else
{
sl = (Convert.ToInt32(dgv.Rows[i].Cells[2].Value.ToString())).ToString();
row.Phantramchietkhau = 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();
row.Thuegiatrigiatang = dgv.Rows[i].Cells[7].Value.ToString();
}
row.Soluong = int.Parse(sl);
row.Giaban = dgv.Rows[i].Cells[3].Value.ToString();
arr.Add(row);
}
if (check == false)
{
Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai();
row.Mahanghoa = themmoi.Mahanghoa;
row.Tenhanghoa = themmoi.Tenhanghoa;
row.Soluong = themmoi.Soluong;
row.Giaban = themmoi.Giaban;
row.Phantramchietkhau = themmoi.Phantramchietkhau;
row.Chietkhau = themmoi.Chietkhau;
row.Tongtien = themmoi.Tongtien;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
arr.Add(row);
check = true;
}
}
else
{
list = new Entities.LayHangHoaTheoMaKhachHangTraLai[1];
Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai();
row.Mahanghoa = themmoi.Mahanghoa;
row.Tenhanghoa = themmoi.Tenhanghoa;
row.Soluong = themmoi.Soluong;
row.Giaban = themmoi.Giaban;
row.Phantramchietkhau = themmoi.Phantramchietkhau;
row.Chietkhau = themmoi.Chietkhau;
row.Tongtien = themmoi.Tongtien;
row.Thuegiatrigiatang = themmoi.Thuegiatrigiatang;
arr.Add(row);
}
int n = arr.Count;
if (n == 0) { list = null; }
list = new Entities.LayHangHoaTheoMaKhachHangTraLai[n];
for (int i = 0; i < n; i++)
{
list[i] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[i];
}
if (list.Length > 0)
{
dgv.DataSource = list;
fixDatagridview();
}
else
{
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgv.DataSource = lay;
fixDatagridview();
}
}
catch (Exception ex)
{
string s = ex.Message;
Entities.LayHangHoaTheoMaKhachHangTraLai[] lay = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgv.DataSource = lay;
fixDatagridview();
}
}
private void getDataTableNhaCungCap(DataGridView dgv)
{
try
{
ArrayList arr = new ArrayList();
Entities.LayHangHoaTheoMaKhachHangTraLai[] list = null;
if (dgv.RowCount > 0 && i >= 0)
{
toolStrip_txtTracuu.Text = dgv[0, i].Value.ToString();
toolStrip_txtTenhang.Text = dgv[1, i].Value.ToString();
toolStrip_txtSoluong.Text = dgv[2, i].Value.ToString();
toolStrip_txtGiagoc.Text = dgv[3, i].Value.ToString();
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_Chietkhau.Text = (Double.Parse(toolStrip_txtSoluong.Text) * Double.Parse(toolStrip_txtGiagoc.Text)).ToString();
toolStrip_txtTongTien.Text = (Double.Parse(toolStrip_txtSoluong.Text) * Double.Parse(toolStrip_txtGiagoc.Text)).ToString();
thue = dgv[7, i].Value.ToString();
for (int j = 0; j < dgv.RowCount; j++)
{
if (dgv[0, j].Value.ToString() != dgv[0, i].Value.ToString())
{
Entities.LayHangHoaTheoMaKhachHangTraLai row = new Entities.LayHangHoaTheoMaKhachHangTraLai();
row.Mahanghoa = dgv.Rows[j].Cells[0].Value.ToString();
row.Tenhanghoa = "" + dgv.Rows[j].Cells[1].Value.ToString();
row.Soluong = int.Parse(dgv.Rows[j].Cells[2].Value.ToString());
row.Giaban = dgv.Rows[j].Cells[3].Value.ToString();
row.Phantramchietkhau = dgv.Rows[j].Cells[4].Value.ToString();
row.Chietkhau = dgv.Rows[j].Cells[5].Value.ToString();
row.Tongtien = dgv.Rows[j].Cells[6].Value.ToString();
row.Thuegiatrigiatang = dgv.Rows[j].Cells[7].Value.ToString();
arr.Add(row);
}
else
{ continue; }
}
int n = arr.Count;
if (n == 0) { arr = null; }
list = new Entities.LayHangHoaTheoMaKhachHangTraLai[n];
for (int x = 0; x < n; x++)
{
list[x] = (Entities.LayHangHoaTheoMaKhachHangTraLai)arr[x];
}
dgv.DataSource = list;
}
else
{
list = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
arr = null;
dgv.DataSource = list;
fixDatagridview();
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void format()
{
if (dgvXemthongtin.RowCount <= 0)
{
dgvXemthongtin.DataSource = null;
Entities.LayHangHoaTheoMaKhachHangTraLai[] row = new Entities.LayHangHoaTheoMaKhachHangTraLai[0];
dgvXemthongtin.DataSource = row;
}
toolStrip_txtTracuu.Text = "";
toolStrip_txtSoluong.Text = "1";
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_txtTenhang.Text = "";
toolStrip_txtGiagoc.Text = "0";
}
