void loadPhieuNhap(DataTable bang)
{
if (pn.Count != 0)
{
for (int i = 0; i < pn.Count; i++)
{
pn.RemoveAt(i);
}
pn = XL_PhieuNhap.ChuyenDoiDTOPhieuNhap(bang);
}
}
private void buttonThem_Click(object sender, EventArgs e)
{
//load du lieu
loadPhieuNhap(XL_PhieuNhap.LayDuLieuPhieuNhap());
//co hieu
int cohieu = 1;
//phieu nhap
string maphieunhap = textBoxMaPhieuNhap.Text;
string ngaynhap = dateTimePickerNgayNhap.Value.ToString();
string hanthanhtoan = dateTimePickerHanThanhToan.Value.ToString();
string manhanvien = gridLookUpEditNhanVien.Text;
string kho = gridLookUpEditKho.Text;
string manhacungcap = gridLookUpEditNCC.Text;
string dieukhoan = gridLookUpEditDieuKhoanThanhToan.Text;
string hinhthucthanhtoan = gridLookUpEditHinhThucThanhToan.Text;
string tientratruoc = textBoxTienTraTruoc.Text;
//tien
double TongTien = 0;
int soluong;
float gia;
for (int i = 0; i < dataGridViewCTPhieuNhap.Rows.Count; i++)
{
//object m = dataGridViewCTPhieuNhap["SoLuong", i].Value;
//object n = dataGridViewCTPhieuNhap["GiaLucNhap", i].Value;
object n = dataGridViewCTPhieuNhap.Rows[i].Cells["GiaLucNhap"].Value;
object m = dataGridViewCTPhieuNhap.Rows[i].Cells["SoLuong"].Value;
if (m != null && n != null)
{
soluong = int.Parse(m.ToString());
gia = float.Parse(n.ToString());
double thue = (soluong * gia) * 0.1;
TongTien += ((soluong * gia) + thue);
}
}
textBoxTongTien.Text = TongTien.ToString();
//xet ma hoa don
for (int i = 0; i < pn.Count; i++)
{
if (maphieunhap == pn[i].MaPhieuNhap)
{
cohieu = 0;
break;
}
}
//phieunhap
if (maphieunhap != "" && cohieu == 1 && ngaynhap != "" && hanthanhtoan != "" && manhanvien != "" &&
kho != "" && manhacungcap != "" && dieukhoan != "" && hinhthucthanhtoan != "" && tientratruoc != "" && dataGridViewCTPhieuNhap.Rows.Count - 1 != 0)
{
bool ThemPhieuNhap = XL_PhieuNhap.ThemPhieuNhap(maphieunhap, ngaynhap, manhanvien, kho, manhacungcap, hinhthucthanhtoan, dieukhoan, TongTien, hanthanhtoan, tientratruoc);
if (ThemPhieuNhap == true)
{
List <bool> ThemCTPhieuNhap = new List <bool>();
int lengt = dataGridViewCTPhieuNhap.Rows.Count;
//ct phieu nhap
int sl = ctpn.Count;
for (int i = 0; i < lengt; i++)
{
//
object m = dataGridViewCTPhieuNhap.Rows[i].Cells["MaSP"].Value;
object n = dataGridViewCTPhieuNhap.Rows[i].Cells["GiaLucNhap"].Value;
object o = dataGridViewCTPhieuNhap.Rows[i].Cells["SoLuong"].Value;
if (m != null && n != null && o != null)
{
CTPhieuNhap temp = new CTPhieuNhap();
//cap phat ma ct phieu nhap tu dong
sl += 1;
temp.MaChiTietNhap = string.Format("CTPN" + sl.ToString());
temp.MaPhieuNhap = maphieunhap;
temp.MaSP = m.ToString();
temp.DonGiaSP = float.Parse(n.ToString());
temp.SoLuongMua = int.Parse(o.ToString());
float thue = 0.1f;
temp.Thue = thue;
//tien moi loai sp
float soluongsp = int.Parse(o.ToString());
float giasp = float.Parse(n.ToString());
double tienthue = (soluongsp * giasp * 0.1);
double tien = ((soluongsp * giasp) + tienthue);
temp.ThanhTien = float.Parse(tien.ToString());
bool Them = XL_CTPhieuNhap.ThemCTPhieuNhap(temp.MaChiTietNhap, temp.MaPhieuNhap, temp.MaSP, temp.DonGiaSP, temp.ThanhTien, temp.Thue, temp.SoLuongMua);
bool Sua = XL_CTPhieuNhap.CapNhatSanPham(kho, temp.MaSP, temp.SoLuongMua);
ThemCTPhieuNhap.Add(Them);
}
}
//bien dem xem co luu dc tat ca k
int dem = 0;
for (int i = 0; i < ThemCTPhieuNhap.Count; i++)
{
if (ThemCTPhieuNhap[i] == true)
{
dem++;
}
}
if (dem == ThemCTPhieuNhap.Count)
{
MessageBox.Show("Thêm thành công!");
this.Close();
}
else
{
MessageBox.Show("Thêm thất bại!");
this.Close();
}
}
}
}
