Example #1
0
        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);
        }
Example #3
0
 public static void ThemCTPSC(ChiTietPhieuSuaChua ctpsc)
 {
     ChiTietPhieuSuaChuaDAL.NhapChiTietPhieuSuaChua(ctpsc);
 }