public string HookUpCompanyAndUser(int SingleProjectID, int UserID, int RoleID,
int CompanyID, string ProjectType, string UserName, string CompanyType)
{
string flag = SystemSet._RETURN_SUCCESS_VALUE;
try {
PublicModel.AddSingleProjectUser(SingleProjectID, RoleID, UserID); //加入到工程用户表中去
PublicModel.AddSingleProjectCompany(SingleProjectID, CompanyID); //加入到工程公司表中去
} catch (Exception ex) {
flag = SystemSet._RETURN_FAILURE_VALUE + ex.Message;
Common.LogUtil.Debug(this, "工程相关表关联(工程用户表,工程公司表)", ex);
}
return(flag);
}
public void Execute(string singleProjectID, string companyID, string companyID2, bool flagType)
{
if (flagType)
{
DeleteSingleProjectCompany(singleProjectID, "AJCompanyInfo");
DeleteSingleProjectCompany(singleProjectID, "ZJCompanyInfo");
PublicModel.AddSingleProjectCompany(ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(companyID)); //安监单位
PublicModel.AddSingleProjectCompany(ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(companyID2)); //质监单位
PublicModel.AddSingleProjectUser(ConvertEx.ToInt(singleProjectID), GetUserInfoMdl(companyID));
PublicModel.AddSingleProjectUser(ConvertEx.ToInt(singleProjectID), GetUserInfoMdl(companyID2));
}
else
{
DeleteSingleProjectCompany(singleProjectID, "JCCompanyInfo");
PublicModel.AddSingleProjectCompany(ConvertEx.ToInt(singleProjectID), ConvertEx.ToInt(companyID)); //检测单位
PublicModel.AddSingleProjectUser(ConvertEx.ToInt(singleProjectID), GetUserInfoMdl(companyID));
}
}
public string HookUpCompanyAndUser(int SingleProjectID, int UserID, int RoleID,
int CompanyID, string ProjectType, string UserName, string CompanyType)
{
string flag = SystemSet._RETURN_SUCCESS_VALUE;
try {
string iSignaturePdf = "0"; //文件是否需要签章
string iSignatureWorkFlow = "0"; //是否按签章流程签章
if (ConvertEx.ToBool(SystemSet._ISIGNATUREPDF))
{
iSignaturePdf = "1";
iSignatureWorkFlow = "1";
}
PublicModel.AddSingleProjectUser(SingleProjectID, RoleID, UserID); //加入到工程用户表中去
PublicModel.AddSingleProjectCompany(SingleProjectID, CompanyID); //加入到工程公司表中去
userOper.CopyFileList(CompanyID, UserID, UserName, SingleProjectID, ProjectType, CompanyType, iSignaturePdf, iSignatureWorkFlow); //用户添加归档目录
#region 关联更新工程表的 施工,监理单位信息
T_SingleProject_MDL singleMDL = singleBLL.GetModel(SingleProjectID);
T_Company_MDL companyMDL = companyBLL.GetModel(CompanyID);
if (singleMDL != null && companyMDL != null)
{
if (ConvertEx.ToInt(CompanyType) == SystemSet._SGCOMPANYINFO)
{
singleMDL.sgdw = companyMDL.CompanyName;
}
else if (ConvertEx.ToInt(CompanyType) == SystemSet._JLCOMPANYINFO)
{
singleMDL.jldw = companyMDL.CompanyName;
}
singleBLL.Update(singleMDL);
}
#endregion
} catch (Exception ex) {
flag = SystemSet._RETURN_FAILURE_VALUE + ex.Message;
Common.LogUtil.Debug(this, "工程相关表关联(工程用户表,工程公司表)", ex);
}
return(flag);
}
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);
}
}