public ActionResult RepairDescription() { //รับพารามิเตอร์ int repairID = Int32.Parse(Request.Params["repID"]); RepairDetailModel rdModel = new RepairDetailModel(); ///////////// RepairModel rModel = new RepairModel(); rModel.REPAIR_NO = repairID; rModel.ALERT_STATUS = "0"; // หมายถึงดูแล้ว Database db = new Database(); RepairDAO rDAO = new RepairDAO(db); rDAO.AlertStatus(rModel); db.Close(); ////////////////////////// db = new Database(); rDAO = new RepairDAO(db); rdModel.REPAIR = rDAO.FindById(repairID); db.Close(); db = new Database(); RequisitionDAO rqDAO = new RequisitionDAO(db); rdModel.STOCK = rqDAO.FindByRepairID(rdModel.REPAIR.REPAIR_NO); db.Close(); ViewData["Repair"] = rdModel; // รายการสถานะ db = new Database(); RepStatusDAO rtDAO = new RepStatusDAO(db); List <RepStatusModel> rtModel = rtDAO.FindAll(); ViewData["STATUS"] = rtModel; db.Close(); db = new Database(); RepairDAO rpDAO = new RepairDAO(db); RepairModel rpModel = rpDAO.FindById(repairID); db.Close(); return(View()); }
public ActionResult CustServiceDetail(int repID) { RepairDetailModel rdModel = new RepairDetailModel(); ///////////// RepairModel rModel = new RepairModel(); rModel.REPAIR_NO = repID; rModel.ALERT_STATUS = "1"; // หมายถึงดูแล้ว Database db = new Database(); RepairDAO rDAO = new RepairDAO(db); rDAO.AlertStatus(rModel); db.Close(); ////////////////////////// db = new Database(); rDAO = new RepairDAO(db); rdModel.REPAIR = rDAO.FindById(repID); db.Close(); db = new Database(); RequisitionDAO rqDAO = new RequisitionDAO(db); rdModel.STOCK = rqDAO.FindByRepairID(rdModel.REPAIR.REPAIR_NO); db.Close(); ViewData["Repair"] = rdModel; // รายการสถานะ db = new Database(); RepStatusDAO rtDAO = new RepStatusDAO(db); List <RepStatusModel> rtModel = rtDAO.FindAll(); ViewData["STATUS"] = rtModel; db.Close(); db = new Database(); RepairDAO rpDAO = new RepairDAO(db); RepairModel rpModel = rpDAO.FindById(repID); db.Close(); return(View()); }
public ActionResult RepairDescriptionBilling(int repID) { string t = "pdf"; LocalReport lr = new LocalReport(); string path = Server.MapPath("~/Reportor/ExportBill.rdlc"); if (System.IO.File.Exists(path)) { lr.ReportPath = path; } Database db = new Database(); RequisitionDAO rqDAO = new RequisitionDAO(db); List <RequisitionModel> reqModel = rqDAO.FindByRepairID(repID).Where(r => r.APROVE.Contains("allow")).ToList(); //HashSet<RequisitionModel> reqModel = rqDAO.FindByRepairID(repID).Where(r => r.APROVE.Contains("allow")).ToList(); db.Close(); var data = reqModel.Select(r => new { REQ_DATE = r.REQ_DATE.ToString("dd MMMM yyyy H:mm"), REQ_DETAIL = r.STOCK_NO.PART.TYPE.PART_TYPE_NAME + " " + r.STOCK_NO.PART.BRAND.PART_BRAND_NAME + " " + r.STOCK_NO.STOCK_INFO, REQ_UNIT = r.REQ_UNIT, REQ_PRICE = r.STOCK_NO.PRICE }).ToList(); db = new Database(); RepairDAO rDAO = new RepairDAO(db); RepairModel rModel = rDAO.FindById(repID); db.Close(); ReportParameter[] pr = new ReportParameter[] { new ReportParameter("NAME", rModel.CUSTOMER.C_NAME + " " + rModel.CUSTOMER.C_LASTNAME), new ReportParameter("ADDR", rModel.CUSTOMER.C_ADDRESS), new ReportParameter("TEL", rModel.CUSTOMER.C_TEL + " " + (rModel.CUSTOMER.C_EMAIL.Equals("")?" ":" Email :" + rModel.CUSTOMER.C_EMAIL)), new ReportParameter("REP_ID", rModel.REPAIR_NO.ToString()), new ReportParameter("REP_PRODUCT", rModel.PRODUCT.TYPE.PRO_TYPE_NAME + " " + rModel.PRODUCT.BANRD.PRO_BAND_NAME + " " + rModel.MODEL + " สี :" + rModel.COLOR), new ReportParameter("DAMAGE", rModel.DAMAGE) }; ReportDataSource rds = new ReportDataSource("DataSetRepairing", data); lr.SetParameters(pr); lr.DataSources.Add(rds); string reportType = t; string mimeType; string encoding; string fileNameExtension; string deviceInfoA4 = "<DeviceInfo>" + " <OutputFormat>" + t + "</OutputFormat>" + " <PageWidth>21cm</PageWidth>" + " <PageHeight>29.7cm</PageHeight>" + " <MarginTop>1cm</MarginTop>" + " <MarginLeft>0.5in</MarginLeft>" + " <MarginRight>0.5in</MarginRight>" + " <MarginBottom>0.5in</MarginBottom>" + "</DeviceInfo>"; Warning[] warnings; string[] streams; byte[] renderedBytes; renderedBytes = lr.Render(reportType, "", out mimeType, out encoding, out fileNameExtension, out streams, out warnings); return(File(renderedBytes, mimeType)); }