/// <summary> /// 获取出差单 /// </summary> /// <param name="b_Employee"></param> /// <returns></returns> public JsonResult GetTravelRecordNo(string b_Employee = "") { var retModel = new JsonReturnModel(); try { List <BusinessTravelModel> returnList = new List <BusinessTravelModel>(); List <B_BUSINESSTRAVEL> list = BusinessTravelDA.GetBusinessTravelByEmployee(b_Employee); foreach (var item in list) { BusinessTravelModel model = new BusinessTravelModel(); model.b_DocumentNo = item.B_DOCUMENTNO; model.b_ApplicationDate = item.B_APPLICATIONDATE.GetValueOrDefault().ToString("yyyy-MM-dd"); model.b_Type = item.B_TYPE; model.b_ProjectName = string.IsNullOrEmpty(item.B_PROJECTNAME) ? "" : item.B_PROJECTNAME; model.b_Destination = item.B_DESTINATION; returnList.Add(model); } retModel.data = returnList; } catch (Exception ex) { retModel.AddError("errorMessage", ex.Message); } return(Json(retModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出凭证清单 /// </summary> /// <param name="list"></param> /// <returns></returns> private Stream ExportBusinessTravelByData(List <BusinessTravelModel> dataList) { HSSFWorkbook workbook = new HSSFWorkbook(); ISheet sheet = workbook.CreateSheet(); // 设置字体 IFont headfont = workbook.CreateFont(); headfont.FontName = "微软雅黑"; // 建表头 IRow row = sheet.CreateRow(0); row.CreateCell(0).CellStyle.SetFont(headfont); row.CreateCell(0).SetCellValue("单号"); row.CreateCell(1).SetCellValue("申请日期"); row.CreateCell(2).SetCellValue("申请部门"); row.CreateCell(3).SetCellValue("申请人"); row.CreateCell(4).SetCellValue("项目名称"); row.CreateCell(5).SetCellValue("目的地"); row.CreateCell(6).SetCellValue("流程状态"); dataList = dataList.OrderByDescending(x => x.b_DocumentNo).ToList(); for (var i = 0; i < dataList.Count; i++) { BusinessTravelModel model = dataList[i]; IRow rowItem = sheet.CreateRow(i + 1); rowItem.CreateCell(0).SetCellValue(model.b_DocumentNo); rowItem.CreateCell(1).SetCellValue(model.nb_ApplicationDate.ToString()); rowItem.CreateCell(2).SetCellValue(model.b_Dept); rowItem.CreateCell(3).SetCellValue(model.b_Employee); rowItem.CreateCell(4).SetCellValue(model.b_ProjectName); rowItem.CreateCell(5).SetCellValue(model.b_Destination); model.status = Common.GetStatus(model.Id); model.status = Common.GetChineseValueByParam(model.status, "BTManageWorkFlow", "WorkFlow"); rowItem.CreateCell(6).SetCellValue(model.status); } MemoryStream ms = new MemoryStream(); workbook.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(ms); }
/// <summary> /// 打印 /// </summary> /// <param name="id"></param> /// <returns></returns> public ViewResult Print(string id) { Item result = BusinessTravelBll.GetBusinessTravelObjById(inn, id); BusinessTravelModel model = new BusinessTravelModel(); model.Id = result.getProperty("id"); model.b_DocumentNo = result.getProperty("b_documentno"); model.b_CompanyCode = result.getProperty("b_companycode"); model.b_Location = result.getProperty("b_location"); model.b_ApplicationDate = DateTime.Parse(result.getProperty("b_applicationdate")).ToString("yyyy-MM-dd"); model.b_TripType = result.getProperty("b_triptype"); model.b_Type = result.getProperty("b_type"); model.b_Preparer = result.getProperty("b_preparer"); model.b_Employee = result.getProperty("b_employee"); model.b_StaffNo = result.getProperty("b_staffno"); model.b_Position = result.getProperty("b_position"); model.b_Dept = result.getProperty("b_dept"); model.b_CostCenter = result.getProperty("b_costcenter"); model.b_Mobile = result.getProperty("b_mobile"); model.b_ProjectName = result.getProperty("b_projectname"); model.b_Destination = result.getProperty("b_destination"); model.b_SeniorManager = result.getProperty("b_seniormanager"); model.b_Director = result.getProperty("b_director"); model.b_VP = result.getProperty("b_vp"); model.b_TravelDate = DateTime.Parse(result.getProperty("b_traveldate")).ToString("yyyy-MM-dd"); model.b_EstimatedReturnDate = DateTime.Parse(result.getProperty("b_estimatedreturndate")).ToString("yyyy-MM-dd"); model.b_Purpose = result.getProperty("b_purpose"); model.b_TravelSchedule = result.getProperty("b_travelschedule"); model.b_TravelBudget = !string.IsNullOrEmpty(result.getProperty("b_travelbudget")) ? decimal.Parse(result.getProperty("b_travelbudget")) : 0; model.b_FlightIsssue = result.getProperty("b_flightisssue"); model.b_FlightBooking = result.getProperty("b_flightbooking"); model.b_HotelBooking = result.getProperty("b_hotelbooking"); model.b_Didi = result.getProperty("b_didi"); model.b_Others = result.getProperty("b_others"); model.b_OtherContent = result.getProperty("b_othercontent"); model.b_IsHangUp = result.getProperty("b_ishangup") == "1" ? true : false; model.b_HangUpActivityName = result.getProperty("b_hangupactivityname"); model.OldRemark = result.getProperty("b_remark"); model.b_TrafficExpense = !string.IsNullOrEmpty(result.getProperty("b_trafficexpense")) ? decimal.Parse(result.getProperty("b_trafficexpense")) : 0; model.b_HotelExpense = !string.IsNullOrEmpty(result.getProperty("b_hotelexpense")) ? decimal.Parse(result.getProperty("b_hotelexpense")) : 0; model.b_FixedSubsidy = !string.IsNullOrEmpty(result.getProperty("b_fixedsubsidy")) ? decimal.Parse(result.getProperty("b_fixedsubsidy")) : 0; model.b_OtherExpenses = !string.IsNullOrEmpty(result.getProperty("b_otherexpenses")) ? decimal.Parse(result.getProperty("b_otherexpenses")) : 0; model.b_DidiMoney = !string.IsNullOrEmpty(result.getProperty("b_didimoney")) ? decimal.Parse(result.getProperty("b_didimoney")) : 0; model.b_DidiAddMoney = !string.IsNullOrEmpty(result.getProperty("b_didiaddmoney")) ? decimal.Parse(result.getProperty("b_didiaddmoney")) : 0; //机票代订 Item Relation = result.getRelationships("R_FlightBooking"); if (Relation.getItemCount() > 0) { model.FlightBookingItems = new List <FlightBooking>(); for (int i = 0; i < Relation.getItemCount(); i++) { Item ItemObJ = Relation.getItemByIndex(i).getRelatedItem(); FlightBooking itemModel = new FlightBooking(); itemModel.Id = ItemObJ.getProperty("id"); itemModel.b_FirstName = ItemObJ.getProperty("b_firstname"); itemModel.b_LastName = ItemObJ.getProperty("b_lastname"); itemModel.b_IDType = ItemObJ.getProperty("b_idtype"); itemModel.b_IDCardNo = ItemObJ.getProperty("b_idcardno"); itemModel.b_Nationality = ItemObJ.getProperty("b_nationality"); itemModel.b_PassportNumber = ItemObJ.getProperty("b_passportnumber"); itemModel.b_Dateofexpiration = !string.IsNullOrEmpty(ItemObJ.getProperty("b_dateofexpiration")) ? DateTime.Parse(ItemObJ.getProperty("b_dateofexpiration")).ToString("yyyy-MM-dd") : ""; itemModel.b_Dateofbirth = ItemObJ.getProperty("b_dateofbirth"); itemModel.b_Address = ItemObJ.getProperty("b_address"); itemModel.b_Gooff = ItemObJ.getProperty("b_gooff"); itemModel.b_Goplace = ItemObJ.getProperty("b_goplace"); itemModel.b_Flightnumber = ItemObJ.getProperty("b_flightnumber"); model.FlightBookingItems.Add(itemModel); } } //酒店代订 Item HotelRelation = result.getRelationships("R_HotelBooking"); if (HotelRelation.getItemCount() > 0) { model.HotelBookingItems = new List <HotelBooking>(); for (int i = 0; i < HotelRelation.getItemCount(); i++) { Item ItemObJ = HotelRelation.getItemByIndex(i).getRelatedItem(); HotelBooking itemHote = new HotelBooking(); itemHote.Id = ItemObJ.getProperty("id"); itemHote.b_Checkindate = !string.IsNullOrEmpty(ItemObJ.getProperty("b_checkindate")) ? DateTime.Parse(ItemObJ.getProperty("b_checkindate")).ToString("yyyy-MM-dd") : ""; itemHote.b_Leavedate = !string.IsNullOrEmpty(ItemObJ.getProperty("b_leavedate")) ? DateTime.Parse(ItemObJ.getProperty("b_leavedate")).ToString("yyyy-MM-dd") : ""; itemHote.b_Specificaddress = ItemObJ.getProperty("b_specificaddress"); model.HotelBookingItems.Add(itemHote); } } //日志信息 model.HistoryList = GetBusinessTravelHistoryList(id); foreach (var item in model.HistoryList) { item.Created_on = item.Create_onStr.GetValueOrDefault().ToString("yyyy-MM-dd HH:mm:ss"); } return(View("~/Views/BusinessTravel/PrintBusinessTravel.cshtml", model)); }