private void btnLapPhieu_Click(object sender, EventArgs e) { try { if (!CheckOpenedTabs("Phiếu sửa chữa")) { string ngaySuaChua = String.Format("{0:MM/dd/yyyy}", DateTime.Now); string maPSC = PhieuSuaChuaBLL.AutoMAPSC(); PhieuSuaChua psc = new PhieuSuaChua(maPSC, txtBienSo.Text, DateTime.Now, 0); PhieuSuaChuaBLL.ThemPhieuSuaChua(psc); TabItem tab = tabControl.CreateTab("Phiếu sửa chữa"); tab.PredefinedColor = eTabItemColor.Yellow; frmPhieuSuaChua _frmPhieuSuaChua = new frmPhieuSuaChua(tabControl, tab); _frmPhieuSuaChua.maPSC = maPSC; _frmPhieuSuaChua.bienSo = txtBienSo.Text; _frmPhieuSuaChua.TopLevel = false; _frmPhieuSuaChua.Dock = DockStyle.Fill; _frmPhieuSuaChua.StartPosition = FormStartPosition.CenterParent; _frmPhieuSuaChua.Show(); tab.AttachedControl.Controls.Add(_frmPhieuSuaChua); tabControl.SelectedTabIndex = tabControl.Tabs.Count - 1; } else { MessageBox.Show("Chức năng sửa chữa đang được tiến hành", "Thông báo"); tabControl.TabIndex = tabControl.Tabs.Count - 1; } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult Save(int idPhieuTN, DateTime date, ChiTietPhieuSua[] chitietphieusua) { string result = "Error! Thêm chi tiết không thể hoàn tất!"; if (idPhieuTN != 0 && date != null && chitietphieusua != null) { PhieuSuaChua phieuSua = new PhieuSuaChua(); phieuSua.IDPhieuTN = idPhieuTN; phieuSua.NgaySuaChua = date; db.PhieuSuaChuas.Add(phieuSua); db.SaveChanges(); int idPhieuSua = phieuSua.IDPhieu; foreach (var ct in chitietphieusua) { ChiTietPhieuSua C = new ChiTietPhieuSua(); C.IDPhieu = idPhieuSua; C.IDPhuTung = ct.IDPhuTung; C.DonGia = ct.DonGia; C.SoLuongBan = ct.SoLuongBan; C.IDTienCong = ct.IDTienCong; C.ThanhTien = ct.ThanhTien; db.ChiTietPhieuSuas.Add(C); } db.SaveChanges(); result = "Thành công! Thêm chi tiết hoàn tất!"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public static List <PhieuSuaChua> ShowPhieuSuaChua() { OpenConnection(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadPSCMayTinh"; cmd.Connection = conn; SqlDataReader reader = cmd.ExecuteReader(); List <PhieuSuaChua> dsPSC = new List <PhieuSuaChua>(); while (reader.Read()) { string maphieu = reader.GetString(0); string mamay = reader.GetString(1); string manv = reader.GetString(2); DateTime ngaysua = reader.GetDateTime(3); double chiphi = reader.GetDouble(4); PhieuSuaChua psc = new PhieuSuaChua(maphieu, mamay, manv, ngaysua, chiphi); dsPSC.Add(psc); } reader.Close(); return(dsPSC); }
public ActionResult DeleteConfirmed(int id) { PhieuSuaChua phieuSuaChua = db.PhieuSuaChuas.Find(id); db.PhieuSuaChuas.Remove(phieuSuaChua); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "IDPhieu,IDPhieuTN,NgaySuaChua,TongTien")] PhieuSuaChua phieuSuaChua) { if (ModelState.IsValid) { db.Entry(phieuSuaChua).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IDPhieuTN = new SelectList(db.PhieuTiepNhans, "IDPhieuTN", "IDPhieuTN", phieuSuaChua.IDPhieuTN); return(View(phieuSuaChua)); }
public PhieuSuaChua GETPHIEUMT() { string maphieu = txtmaphieu.Text; string mamay = txtmamay.Text; string manv = txtmanv.Text; DateTime ngaysua = dtngaysua.Value; double chiphi = double.Parse(txtchihi.Text); PhieuSuaChua phieu = new PhieuSuaChua(maphieu, mamay, manv, ngaysua, chiphi); return(phieu); }
private void btnLapPhieu_Click(object sender, EventArgs e) { try { if (KiemTraSoLuongTon()) { if (KTMaSuaChua(txtMaPhieu.Text)) { if (KTNhapXuat()) { PhieuSuaChua psc = new PhieuSuaChua(); CT_PhieuSuaChua ct_psc = new CT_PhieuSuaChua(); psc.MaPhieuSuaChua = txtMaPhieu.Text; psc.NgaySuaChua = dtpNgaySuaChua.Text; psc.BienSo = cbBienSo.Text; psc.TongTien = double.Parse(txtThanhTien.Text); PhieuSuaChuaBUS.PhieuSuaChua_Insert(psc); ct_psc.MaPhieuSuaChua = txtMaPhieu.Text; ct_psc.MaVatTuPhuTung = cbVTPT.Text; ct_psc.NoiDungSuaChua = cbNoiDung.Text; ct_psc.SoLuong = int.Parse(txtSoLuong.Text); ct_psc.DonGia = double.Parse(txtDonGia.Text); ct_psc.TienCong = double.Parse(txtTienCong.Text); ct_psc.ThanhTien = TinhTien(); CT_PhieuSuaChuaBUS.CT_PhieuSuaChua_Insert(ct_psc); LoadDSxeTheoBienSo(cbBienSo.Text); lbcSoLuongTon.Text = VatTuPhuTungBUS.VatTuPhuTung_GetSoLuongTon(cbVTPT.Text).ToString(); MessageBox.Show("Lập phiếu thành công!"); DoanhSo_Insert(); } } else { MessageBox.Show("Mã sửa chữa đã có"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { SQLDataProvider.connection.Close(); } btnIn.Enabled = false; btnXoa.Enabled = false; }
public void PhieuSuaChua_Insert(PhieuSuaChua Data) { using (var cmd = new SqlCommand("sp_PhieuSuaChua_Insert", GetConnection())) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaPhieuSuaChua", Data.MaPhieuSuaChua)); cmd.Parameters.Add(new SqlParameter("@BienSo", Data.BienSo)); cmd.Parameters.Add(new SqlParameter("@NgaySuaChua", Data.NgaySuaChua)); cmd.ExecuteNonQuery(); connection.Close(); } }
// GET: PhieuSuaChuas/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuSuaChua phieuSuaChua = db.PhieuSuaChuas.Find(id); if (phieuSuaChua == null) { return(HttpNotFound()); } return(View(phieuSuaChua)); }
public static void ThemPhieuSuaChua(PhieuSuaChua psc) { DataAccessHelper db = new DataAccessHelper(); SqlCommand cmd = db.Command("THEMPSC"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MAPSC", psc.MaPhieuSuaChua); cmd.Parameters.AddWithValue("@BIENSO", psc.BienSo); cmd.Parameters.AddWithValue("@NGAYSC", psc.NgaySuaChua); //Ngày sửa chữa là ngày lập phiếu SqlDataAdapter da = new SqlDataAdapter(cmd); db.dt = new System.Data.DataTable(); da.Fill(db.dt); }
// GET: PhieuSuaChuas/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuSuaChua phieuSuaChua = db.PhieuSuaChuas.Find(id); if (phieuSuaChua == null) { return(HttpNotFound()); } ViewBag.IDPhieuTN = new SelectList(db.PhieuTiepNhans, "IDPhieuTN", "IDPhieuTN", phieuSuaChua.IDPhieuTN); return(View(phieuSuaChua)); }
public static void ThemPhieuSuaChua(PhieuSuaChua psc) { PhieuSuaChuaDAL.ThemPhieuSuaChua(psc); string hieuXe = XeDAL.GetHieuXe(psc.BienSo); string maBCDT = BaoCaoDoanhThuBLL.GetMaBC(psc.NgaySuaChua.Month, psc.NgaySuaChua.Year); if (maBCDT == "") { maBCDT = BaoCaoDoanhThuBLL.AutoMABC(); BaoCaoDoanhThu baoCao = new BaoCaoDoanhThu(); baoCao.MaBaoCaoDoanhThu = maBCDT; baoCao.Thang = psc.NgaySuaChua.Month; baoCao.Nam = psc.NgaySuaChua.Year; BaoCaoDoanhThuBLL.ThemBC(baoCao); } ChiTietBaoCaoDoanhThu chiTiet = new ChiTietBaoCaoDoanhThu(); chiTiet.MaBC = maBCDT; chiTiet.MaCTBC = ChiTietBaoCaoDoanhThuBLL.GetMaCTBC(maBCDT, hieuXe); if (chiTiet.MaCTBC == "") { chiTiet.MaCTBC = ChiTietBaoCaoDoanhThuBLL.AutoMACTBC(); chiTiet.HieuXe = hieuXe; ChiTietBaoCaoDoanhThuBLL.ThemCTBC(chiTiet); } ChiTietBaoCaoDoanhThuBLL.CapNhatSoLuotSua(chiTiet); string maBCT = BaoCaoTonBLL.GetMaBCT(psc.NgaySuaChua.Month, psc.NgaySuaChua.Year); if (maBCT == "") { maBCT = BaoCaoTonBLL.AutoMABCT(); BaoCaoTon BCT = new BaoCaoTon(); BCT.MaBCT = maBCT; BCT.Thang = psc.NgaySuaChua.Month; BCT.Nam = psc.NgaySuaChua.Year; BaoCaoTonBLL.ThemBC(BCT); } }
public static void UpDate(PhieuSuaChua ph) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SuaPSCMayTinh"; cmd.Connection = conn; OpenConnection(); cmd.Parameters.Add("@MaPhieu", SqlDbType.NVarChar).Value = ph.MaPhieu; cmd.Parameters.Add("@MaMay", SqlDbType.NVarChar).Value = ph.MaMay; cmd.Parameters.Add("@MaNV", SqlDbType.NVarChar).Value = ph.MaNV; cmd.Parameters.Add("@NgaySua", SqlDbType.Date).Value = ph.NgaySua; cmd.Parameters.Add("@ChiPhi", SqlDbType.Float).Value = ph.ChiPhi; cmd.ExecuteNonQuery(); CloseConnection(); }
public static void SuaPhieu(PhieuSuaChua ph) { PSCMayTinhAccess.UpDate(ph); }
public static void ThemPhieu(PhieuSuaChua ph) { PSCMayTinhAccess.Insert(ph); }
public static void PhieuSuaChua_Insert(PhieuSuaChua Data) { db.PhieuSuaChua_Insert(Data); }
public static void PhieuSuaChua_Delete(PhieuSuaChua Data) { db.PhieuSuaChua_Delete(Data); }