public int AddDeliveryBillDetail(DtoDeliveryBillDetail data)
        {
            SqlParameter[] para =
            {
                new SqlParameter("@MaChiTietPhieuXuatKho", data.MaChiTietPhieuXuatKho),
                new SqlParameter("@MaPhieuXuatKho", data.MaPhieuXuatKho),
                new SqlParameter("@MaSanPham", data.MaSanPham),
                new SqlParameter("@SoLuong", data.SoLuong),
                new SqlParameter("@GhiChu", data.GhiChu),
            };

            try
            {
                return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure,
                    "AddDeliveryBillDetail",
                    para);
            }
            catch (SqlException)
            {
                throw new ArgumentException(Constants.MsgExceptionSql);
            }
            catch (Exception)
            {
                throw new AggregateException(Constants.MsgExceptionError);
            }
        }
Esempio n. 2
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            List<DtoDeliveryBillDetail> list = new List<DtoDeliveryBillDetail>();
            DtoDeliveryBill DeliveryBill = new DtoDeliveryBill();
            DeliveryBill.MaPhieuXuatKho = txtMaPhieuXuatKho.Text;
            DeliveryBill.NgayLapPhieu = DateTime.Now;
            DeliveryBill.MaNguoiNhan = maNguoiNhanComboBox.SelectedValue.ToString();
            DeliveryBill.MaNguoiLapPhieu = nguoiLapPhieuComboBox.SelectedValue.ToString();
            DeliveryBill.GhiChu = txtGhiChu.Text;

            for (int i = 0; i < dgvDetailDeliveryBill.Rows.Count - 1; i++)
            {
                DtoDeliveryBillDetail detail = new DtoDeliveryBillDetail();
                detail.MaChiTietPhieuXuatKho = dgvDetailDeliveryBill.Rows[i].Cells[0].Value.ToString();
                detail.MaPhieuXuatKho = DeliveryBill.MaPhieuXuatKho;
                detail.MaSanPham = dgvDetailDeliveryBill.Rows[i].Cells[1].Value.ToString();
                detail.SoLuong = int.Parse(dgvDetailDeliveryBill.Rows[i].Cells[3].Value.ToString());
                detail.GhiChu = dgvDetailDeliveryBill.Rows[i].Cells[4].Value.ToString();
                list.Add(detail);
            }

            if (_bllDeliveryBill.AddDeliveryBillTran(DeliveryBill, list))
            {
                MessageBox.Show(Constants.MsgNotificationSuccessfuly);
                btnThoat.PerformClick();
            }
            else
            {
                MessageBox.Show(Constants.MsgExceptionError);
            }
        }