/// <summary> /// 已审核和待审批列表 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYSPHDSPYCGLLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { List <Yan_WF_TI> ListData = new Yan_WF_TIB().GetEntities("TaskUserID ='" + UserInfo.User.UserName + "' AND isnull(TaskUserView,'')!='发起表单'").ToList(); List <string> intPro = ListData.Select(d => d.PIID.ToString()).ToList(); int page = 0; int.TryParse(context.Request.QueryString["p"] ?? "1", out page); page = page == 0 ? 1 : page; if (intPro.Count > 0) { string tableName = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID"); string tableColumn = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , case when wfpi.isComplete='Y' then '已审批' WHEN wfpi.IsCanceled='Y' then '已退回' else '正在审批' END StateName "; string strWhere = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intPro.ListTOString(',') + ")"; if (P1 != "") { strWhere += string.Format(" And ycgl.XCType='{0}'", P1); } if (P2 != "") { strWhere += string.Format(" And ycgl.Remark like '%{0}%'", P2); } int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager(tableName, tableColumn, 8, page, " ycgl.CRDate desc", strWhere, ref total); msg.Result = dt; msg.Result1 = total; } }
public void GETMANGWFDATA(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { try { int PIID = int.Parse(P1); if (PIID > 0) { Yan_WF_PI PIMODEL = new Yan_WF_PIB().GetEntity(d => d.ID == PIID); if (PIMODEL == null) { msg.ErrorMsg = "流程数据已清除"; return; } else { DataTable dtList = new Yan_WF_TDB().GetEntities(d => d.ProcessDefinitionID == PIMODEL.PDID.Value).OrderBy(d => d.Taskorder).ToDataTable(); dtList.Columns.Add("userrealname"); dtList.Columns.Add("EndTime"); dtList.Columns.Add("TaskUserView"); dtList.Columns.Add("state"); foreach (DataRow dr in dtList.Rows) { string tdCode = dr["TDCODE"].ToString(); Yan_WF_TI tiModel = new Yan_WF_TIB().GetEntity(d => d.PIID == PIID && d.TDCODE == tdCode && d.EndTime != null);// if (tiModel != null) { dr["userrealname"] = new JH_Auth_UserB().GetUserRealName(UserInfo.QYinfo.ComId, tiModel.TaskUserID); dr["EndTime"] = tiModel.EndTime; dr["TaskUserView"] = tiModel.TaskUserView; dr["state"] = tiModel.TaskState; } } msg.Result = dtList; Yan_WF_PD pdmodel = new Yan_WF_PDB().GetEntity(d => d.ID == PIMODEL.PDID); msg.Result1 = pdmodel; msg.Result2 = "{ \"ISCANSP\":\"" + new Yan_WF_PIB().isCanSP(UserInfo.User.UserName, int.Parse(P1)) + "\",\"ISCANCEL\":\"" + new Yan_WF_PIB().isCanCancel(UserInfo.User.UserName, PIMODEL) + "\"}"; msg.Result3 = PIMODEL;//可修改字段 if (!string.IsNullOrEmpty(pdmodel.Files)) { msg.Result4 = new FT_FileB().GetDTByCommand("SELECT * FROM FT_File WHERE ID IN (" + pdmodel.Files + ") "); } } } } catch (Exception ex) { msg.ErrorMsg = ex.Message; } }
/// <summary> /// 对流程待处理人员发送提醒(催办) /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void SENDLCCB(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { int Id = int.Parse(P1); var CBResult = new Yan_WF_TIB().GetEntities(d => d.PIID == Id && d.TaskState == 0); foreach (Yan_WF_TI item in CBResult) { SZHL_TXSX MODEL = new SZHL_TXSXB().GetEntity(d => d.TXUser == item.TaskUserID && d.intProcessStanceid == item.PIID); if (MODEL != null) { MODEL.Status = "0"; new SZHL_TXSXB().Update(MODEL); } } }
/// <summary> /// 已审核,待审批列表 /// </summary> /// <param name="context"></param> /// <param name="msg"></param> /// <param name="P1"></param> /// <param name="P2"></param> /// <param name="UserInfo"></param> public void GETYSPYCGLLIST_PAGE(HttpContext context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo) { #region 已审核 List <Yan_WF_TI> ListData = new Yan_WF_TIB().GetEntities("TaskUserID ='" + UserInfo.User.UserName + "' AND EndTime IS NOT NULL AND TaskUserView!='发起表单'").ToList(); List <string> intPro = ListData.Select(d => d.PIID.ToString()).ToList(); int page = 0; int.TryParse(P2, out page); page = page == 0 ? 1 : page; if (intPro.Count > 0) { string tableName = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID inner join Yan_WF_PI wfpi on ycgl.intProcessStanceid=wfpi.ID"); string tableColumn = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , case when wfpi.IsCanceled is null then '已审批' WHEN wfpi.IsCanceled='Y' then '已退回' END StateName "; string strWhere = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intPro.ListTOString(',') + ")"; if (P1 != "") { strWhere += string.Format(" And ycgl.XCType='{0}'", P1); } if (P2 != "") { strWhere += string.Format(" And ycgl.Remark like '%{0}%'", P2); } int total = 0; DataTable dt = new SZHL_YCGLB().GetDataPager(tableName, tableColumn, 8, page, " ycgl.CRDate desc", strWhere, ref total); msg.Result = dt; msg.Result1 = total; } #endregion #region 待审核 if (page == 1 && P1 == "" && P2 == "") { List <string> intProD = new Yan_WF_PIB().GetDSH(UserInfo.User).Select(d => d.PIID.ToString()).ToList(); if (intProD.Count() > 0) { string tableNameD = string.Format(@" SZHL_YCGL ycgl inner join SZHL_YCGL_CAR car on ycgl.CarID=car.ID"); string tableColumnD = "ycgl.* ,car.CarBrand,car.CarType,car.CarNum , '正在审批' StateName"; string strWhereD = " ycgl.ComId=" + UserInfo.User.ComId + " And ycgl.intProcessStanceid in (" + intProD.ListTOString(',') + ")"; string strSql = string.Format("Select {0} From {1} where {2} order by ycgl.CRDate desc", tableColumnD, tableNameD, strWhereD); msg.Result2 = new SZHL_YCGLB().GetDTByCommand(strSql); } } #endregion }
public ActionResult <string> EXPORTWORD() { var context = _accessor.HttpContext; var tokenHeader = context.Request.Cookies["szhlcode"].ToString().Replace("Bearer ", ""); TokenModelJWT tokenModel = JwtHelper.SerializeJWT(tokenHeader); JH_Auth_UserB.UserInfo UserInfo = new JH_Auth_UserB().GetUserInfo(10334, tokenModel.UserName); string P1 = context.Request.Query["P1"].ToString(); string P2 = context.Request.Query["P2"].ToString(); int pdid = 0; int.TryParse(P1, out pdid); int piid = 0; int.TryParse(P2, out piid); Yan_WF_PD PD = new Yan_WF_PDB().GetEntity(d => d.ID == pdid && d.ComId == UserInfo.User.ComId); Yan_WF_PI PI = new Yan_WF_PIB().GetEntity(d => d.ID == piid && d.ComId == UserInfo.User.ComId); if (PD.ExportFile == null) { return(""); } int fileID = int.Parse(PD.ExportFile); FT_File MBFile = new FT_FileB().GetEntities(d => d.ID == fileID).FirstOrDefault(); Dictionary <string, string> dictSource = new Dictionary <string, string>(); List <JH_Auth_ExtendMode> ExtendModes = new List <JH_Auth_ExtendMode>(); ExtendModes = new JH_Auth_ExtendModeB().GetEntities(D => D.ComId == UserInfo.User.ComId && D.PDID == pdid).ToList(); foreach (JH_Auth_ExtendMode item in ExtendModes) { string strValue = new JH_Auth_ExtendDataB().GetFiledValue(item.TableFiledColumn, pdid, piid); dictSource.Add("qj_" + item.TableFiledColumn, strValue); } dictSource.Add("qj_CRUser", PI.CRUserName); dictSource.Add("qj_BranchName", PI.BranchName); dictSource.Add("qj_CRDate", PI.CRDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); dictSource.Add("qj_PINUM", PI.ID.ToString()); List <Yan_WF_TI> tiModels = new Yan_WF_TIB().GetEntities(d => d.PIID == piid).ToList(); for (int i = 0; i < tiModels.Count; i++) { dictSource.Add("qj_Task" + i + ".TaskUser", new JH_Auth_UserB().GetUserRealName(UserInfo.User.ComId.Value, tiModels[i].TaskUserID)); dictSource.Add("qj_Task" + i + ".TaskUserView", tiModels[i].TaskUserView); if (tiModels[i].EndTime != null) { dictSource.Add("qj_Task" + i + ".EndTime", tiModels[i].EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); } } string strFileUrl = UserInfo.QYinfo.FileServerUrl + "/" + UserInfo.QYinfo.QYCode + "/document/" + MBFile.zyid; Aspose.Words.Document doc = new Aspose.Words.Document(strFileUrl); //使用文本方式替换 foreach (string name in dictSource.Keys) { doc.Range.Replace(name, dictSource[name]); } #region 使用书签替换模式 #endregion string Filepath = hostingEnv.WebRootPath + "/Export/"; string strFileName = PD.ProcessName + DateTime.Now.ToString("yyMMddHHss") + ".doc"; doc.Save(Filepath + strFileName, Aspose.Words.Saving.DocSaveOptions.CreateSaveOptions(SaveFormat.Doc)); return(File("~/excels/report.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "report.xlsx")); }