public string SaveAndSubmit() { try { string Tmp_Action = Common.ConvertEx.ToString(Session["Tmp_Action"]); string Tmp_SingleProjectID = Common.ConvertEx.ToString(Session["Tmp_SingleProjectID"]); string Tmp_WorkFlowID = Common.ConvertEx.ToString(Session["Tmp_WorkFlowID"]); if (Tmp_Action == "Add") { //存下华表路径 List <T_WorkFlowDefine_MDL> ltDefineMdl = new T_WorkFlowDefine_BLL().GetModelList("SingleProjectID=" + Tmp_SingleProjectID + " AND WorkFlowID=" + Tmp_WorkFlowID + ""); if (ltDefineMdl.Count > 0) { T_WorkFlowDefine_MDL Mdl = ltDefineMdl[0]; Mdl.SubmitCellPath = "SubmitToReadyCheck.aspx?CellName=" + Session["CellTempGUID"].ToString(); Mdl.RecvCellPath = Mdl.SubmitCellPath; //Mdl.SubmitDateTime = DateTime.Now; //Mdl.SubmitUserID = Common.ConvertEx.ToInt(Session["UserID"]); new T_WorkFlowDefine_BLL().Update(Mdl); } //仅处理最后结果 WorkFlowManage workflowmanage = new WorkFlowManage(); workflowmanage.GoNextProjectWorkFlowSataus(Common.ConvertEx.ToInt(Tmp_SingleProjectID), Common.ConvertEx.ToInt(Tmp_WorkFlowID)); } return("success");//MyTaskList.aspx } catch { return("fail"); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { T_SingleProject_MDL singleProMDL = singleProBLL.GetModel(DNTRequest.GetQueryInt("SingleProjectID", 0)); if (singleProMDL != null) { //将指导人员指导环节的所有 [受理]全部 做,这样,除了管理员和受理人员外,其他人都看不到流程下的工程 T_WorkFlowDefine_BLL workFlowDefineBLL = new T_WorkFlowDefine_BLL(); IList <T_WorkFlowDefine_MDL> workFlowDefineLT = workFlowDefineBLL.GetModelList(" SingleProjectID=" + singleProMDL.SingleProjectID + " and WorkFlowID in(" + SystemSet._DEFAULT_RECV_WORKFLOWID + ") "); if (workFlowDefineLT != null && workFlowDefineLT.Count > 0) { foreach (T_WorkFlowDefine_MDL wkdMDL in workFlowDefineLT) { wkdMDL.SubmitStatus = 2;//受理完成状态 wkdMDL.RecvUserID = Common.ConvertEx.ToInt(ddlNewUser.SelectValue); wkdMDL.RecvDateTime = DateTime.Now; workFlowDefineBLL.Update(wkdMDL); } } singleProMDL.ChargeUserID = Common.ConvertEx.ToInt(ddlNewUser.SelectValue); singleProBLL.Update(singleProMDL); Common.LogUtil.Info(this, "变更业务指导人员:" + singleProMDL.gcbm + "-------" + ddlOldUser.SelectText + "-------" + ddlNewUser.SelectText); PublicModel.writeLog(SystemSet.EumLogType.UpdData.ToString(), string.Concat("T_SingleProject_MDL;keyList=", singleProMDL.SingleProjectID, ";gcbm=", singleProMDL.gcbm, ";gcmc=", singleProMDL.gcmc, ";UserName="******"UserName"), ";UserID=", Common.Session.GetSession("UserID"), "变更业务指导人员(", ddlOldUser.SelectText, "--->", ddlNewUser.SelectText, ")")); } Common.MessageBox.CloseLayerOpenWeb(this.Page); } catch (Exception ex) { Common.LogUtil.Debug(this, "变更业务指导人员", ex); } }
public void DeleteFlag(int WorkFlowDefinID, bool DeleteFlag) { BLL.T_WorkFlowDefine_BLL bll = new T_WorkFlowDefine_BLL(); Model.T_WorkFlowDefine_MDL mdl = bll.GetModel(WorkFlowDefinID); mdl.Del = DeleteFlag; bll.Update(mdl); }
public string AcceptProject(string singleProjectID, string workFlowDefineID) { BLL.T_WorkFlowDefine_BLL wkdBLL = new T_WorkFlowDefine_BLL(); Model.T_WorkFlowDefine_MDL wkdMDL = wkdBLL.GetModel(ConvertEx.ToInt(workFlowDefineID)); int strSubmitStatus = wkdMDL.SubmitStatus; if (strSubmitStatus == 0 || strSubmitStatus == 1) //第一个流程strSubmitStatus=0; { wkdMDL.SubmitStatus = 2; //受理完成状态 wkdMDL.RecvUserID = ConvertEx.ToInt(Common.Session.GetSession("UserID")); wkdMDL.RecvDateTime = DateTime.Now; wkdBLL.Update(wkdMDL); //=====受理时需要加入权限的。否则看不到的。 CBLL.SingleProjectUser projectRole = new DigiPower.Onlinecol.Standard.CBLL.SingleProjectUser(); projectRole.Update(Common.ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(Session["RoleID"].ToString()), ConvertEx.ToInt(Session["UserID"].ToString())); //============================ return(SystemSet._RETURN_SUCCESS_VALUE); } else { return(SystemSet._RETURN_FAILURE_VALUE); } }
/// <summary> /// 获取文件的版本号 /// </summary> /// <param name="singleProjectID">工程ID</param> /// <returns></returns> public static int getFileVersion(string singleProjectID) { var version = 0; T_WorkFlowDefine_BLL workFlowBLL = new T_WorkFlowDefine_BLL(); string strWhere = "SingleProjectID=" + singleProjectID + " AND IsRollBack=1 and DoStatus=1 "; IList <T_WorkFlowDefine_MDL> list = workFlowBLL.GetModelList(strWhere); if (list != null && list.Count > 0) { version = ConvertEx.ToInt(list[0].RollBackCount); } return(version); }
public string SaveAndAccept() { try { //仅处理最后结果 string Tmp_SingleProjectID = Common.ConvertEx.ToString(Session["Tmp_SingleProjectID"]); string Tmp_WorkFlowID = Common.ConvertEx.ToString(Session["Tmp_WorkFlowID"]); //WorkFlowManage workflowmanage = new WorkFlowManage(); //if (workflowmanage.GoNextProjectWorkFlowSataus(SingleProjectID, WorkFlowID)) //{ // Response.Redirect("~/MyTaskList.aspx"); //} //存下华表路径 //List<T_WorkFlowDefine_MDL> ltDefineMdl = new T_WorkFlowDefine_BLL().GetModelList("SingleProjectID=" + Tmp_SingleProjectID + " AND WorkFlowID=" + Tmp_WorkFlowID + ""); //if (ltDefineMdl.Count > 0) //{ // T_WorkFlowDefine_MDL Mdl = ltDefineMdl[0]; // Mdl.RecvCellPath = "SubmitToReadyCheck.aspx?CellName=" + NewGUID; // //Mdl.RecvDateTime = DateTime.Now; // //Mdl.RecvUserID = Common.ConvertEx.ToInt(Session["UserID"]); // new T_WorkFlowDefine_BLL().Update(Mdl); //} BLL.T_WorkFlowDefine_BLL wkdBLL = new T_WorkFlowDefine_BLL(); DataSet ds = wkdBLL.GetList("SingleProjectID=" + Tmp_SingleProjectID + " AND WorkFlowID=" + Tmp_WorkFlowID); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { Model.T_WorkFlowDefine_MDL wkdMDL = wkdBLL.GetModel(Common.ConvertEx.ToInt(ds.Tables[0].Rows[0]["WorkFlowDefineID"].ToString())); wkdMDL.SubmitStatus = 2;//受理完成状态 wkdMDL.RecvUserID = Common.ConvertEx.ToInt(Session["UserID"]); wkdMDL.RecvDateTime = DateTime.Now; wkdMDL.RecvCellPath = "SubmitToReadyCheck.aspx?CellName=" + Session["CellTempGUID"].ToString(); wkdBLL.Update(wkdMDL); return(" SingleProjectID=" + Tmp_SingleProjectID + "&WorkFlowID=" + Tmp_WorkFlowID); } return("success"); } catch { return("fail"); } }
public bool CheckRecvStatus(string singleProjectID, string workFlowID) { if (!Common.Session.GetSessionBool("IsCompany")) { T_WorkFlowDefine_BLL wfDefine = new T_WorkFlowDefine_BLL(); DataSet ds = wfDefine.GetList("SingleProjectID=" + singleProjectID + " AND WorkFlowID=" + workFlowID + " AND SubmitStatus<>2"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) //未受理 { return(false); } else { return(true); } } return(true); }
public string SubMitProject(string singleProjectID, string workFlowID, string workFlowDefineID) { Model.T_SingleProject_MDL spMDL = (new BLL.T_SingleProject_BLL()).GetModel(ConvertEx.ToInt(singleProjectID)); BLL.T_FileList_BLL flBLL = new T_FileList_BLL(); DataSet ds2 = flBLL.GetList("SingleProjectID=" + singleProjectID); if (!String.IsNullOrEmpty(spMDL.gcbm) && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0) { //窗口接收提交的时候,更新该工程所有案卷下的文件序号,根据文件编号排序更新 if (ConvertEx.ToInt(workFlowID) == PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.WINRECV.ToString())) { new T_Archive_BLL().updateFileOrderIndexBySingleProjectID(singleProjectID); } BLL.T_WorkFlowDefine_BLL wkBLL = new T_WorkFlowDefine_BLL(); Model.T_WorkFlowDefine_MDL wkMDL = wkBLL.GetModel(ConvertEx.ToInt(workFlowDefineID)); if (String.IsNullOrEmpty(wkMDL.SubmitCellPath)) //有些地方不需要填申请单的 { WorkFlowManage workflowmanage = new WorkFlowManage(); if (workflowmanage.GoNextProjectWorkFlowSataus(ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(workFlowID))) { return(SystemSet._RETURN_SUCCESS_VALUE); } else { return(SystemSet._RETURN_FAILURE_VALUE); } } else //填申请单的未做 { return(SystemSet._RETURN_SUCCESS_VALUE); } } else { return("请选分配任务!"); } }
/// <summary> /// 绑定接收审核信息 /// </summary> /// <param name="SingleProjectID"></param> public void DataBindEx(string SingleProjectID, string WorkFlowCode) { DataTable dt = new T_WorkFlowDefine_BLL().GetWrokFlowCheckInfo(SingleProjectID, WorkFlowCode).Tables[0]; if (dt != null && dt.Rows.Count > 0) { SubmitUser_dash.Text = ConvertEx.ToString(dt.Rows[0]["P_SubmitUserName"]); SubmitDateTime_dash.Text = ConvertEx.ToDate(dt.Rows[0]["P_SubmitDateTime"]).ToString("yyyy-MM-dd"); RecvUser_dash.Text = ConvertEx.ToString(dt.Rows[0]["RecvUserName"]); RecvDateTime_dash.Text = ConvertEx.ToDate(dt.Rows[0]["RecvDateTime"]).ToString("yyyy-MM-dd"); DataSet ds = new T_Other_BLL().GetArchiveInfo(Common.DNTRequest.GetQueryString("SingleProjectID")); if (ds.Tables.Count > 0) { DataTable table = ds.Tables[0]; ArchiveCount.Text = Common.ConvertEx.ToString(table.Rows[0]["archiveCount"]); //案卷个数 wz.Text = Common.ConvertEx.ToString(table.Rows[0]["wz"]); //文字 tzz.Text = Common.ConvertEx.ToString(table.Rows[0]["tzz"]); //图纸层 zp.Text = Common.ConvertEx.ToString(table.Rows[0]["zp"]); //照片 hh.Text = Common.ConvertEx.ToString(table.Rows[0]["hh"]); //混合 } } }
/// <summary> /// 绑定接收审核信息 /// </summary> /// <param name="SingleProjectID"></param> public void DataBindEx(string SingleProjectID) { List <T_WorkFlowDefine_MDL> ltWorkFlowDefine2 = new T_WorkFlowDefine_BLL().GetModelList("SingleProjectID=" + SingleProjectID + " AND WorkFlowID=(select WorkFlowID from T_WorkFlow where WorkFlowCode='CHECK')"); if (ltWorkFlowDefine2.Count > 0) { SubmitUser_dash.Text = GetUserName(Common.ConvertEx.ToInt(ltWorkFlowDefine2[0].SubmitUserID)); SubmitDateTime_dash.Text = Common.ConvertEx.ToDate(ltWorkFlowDefine2[0].SubmitDateTime).ToString("yyyy-MM-dd"); RecvUser_dash.Text = GetUserName(Common.ConvertEx.ToInt(ltWorkFlowDefine2[0].RecvUserID)); RecvDateTime_dash.Text = Common.ConvertEx.ToDate(ltWorkFlowDefine2[0].RecvDateTime).ToString("yyyy-MM-dd"); DataSet ds = new T_Other_BLL().GetArchiveInfo(Common.DNTRequest.GetQueryString("SingleProjectID")); if (ds.Tables.Count > 0) { DataTable table = ds.Tables[0]; ArchiveCount.Text = Common.ConvertEx.ToString(table.Rows[0]["archiveCount"]); //案卷个数 wz.Text = Common.ConvertEx.ToString(table.Rows[0]["wz"]); //文字卷数 tzz.Text = Common.ConvertEx.ToString(table.Rows[0]["tzz"]); //图纸卷数 zp.Text = Common.ConvertEx.ToString(table.Rows[0]["zp"]); //照片卷数 hh.Text = Common.ConvertEx.ToString(table.Rows[0]["hh"]); //混合卷数 } } }
public string AllotSingleProject(string SingleProjectID, string ChargeUserID, string WorkFlowID) { try { //激活工程 T_SingleProject_MDL singleProjectMDL = singleProjectBLL.GetModel(ConvertEx.ToInt(SingleProjectID)); singleProjectMDL.Status = 1; int CompanyID = 0; #region 没有工程编号则生成 if (String.IsNullOrEmpty(singleProjectMDL.gcbm)) { T_Other_BLL otherBLL = new T_Other_BLL(); singleProjectMDL.gcbm = otherBLL.GetNewEngineerID(); singleProjectBLL.Update(singleProjectMDL); //产生工程号 T_Construction_Project_BLL cpBLL = new T_Construction_Project_BLL(); Model.T_Construction_Project_MDL cpMDL = cpBLL.GetModel(singleProjectMDL.ConstructionProjectID); if (cpMDL != null) { CompanyID = cpMDL.CompanyID; //建设单位ID if (String.IsNullOrEmpty(cpMDL.xmh)) { cpMDL.xmh = otherBLL.GetNewProjectID(); cpBLL.Update(cpMDL); //更新项目号 } } } #endregion #region 激活用户 T_UsersInfo_BLL userBLL = new T_UsersInfo_BLL(); T_UsersInfo_MDL userMDL = userBLL.GetModel(singleProjectMDL.CompanyUserID); if (userMDL != null) { userMDL.IsValid = true; userBLL.Update(userMDL); } #endregion #region 修改工程分配信息 if (singleProjectMDL != null) { singleProjectMDL.AllotDate = DateTime.Now; //分配时间 singleProjectMDL.AllotUserID = ConvertEx.ToInt(Common.Session.GetSession("UserId")); //分配人员 singleProjectMDL.ChargeUserID = ConvertEx.ToInt(ChargeUserID); //业务指导人员 singleProjectBLL.Update(singleProjectMDL); } #endregion #region 添加建设单位归档目录 string iSignaturePdf = "0"; //文件是否需要签章 string iSignatureWorkFlow = "0"; //是否按签章流程签章 if (ConvertEx.ToBool(SystemSet._ISIGNATUREPDF)) { iSignaturePdf = "1"; iSignatureWorkFlow = "1"; } new UserOperate().CopyFileList(CompanyID, singleProjectMDL.CompanyUserID, "", singleProjectMDL.SingleProjectID, singleProjectMDL.ProjectType, iSignaturePdf, iSignatureWorkFlow); #endregion #region 把业务指导人员用户加入到这个工程用户中去 T_UsersInfo_MDL ChargeUserMDL = userBLL.GetModel(Common.ConvertEx.ToInt(ChargeUserID)); PublicModel.AddSingleProjectUser(singleProjectMDL.SingleProjectID, ChargeUserMDL); #endregion #region 相关流程的用户也需要加入,否则流程走不下去===现在有了受理,可以达到这个功能,不需要加了。让用户受理下来。受理还没做完呢? SingleProjectUser projectRole = new SingleProjectUser(); BLL.T_WorkFlow_BLL workFlowBLL = new T_WorkFlow_BLL(); DataSet workFlowDS = workFlowBLL.GetList(" OrderIndex=1 "); if (workFlowDS.Tables.Count > 0) { foreach (DataRow row in workFlowDS.Tables[0].Rows) { projectRole.Update(singleProjectMDL.SingleProjectID, Common.ConvertEx.ToInt(row["RoleID"]), Common.ConvertEx.ToInt(row["UserID"])); } } #endregion #region 发送邮件通知客户 if (SystemSet._ACCEPTSINGLE_SENDEMAILFLAG) { string strMsgBody = "您好!<br />"; strMsgBody += "您报建的工程:" + singleProjectMDL.gcmc + ",已确认通过,产生的工程编号是:" + singleProjectMDL.gcbm + ",您现在已经可以通过注册时的账号密码登记系统操作了!"; T_UsersInfo_MDL CompanyUserMDL = userBLL.GetModel(singleProjectMDL.CompanyUserID); Common.CSendEmail.SendEmail("档案馆", CompanyUserMDL.EMail, "工程报建确认通知", strMsgBody, ""); } #endregion #region 提交到下一个流程 WorkFlowManage workflowmanage = new WorkFlowManage(); workflowmanage.GoNextProjectWorkFlowSataus(singleProjectMDL.SingleProjectID, ConvertEx.ToInt(WorkFlowID)); #endregion #region 将指导人员指导环节的所有 [受理]全部 做,这样,除了管理员和受理人员外,其他人都看不到流程下的工程 T_WorkFlowDefine_BLL workFlowDefineBLL = new T_WorkFlowDefine_BLL(); IList <T_WorkFlowDefine_MDL> workFlowDefineLT = workFlowDefineBLL.GetModelList(" SingleProjectID=" + singleProjectMDL.SingleProjectID + " and WorkFlowID in(" + SystemSet._DEFAULT_RECV_WORKFLOWID + ") "); if (workFlowDefineLT != null && workFlowDefineLT.Count > 0) { foreach (T_WorkFlowDefine_MDL wkdMDL in workFlowDefineLT) { wkdMDL.SubmitStatus = 2;//受理完成状态 wkdMDL.RecvUserID = Common.ConvertEx.ToInt(ChargeUserID); wkdMDL.RecvDateTime = DateTime.Now; workFlowDefineBLL.Update(wkdMDL); } } #endregion return(singleProjectMDL.gcbm); } catch (Exception ex) { return(SystemSet._RETURN_FAILURE_VALUE + ex.Message); } }
protected void GetWorkFlowHtml(T_SingleProject_MDL spMDL) { if (spMDL != null) { StringBuilder strBuilder = new StringBuilder(); DateTime createDt = ConvertEx.ToDate(spMDL.CreateDate); strBuilder.Append("<h2 class=\"first\"><a href=\"#nogo\">" + createDt.ToString("yyyy") + "年</a></h2> "); strBuilder.Append("<li> "); strBuilder.Append(" <h3>" + createDt.ToString("MM.dd") + "<span>" + createDt.ToString("yyyy") + "</span></h3> "); strBuilder.Append(" <dl> "); strBuilder.Append(" <dt>工程开始报建"); strBuilder.Append(" <span>" + spMDL.jsdw + " </span> "); strBuilder.Append(" </dt> "); strBuilder.Append(" </dl>"); strBuilder.Append("</li> "); DataSet ds = new T_WorkFlowDefine_BLL().GetProjectListByWorkFlowAndUser(spMDL.SingleProjectID.ToString()); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0].Copy(); dt.Clear(); Recursion(ds.Tables[0], 0, ref dt); foreach (DataRow row in dt.Rows) { string recvDateTime = String.IsNullOrEmpty(ConvertEx.ToString(row["RecvDateTime"])) ? "" : Convert.ToDateTime(row["RecvDateTime"]).ToString("yyyy-MM-dd HH:mm:ss"); string submitDateTime = String.IsNullOrEmpty(ConvertEx.ToString(row["SubmitDateTime"])) ? "" : Convert.ToDateTime(row["SubmitDateTime"]).ToString("yyyy-MM-dd HH:mm:ss"); if (ConvertEx.ToInt(row["DoStatus"]) == 1 && ConvertEx.ToInt(spMDL.Status) < 3722) { strBuilder.Append("<li class=\"green\">"); } else { strBuilder.Append("<li>"); } if (recvDateTime.Length > 0) { strBuilder.Append(" <h3>" + ConvertEx.ToDate(recvDateTime).ToString("MM.dd") + "<span>" + ConvertEx.ToDate(recvDateTime).ToString("yyyy") + "</span></h3> "); } else { strBuilder.Append(" <h3> <span> </span></h3> "); } strBuilder.Append(" <dl>"); strBuilder.Append(" <dt>" + ConvertEx.ToString(row["WorkFlowName"]) + ""); strBuilder.Append(" <span>"); if (!string.IsNullOrWhiteSpace(row["RecvUserName"].ToString()) && !string.IsNullOrWhiteSpace(recvDateTime)) { strBuilder.Append(String.Concat("受理人:", Convert.ToString(row["RecvUserName"]), " ", "受理时间:", recvDateTime)); } if (!string.IsNullOrWhiteSpace(row["SubmitUserName"].ToString()) && !string.IsNullOrWhiteSpace(submitDateTime)) { strBuilder.Append(String.Concat("<br/>", "提交人:", Convert.ToString(row["SubmitUserName"]), " ", "提交时间:", submitDateTime)); } strBuilder.Append(" </span>"); strBuilder.Append(" </dt> "); strBuilder.Append(" </dl> "); strBuilder.Append("</li> "); } } if (ConvertEx.ToInt(spMDL.Status) == 3722 && spMDL.Rksj != null) { strBuilder.Append("<li class=\"green\"> "); strBuilder.Append(" <h3>" + ConvertEx.ToDate(spMDL.Rksj).ToString("MM.dd") + "<span>" + ConvertEx.ToDate(spMDL.Rksj).ToString("yyyy") + "</span></h3> "); strBuilder.Append(" <dl> "); strBuilder.Append(" <dt>工程档案数据已移交到库房"); strBuilder.Append(" <span>" + ConvertEx.ToDate(spMDL.Rksj).ToString("yyyy-MM-dd HH:mm:ss") + " </span> "); strBuilder.Append(" </dt> "); strBuilder.Append(" </dl>"); strBuilder.Append("</li> "); } ltWorkFlow.Text = strBuilder.ToString(); } }