public ActionResult RequisitionExportReport(string t)
{
string month = Request.Params["month"];
List <RequisitionModel> rqModel = new List <RequisitionModel>();
Database db = new Database();
RequisitionDAO rqDAO = new RequisitionDAO(db);
rqModel = rqDAO.FindByMonthYear(month);
db.Close();
LocalReport lr = new LocalReport();
string path = Server.MapPath("~/Reportor/RequisitionReport.rdlc");
if (System.IO.File.Exists(path))
{
lr.ReportPath = path;
}
var data = rqModel.Select(d => new
{
DAMAGE = d.REPAIR_NO.DAMAGE,
SPARE = d.STOCK_NO.PART.TYPE.PART_TYPE_NAME + " " + d.STOCK_NO.PART.BRAND.PART_BRAND_NAME + " " + d.STOCK_NO.STOCK_INFO,
UNIT = d.REQ_UNIT,
PRICE = d.STOCK_NO.PRICE,
WITHDRAWAL = d.STAFF.NAME + " " + d.STAFF.LASTNAME
}).ToList();
ConvertClass cv = new ConvertClass();
string[] x = month.Split('-');
ReportParameter rpm = new ReportParameter()
{
Name = "MONTH",
Values = { cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0] } // ชื่อรายงาน
};
ReportDataSource rds = new ReportDataSource("DataSetRQ", data);
lr.SetParameters(rpm);
lr.DataSources.Add(rds);
lr.DisplayName = "รายงานประจำ" + cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0]; // ชื่อรายงาน
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));
}
public ActionResult ExportEmployeesWorkingReport(string month)
{
List <UsersModel> lusModel = new List <UsersModel>();
Database db = new Database();
UsersDAO usDAO = new UsersDAO(db);
lusModel = usDAO.FindByMonthYear(month);
db.Close();
foreach (var u in lusModel)
{
db = new Database();
RepairDAO rDAO = new RepairDAO(db);
u.REPAIR = new WorkingEmployeesViewModel();
u.REPAIR.SUCCESS_REP = rDAO.CountByUserIDSuccess(u.USER_NO);
db.Close();
db = new Database();
rDAO = new RepairDAO(db);
u.REPAIR.WAIT_REP = rDAO.CountByUserIDWait(u.USER_NO);
db.Close();
db = new Database();
rDAO = new RepairDAO(db);
u.REPAIR.NOW_REP = rDAO.CountByUserIDNowWorking(u.USER_NO);
db.Close();
db = new Database();
rDAO = new RepairDAO(db);
u.REPAIR.CANNOT_REP = rDAO.CountByUserIDFail(u.USER_NO);
db.Close();
}
string type = "excel";
LocalReport lr = new LocalReport();
string path = Server.MapPath("~/Reportor/EmployeeWorkingReport.rdlc");
if (System.IO.File.Exists(path))
{
lr.ReportPath = path;
}
var data = lusModel.Select(d => new {
UID = d.USER_UID,
NAME = d.NAME + " " + d.LASTNAME,
WAIT = d.REPAIR.WAIT_REP,
NOW = d.REPAIR.NOW_REP,
SUCCESS = d.REPAIR.SUCCESS_REP,
CANNOT = d.REPAIR.CANNOT_REP
}).ToList();
ConvertClass cv = new ConvertClass();
string[] x = month.Split('-');
ReportParameter rpm = new ReportParameter()
{
Name = "MONTH",
Values = { cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0] } // ชื่อรายงาน
};
ReportDataSource rds = new ReportDataSource("WorkingDataSetReport", data);
lr.SetParameters(rpm);
lr.DataSources.Add(rds);
lr.DisplayName = "รายงานผลงานประจำ" + cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0]; // ชื่อรายงาน
string reportType = type;
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfoA4 =
"<DeviceInfo>" +
" <OutputFormat>" + type + "</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));
}
public ActionResult RepairingExportReport(string t)
{
string month = Request.Params["month"];
Database db = new Database();
RepairDAO rDAO = new RepairDAO(db);
List <RepairModel> rModel = rDAO.FindByMonthYear(month);
db.Close();
LocalReport lr = new LocalReport();
string path = Server.MapPath("~/Reportor/RepairingReport.rdlc");
if (System.IO.File.Exists(path))
{
lr.ReportPath = path;
}
var data = rModel.Select(r => new
{
C_UID = r.CUSTOMER.CUST_UID,
C_NAME = r.CUSTOMER.C_NAME + " " + r.CUSTOMER.C_LASTNAME,
REP_DET = r.PRODUCT.TYPE.PRO_TYPE_NAME + " " + r.PRODUCT.BANRD.PRO_BAND_NAME + " " + r.MODEL,
DAMAGE = r.DAMAGE,
STAFF = r.STAFF.NAME + " " + r.STAFF.LASTNAME
}).ToList();
ConvertClass cv = new ConvertClass();
string[] x = month.Split('-');
ReportParameter rpm = new ReportParameter()
{
Name = "MONTH",
Values = { cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0] } // ชื่อรายงาน
};
ReportDataSource rds = new ReportDataSource("DataSetRepairing", data);
lr.SetParameters(rpm);
lr.DataSources.Add(rds);
lr.DisplayName = "รายงานประจำ" + cv.monthToStringMonth(Int32.Parse(x[1])) + " " + x[0]; // ชื่อรายงาน
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));
}