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();
}
}
