Пример #1
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            List<DtoWarehouseBillDetail> list = new List<DtoWarehouseBillDetail>();
            DtoWarehouseBill warehouseBill = new DtoWarehouseBill();
            warehouseBill.MaPhieuNhapKho = txtMaPhieuNhapKho.Text;
            warehouseBill.NgayLapPhieu = DateTime.Now;
            warehouseBill.MaNguoiLapPhieu = nguoiLapPhieuComboBox.SelectedValue.ToString();
            warehouseBill.GhiChu = txtGhiChu.Text;

            for (int i = 0; i < dgvDetailWarehouseBill.Rows.Count - 1; i++)
            {
                DtoWarehouseBillDetail detail = new DtoWarehouseBillDetail();
                detail.MaChiTietPhieuNhapKho = dgvDetailWarehouseBill.Rows[i].Cells[0].Value.ToString();
                detail.MaPhieuNhapKho = warehouseBill.MaPhieuNhapKho;
                detail.MaSanPham = dgvDetailWarehouseBill.Rows[i].Cells[1].Value.ToString();
                detail.SoLuong =  int.Parse(dgvDetailWarehouseBill.Rows[i].Cells[3].Value.ToString());
                detail.GhiChu = dgvDetailWarehouseBill.Rows[i].Cells[4].Value.ToString();
                list.Add(detail);
            }

            if (_bllWarehouseBill.AddWarehouseBillTran(warehouseBill, list))
            {
                MessageBox.Show(Constants.MsgNotificationSuccessfuly);
                btnThoat.PerformClick();
            }
            else
            {
                MessageBox.Show(Constants.MsgExceptionError);
            }
        }
        public int AddWarehouseBillDetail(DtoWarehouseBillDetail data)
        {
            SqlParameter[] para =
            {
                new SqlParameter("@MaChiTietPhieuNhapKho", data.MaChiTietPhieuNhapKho),
                new SqlParameter("@MaPhieuNhapKho", data.MaPhieuNhapKho),
                new SqlParameter("@MaSanPham", data.MaSanPham),
                new SqlParameter("@SoLuong", data.SoLuong),
                new SqlParameter("@GhiChu", data.GhiChu),
            };

            try
            {
                return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure,
                    "AddWarehouseBillDetail",
                    para);
            }
            catch (SqlException)
            {
                throw new ArgumentException(Constants.MsgExceptionSql);
            }
            catch (Exception)
            {
                throw new AggregateException(Constants.MsgExceptionError);
            }
        }
        private void btnThem_Click(object sender, EventArgs e)
        {
            try
            {
                List<DtoWarehouseBillDetail> list = new List<DtoWarehouseBillDetail>();
                DtoWarehouseBill warehouseBill = new DtoWarehouseBill();
                warehouseBill.MaPhieuNhapKho = txtWarehouseBillID.Text;
                warehouseBill.NgayLapPhieu = DateTime.Now;
                warehouseBill.MaNguoiLapPhieu = maNV;
                warehouseBill.GhiChu = txtGhiChu.Text;
                for (int i = 0; i < dgvDetailWarehouseBill.Rows.Count - 1; i++)
                {
                    DtoWarehouseBillDetail detail = new DtoWarehouseBillDetail();
                    detail.MaPhieuNhapKho = warehouseBill.MaPhieuNhapKho;
                    detail.MaSanPham = dgvDetailWarehouseBill.Rows[i].Cells[1].Value.ToString();
                    detail.SoLuong = int.Parse(dgvDetailWarehouseBill.Rows[i].Cells[3].Value.ToString());
                    if (dgvDetailWarehouseBill.Rows[i].Cells[4].Value != null)
                    {
                        detail.GhiChu = dgvDetailWarehouseBill.Rows[i].Cells[4].Value.ToString();
                    }
                    else
                    {
                        detail.GhiChu = "";
                    }
                    list.Add(detail);
                }

                if (_bllWarehouseBill.AddWarehouseBillTran(warehouseBill, list))
                {
                    txtWarehouseBillID.Text = CreateNewWarehouseBillID();
                    DisplayNotify("Thêm phiếu nhập kho thành công!", 1);
                    btnThem.Enabled = false;
                   // MessageBox.Show("Thêm phiếu nhập kho thành công!");
                    cleandgv(dgvDetailWarehouseBill);
                }

            }
            catch (Exception ex)
            {
                DisplayNotify("Lỗi không thể thêm phiếu nhập kho, mã lỗi:" + ex.Message, -1);
            }
        }