private void btnThem_Click(object sender, EventArgs e) { DateTime today = DateTime.Now; string maBCT = BaoCaoTonBLL.GetMaBCT(today.Month, today.Year); string maCTBCT = ChiTietBaoCaoTonBLL.getMaCTBCT(maBCT, cboPhuTung.Text); ChiTietBaoCaoTon chitiet = new ChiTietBaoCaoTon(); chitiet.MaBCT = maBCT; chitiet.MaCTBCT = maCTBCT; chitiet.TenPT = cboPhuTung.Text; chitiet.TonCuoi = int.Parse(txtSL.Text); chitiet.PhatSinh = 0; chitiet.TonDau = 0; ChiTietBaoCaoTonBLL.capNhatTonCuoi(chitiet); decimal thanhTien = decimal.Parse(txtThanhTien.Text); txtTongTien.Text = string.Format("{0:0,0}", decimal.Parse(tongTien.ToString())); string maCTPSC = ChiTietPhieuSuaChuaBLL.AutoMACTSC(); ChiTietPhieuSuaChua ctpsc = new ChiTietPhieuSuaChua(maCTPSC, txtMaPhieu.Text, cboPhuTung.SelectedValue.ToString(), int.Parse(txtSL.Text), cboNoiDung.Text, decimal.Parse(txtThanhTien.Text)); int soLuongPTTon = int.Parse(PhuTungBLL.LaySoLuongPhuTung(cboPhuTung.Text)); try { if (soLuongPTTon < int.Parse(txtSL.Text)) { MessageBox.Show("Số lượng phụ tùng trong kho không đủ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { ChiTietPhieuSuaChuaBLL.ThemCTPSC(ctpsc); GetDataGridView(); tongTien += thanhTien; txtTongTien.Text = string.Format("{0:0,0}", decimal.Parse(tongTien.ToString())); MessageBox.Show("Thêm chi tiết thành công!", "Thông báo", MessageBoxButtons.OK); } } catch (Exception ex) { MessageBox.Show(ex.Message); } txtDonGia.Clear(); txtSL.Clear(); txtThanhTien.Clear(); txtTienCong.Clear(); cboNoiDung.Text = ""; cboPhuTung.Text = ""; }
public static void NhapChiTietPhieuSuaChua(ChiTietPhieuSuaChua ctpsc) { DataAccessHelper db = new DataAccessHelper(); SqlCommand cmd = db.Command("THEMCT_PSC"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MACTPSC", ctpsc.MaChiTietPhieuSuaChua); cmd.Parameters.AddWithValue("@MAPSC", ctpsc.MaPhieuSuaChua); cmd.Parameters.AddWithValue("@NOIDUNG", ctpsc.NoiDung); cmd.Parameters.AddWithValue("@MAPT", ctpsc.MaPhuTung); cmd.Parameters.AddWithValue("@SL", ctpsc.SoLuong); SqlDataAdapter da = new SqlDataAdapter(cmd); db.dt = new DataTable(); da.Fill(db.dt); }
public static void ThemCTPSC(ChiTietPhieuSuaChua ctpsc) { ChiTietPhieuSuaChuaDAL.NhapChiTietPhieuSuaChua(ctpsc); }