public static void ThemPhieuSuaChua(PHIEUSUACHUA psc) { DataAccessHelper db = new DataAccessHelper(); SqlCommand cmd = db.Command("THEMPSC"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MAPSC", psc.MaPhieuSC); cmd.Parameters.AddWithValue("@MAXE", psc.MaXe); cmd.Parameters.AddWithValue("@NGAYSC", psc.NgaySuaChua); SqlDataAdapter da = new SqlDataAdapter(cmd); db.dt = new System.Data.DataTable(); da.Fill(db.dt); }
public static void ThemPhieuSuaChua(PHIEUSUACHUA psc) { PHIEUSUACHUA_DAO.ThemPhieuSuaChua(psc); string maHieuXe = XE_DAO.GetMaHieuXe(psc.MaXe.ToString()); string maBCDS = BC_DOANHSO_BUS.GetMaBC(psc.NgaySuaChua.Month, psc.NgaySuaChua.Year); if (maBCDS == "") { maBCDS = BC_DOANHSO_BUS.AutoMABC(); BC_DOANHSO baoCao = new BC_DOANHSO(); baoCao.MaBaoCaoDoanhSo = maBCDS; baoCao.Thang = psc.NgaySuaChua.Month; baoCao.Nam = psc.NgaySuaChua.Year; BC_DOANHSO_BUS.ThemBC(baoCao); } CT_BC_DOANHSO chiTiet = new CT_BC_DOANHSO(); chiTiet.MaBCDS = maBCDS; chiTiet.MaCTBC = CT_BC_DOANHSO_BUS.GetMaCTBC(maBCDS, maHieuXe); if (chiTiet.MaCTBC == "") { chiTiet.MaCTBC = CT_BC_DOANHSO_BUS.AutoMACTBC(); chiTiet.MaHieuXe = maHieuXe; CT_BC_DOANHSO_BUS.ThemCTBC(chiTiet); } CT_BC_DOANHSO_BUS.CapNhatSoLuotSua(chiTiet); string maBCT = BC_TONVTPT_BUS.GetMaBCT(psc.NgaySuaChua.Month, psc.NgaySuaChua.Year); if (maBCT == "") { maBCT = BC_TONVTPT_BUS.AutoMABCT(); BC_TONVTPT BCT = new BC_TONVTPT(); BCT.MaBCT = maBCT; BCT.Thang = psc.NgaySuaChua.Month; BCT.Nam = psc.NgaySuaChua.Year; BC_TONVTPT_BUS.ThemBC(BCT); } }