public ActionResult ApplyDetail_FlowOrderBugetSearch(string applyId)
{
FlowOrderBugetDto flowOrderBugetDto = service.ApplyDtl_FlowOrderBugetSearch(applyId).FirstOrDefault();
if (flowOrderBugetDto == null)
{
return(Json(false));
}
return(Json(flowOrderBugetDto));
}
public ActionResult FlowOrderExport(string projectId, string supplierId)
{
string absPath = Server.MapPath(basePath);
if (!Directory.Exists(absPath))
{
Directory.CreateDirectory(absPath);
}
string createFileName = "应付流转单_" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx";
string path = absPath + createFileName;
string templateFile = Server.MapPath(tempPath + "应付流转单.xlsx");// 模板的路径
System.IO.File.Copy(templateFile, path);
MSExcelUtil msExcelUtil = new MSExcelUtil();
Workbook workbook = msExcelUtil.OpenExcelByMSExcel(path);
Worksheet sheet = workbook.ActiveSheet;
FlowOrderBugetDto dto_flow = service.FlowOrderBugetSearch(projectId).FirstOrDefault();
if (string.IsNullOrEmpty(dto_flow.FactSum))
{
dto_flow.FactSum = "0.00";
}
msExcelUtil.SetCellValue(sheet, 2, 2, dto_flow.Contingency);
msExcelUtil.SetCellValue(sheet, 4, 2, dto_flow.BugetSum);
msExcelUtil.SetCellValue(sheet, 6, 2, dto_flow.FactSum);
List <FlowOrderDto> list = service.FlowOrderSearch(projectId, supplierId, UserInfo.UserId);
int startIndex = 4;
if (list.Count > 0)
{
foreach (FlowOrderDto dto in list)
{
msExcelUtil.SetCellValue(sheet, 1, startIndex, dto.ServiceTrade);
// msExcelUtil.SetCellValue(sheet, 2, startIndex, dto.DepartmentCode);
msExcelUtil.SetCellValue(sheet, 2, startIndex, dto.CostDepartment);
msExcelUtil.SetCellValue(sheet, 3, startIndex, dto.ProjectName);
msExcelUtil.SetCellValue(sheet, 4, startIndex, dto.ProjectShortName);
msExcelUtil.SetCellValue(sheet, 5, startIndex, dto.ProjectCode);
msExcelUtil.SetCellValue(sheet, 6, startIndex, dto.ExecuteCycleStartDate);
msExcelUtil.SetCellValue(sheet, 7, startIndex, dto.ExecuteCycleEndDate);
msExcelUtil.SetCellValue(sheet, 8, startIndex, dto.SupplierName);
msExcelUtil.SetCellValue(sheet, 9, startIndex, dto.BudgetAmt);
msExcelUtil.SetCellValue(sheet, 10, startIndex, dto.BudgetLeftAmt);
msExcelUtil.SetCellValue(sheet, 11, startIndex, dto.ExpendType);
msExcelUtil.SetCellValue(sheet, 12, startIndex, dto.ExpendPattern);
msExcelUtil.SetCellValue(sheet, 13, startIndex, dto.PaymentType);
msExcelUtil.SetCellValue(sheet, 14, startIndex, dto.PaymentCompany);
msExcelUtil.SetCellValue(sheet, 15, startIndex, dto.EstimatedPaymentTime);
msExcelUtil.SetCellValue(sheet, 16, startIndex, dto.EstimatePaymentAmt);
msExcelUtil.SetCellValue(sheet, 17, startIndex, dto.FactPaymentTime);
msExcelUtil.SetCellValue(sheet, 18, startIndex, dto.FactPaymentAmt);
msExcelUtil.SetCellValue(sheet, 19, startIndex, dto.InvoiceAmt);
msExcelUtil.SetCellValue(sheet, 20, startIndex, dto.Payee);
msExcelUtil.SetCellValue(sheet, 21, startIndex, dto.Remark);
msExcelUtil.SetCellValue(sheet, 22, startIndex, dto.Finance_PaymentStatus);
if (list.IndexOf(dto) < list.Count - 1)
{
msExcelUtil.CopyRow(sheet, startIndex);
startIndex++;
msExcelUtil.AddRow(sheet, startIndex);
}
}
}
workbook.Save();
msExcelUtil.dispose();
return(Json(new { ExportPath = path }));
}
public ActionResult BugetSearch(string projectId)
{
FlowOrderBugetDto dto = service.FlowOrderBugetSearch(projectId).FirstOrDefault();
return(Json(dto, JsonRequestBehavior.AllowGet));
}
