/// <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"));
}
