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);
}
/// <summary>
/// 修改工程流程状态
/// </summary>
/// <param name="WorkFlowID">流程id</param>
/// <param name="SingleProjectID">工程id</param>
/// <returns></returns>
public DataSet UpdateProjectWorkFlowStatus(Model.T_WorkFlowDefine_MDL wkMDL)
{
string strsql1 = "update T_WorkFlowDefine set ";
strsql1 += "dostatus=0,";
strsql1 += "IsRollBack='" + wkMDL.IsRollBack + "',";
strsql1 += "SubmitStatus='" + wkMDL.SubmitStatus + "',";
strsql1 += "SubmitUserID=" + wkMDL.SubmitUserID + ",";
strsql1 += "SubmitDateTime='" + wkMDL.SubmitDateTime + "' ";
strsql1 += "where SingleProjectID=" + wkMDL.SingleProjectID + " and WorkFlowID=" + wkMDL.WorkFlowID;
//string strsql1 = "update T_WorkFlowDefine set dostatus=0 where SingleProjectID=" + wkMDL.SingleProjectID + " and WorkFlowID=" + wkMDL.WorkFlowID;
string strsql2 = "update T_WorkFlowDefine set dostatus=1 where SingleProjectID=" + wkMDL.SingleProjectID + " and PID=" + wkMDL.WorkFlowID;
//jdk 11.18 更新工程表中的 流程ID
string strsql3 = "update T_SingleProject set WorkFlow_DoStatus=(select top 1 WorkFlowID from T_WorkFlowDefine where SingleProjectID=" + wkMDL.SingleProjectID + " and PID=" + wkMDL.WorkFlowID + ") ";
strsql3 += " where SingleProjectID=" + wkMDL.SingleProjectID;
List <string> sqllist = new List <string>();
sqllist.Add(strsql1);
sqllist.Add(strsql2);
sqllist.Add(strsql3);
try {
//DbHelperSQL.ExecuteSql(strsql1);
//DbHelperSQL.ExecuteSql(strsql2);
DbHelperSQL.ExecuteSqlTran(sqllist);
string strwhere = " SingleProjectID=" + wkMDL.SingleProjectID + " and pid=" + wkMDL.WorkFlowID;
return(GetList(strwhere));
} catch {
return(null);
}
}
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);
}
}
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 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>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion 成员方法
/// <summary>
/// 修改工程流程状态
/// </summary>
/// <param name="workflowid">流程ID</param>
/// <param name="SingleProjectID">工程ID</param>
/// <returns></returns>
public DataSet UpdateProjectWorkFlowStatus(Model.T_WorkFlowDefine_MDL wkMDL)
{
return(dal.UpdateProjectWorkFlowStatus(wkMDL));
}
