/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页参数</param>
/// <param name="queryJson">查询参数</param>
/// <returns>返回分页列表Json</returns>
//[HandlerMonitor(3, "分页查询用户信息!")]
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
queryJson = queryJson ?? "";
pagination.p_kid = "ID";
pagination.p_fields = "IsSubmit,CREATEUSERID,WSSJNAME, WSSJTYPENAME,HAPPENTIME,AREANAME,WSSJBGUSERNAME,CREATEUSERDEPTCODE as departmentcode,CREATEUSERORGCODE as organizecode";
pagination.p_tablename = "V_AEM_WSSJBG_Order t";
pagination.conditionJson = "1=1";
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
if (user.IsSystem)
{
pagination.conditionJson = "1=1";
}
else
{
string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE");
if (!string.IsNullOrEmpty(where))
{
pagination.conditionJson += " and " + where;
}
}
var watch = CommonHelper.TimerStart();
var data = wssjbgbll.GetPageList(pagination, queryJson);
var JsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(Content(JsonData.ToJson()));
}
public object GetWssjBgList([FromBody] JObject json)
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userid = dy.userid;
string wssjName = dy.WssjName ?? ""; //事故名称
string wssjType = dy.WssjType ?? ""; //事故类型
string happenTimeStart = dy.HappenTimeStart ?? ""; //发生时间
string happenTimeEnd = dy.HappenTimeEnd ?? ""; //发生时间
string wssjbgUserId = dy.WssjbgUserId ?? ""; //报告人
//获取用户基本信息
OperatorProvider.AppUserId = userid; //设置当前用户
Operator curUser = OperatorProvider.Provider.Current();
if (null == curUser)
{
return(new { code = -1, count = 0, info = "请求失败,请登录!" });
}
//分页获取数据
Pagination pagination = new Pagination();
pagination.page = int.Parse(dy.page ?? "1");
pagination.rows = int.Parse(dy.rows ?? "1");
pagination.p_kid = "ID";
pagination.p_fields = "WssjName,HappenTime,AreaName,AreaId,WSSJTPSP";
pagination.p_tablename = "V_AEM_WSSJBG t";
pagination.sidx = "HappenTime";
pagination.sord = "desc";
pagination.conditionJson = "CREATEUSERORGCODE='" + curUser.OrganizeCode + "'";
//查询条件
if (happenTimeStart.Length > 0)
{
pagination.conditionJson += string.Format(" and happentime >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happenTimeStart);
}
if (happenTimeEnd.Length > 0)
{
pagination.conditionJson += string.Format(" and happentime <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happenTimeEnd);
}
if (wssjType.Length > 0)
{
pagination.conditionJson += string.Format(" and WSSJTYPE = '{0}'", wssjType);
}
if (wssjName.Length > 0)
{
pagination.conditionJson += string.Format(" and WSSJNAME like '%{0}%'", wssjName);
}
if (wssjbgUserId.Length > 0)
{
pagination.conditionJson += string.Format(" and WSSJBGUSERID = '{0}'", wssjbgUserId);
}
//获取数据
var data = wssjbgbll.GetPageList(pagination, "");
var JsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
};
return(new { code = 0, info = "获取数据成功", data = JsonData });
}
