private void SelectDataHDNhap(string maKho)
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", new Entities.HoaDonNhap("Select", "", maKho, 1));
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh == null)
{
return;
}
List <Entities.HoaDonNhap> L = new List <Entities.HoaDonNhap>();
foreach (Entities.HoaDonNhap item in ddh)
{
if (item.MaKho.ToUpper().Equals(maKho.ToUpper()))
{
L.Add(item);
}
}
dgvHienThi.DataSource = L.ToArray();
FixDataGridView();
}
catch { }
}
public void SelectData(string str)
{
try
{
Entities.HoaDonNhap ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client1, "HDN", ctdh);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh == null)
{
hienthi = new Entities.HoaDonNhap[0];
dtgvKH.DataSource = hienthi;
return;
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[ddh.Length];
int sotang = 0;
for (int j = 0; j < ddh.Length; j++)
{
if (ddh[j].Deleted == false && ddh[j].MaNhaCungCap == str)
{
double ttn = Convert.ToDouble(ddh[j].ThanhToanNgay);
double ttnklp = Convert.ToDouble(ddh[j].ThanhToanSauKhiLapPhieu);
double tt = Convert.ToDouble(ddh[j].TongTien);
if ((ttn + ttnklp) != tt)
{
pt2[sotang] = ddh[j];
sotang++;
}
}
}
hienthi = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
hienthi = new Entities.HoaDonNhap[0];
dtgvKH.DataSource = hienthi;
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
public void LayHDNhap()
{
try
{
List <Entities.HoaDonNhap> listTemp = new List <Entities.HoaDonNhap>();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
//
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
listTemp.Add(HDN[i]);
}
}
//
HoaDonNhap = listTemp.ToArray();
}
catch
{
}
}
/// <summary>
/// hungvv =================sua====================
/// </summary>
/// <returns></returns>
private Entities.HoaDonNhap getDatagridview()
{
Entities.HoaDonNhap dathang = new Entities.HoaDonNhap();
int x = dgvHienThi.RowCount;
int y = dgvHienThi.ColumnCount;
if (y <= -1 || x <= -1)
{
}
else
{
int vitri = dgvHienThi.CurrentRow.Index;
dathang.MaHoaDonNhap = "" + dgvHienThi.Rows[vitri].Cells[2].Value.ToString().ToUpper();
dathang.NgayNhap = DateTime.Parse("" + dgvHienThi.Rows[vitri].Cells[3].Value.ToString());
dathang.MaNhaCungCap = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString().ToUpper();
dathang.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString();
dathang.NguoiGiaoHang = "" + dgvHienThi.Rows[vitri].Cells[6].Value.ToString();
dathang.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells[7].Value.ToString();
dathang.MaKho = "" + dgvHienThi.Rows[vitri].Cells[8].Value.ToString().ToUpper();
dathang.DieuKienThanhToan = "" + dgvHienThi.Rows[vitri].Cells[9].Value.ToString();
dathang.MaDonDatHang = "" + dgvHienThi.Rows[vitri].Cells[11].Value.ToString().ToUpper();
dathang.HanThanhToan = DateTime.Parse(dgvHienThi.Rows[vitri].Cells[10].Value.ToString());
dathang.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells[12].Value.ToString().ToUpper();
dathang.ChietKhau = dgvHienThi.Rows[vitri].Cells[13].Value.ToString();
dathang.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells[14].Value.ToString();
dathang.ThueGTGT = dgvHienThi.Rows[vitri].Cells[15].Value.ToString();
dathang.TongTien = dgvHienThi.Rows[vitri].Cells[16].Value.ToString();
dathang.GhiChu = "" + dgvHienThi.Rows[vitri].Cells[17].Value.ToString();
}
return(dathang);
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
string month1 = hdn[j].NgayNhap.Month.ToString();
string year1 = hdn[j].NgayNhap.Year.ToString();
if (hdn[j].Deleted == false && month1 == month && year == year1 && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
{
hdn = new Entities.HoaDonNhap[0];
}
}
catch { }
}
private void toolStripStatus_ThemMoi_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 4))
{
return;
}
for (int j = 0; j < 100; j++)
{
if (BaoDong == "")
{
frmXuLyNhapKho fr = new frmXuLyNhapKho("Insert");
fr.ShowDialog();
Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri();
tra = new Common.Utilities().CaiDatKho("View", "", "");
Entities.HoaDonNhap nhap = new Entities.HoaDonNhap();
nhap.Hanhdong = "Select";
nhap.MaHoaDonNhap = "";
nhap.MaKho = tra.Giatritruyen;
SelectData(nhap);
}
else
{
BaoDong = "";
break;
}
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// hungvv kiem tra dinh dang khi them moi hoa don
/// </summary>
/// <param name="maDonDatHang"></param>
private Boolean CheckData(Entities.HoaDonNhap dat)
{
if (dat.MaHoaDonNhap.Length <= 0)
{
txtSodonhang.Focus();
System.Windows.Forms.MessageBox.Show("Hãy nhập mã hóa đơn");
return(false);
}
else
{
if (dat.MaNhaCungCap.Length <= 0)
{
txtManhacungcap.Focus();
MessageBox.Show("Kiểm tra mã nhà cung cấp");
return(false);
}
else
{
if (dat.DieuKienThanhToan.Length <= 0)
{
cbxDieuKienThanhToan.Focus();
MessageBox.Show("Chọn điều kiện thanh toán");
return(false);
}
else
{
if (dat.MaKho.Length <= 0)
{
cbxKhoHang.Focus();
MessageBox.Show("Chọn mã kho");
return(false);
}
else
{
if (dat.MaTienTe.Length <= 0)
{
cbxTienTe_TyGia.Focus();
MessageBox.Show("Loại tiền tệ không đúng");
return(false);
}
else
{
if (dat.MaDonDatHang.Length <= 0 && chekChonLoai.Checked == true)
{
txtMadondathang.Text = "";
txtMadondathang.Focus();
System.Windows.Forms.MessageBox.Show("Hãy nhập mã đơn đặt hàng");
return(false);
}
else
{
return(true);
}
}
}
}
}
}
}
/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void Select_ChiTietHoaDonNhap(string hanhdong)
{
Entities.HoaDonNhap pt = new Entities.HoaDonNhap();
pt = new Entities.HoaDonNhap(hanhdong);
Entities.ChiTietHoaDonNhap[] pt1 = new Entities.ChiTietHoaDonNhap[10];
clientstrem = cl.SerializeObj(this.client, "ChiTietHoaDonNhap", pt);
Binding((Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper(clientstrem, pt1));
}
public Entities.HoaDonNhap[] HoaDonNhap()
{
Entities.HoaDonNhap[] hdn = new BizLogic.HoaDonNhap().Select();
if (hdn == null)
{
hdn = new Entities.HoaDonNhap[0];
}
return(hdn);
}
private Entities.HoaDonNhap HanThanhToanNhoNhat(List <Entities.HoaDonNhap> l)
{
Entities.HoaDonNhap kq = new Entities.HoaDonNhap();
int temp = 31;
foreach (Entities.HoaDonNhap item in l)
{
temp = item.HanThanhToan.Day;
kq = item;
}
return(kq);
}
private void toolStripStatusLabel2_Click(object sender, EventArgs e)
{
try
{
Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri();
tra = new Common.Utilities().CaiDatKho("View", "", "");
Entities.HoaDonNhap nhap = new Entities.HoaDonNhap();
nhap.Hanhdong = "Select";
nhap.MaHoaDonNhap = "";
nhap.MaKho = tra.Giatritruyen;
SelectData(nhap);
}
catch (Exception ex)
{ string s = ex.Message; }
}
private void txtTimkiem_TextChanged(object sender, EventArgs e)
{
try
{
SearchData(rdbMa, rdbNgay, rdoTatca, dgvHienThi, txtTimkiem.Text, hoadonnhap);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = k;
FixDatagridview(dgvHienThi);
count = 1;
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HoaDonNhap[0];
return;
}
int soluong = 0;
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HoaDonNhap[0];
return;
}
Entities.HoaDonNhap[] hienthitheoma = new Entities.HoaDonNhap[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoma;
}
}
finally
{
fix();
}
}
/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void SelectData()
{
dgvHienThi.DataSource = null;
ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
dgvHienThi.DataSource = ddh;
dgvHienThi.Columns[1].Visible = false;
dgvHienThi.Columns[0].HeaderText = "STT";
new Common.Utilities().CountDatagridview(dgvHienThi);
client.Close();
clientstrem.Close();
}
public void LayHDNhap()
{
try
{
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = new BizLogic.HoaDonNhap().Select();
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
int count = 0;
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
count++;
}
}
Entities.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count];
count = 0;
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
HoaDonNhap1[count] = HDN[i];
count++;
}
}
if (HoaDonNhap1.Length == 0)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
else
{
HoaDonNhap = HoaDonNhap1;
}
}
catch
{
}
}
private void XuLy_Xoa_HoaDonNhap(string hanhdong, string mahoadonnhap)
{
Entities.HoaDonNhap them = new Entities.HoaDonNhap();
them = new Entities.HoaDonNhap(hanhdong, mahoadonnhap);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", them);
//hứng giá trị trả về
int trave;
Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1];
trave = (int)cl.DeserializeHepper(clientstrem, tralai);
//thong bao
if (trave == 1)
{
MessageBox.Show("Thành công !");
}
else
{
MessageBox.Show("Thất bại !");
}
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
if (hdn == null || hdn.Length == 0)
{
hdn = new Entities.HoaDonNhap[0];
return;
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
DateTime hientai = hdn[j].NgayNhap;
if (hdn[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date&& hientai.Date < Convert.ToDateTime(ketthuc).Date)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
{
hdn = new Entities.HoaDonNhap[0];
}
}
catch (Exception ex)
{
}
finally
{
}
}
/// <summary>
/// hungvv =======================Xoa ===========================
/// </summary>
private void DeleteData(string ID)
{
ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Delete",ID);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh);
int trave = 0;
trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave));
client.Close();
clientstrem.Close();
if (trave == 1)
{
SelectData();
MessageBox.Show("Thành công !");
}
if (trave == 0)
{
MessageBox.Show("Thất bại !");
}
}
/// <summary>
/// hungvv =================do du lieu vao txt===========================
/// </summary>
/// <param name="dat"></param>
private void DoDuLieu(Entities.HoaDonNhap dat)
{
Common.Utilities com = new Common.Utilities();
txtSodonhang.Text = dat.MaHoaDonNhap;
txtManhacungcap.Text = dat.MaNhaCungCap;
GiaTriCanLuu.Ma = dat.MaNhaCungCap;
makNgaydonhang.Text = com.XuLy(2, dat.NgayNhap.ToString());
makHanthanhtoan.Text = com.XuLy(2, dat.HanThanhToan.ToString());
txtNohienthoi.Text = dat.NoHienThoi.ToString();
txtnguoigiaohang.Text = dat.NguoiGiaoHang;
cbxHinhthucthanhtoan.SelectedItem = dat.HinhThucThanhToan;
cbxKhoHang.SelectedValue = dat.MaKho;
cbxDieuKienThanhToan.SelectedItem = dat.DieuKienThanhToan;
txtMadondathang.Text = dat.MaDonDatHang;
cbxTienTe_TyGia.SelectedValue = dat.MaTienTe;
txtChietkhau.Text = dat.ChietKhau.ToString();
txtThanhtoanngay.Text = dat.ThanhToanNgay.ToString();
txtGiatrigiatang.Text = dat.ThueGTGT.ToString();
txtTongtien.Text = dat.TongTien.ToString();
txtDiengiai.Text = dat.GhiChu;
//HienThi_ChiTiet_HoaDonNhap();
}
/// <summary>
/// hungvv =======================Xoa ===========================
/// </summary>
private void DeleteData(string ID)
{
ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Delete", ID);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh);
int trave = 0;
trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave));
client.Close();
clientstrem.Close();
if (trave == 1)
{
SelectData();
MessageBox.Show("Thành công !");
}
if (trave == 0)
{
MessageBox.Show("Thất bại !");
}
}
private void SelectData(Entities.HoaDonNhap nhap)
{
try
{
dgvHienThi.DataSource = null;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", nhap);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
client.Close();
clientstrem.Close();
if (ddh.Length > 0)
{
hoadonnhap = new Entities.HoaDonNhap[ddh.Length];
hoadonnhap = ddh;
dgvHienThi.DataSource = null;
dgvHienThi.DataSource = hoadonnhap;
}
else
{
dgvHienThi.DataSource = null;
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = lay;
hoadonnhap = null;
}
FixDatagridview(dgvHienThi);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = lay;
FixDatagridview(dgvHienThi);
hoadonnhap = null;
}
}
/// <summary>
/// hungvv =================sua====================
/// </summary>
/// <returns></returns>
private Entities.HoaDonNhap getDatagridview()
{
Entities.HoaDonNhap dathang = new Entities.HoaDonNhap();
int x = dgvHienThi.RowCount;
int y = dgvHienThi.ColumnCount;
if (y <= -1 || x <= -1)
{ }
else
{
int vitri = dgvHienThi.CurrentRow.Index;
dathang.MaHoaDonNhap = "" + dgvHienThi.Rows[vitri].Cells[2].Value.ToString().ToUpper();
dathang.NgayNhap = DateTime.Parse("" + dgvHienThi.Rows[vitri].Cells[3].Value.ToString());
dathang.MaNhaCungCap = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString().ToUpper();
dathang.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString();
dathang.NguoiGiaoHang = ""+dgvHienThi.Rows[vitri].Cells[6].Value.ToString();
dathang.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells[7].Value.ToString();
dathang.MaKho = "" + dgvHienThi.Rows[vitri].Cells[8].Value.ToString().ToUpper();
dathang.DieuKienThanhToan = "" + dgvHienThi.Rows[vitri].Cells[9].Value.ToString();
dathang.MaDonDatHang = "" + dgvHienThi.Rows[vitri].Cells[11].Value.ToString().ToUpper();
dathang.HanThanhToan = DateTime.Parse(dgvHienThi.Rows[vitri].Cells[10].Value.ToString());
dathang.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells[12].Value.ToString().ToUpper();
dathang.ChietKhau = dgvHienThi.Rows[vitri].Cells[13].Value.ToString();
dathang.ThanhToanNgay =dgvHienThi.Rows[vitri].Cells[14].Value.ToString();
dathang.ThueGTGT = dgvHienThi.Rows[vitri].Cells[15].Value.ToString();
dathang.TongTien = dgvHienThi.Rows[vitri].Cells[16].Value.ToString();
dathang.GhiChu = "" + dgvHienThi.Rows[vitri].Cells[17].Value.ToString();
}
return dathang;
}
public void LayHDNhap()
{
try
{
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = new BizLogic.HoaDonNhap().Select();
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
int count = 0;
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
count++;
}
}
Entities.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count];
count = 0;
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
HoaDonNhap1[count] = HDN[i];
count++;
}
}
if (HoaDonNhap1.Length == 0)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
else
HoaDonNhap = HoaDonNhap1;
}
catch
{
}
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
if (hdn == null || hdn.Length == 0)
{
hdn = new Entities.HoaDonNhap[0];
return;
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
string month1 = hdn[j].NgayNhap.Month.ToString();
string year1 = hdn[j].NgayNhap.Year.ToString();
if (hdn[j].Deleted == false && month1 == month && year1 == year)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
hdn = new Entities.HoaDonNhap[0];
}
catch { }
}
private void SelectDataHDNhap(string maKho)
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", new Entities.HoaDonNhap("Select", "", maKho, 1));
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh == null)
{
return;
}
List<Entities.HoaDonNhap> L = new List<Entities.HoaDonNhap>();
foreach (Entities.HoaDonNhap item in ddh)
{
if (item.MaKho.ToUpper().Equals(maKho.ToUpper()))
{
L.Add(item);
}
}
dgvHienThi.DataSource = L.ToArray();
FixDataGridView();
}
catch { }
}
public void LayHDNhap()
{
try
{
List<Entities.HoaDonNhap> listTemp = new List<Entities.HoaDonNhap>();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", "");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0];
HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
HoaDonNhap = new Entities.HoaDonNhap[0];
return;
}
//
for (int i = 0; i < HDN.Length; i++)
{
DateTime ngaylap = HDN[i].NgayNhap;
if (ngaylap >= BatDau && ngaylap <= KetThuc)
{
listTemp.Add(HDN[i]);
}
}
//
HoaDonNhap = listTemp.ToArray();
}
catch
{
}
}
public frmXuLy_HoaDonNhap(string hanhdong, Entities.HoaDonNhap hoa)
{
InitializeComponent();
this.hanhdong = hanhdong;
this.hoadon = hoa;
}
/// <summary>
/// them moi, sua thong tin don dat hang
/// </summary>
/// <param name="hanhdong"></param>
private void XuLy_HoaDonNhap(string hanhdong)
{
try
{
Entities.HoaDonNhap don = new Entities.HoaDonNhap();
string thoigian_1 = null;
thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text);
string thoigian_2 = null;
thoigian_2 = new Common.Utilities().MyDateConversion(makHanthanhtoan.Text);
if (thoigian_1 != null && thoigian_2 != null)
{
don.NgayNhap = DateTime.Parse(thoigian_1);
thoigian_1 = null;
don.HanThanhToan = DateTime.Parse(thoigian_2);
thoigian_2 = null;
don.Hanhdong = hanhdong;
don.MaHoaDonNhap = "" + txtSodonhang.Text.ToUpper();
don.MaNhaCungCap = "" + txtManhacungcap.Text.ToUpper();
don.NoHienThoi = 0+txtNohienthoi.Text;
don.NguoiGiaoHang = "" + txtnguoigiaohang.Text;
don.HinhThucThanhToan = "" + cbxHinhthucthanhtoan.SelectedItem.ToString();
don.MaKho = "" + cbxKhoHang.SelectedValue.ToString().ToUpper();
don.DieuKienThanhToan = "" + cbxDieuKienThanhToan.SelectedItem.ToString();
string MaDonDatHang = txtMadondathang.Text.ToUpper();
if (MaDonDatHang == "<F4 -TRA CỨU>" || MaDonDatHang.Length <= 0)
{
MaDonDatHang = "NULL";
}
don.MaDonDatHang = MaDonDatHang;
don.MaTienTe = "" + cbxTienTe_TyGia.SelectedValue.ToString().ToUpper();
don.ChietKhau = 0+txtChietkhau.Text;
don.ThanhToanNgay = 0+txtThanhtoanngay.Text;
don.ThueGTGT = 0+txtGiatrigiatang.Text;
don.TongTien = 0+txtTongtien.Text;
don.GhiChu = txtDiengiai.Text;
don.Deleted = false;
if (dgvInsertOrder.RowCount > 0)
{
if (CheckData(don) == true)
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", don);
Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1];
int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai));
if (trave == 1)
{
LuuChiTietDonHang();
//cap nhat trang thai don dat hang
CapNhatTrangThaiDonDatHang("Update",MaDonDatHang,"Đã thành công");
MessageBox.Show("Thành công");
frmHienThi_HoaDonNhap.BaoDong = "";
this.Close();
}
else
{
MessageBox.Show("Thất bại");
}
}
}
else
{ MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); }
}
else
{ MessageBox.Show("Kiểm tra ngày"); }
}
catch (Exception ex)
{
string s = ex.Message.ToString();
MessageBox.Show("Thông tin nhập không đúng");
}
}
private void XuLy_Xoa_HoaDonNhap(string hanhdong, string mahoadonnhap)
{
Entities.HoaDonNhap them = new Entities.HoaDonNhap();
them = new Entities.HoaDonNhap(hanhdong, mahoadonnhap);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", them);
//hứng giá trị trả về
int trave;
Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1];
trave = (int)cl.DeserializeHepper(clientstrem, tralai);
//thong bao
if (trave == 1) { MessageBox.Show("Thành công !"); }
else { MessageBox.Show("Thất bại !"); }
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
if (hdn == null || hdn.Length == 0)
{
hdn = new Entities.HoaDonNhap[0];
return;
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
DateTime hientai = hdn[j].NgayNhap;
if (hdn[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date && hientai.Date < Convert.ToDateTime(ketthuc).Date)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
hdn = new Entities.HoaDonNhap[0];
}
catch (Exception ex)
{
}
finally
{
}
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
string month1 = hdn[j].NgayNhap.Month.ToString();
string year1 = hdn[j].NgayNhap.Year.ToString();
if (hdn[j].Deleted == false && month1 == month && year == year1 && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
hdn = new Entities.HoaDonNhap[0];
}
catch { }
}
public frmXuLy_HoaDonNhap(string hanhdong,Entities.HoaDonNhap hoa)
{
InitializeComponent();
this.hanhdong = hanhdong;
this.hoadon = hoa;
}
//Entities.HDBanHang[] hienthi;
public void SelectDatancc()
{
try
{
DateTime dateSerVer = DateServer.Date();
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.HoaDonNhap pt = new Entities.HoaDonNhap("Select");
// khởi tạo mảng đối tượng để hứng giá trị
pt1 = new Entities.HoaDonNhap[1];
clientstrem = cl.SerializeObj(this.client1, "HDN", pt);
// đổ mảng đối tượng vào datagripview
pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1);
if (pt1 == null)
pt1 = new Entities.HoaDonNhap[0];
if (int.Parse(duno) != 0)
{
List<Entities.HoaDonNhap> l = new List<Entities.HoaDonNhap>();
for (int j = 0; j < pt1.Length; j++)
{
double noHienThoi = 0;
double thanhToanNgay = 0;
double tongTien = 0;
double thanhToanNgayKhiLapPhieu = 0;
DateTime hanThanhToan = pt1[j].HanThanhToan;
int YY = dateSerVer.Year;
int MM = dateSerVer.Month;
int DD = dateSerVer.Day;
if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay))
thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay);
if (!string.IsNullOrEmpty(pt1[j].TongTien))
tongTien = double.Parse(pt1[j].TongTien);
if (!string.IsNullOrEmpty(pt1[j].ThanhToanSauKhiLapPhieu))
thanhToanNgayKhiLapPhieu = double.Parse(pt1[j].ThanhToanSauKhiLapPhieu);
noHienThoi = thanhToanNgay + thanhToanNgayKhiLapPhieu - tongTien;
if (pt1[j].MaNhaCungCap.Equals(mancc) && YY == hanThanhToan.Year && MM == hanThanhToan.Month && (hanThanhToan.Day - DD) <= 3 && (hanThanhToan.Day - DD) >= 0 && (noHienThoi != 0))
{
l.Add(pt1[j]);
}
}
Entities.HoaDonNhap hdn = HanThanhToanNhoNhat(l);
if (hdn != null && !string.IsNullOrEmpty(hdn.MaHoaDonNhap))
label1.Text = "Sắp tới hạn thanh toán với nhà cung cấp " + hdn.HanThanhToan.ToString("dd/MM/yyyy");
}
}
catch { }
}
/// <summary>
/// kiểm tra dtgv trước khi update
/// </summary>
/// <param name="dgv"></param>
public bool CheckDataGridUpdate(DataGridView dgv)
{
bool kkt = false;
try
{
if (dgv.RowCount != 0)
{
Entities.HoaDonNhap[] cthdbh = new Entities.HoaDonNhap[dgv.RowCount];
for (int j = 0; j < cthdbh.Length; j++)
{
double tongtien = Convert.ToDouble(dgv[1, j].Value.ToString());
double sotienno = Convert.ToDouble(dgv[2, j].Value.ToString());
double sothanhtoan = Convert.ToDouble(dgv[3, j].Value.ToString());
double thanhtoankhilap = Convert.ToDouble(dgv[4, j].Value.ToString());
string sotiendathanhtoan = (sothanhtoan + thanhtoankhilap).ToString();
cthdbh[j] = new Entities.HoaDonNhap("Update", dgv[0, j].Value.ToString(), sotiendathanhtoan);
}
kkt = InsertMang(cthdbh);
return kkt;
}
return kkt;
}
catch
{
return false;
}
}
//Entities.HDBanHang[] hienthi;
public void SelectDatancc()
{
try
{
DateTime dateSerVer = DateServer.Date();
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.HoaDonNhap pt = new Entities.HoaDonNhap("Select");
// khởi tạo mảng đối tượng để hứng giá trị
pt1 = new Entities.HoaDonNhap[1];
clientstrem = cl.SerializeObj(this.client1, "HDN", pt);
// đổ mảng đối tượng vào datagripview
pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1);
if (pt1 == null)
{
pt1 = new Entities.HoaDonNhap[0];
}
if (int.Parse(duno) != 0)
{
List <Entities.HoaDonNhap> l = new List <Entities.HoaDonNhap>();
for (int j = 0; j < pt1.Length; j++)
{
double noHienThoi = 0;
double thanhToanNgay = 0;
double tongTien = 0;
double thanhToanNgayKhiLapPhieu = 0;
DateTime hanThanhToan = pt1[j].HanThanhToan;
int YY = dateSerVer.Year;
int MM = dateSerVer.Month;
int DD = dateSerVer.Day;
if (!string.IsNullOrEmpty(pt1[j].ThanhToanNgay))
{
thanhToanNgay = double.Parse(pt1[j].ThanhToanNgay);
}
if (!string.IsNullOrEmpty(pt1[j].TongTien))
{
tongTien = double.Parse(pt1[j].TongTien);
}
if (!string.IsNullOrEmpty(pt1[j].ThanhToanSauKhiLapPhieu))
{
thanhToanNgayKhiLapPhieu = double.Parse(pt1[j].ThanhToanSauKhiLapPhieu);
}
noHienThoi = thanhToanNgay + thanhToanNgayKhiLapPhieu - tongTien;
if (pt1[j].MaNhaCungCap.Equals(mancc) && YY == hanThanhToan.Year && MM == hanThanhToan.Month && (hanThanhToan.Day - DD) <= 3 && (hanThanhToan.Day - DD) >= 0 && (noHienThoi != 0))
{
l.Add(pt1[j]);
}
}
Entities.HoaDonNhap hdn = HanThanhToanNhoNhat(l);
if (hdn != null && !string.IsNullOrEmpty(hdn.MaHoaDonNhap))
{
label1.Text = "Sắp tới hạn thanh toán với nhà cung cấp " + hdn.HanThanhToan.ToString("dd/MM/yyyy");
}
}
}
catch { }
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HoaDonNhap[0];
return;
}
int soluong = 0;
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HoaDonNhap[0];
return;
}
Entities.HoaDonNhap[] hienthitheoma = new Entities.HoaDonNhap[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHoaDonNhap.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoma;
}
}
finally
{
fix();
}
}
/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void SelectData()
{
dgvHienThi.DataSource = null;
ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", ctdh);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
dgvHienThi.DataSource = ddh;
dgvHienThi.Columns[1].Visible = false;
dgvHienThi.Columns[0].HeaderText = "STT";
new Common.Utilities().CountDatagridview(dgvHienThi);
client.Close();
clientstrem.Close();
}
/// <summary>
/// select nhập kho
/// </summary>
private void SelectNhapKho()
{
try
{
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[hdn.Length];
int sotang = 0;
for (int j = 0; j < hdn.Length; j++)
{
if (hdn[j].Deleted == false && batDau <= hdn[j].NgayNhap && hdn[j].NgayNhap <= ketThuc && Convert.ToDouble(hdn[j].ThanhToanNgay) != 0)
{
pt2[sotang] = hdn[j];
sotang++;
}
}
hdn = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hdn[j] = pt2[j];
}
}
else
hdn = new Entities.HoaDonNhap[0];
}
catch (Exception ex)
{
}
finally
{
}
}
/// <summary>
/// hungvv =======================giao tiep voi server===========================
/// </summary>
private void Select_ChiTietHoaDonNhap(string hanhdong)
{
Entities.HoaDonNhap pt = new Entities.HoaDonNhap();
pt = new Entities.HoaDonNhap(hanhdong);
Entities.ChiTietHoaDonNhap[] pt1 = new Entities.ChiTietHoaDonNhap[10];
clientstrem = cl.SerializeObj(this.client, "ChiTietHoaDonNhap", pt);
Binding((Entities.ChiTietHoaDonNhap[])cl.DeserializeHepper(clientstrem, pt1));
}
/// <summary>
/// them moi, sua thong tin don dat hang
/// </summary>
/// <param name="hanhdong"></param>
private void XuLy_HoaDonNhap(string hanhdong)
{
try
{
Entities.HoaDonNhap don = new Entities.HoaDonNhap();
string thoigian_1 = null;
thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text);
string thoigian_2 = null;
thoigian_2 = new Common.Utilities().MyDateConversion(makHanthanhtoan.Text);
if (thoigian_1 != null && thoigian_2 != null)
{
don.NgayNhap = DateTime.Parse(thoigian_1);
thoigian_1 = null;
don.HanThanhToan = DateTime.Parse(thoigian_2);
thoigian_2 = null;
don.Hanhdong = hanhdong;
don.MaHoaDonNhap = "" + txtSodonhang.Text.ToUpper();
don.MaNhaCungCap = "" + txtManhacungcap.Text.ToUpper();
don.NoHienThoi = 0 + txtNohienthoi.Text;
don.NguoiGiaoHang = "" + txtnguoigiaohang.Text;
don.HinhThucThanhToan = "" + cbxHinhthucthanhtoan.SelectedItem.ToString();
don.MaKho = "" + cbxKhoHang.SelectedValue.ToString().ToUpper();
don.DieuKienThanhToan = "" + cbxDieuKienThanhToan.SelectedItem.ToString();
string MaDonDatHang = txtMadondathang.Text.ToUpper();
if (MaDonDatHang == "<F4 -TRA CỨU>" || MaDonDatHang.Length <= 0)
{
MaDonDatHang = "NULL";
}
don.MaDonDatHang = MaDonDatHang;
don.MaTienTe = "" + cbxTienTe_TyGia.SelectedValue.ToString().ToUpper();
don.ChietKhau = 0 + txtChietkhau.Text;
don.ThanhToanNgay = 0 + txtThanhtoanngay.Text;
don.ThueGTGT = 0 + txtGiatrigiatang.Text;
don.TongTien = 0 + txtTongtien.Text;
don.GhiChu = txtDiengiai.Text;
don.Deleted = false;
if (dgvInsertOrder.RowCount > 0)
{
if (CheckData(don) == true)
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", don);
Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1];
int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai));
if (trave == 1)
{
LuuChiTietDonHang();
//cap nhat trang thai don dat hang
CapNhatTrangThaiDonDatHang("Update", MaDonDatHang, "Đã thành công");
MessageBox.Show("Thành công");
frmHienThi_HoaDonNhap.BaoDong = "";
this.Close();
}
else
{
MessageBox.Show("Thất bại");
}
}
}
else
{
MessageBox.Show("Không có hàng hóa trong đơn đặt hàng");
}
}
else
{
MessageBox.Show("Kiểm tra ngày");
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
MessageBox.Show("Thông tin nhập không đúng");
}
}
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim, Entities.HoaDonNhap[] mangtim)
{
try
{
if (giatritim.Length > 0)
{
if (mangtim.Length > 0)
{
if (rdoNgay.Checked == true)
{
if (mangtim == null)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
Boolean check = false;
List <Entities.HoaDonNhap> tt1_search = new List <Entities.HoaDonNhap>();
for (int i = 0; i < mangtim.Length; i++)
{
int index = -1;
index = mangtim[i].NgayNhap.ToString().ToLower().IndexOf(giatritim.ToLower());
if (index >= 0)
{
check = true;
tt1_search.Add(mangtim[i]);
}
}
if (check == false)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
dgv.DataSource = tt1_search.ToArray();
tt1_search = null;
}
}
}
if (rdoMa.Checked == true)
{
if (mangtim == null)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
Boolean check = false;
List <Entities.HoaDonNhap> tt1_search = new List <Entities.HoaDonNhap>();
for (int i = 0; i < mangtim.Length; i++)
{
int index = -1;
index = mangtim[i].MaHoaDonNhap.ToString().ToLower().IndexOf(giatritim.ToLower());
if (index >= 0)
{
check = true;
tt1_search.Add(mangtim[i]);
}
}
if (check == false)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
dgv.DataSource = tt1_search.ToArray();
tt1_search = null;
}
}
}
if (rdoTatca.Checked == true)
{
if (mangtim != null)
{
dgv.DataSource = mangtim;
}
else
{
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
}
}
}
else
{
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
}
}
else
{
if (rdoTatca.Checked == true)
{
dgv.DataSource = mangtim;
}
}
FixDatagridview(dgv);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
FixDatagridview(dgv);
count = 1;
}
}
private void SearchData(RadioButton rdoMa, RadioButton rdoNgay, RadioButton rdoTatCa, DataGridView dgv, string giatritim, Entities.HoaDonNhap[] mangtim)
{
try
{
if (giatritim.Length > 0)
{
if (mangtim.Length > 0)
{
if (rdoNgay.Checked == true)
{
if (mangtim == null)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
Boolean check = false;
List<Entities.HoaDonNhap> tt1_search = new List<Entities.HoaDonNhap>();
for (int i = 0; i < mangtim.Length; i++)
{
int index = -1;
index = mangtim[i].NgayNhap.ToString().ToLower().IndexOf(giatritim.ToLower());
if (index >= 0)
{
check = true;
tt1_search.Add(mangtim[i]);
}
}
if (check == false)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
dgv.DataSource = tt1_search.ToArray();
tt1_search = null;
}
}
}
if (rdoMa.Checked == true)
{
if (mangtim == null)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
Boolean check = false;
List<Entities.HoaDonNhap> tt1_search = new List<Entities.HoaDonNhap>();
for (int i = 0; i < mangtim.Length; i++)
{
int index = -1;
index = mangtim[i].MaHoaDonNhap.ToString().ToLower().IndexOf(giatritim.ToLower());
if (index >= 0)
{
check = true;
tt1_search.Add(mangtim[i]);
}
}
if (check == false)
{
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgv.DataSource = lay;
}
else
{
dgv.DataSource = tt1_search.ToArray();
tt1_search = null;
}
}
}
if (rdoTatca.Checked == true)
{
if (mangtim != null)
{
dgv.DataSource = mangtim;
}
else
{
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
}
}
}
else
{
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
}
}
else
{
if (rdoTatca.Checked == true)
{
dgv.DataSource = mangtim;
}
}
FixDatagridview(dgv);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgv.DataSource = k;
FixDatagridview(dgv);
count = 1;
}
}
private void SelectData(Entities.HoaDonNhap nhap)
{
try
{
dgvHienThi.DataSource = null;
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", nhap);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
client.Close();
clientstrem.Close();
if (ddh.Length > 0)
{
hoadonnhap = new Entities.HoaDonNhap[ddh.Length];
hoadonnhap = ddh;
dgvHienThi.DataSource = null;
dgvHienThi.DataSource = hoadonnhap;
}
else
{
dgvHienThi.DataSource = null;
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = lay;
hoadonnhap = null;
}
FixDatagridview(dgvHienThi);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] lay = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = lay;
FixDatagridview(dgvHienThi);
hoadonnhap = null;
}
}
private void toolStripStatusLabel2_Click(object sender, EventArgs e)
{
try
{
Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri();
tra = new Common.Utilities().CaiDatKho("View", "", "");
Entities.HoaDonNhap nhap = new Entities.HoaDonNhap();
nhap.Hanhdong = "Select";
nhap.MaHoaDonNhap = "";
nhap.MaKho = tra.Giatritruyen;
SelectData(nhap);
}
catch (Exception ex)
{ string s = ex.Message; }
}
private Entities.HoaDonNhap HanThanhToanNhoNhat(List<Entities.HoaDonNhap> l)
{
Entities.HoaDonNhap kq = new Entities.HoaDonNhap();
int temp = 31;
foreach (Entities.HoaDonNhap item in l)
{
temp = item.HanThanhToan.Day;
kq = item;
}
return kq;
}
private void toolStripStatus_ThemMoi_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !CheckQuyen(this.Name, 4))
{ return; }
for (int j = 0; j < 100; j++)
{
if (BaoDong == "")
{
frmXuLyNhapKho fr = new frmXuLyNhapKho("Insert");
fr.ShowDialog();
Entities.TruyenGiaTri tra = new Entities.TruyenGiaTri();
tra = new Common.Utilities().CaiDatKho("View", "", "");
Entities.HoaDonNhap nhap = new Entities.HoaDonNhap();
nhap.Hanhdong = "Select";
nhap.MaHoaDonNhap = "";
nhap.MaKho = tra.Giatritruyen;
SelectData(nhap);
}
else
{
BaoDong = "";
break;
}
}
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// select hóa đơn nhập
/// </summary>
public void SelectHoaDonNhap()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HoaDonNhap pt = new Entities.HoaDonNhap("Select");
Entities.HoaDonNhap[] pt1 = new Entities.HoaDonNhap[1];
clientstrem = cl.SerializeObj(this.client1, "HDN", pt);
pt1 = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, pt1);
if (pt1 == null)
{
hienthi = new Entities.HoaDonNhap[0];
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[pt1.Length];
int sotang = 0;
for (int j = 0; j < pt1.Length; j++)
{
if (pt1[j].Deleted == false)
{
pt2[sotang] = pt1[j];
sotang++;
}
}
hienthi = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
}
catch (Exception ex)
{
}
finally
{
}
}
private void txtTimkiem_TextChanged(object sender, EventArgs e)
{
try
{
SearchData(rdbMa, rdbNgay, rdoTatca, dgvHienThi, txtTimkiem.Text, hoadonnhap);
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HoaDonNhap[] k = new Entities.HoaDonNhap[0];
dgvHienThi.DataSource = k;
FixDatagridview(dgvHienThi);
count = 1;
}
}
public void SelectData(string str)
{
try
{
Entities.HoaDonNhap ctdh = new Entities.HoaDonNhap();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctdh = new Entities.HoaDonNhap("Select");
clientstrem = cl.SerializeObj(this.client1, "HDN", ctdh);
Entities.HoaDonNhap[] ddh = new Entities.HoaDonNhap[1];
ddh = (Entities.HoaDonNhap[])cl.DeserializeHepper(clientstrem, ddh);
if (ddh == null)
{
hienthi = new Entities.HoaDonNhap[0];
dtgvKH.DataSource = hienthi;
return;
}
Entities.HoaDonNhap[] pt2 = new Entities.HoaDonNhap[ddh.Length];
int sotang = 0;
for (int j = 0; j < ddh.Length; j++)
{
if (ddh[j].Deleted == false && ddh[j].MaNhaCungCap==str)
{
double ttn = Convert.ToDouble(ddh[j].ThanhToanNgay);
double ttnklp = Convert.ToDouble(ddh[j].ThanhToanSauKhiLapPhieu);
double tt = Convert.ToDouble(ddh[j].TongTien);
if ((ttn + ttnklp) != tt)
{
pt2[sotang] = ddh[j];
sotang++;
}
}
}
hienthi = new Entities.HoaDonNhap[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
hienthi = new Entities.HoaDonNhap[0];
dtgvKH.DataSource = hienthi;
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
public Entities.HoaDonNhap[] HoaDonNhap()
{
Entities.HoaDonNhap[] hdn = new BizLogic.HoaDonNhap().Select();
if (hdn == null)
hdn = new Entities.HoaDonNhap[0];
return hdn;
}
