protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(RequestData.Get <string>("currentWeek")))
{
currentWeek = GetWeekOfYear();
}
else
{
currentWeek = RequestData.Get <int>("currentWeek");
year = RequestData.Get <int>("year");
}
switch (RequestActionString.ToLower())
{
case "create":
//ent = JsonHelper.GetObject<ChouJin>(jsonstr);
//ent.DoCreate();
//foreach (string str in shoukuanarray)
//{
// ShouKuan skEnt = ShouKuan.Find(str);
// skEnt.ChouJinId = ent.Id;
// skEnt.DoUpdate();
//}
//PageState.Add("Result", ent.Id);
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
switch (RequestActionString.ToLower())
{
case "delete":
string tripids = RequestData.Get <string>("tripids");
sql = "delete from BJKY_IntegratedManage..LeaderTrip where '" + tripids + "' like '%'+Id+'%'";
DataHelper.ExecSql(sql);
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(RequestData.Get <string>("currentWeek")))
{
currentWeek = GetWeekOfYear();
}
else
{
currentWeek = RequestData.Get <int>("currentWeek");
year = RequestData.Get <int>("year");
}
switch (RequestActionString.ToLower())
{
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
switch (RequestActionString.ToLower())
{
case "startflow":
//启动流程
/*string key = "FirstFlow";
* //表单路径,后面加上参数传入
* string formUrl = "/EPC/PrjBasic/PrjBasicEdit.aspx?op=u";
* Aim.WorkFlow.WorkFlow.StartWorkFlow("", formUrl, "流程的标题", key, this.UserInfo.UserID, this.UserInfo.Name);*/
string key = this.RequestData.Get <string>("flowkey");
Aim.WorkFlow.WorkflowTemplate ne = Aim.WorkFlow.WorkflowTemplate.FindAllByProperty("Code", key)[0];
//启动流程
//表单路径,后面加上参数传入
string formUrl = "/WorkFlow/flowdemo.htm";
Aim.WorkFlow.WorkFlow.StartWorkFlow(ne.ID, formUrl, ne.TemplateName, key, this.UserInfo.UserID, this.UserInfo.Name);
PageState.Add("message", "启动成功");
break;
default:
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
case "BeginDate":
where += " and ReceiveDate>='" + item.Value + "' ";
break;
case "EndDate":
where += " and ReceiveDate<='" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
break;
default:
where += " and " + item.PropertyName + " like '%" + item.Value + "%' ";
break;
}
}
}
if (int.Parse(RequestData["Status"].ToString()) == 0)
{
sql = @"select * from (
select Id,(WorkFlowName+'--'+ApprovalNodeName) Title,WorkFlowInstanceId,WorkFlowName,ApprovalNodeName,CreatedTime as CreateTime,
'综合办公' RelateName,'' System,'' Type,'' ExecUrl,'' RelateType,'' OwnerUserId from Task where status=0 and OwnerId='{0}'
union
select Id,(FlowName+'--'+TaskName) Title,FlowId WorkFlowInstanceId,FlowName WorkFlowName,TaskName ApprovalNodeName,CreateTime,'综合办公' RelateName,System,Type,
ExecUrl,RelateType,OwnerUserId from BJKY_BeAdmin..WfWorkList where State='New'and isnull(OwnerUserId,'')<>'' and IsSign='{0}'
union
select Id,Title,'' WorkFlowInstanceId,'' WorkFlowName,'' ApprovalNodeName,CreateTime,'问卷调查' Relatename,'' System,'Questionare' Type,'' ExecUrl,
'' RelateType,'' OwnerUserId from BJKY_IntegratedManage..SurveyQuestion c
where state='1' and (select count(1) from BJKY_IntegratedManage..SurveyCommitHistory t where t.SurveyId=c.Id and t.SurveyedUserId='{0}')=0
and (isnull(StatisticsPower,'')='' or PatIndex('%{0}%',StatisticsPower)>0)
union
select Id,(FlowName+'--'+TaskName) Title,FlowId WorkFlowInstanceId,FlowName WorkFlowName,TaskName ApprovalNodeName,CreateTime,System as RelateName,System,'MiddleDB' Type,
ExecUrl,RelateType,OwnerUserId from BJKY_MiddleDB..TaskMiddle where (State='New' or State='0') and OwnerUserId='{0}'
) b where 1=1 " + where;
}
if (int.Parse(RequestData["Status"].ToString()) == 1)
{
sql = @"select * from (
select Id,(WorkFlowName+'--'+ApprovalNodeName) Title,WorkFlowInstanceId,WorkFlowName,ApprovalNodeName,CreatedTime as CreateTime,
'综合办公' RelateName,'' System,'' Type,'' ExecUrl,'' RelateType,'' OwnerUserId from Task where status<>0 and OwnerId='{0}'
union
select Id,(FlowName+'--'+TaskName) Title,FlowId WorkFlowInstanceId,FlowName WorkFlowName,TaskName ApprovalNodeName,CreateTime,'综合办公' as RelateName,System,Type,
ExecUrl,RelateType,OwnerUserId from BJKY_BeAdmin..WfWorkList where isnull(State,'')<>'New'and isnull(OwnerUserId,'')<>'' and IsSign='{0}'
union
select Id,Title,'' WorkFlowInstanceId,'' WorkFlowName,'' ApprovalNodeName,CreateTime,'问卷调查' RelateName,'' System,'Questionare' Type,'' ExecUrl,
'' RelateType,'' OwnerUserId from BJKY_IntegratedManage..SurveyQuestion c where
(select count(1) from BJKY_IntegratedManage..SurveyCommitHistory t where t.SurveyId=c.Id and t.SurveyedUserId='{0}')>0 and (isnull(StatisticsPower,'')='' or PatIndex('%{0}%',StatisticsPower)>0)
union
select Id,(FlowName+'--'+TaskName) Title,FlowId WorkFlowInstanceId,FlowName WorkFlowName,TaskName ApprovalNodeName,CreateTime,System as RelateName,System,'MiddleDB' Type,
ExecUrl,RelateType,OwnerUserId from BJKY_MiddleDB..TaskMiddle where isnull(State,'')<>'New' and isnull(State,'')<>'0'
and OwnerUserId='{0}' and System!='科研管理系统'
union
select Id,(FlowName+'--'+TaskName) Title,FlowId WorkFlowInstanceId,FlowName WorkFlowName,TaskName ApprovalNodeName,CreateTime,System as RelateName,System,'MiddleDB' Type,
ExecUrl,RelateType,OwnerUserId from BJKY_MiddleDB..TaskFinishMiddle where OwnerUserId='{0}' and System='科研管理系统'
) b where datediff(month,CreateTime,getdate())<=6 " + where;
}
sql = string.Format(sql, UserInfo.UserID);
PageState.Add("SysWorkFlowTaskList", GetPageData(sql, SearchCriterion));
break;
}
}