/// <summary>
/// 专项整治逻辑处理
/// </summary>
/// <param name="WFSNAME">流程详细名称</param>
/// <param name="WFSID">流程详细ID</param>
/// <param name="smsj">要处理的表(smsj)</param>
/// <returns></returns>
public string function_specialtasks(out string WFSNAME, string WFSID, zxzz_tasks zxzzmodel)
{
Entities dbsmsj = new Entities();
zxzz_tasks zxzztaskmodel = null;
string INDID = string.Empty;
wf_workflowspecifics wfsmodel = new WF_WorkFlowSpecificDAL().GetSingle(WFSID);
if (wfsmodel != null && !string.IsNullOrEmpty(wfsmodel.tablenameid))
{
zxzztaskmodel = dbsmsj.zxzz_tasks.SingleOrDefault(t => t.taskid == wfsmodel.tablenameid);
if (zxzztaskmodel == null)
{
zxzztaskmodel = new zxzz_tasks();
INDID = GetNewId();
}
else
{
zxzztaskmodel.summarytime = zxzzmodel.summarytime;
zxzztaskmodel.summaryuserid = zxzzmodel.summaryuserid;
zxzztaskmodel.summary = zxzzmodel.summary;
zxzztaskmodel.results = zxzzmodel.results;
zxzztaskmodel.experiences = zxzzmodel.experiences;
new Zxzz_SpecialTaskDAL().UpdateSpecailTask(zxzztaskmodel);
}
}
else
{
zxzztaskmodel = new zxzz_tasks();
INDID = GetNewId();
}
if (!string.IsNullOrEmpty(INDID))//说明不存在
{
zxzztaskmodel.taskid = INDID;
zxzztaskmodel.title = zxzzmodel.title;
zxzztaskmodel.tasktype = zxzzmodel.tasktype;
zxzztaskmodel.level = zxzzmodel.level;
zxzztaskmodel.term = zxzzmodel.term;
zxzztaskmodel.starttime = zxzzmodel.starttime;
zxzztaskmodel.endtime = zxzzmodel.endtime;
zxzztaskmodel.region = zxzzmodel.region;
zxzztaskmodel.taskexplain = zxzzmodel.taskexplain;
zxzztaskmodel.grometry = zxzzmodel.grometry;
zxzztaskmodel.fqr = zxzzmodel.fqr;
zxzztaskmodel.fqtime = zxzzmodel.fqtime;
zxzztaskmodel.xdzd = zxzzmodel.xdzd;
zxzztaskmodel.leader = zxzzmodel.leader;
zxzztaskmodel.createuserid = zxzzmodel.createuserid;
zxzztaskmodel.createtime = DateTime.Now;
}
if (!string.IsNullOrEmpty(INDID))
{
//添加
dbsmsj.zxzz_tasks.Add(zxzztaskmodel);
dbsmsj.SaveChanges();
}
if (string.IsNullOrEmpty(INDID))
{
INDID = zxzztaskmodel.taskid;
}
WFSNAME = zxzzmodel.title;
return(INDID);
}
/// <summary>
/// 协同管理执法的逻辑处理
/// </summary>
/// <param name="WFSNAME">流程详细名称</param>
/// <param name="WFSID">流程详细ID</param>
/// <param name="smsj">要处理的表(smsj)</param>
/// <returns></returns>
public string function_citizenservices(out string WFSNAME, string WFSID, sm_citizenservices smsj)
{
Entities dbsmsj = new Entities();
sm_citizenservices citizenservicesmodel = null;
string INDID = string.Empty;
wf_workflowspecifics wfsmodel = new WF_WorkFlowSpecificDAL().GetSingle(WFSID);
if (wfsmodel != null && !string.IsNullOrEmpty(wfsmodel.tablenameid))
{
citizenservicesmodel = dbsmsj.sm_citizenservices.SingleOrDefault(t => t.citizenid == wfsmodel.tablenameid);
if (citizenservicesmodel == null)
{
citizenservicesmodel = new sm_citizenservices();
INDID = GetNewId();
}
if (!string.IsNullOrEmpty(smsj.processmode) || !string.IsNullOrEmpty(smsj.satisfaction))
{
citizenservicesmodel.processmode = smsj.processmode;
citizenservicesmodel.satisfaction = smsj.satisfaction;
new SM_CitizenServicesDAL().UpdateCitizen(citizenservicesmodel);
}
if (smsj.processuserid != null)
{
citizenservicesmodel.processuserid = smsj.processuserid;
new SM_CitizenServicesDAL().UpdateCitizenProcess(citizenservicesmodel);
}
if (smsj.officeuserid != null)
{
citizenservicesmodel.officeuserid = smsj.officeuserid;
new SM_CitizenServicesDAL().UpdateCitizenOffice(citizenservicesmodel);
}
if (!string.IsNullOrEmpty(smsj.workflowtype))
{
citizenservicesmodel.workflowtype = smsj.workflowtype;
new SM_CitizenServicesDAL().UpdateCitizenOffice(citizenservicesmodel);
}
if (!string.IsNullOrEmpty(smsj.suggest))
{
citizenservicesmodel.suggest = smsj.suggest;
new SM_CitizenServicesDAL().UpdateCitizenOffice(citizenservicesmodel);
}
if (smsj.gdsj != null)
{
citizenservicesmodel.gdsj = smsj.gdsj;
new SM_CitizenServicesDAL().UpdateCitizengdsj(citizenservicesmodel);
}
if (!string.IsNullOrEmpty(smsj.pqxzid))
{
citizenservicesmodel.pqxzid = smsj.pqxzid;
new SM_CitizenServicesDAL().UpdateCitizenpqxz(citizenservicesmodel);
}
}
else
{
citizenservicesmodel = new sm_citizenservices();
INDID = GetNewId();
}
if (!string.IsNullOrEmpty(INDID))//说明不存在
{
citizenservicesmodel.citizenid = INDID;
citizenservicesmodel.sourceid = smsj.sourceid;
citizenservicesmodel.dutytime = smsj.dutytime;
citizenservicesmodel.eventid = smsj.eventid;
citizenservicesmodel.complainant = smsj.complainant;
citizenservicesmodel.cnumber = smsj.cnumber;
citizenservicesmodel.foundtime = smsj.foundtime;
citizenservicesmodel.contactphone = smsj.contactphone;
citizenservicesmodel.contactaddress = smsj.contactaddress;
citizenservicesmodel.eventaddress = smsj.eventaddress;
citizenservicesmodel.eventtitle = smsj.eventtitle;
citizenservicesmodel.eventcontent = smsj.eventcontent;
citizenservicesmodel.bigtypeid = smsj.bigtypeid;
citizenservicesmodel.smalltypeid = smsj.smalltypeid;
citizenservicesmodel.limittime = smsj.limittime;
citizenservicesmodel.recorduser = smsj.recorduser;
citizenservicesmodel.grometry = smsj.grometry;
citizenservicesmodel.createtime = smsj.createtime;
citizenservicesmodel.createuserid = smsj.createuserid;
citizenservicesmodel.sfzxzz = smsj.sfzxzz;
citizenservicesmodel.srid = smsj.srid;
citizenservicesmodel.processmode = smsj.processmode;
citizenservicesmodel.satisfaction = smsj.satisfaction;
citizenservicesmodel.processuserid = smsj.processuserid;
citizenservicesmodel.gdsj = smsj.gdsj;
citizenservicesmodel.workflowtype = smsj.workflowtype;
citizenservicesmodel.suggest = smsj.suggest;
citizenservicesmodel.xzid = smsj.xzid;
citizenservicesmodel.pqxzid = smsj.pqxzid;
}
if (!string.IsNullOrEmpty(INDID))
{
//添加
dbsmsj.sm_citizenservices.Add(citizenservicesmodel);
dbsmsj.SaveChanges();
}
//else
//{
// //更新
// sm_citizenservices smsjmodel = dbsmsj.sm_citizenservices.SingleOrDefault(a => a.citizenid == wfsmodel.tablenameid);
// if (smsjmodel != null)
// {
// smsjmodel.sourceid = smsj.sourceid;
// smsjmodel.dutytime = smsj.dutytime;
// smsjmodel.eventid = smsj.eventid;
// smsjmodel.complainant = smsj.complainant;
// smsjmodel.cnumber = smsj.cnumber;
// smsjmodel.foundtime = smsj.foundtime;
// smsjmodel.contactphone = smsj.contactphone;
// smsjmodel.contactaddress = smsj.contactaddress;
// smsjmodel.eventaddress = smsj.eventaddress;
// smsjmodel.eventtitle = smsj.eventtitle;
// smsjmodel.eventcontent = smsj.eventcontent;
// smsjmodel.bigtypeid = smsj.bigtypeid;
// smsjmodel.smalltypeid = smsj.smalltypeid;
// smsjmodel.limittime = smsj.limittime;
// smsjmodel.recorduser = smsj.recorduser;
// smsjmodel.grometry = smsj.grometry;
// smsjmodel.createtime = smsj.createtime;
// smsjmodel.createuserid = smsj.createuserid;
// smsjmodel.sfzxzz = smsj.sfzxzz;
// smsjmodel.srid = smsj.srid;
// smsjmodel.processmode = smsj.processmode;
// smsjmodel.satisfaction = smsj.satisfaction;
// smsjmodel.processuserid = smsj.processuserid;
// smsjmodel.gdsj = smsj.gdsj;
// dbsmsj.SaveChanges();
// }
//}
if (string.IsNullOrEmpty(INDID))
{
INDID = citizenservicesmodel.citizenid;
}
WFSNAME = smsj.eventtitle;
return(INDID);
}
/// <summary>
/// 养护任务逻辑处理
/// </summary>
/// <param name="WFSNAME">流程详细名称</param>
/// <param name="WFSID">流程详细ID</param>
/// <param name="smsj">要处理的表(smsj)</param>
/// <returns></returns>
public string function_yhtasks(out string WFSNAME, string WFSID, yh_yhtasks yhmodel)
{
Entities dbsmsj = new Entities();
yh_yhtasks yhtasksmodel = null;
string INDID = string.Empty;
wf_workflowspecifics wfsmodel = new WF_WorkFlowSpecificDAL().GetSingle(WFSID);
if (wfsmodel != null && !string.IsNullOrEmpty(wfsmodel.tablenameid))
{
yhtasksmodel = dbsmsj.yh_yhtasks.SingleOrDefault(t => t.yhtaskid == wfsmodel.tablenameid);
if (yhtasksmodel == null)
{
yhtasksmodel = new yh_yhtasks();
INDID = GetNewId();
}
//if (!string.IsNullOrEmpty(smsj.processmode) || !string.IsNullOrEmpty(smsj.satisfaction))
//{
// citizenservicesmodel.processmode = smsj.processmode;
// citizenservicesmodel.satisfaction = smsj.satisfaction;
// new SM_CitizenServicesDAL().UpdateCitizen(citizenservicesmodel);
//}
if (yhmodel.pqrid != null)
{
yhtasksmodel.pqrid = yhmodel.pqrid;
new YH_YhTaskDAL().UpdateCitizenProcess(yhtasksmodel);
}
//if (smsj.officeuserid!=null)
//{
// citizenservicesmodel.officeuserid = smsj.officeuserid;
// new SM_CitizenServicesDAL().UpdateCitizenOffice(citizenservicesmodel);
//}
}
else
{
yhtasksmodel = new yh_yhtasks();
INDID = GetNewId();
}
if (!string.IsNullOrEmpty(INDID))//说明不存在
{
yhtasksmodel.yhtaskid = INDID;
yhtasksmodel.yhcompany = yhmodel.yhcompany;
yhtasksmodel.foundtime = yhmodel.foundtime;
yhtasksmodel.fileename = yhmodel.fileename;
yhtasksmodel.wtsource = yhmodel.wtsource;
yhtasksmodel.yhtype = yhmodel.yhtype;
yhtasksmodel.wtbigclass = yhmodel.wtbigclass;
yhtasksmodel.wtsmallclass = yhmodel.wtsmallclass;
yhtasksmodel.yhobject = yhmodel.yhobject;
yhtasksmodel.weather = yhmodel.weather;
yhtasksmodel.duetime = yhmodel.duetime;
yhtasksmodel.outlay = yhmodel.outlay;
yhtasksmodel.workload = yhmodel.workload;
yhtasksmodel.yhcontract = yhmodel.yhcontract;
yhtasksmodel.wtaddress = yhmodel.wtaddress;
yhtasksmodel.wtdescribe = yhmodel.wtdescribe;
yhtasksmodel.geography84 = yhmodel.geography84;
yhtasksmodel.geography2000 = yhmodel.geography2000;
yhtasksmodel.wtnature = yhmodel.wtnature;
yhtasksmodel.points = yhmodel.points;
yhtasksmodel.debit = yhmodel.debit;
yhtasksmodel.sendusername = yhmodel.sendusername;
yhtasksmodel.outlay = yhmodel.outlay;
yhtasksmodel.sendopinion = yhmodel.sendopinion;
yhtasksmodel.createtime = DateTime.Now;
yhtasksmodel.createuserid = yhmodel.createuserid;
}
if (!string.IsNullOrEmpty(INDID))
{
//添加
dbsmsj.yh_yhtasks.Add(yhtasksmodel);
dbsmsj.SaveChanges();
}
if (string.IsNullOrEmpty(INDID))
{
INDID = yhtasksmodel.yhtaskid;
}
WFSNAME = yhmodel.yhobject;
return(INDID);
}
/// <summary>
/// 流程提交
/// </summary>
/// <param name="workflow">流程实例模型</param>
/// <param name="TableModel">具体表模型</param>
/// <returns></returns>
public string WF_Submit(WorkFlowClass workflow, object TableModel)
{
#region 获取数据
string tableName = workflow.FunctionName; //获取表名
string WFID = workflow.WFID; //工作流编号
string WFDID = workflow.WFDID; //工作流环节编号
string WFSID = workflow.WFSID; //活动实例编号
string WFSAID = workflow.WFSAID; //当前环节实例编号
string dealContent = workflow.DEALCONTENT; //会签意见
string NextWFDID = workflow.NextWFDID; //下一个环节编号
string NextWFUSERIDS = workflow.NextWFUSERIDS; //获取下一个环节的用户
string IsSendMsg = workflow.IsSendMsg; //是否发送短信
string Remark = workflow.Remark;
string processmode = workflow.processmode;
string satisfaction = workflow.satisfaction;
#endregion
#region 增加/修改 对应的流程
string TABLENAMEID = string.Empty; //对应表数据编号
string WFSNAME = string.Empty; //活动流程名称
switch (workflow.FunctionName)
{
case "sm_citizenservices": //市民服务基础表
TABLENAMEID = function_citizenservices(out WFSNAME, workflow.WFSID, (sm_citizenservices)TableModel);
break;
case "yh_yhtasks": //养护任务基础表
TABLENAMEID = function_yhtasks(out WFSNAME, workflow.WFSID, (yh_yhtasks)TableModel);
break;
case "zxzz_tasks": //专项整治基础表
TABLENAMEID = function_specialtasks(out WFSNAME, workflow.WFSID, (zxzz_tasks)TableModel);
break;
case "audit_project_w": //行政审批基础表
TABLENAMEID = workflow.syncrowguid;
break;
default:
break;
}
#endregion
#region 检查是否存在当前实例，如果不存在则增加当前活动实例
wf_workflowspecifics WFSModel = null;
if (!string.IsNullOrEmpty(workflow.WFSID))
{
WFSModel = new WF_WorkFlowSpecificDAL().GetSingle(workflow.WFSID);
if (WFSModel == null)
{
WFSID = "";
}
else
{
WFSModel.wfsname = WFSNAME;
new WF_WorkFlowSpecificDAL().Update(WFSModel);
}
}
if (string.IsNullOrEmpty(WFSID))
{
WFSModel = new wf_workflowspecifics();
WFSModel.wfsid = GetNewId();
WFSModel.wfid = WFID;
WFSModel.tablename = tableName;
WFSModel.createuserid = workflow.WFCreateUserID;
WFSModel.createtime = DateTime.Now;
WFSModel.status = 1;
WFSModel.tablenameid = TABLENAMEID;
WFSModel.wfsname = WFSNAME;
new WF_WorkFlowSpecificDAL().Add(WFSModel);
WFSID = WFSModel.wfsid;
}
#endregion
#region 增加活动实例具体的流程
#region 更新当前环节
decimal oldStatus;//当前环节是否已经处理完成 1：未处理，2已经处理
//更新或者增加当前流程的具体事例---返回当前环节编号
WFSAID = function_WF_DealCurentActivity(WFSAID, WFSID, workflow.WFCreateUserID.Value, 2, WFDID, out oldStatus);
//更新或者增加当前环节用户处理的意见---返回当前环节用户需要处理的编号
string WFSUID = function_WF_DealCurentActivityUser(WFSAID, workflow.WFCreateUserID.Value, dealContent, 2, DateTime.Now, "false", WFSNAME, workflow.WFCreateUserID.Value, Remark, processmode, satisfaction);
//增加当前处理用户的附件
switch (workflow.FunctionName)
{
case "sm_citizenservices": //市民服务
function_WF_WorkFlowAttrach_smsj(WFSUID, workflow.files, workflow.FileSource);
break;
case "yh_yhtasks": //养护任务
function_WF_WorkFlowAttrach_smsj(WFSUID, workflow.files, workflow.FileSource);
break;
case "zxzz_tasks": //专项整治
function_WF_WorkFlowAttrach_smsj(WFSUID, workflow.files, workflow.FileSource);
break;
case "audit_project_w": //行政审批基础表
function_WF_WorkFlowAttrach_smsj(WFSUID, workflow.files, workflow.FileSource);
break;
default:
break;
}
#endregion
//当前状态为处理，则说明是第一个人处理，则需要增加下一个环节，如果当前环节已经处理，则不需要增加下一个环节
string NextWFSAID = "";
if (oldStatus == 1)
{
//获取该环节是否为最后一个环节
wf_workflowdetails wfdModel = new WF_WorkFlowDetailDAL().GetSingle(NextWFDID);
//如果下一个环节的子环节存在，则状态为执行中，内容为空，否则下一个环节状态为结束，内容为已结束
int status_wfsa = 0;
string content_wfsa = string.Empty;
if (wfdModel != null && !string.IsNullOrEmpty(wfdModel.nextid))
{
status_wfsa = 1;
content_wfsa = "";
}
else
{
//结束该流程
WFSModel = new WF_WorkFlowSpecificDAL().GetSingle(WFSID);
if (WFSModel != null)
{
WFSModel.status = 2;
new WF_WorkFlowSpecificDAL().Update(WFSModel);
}
status_wfsa = 2;
content_wfsa = "已结束";
}
#region 增加下一个环节
//增加环节
NextWFSAID = function_WF_DealCurentActivity("", WFSID, workflow.WFCreateUserID.Value, status_wfsa, NextWFDID, out oldStatus);
#region 更新活动实例的当前环节编号
WFSModel = new WF_WorkFlowSpecificDAL().GetSingle(WFSID);
if (WFSModel != null)
{
WFSModel.currentwfsaid = NextWFSAID;
WFSModel.status = status_wfsa;
new WF_WorkFlowSpecificDAL().Update(WFSModel);
}
#endregion
//增加下一个环节的能操作的用户
if (!string.IsNullOrEmpty(NextWFUSERIDS))
{
string[] NextWFUSERIDS_split = NextWFUSERIDS.Split(',');
foreach (var item in NextWFUSERIDS_split)
{
decimal userid;
DateTime?dealTime = null;
if (decimal.TryParse(item, out userid))
{
if (status_wfsa == 2)
{
userid = workflow.WFCreateUserID.Value;
dealTime = DateTime.Now;
IsSendMsg = "false";
}
//增加流程能操作的用户
function_WF_DealCurentActivityUser(NextWFSAID, (int)userid, content_wfsa, status_wfsa, dealTime, IsSendMsg, WFSNAME, workflow.WFCreateUserID, Remark, processmode, satisfaction);
}
}
}
#endregion
}
#endregion
return(WFSID + "," + NextWFSAID + "," + TABLENAMEID);
}