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(); } } } }
public int ThemPhieuNhap(PhieuNhap pn) { return(xl_pn.ThemPhieuNhap(pn)); }