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);
}
