public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
pagination.p_kid = "ID";
pagination.p_fields = @"EquipmentName,EquipmentNo,Specifications,district,districtid,districtcode,case when t.state=1 then '未启用'
when t.state=2 then '在用' when t.state=3 then '停用' when t.state=4 then '报废' when t.state=5 then '离厂' end as state,ControlDeptCode,CreateUserId,affiliation,(select count(1) from v_basehiddeninfo where workstream != '整改结束' and deviceid=t.ID) hidnum,remark";
pagination.p_tablename = "BIS_EQUIPMENT t";
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
if (user.IsSystem)
{
pagination.conditionJson = " 1=1";
}
else
{
//pagination.conditionJson = string.Format(" CREATEUSERORGCODE ='{0}'", user.OrganizeCode);
pagination.conditionJson = string.Format(" CREATEUSERORGCODE in(select encode from BASE_DEPARTMENT start with encode='{0}' connect by prior departmentid = parentid)", user.OrganizeCode);
}
//if (user.IsSystem)
//{
// pagination.conditionJson = "1=1";
//}
//else
//{
// string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value);
// pagination.conditionJson = where;
//}
var watch = CommonHelper.TimerStart();
var data = equipmentbll.GetPageList(pagination, queryJson);
var jsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(ToJsonResult(jsonData));
}
