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