public ActionResult SubmitAuthorizeForm(int man) { try { AppointManApp appointMan = new AppointManApp(); var authorize = appointMan.GetForm(); var queryList = applyBillApp.GetPointList(authorize.man); var pointMan = appointMan.SubmitForm(man); foreach (var item in queryList) { if (item.appExaMan.Equals(authorize.man)) { item.appExaMan = pointMan.man; } else if (item.appAuthMan.Equals(authorize.man)) { item.appAuthMan = pointMan.man; } else if (item.purExaMan.Equals(authorize.man)) { item.purExaMan = pointMan.man; } else { item.purAuthMan = pointMan.man; } applyBillApp.SubmitForm(item, item.ID); } return(Success("操作成功。")); } catch (Exception) { return(Error("操作失败。")); } }
public ActionResult UploadFile() { try { if (Request.Files.Count < 1) { return(Error("操作失败")); } string filename = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".xls"; string virtualPath = String.Format("~/File/{0}", filename); string path = Server.MapPath(virtualPath); Request.Files[0].SaveAs(path);//上传文件 var appMan = OperatorProvider.Provider.GetCurrent().UserName; var departId = OperatorProvider.Provider.GetCurrent().DepartmentId; var depart = organizeApp.GetForm(departId); var groupDepart = organizeApp.getDepartByGroup(depart.F_DepartGroupId); groupDepart.Add(departId); var checkRoleIds = dutyApp.GetApplyCheckList(); var appDep = organizeApp.GetForm(departId).F_FullName; var data = userApp.GetUserCheckList(groupDepart, checkRoleIds); data.Reverse(); var da = data.First(); var appExaMan = da.F_RealName; var appAuthMan = appManApp.GetForm().man; if (applyBillApp.ImportExcel(path, System.Configuration.ConfigurationManager.ConnectionStrings["XZOADbContext"].ConnectionString, appMan, appDep, appExaMan, appAuthMan)) { if (!string.IsNullOrEmpty(da.F_Email)) { mHelper.MailServer = "10.110.120.2"; mHelper.Send(da.F_Email, "申购单审核", "你好," + appMan + "有申购单需要你登录OA去做审核,请点击链接<a>http://10.110.120.6:8090/</a>"); } return(Success("操作成功")); } return(Error("导入文件格式错误!")); } catch (Exception ex) { // new ErrorLogApp().SubmitForm(ex); return(Error(ex.Message)); } }