private void DoSelect()
{
if (op == "c")
{
sql = @"select top 1 case [Type] when 3 then ParentDeptName when 2 then ChildDeptName end as DeptName,
case [Type] when 3 then ParentId when 2 then DeptId end as DeptId
from View_SysUserGroup where UserId='{0}'";
sql = string.Format(sql, UserInfo.UserID);
IList <EasyDictionary> deptDics = DataHelper.QueryDictList(sql);
ent = new AbsenceApply();
if (deptDics.Count > 0)
{
ent.DeptId = deptDics[0].Get <string>("DeptId");
ent.DeptName = deptDics[0].Get <string>("DeptName");
}
ent.ApplyUserId = UserInfo.UserID;
ent.ApplyUserName = UserInfo.Name;
}
sql = @"select * from Task where PatIndex('%{0}%',EFormName)>0 and Status='4' order by FinishTime asc";
sql = string.Format(sql, id);
IList <EasyDictionary> taskDics = DataHelper.QueryDictList(sql);
PageState.Add("Opinion", taskDics);
string taskId = RequestData.Get <string>("TaskId");//取审批暂存时所填写的意见
if (!string.IsNullOrEmpty(taskId))
{
Task tEnt = Task.Find(taskId);
if (tEnt.Status != 4 && !string.IsNullOrEmpty(tEnt.Description))
{
PageState.Add("UnSubmitOpinion", tEnt.Description);
}
}
SetFormData(ent);
}
protected void Page_Load(object sender, EventArgs e)
{
AbsenceApply ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <AbsenceApply>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
DoBatchDelete();
}
else if (RequestActionString == "Submit")
{
ChanageState();
}
else
{
DoSelect();
}
break;
}
}
private void DoBatchDelete()
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
AbsenceApply.DoBatchDelete(idList.ToArray());
}
}
/// <summary>
/// 修改状态
/// </summary>
private void ChanageState()
{
string Id = this.RequestData.Get <string>("Id");
if (!string.IsNullOrEmpty(Id))
{
AbsenceApply ent = AbsenceApply.Find(Id);
if (ent == null)
{
return;
}
// ent.State = "1";
ent.DoUpdate();
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id");
if (!string.IsNullOrEmpty(id))
{
ent = AbsenceApply.Find(id);
}
switch (RequestActionString)
{
case "delete":
ent.DoDelete();
break;
case "submit":
StartFlow();
break;
case "AutoExecuteFlow":
AutoExecuteFlow();
break;
case "CancelFlow":
ent.WorkFlowState = "End";
ent.ApproveResult = "已撤销";
ent.DoUpdate();
IList <WorkflowInstance> wfiEnts = WorkflowInstance.FindAllByProperties("Status", "Processing", "RelateId", ent.Id);
if (wfiEnts.Count > 0)
{
wfiEnts[0].Status = "Completed";
wfiEnts[0].EndTime = System.DateTime.Now;
wfiEnts[0].DoUpdate();
sql = "update Task set Status=4 ,Result='已撤销',Description='已撤销',FinishTime='" + System.DateTime.Now + "' where WorkFlowInstanceId='" + wfiEnts[0].ID + "' and Status=0";
DataHelper.ExecSql(sql);
}
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
if (!string.IsNullOrEmpty(id))
{
ent = AbsenceApply.Find(id);
}
JsonString = RequestData.Get <string>("JsonString");
switch (RequestActionString)
{
case "update":
if (!string.IsNullOrEmpty(JsonString))
{
AbsenceApply tempEnt = JsonHelper.GetObject <AbsenceApply>(JsonString);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(JsonString);
DataHelper.MergeData <AbsenceApply>(ent, tempEnt, dic.Keys);
ent.DoUpdate();
}
else
{
ent = this.GetMergedData <AbsenceApply>();
ent.DoUpdate();
}
PageState.Add("Id", ent.Id);
break;
case "create":
ent = this.GetPostedData <AbsenceApply>();
ent.DoCreate();
PageState.Add("Id", ent.Id);
break;
case "delete":
ent = this.GetTargetData <AbsenceApply>();
ent.DoDelete();
return;
case "submit":
StartFlow();
break;
case "AutoExecuteFlow":
AutoExecuteFlow();
break;
case "GetNextUsers":
PageState.Add("NextUsers", new string[] { ent.ExamineUserId, ent.ExamineUserName });
break;
case "submitfinish":
ent.WorkFlowState = RequestData.Get <string>("state");
ent.ApproveResult = RequestData.Get <string>("ApproveResult");
ent.DoUpdate();
break;
default:
DoSelect();
break;
}
}
