/// <summary>
/// 事件详情
/// </summary>
/// <param name="filters"></param>
/// <param name="start"></param>
/// <param name="limit"></param>
/// <returns></returns>
public Zxzz_TaskModel GetSpecialTaskModel(string taskid)
{
Zxzz_TaskModel model = new Zxzz_TaskModel();
using (Entities db = new Entities())
{
string sql = string.Format(@"select * from (select wfs.wfsid,wfs.wfsname,wfs.status,wf.wfid,wf.wfname,wfsa.wfdid,wfd.wfdname,wfsa.wfsaid,
u.id as userid,u.displayname as username,bu.displayname as createusername,wfw.createuserid as nextuserid,buser.displayname as nextusername,bz.zd_name,wfd.seqnum,zt.taskid,zt.title,zt.tasktype,zt.level,zt.term,zt.starttime,zt.endtime,zt.region,zt.taskexplain,zt.grometry,zt.fqr,zt.fqtime,zt.xdzd,zt.leader,zt.summarytime,zt.summaryuserid,zt.summary,zt.results,zt.experiences
from wf_workflowspecifics wfs
inner join wf_workflowspecificactivitys wfsa on wfs.wfsid=wfsa.wfsid and
wfs.CURRENTWFSAID=wfsa.wfsaid
inner join wf_workflows wf on wf.wfid=wfs.wfid
inner join wf_workflowdetails wfd on wfsa.wfdid=wfd.wfdid
inner join zxzz_tasks zt on wfs.TABLENAMEID=zt.taskid
inner join base_users u on u.id=wfs.createuserid
inner join base_users bu on bu.id=zt.createuserid
inner join base_zds bz on zt.tasktype=bz.zd_id and bz.zd_type='type_task'
inner join wf_workflowspecificusers wfw on wfw.wfsaid=wfsa.wfsaid
inner join base_users buser on buser.id=wfw.createuserid
where wfs.wfsid in (
select wfsid from wf_workflowspecificactivitys where wfsaid in (
select wfsaid from wf_workflowspecificusers
)
)
order by wfsa.createtime desc) tab1 GROUP BY tab1.wfsid");
IEnumerable <Zxzz_TaskModel> list = db.Database.SqlQuery <Zxzz_TaskModel>(sql);
if (list.Count() > 0)
{
model = list.FirstOrDefault(a => a.taskid == taskid);
}
return(model);
}
}
public HttpResponseMessage SpecialTaskSummarize(Zxzz_TaskModel model)
{
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
WorkFlowManagerBLL bll = new WorkFlowManagerBLL();
zxzz_tasks ztmodel = new zxzz_tasks();
WorkFlowClass wf = new WorkFlowClass();
List <FileClass> list = new List <FileClass>();
Zxzz_SpecialTaskBLL ztbll = new Zxzz_SpecialTaskBLL();
string[] fileClass = model.uploadpanelValue;
ztmodel.summarytime = model.summarytime;
ztmodel.summaryuserid = model.summaryuserid;
ztmodel.summary = model.summary;
ztmodel.results = model.results;
ztmodel.experiences = model.experiences;
if (fileClass != null && fileClass.Length > 0)
{
foreach (var item in fileClass)
{
FileClass infileClass = new FileClass();
JObject jo = new JObject();
jo = (JObject)JsonConvert.DeserializeObject(item);
infileClass.OriginalPath = jo["OriginalPath"] == null ? "" : jo["OriginalPath"].ToString();
infileClass.OriginalName = jo["OriginalName"] == null ? "" : jo["OriginalName"].ToString();
infileClass.OriginalType = jo["OriginalType"] == null ? "" : jo["OriginalType"].ToString();
infileClass.size = jo["size"] == null ? 0 : (double)jo["size"];
list.Add(infileClass);
}
}
#region 专项整治流程
wf.FunctionName = "zxzz_tasks";
wf.WFID = "2017041214100001";
wf.WFDID = "2017041214200004";
wf.NextWFDID = "2017041214200005";
wf.NextWFUSERIDS = ztbll.GetUseridsByUnitids(model.xdzd);
wf.WFSAID = model.wfsaid;
wf.WFSID = model.wfsid;
wf.IsSendMsg = "false";
wf.WFCreateUserID = model.summaryuserid;
wf.files = list;
#endregion
bll.WF_Submit(wf, ztmodel);
//结束总结所有wfsu用户的未处理
ztbll.EndAllWFSU(wf.WFSAID);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
return(response);
}
public HttpResponseMessage SpecialTaskFiring(Zxzz_TaskModel model)
{
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
WorkFlowManagerBLL bll = new WorkFlowManagerBLL();
WorkFlowClass wf = new WorkFlowClass();
List <FileClass> list = new List <FileClass>();
Zxzz_SpecialTaskBLL zpbll = new Zxzz_SpecialTaskBLL();
string[] fileClass = model.uploadpanelValue;
zxzz_tasks ztmodel = new zxzz_tasks();
if (fileClass != null && fileClass.Length > 0)
{
foreach (var item in fileClass)
{
FileClass infileClass = new FileClass();
JObject jo = new JObject();
jo = (JObject)JsonConvert.DeserializeObject(item);
infileClass.OriginalPath = jo["OriginalPath"] == null ? "" : jo["OriginalPath"].ToString();
infileClass.OriginalName = jo["OriginalName"] == null ? "" : jo["OriginalName"].ToString();
infileClass.OriginalType = jo["OriginalType"] == null ? "" : jo["OriginalType"].ToString();
infileClass.size = jo["size"] == null ? 0 : (double)jo["size"];
list.Add(infileClass);
}
}
#region 专项整治流程
wf.FunctionName = "zxzz_tasks";
wf.WFID = "2017041214100001";
wf.WFDID = model.wfdid;
wf.NextWFDID = model.nextwfdid;
wf.processmode = model.nextwfdid;
wf.NextWFUSERIDS = zpbll.GetUseridsByUnitids(model.xdzd);
wf.WFSAID = model.wfsaid;
wf.WFSID = model.wfsid;
wf.DEALCONTENT = model.dealcontent;
wf.IsSendMsg = "false";
wf.WFCreateUserID = model.createuserid;
wf.files = list;
#endregion
string wf_data = bll.WF_Submit(wf, ztmodel);
//初始化WFSU
zpbll.ReloadWFSU(wf_data.Split(',')[1]);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
return(response);
}
public HttpResponseMessage AddSpecialTask(Zxzz_TaskModel model)
{
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
WorkFlowManagerBLL bll = new WorkFlowManagerBLL();
WorkFlowClass wf = new WorkFlowClass();
List <FileClass> list = new List <FileClass>();
zxzz_tasks ztmodel = new zxzz_tasks();
ztmodel.title = model.title;
ztmodel.tasktype = model.tasktype;
ztmodel.level = model.level;
ztmodel.term = model.term;
ztmodel.starttime = model.starttime;
ztmodel.endtime = model.endtime;
ztmodel.region = model.region;
ztmodel.taskexplain = model.taskexplain;
ztmodel.grometry = model.grometry;
ztmodel.fqr = model.fqr;
ztmodel.fqtime = model.fqtime;
ztmodel.leader = model.leader;
ztmodel.createuserid = model.fqr;
ztmodel.createtime = DateTime.Now;
string[] fileClass = model.uploadpanelValue;
string[] fileClassXDZD = model.xdzdValue;
foreach (var item in fileClassXDZD)
{
model.xdzd += item + ",";
}
ztmodel.xdzd = model.xdzd.Substring(0, model.xdzd.Length - 1);
if (fileClass != null && fileClass.Length > 0)
{
foreach (var item in fileClass)
{
FileClass infileClass = new FileClass();
JObject jo = new JObject();
jo = (JObject)JsonConvert.DeserializeObject(item);
infileClass.OriginalPath = jo["OriginalPath"] == null ? "" : jo["OriginalPath"].ToString();
infileClass.OriginalName = jo["OriginalName"] == null ? "" : jo["OriginalName"].ToString();
infileClass.OriginalType = jo["OriginalType"] == null ? "" : jo["OriginalType"].ToString();
infileClass.size = jo["size"] == null ? 0 : (double)jo["size"];
list.Add(infileClass);
}
}
#region 专项整治流程
wf.FunctionName = "zxzz_tasks";
wf.WFID = "2017041214100001";
wf.WFDID = "2017041214200001";
wf.NextWFDID = "2017041214200002";
wf.NextWFUSERIDS = model.leader.ToString();
wf.IsSendMsg = "false";
wf.WFCreateUserID = model.fqr;
wf.files = list;
#endregion
bll.WF_Submit(wf, ztmodel);
#region 添加日志
SystemLogBLL slbll = new SystemLogBLL();
slbll.WriteSystemLog("专项整治", "", (int)model.fqr);
#endregion
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
return(response);
}
