/// <summary>
/// 获取案件详情
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IActionResult GetInstanceById(int id)
{
GetBusinesses();
GetInstanceState();
InstanceDataModel instance = _approve.GetInstanceById(id);
return(View(instance));
}
/// <summary>
/// 审批页面显示
/// </summary>
/// <returns></returns>
//PageList<ApproveDataModel> GetApproveList(PageParams pageParams)
//{
// var db = SugerBase.GetInstance();
// List<ApproveDataModel> list = db.SqlQueryable<ApproveDataModel>(
// "select Approve.ID,Instance.ID as InstanceID,Instance.RegisterPeopleID,Business.ID as BusinessID,Business.Name as BusinessName,Users.realName as UsersName,Role.Name as RoleName,Instance.InstanceTypes,Instance.InstanceTime,Instance.ApproveState " +
// "from Approve,Users,Instance,Business,Role " +
// "where Approve.ORIGINALID=Instance.ID and Approve.BUSINESSTYPEID=Business.ID and Approve.APPROVEPEOPLEID=USERS.ID and Approve.ROLEID=Role.ID and Approve.State=1 "+pageParams.Filter).Skip(pageParams.CurPage).Take(pageParams.PageSize).ToList();
// int count = db.SqlQueryable<ApproveDataModel>(
// "select Approve.ID,Instance.ID as InstanceID,Instance.RegisterPeopleID,Business.ID as BusinessID,Business.Name as BusinessName,Users.realName as UsersName,Role.Name as RoleName,Instance.InstanceTypes,Instance.InstanceTime,Instance.ApproveState " +
// "from Approve,Users,Instance,Business,Role " +
// "where Approve.ORIGINALID=Instance.ID and Approve.BUSINESSTYPEID=Business.ID and Approve.APPROVEPEOPLEID=USERS.ID and Approve.ROLEID=Role.ID and Approve.State=1 " + pageParams.Filter).Count();
// PageList<ApproveDataModel> pagelist = new PageList<ApproveDataModel>() { ListData = list, TotalCount = count };
// return pagelist;
//}
/// <summary>
/// 审批页面点击查看案件详情页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public InstanceDataModel GetInstanceById(int id)
{
var db = SugerBase.GetInstance();
List <InstanceDataModel> inStanceList = db.SqlQueryable <InstanceDataModel>(
"select Instance.ID,Alarm.AlarmReason,Alarm.DetailSplace,Users.RealName,Instance.InstanceTypes,Instance.ApproveState,Instance.InstanceState,Instance.Time as InstanceTime,Instance.Space " +
"from Instance,Alarm,Users" +
" where Instance.AlterID=Alarm.ID and Instance.RegisterPeopleID=Users.ID and Instance.ID=" + id
).ToList();
InstanceDataModel inStance = inStanceList[0];
return(inStance);
}
