public ActionResult GetMeasuresPageList(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
Operator opertator = new OperatorProvider().Current();
var queryParam = queryJson.ToJObject();
if (pagination.p_fields.IsEmpty())
{
pagination.p_fields = "worktask,dangerpoint,measures,createuserid,createuserorgcode,createuserdeptcode,isover,remark,remark1";
}
pagination.p_kid = "id";
pagination.p_tablename = @"epg_workmeetingmeasures";
pagination.conditionJson = " 1=1 ";
if (!queryParam["recid"].IsEmpty())
{
pagination.conditionJson += string.Format(@" and workmeetingid ='{0}'", queryParam["recid"].ToString());
}
var data = workMeetingbll.GetPageList(pagination, queryJson);
var jsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(ToJsonResult(jsonData));
}
public object GetList([FromBody] JObject json)
{
string res = json.Value <string>("json");
dynamic dyy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userid = dyy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userid; //设置当前用户
Operator curUser = OperatorProvider.Provider.Current();
if (null == curUser)
{
return(new { code = -1, count = 0, info = "请求失败,请登录!", data = new object() });
}
string roleNames = curUser.RoleName;
//分页获取数据
var dy = dyy.data;
Pagination pagination = new Pagination();
pagination.page = int.Parse(dy.page ?? "1");
pagination.rows = int.Parse(dy.rows ?? "1");
pagination.p_kid = "a.id";
pagination.p_fields = "a.autoid,a.createdate,a.createuserid,a.createuserdeptcode,a.createuserorgcode,a.modifydate,a.modifyuserid,a.meetingname,a.meetingtype,a.meetingdate,a.shoudpernum,a.realpernum,a.address,b.fullname outprojectname";
pagination.p_tablename = "BIS_WORKMEETING a left join ( select d.FullName,c.ID from EPG_OUTSOURINGENGINEER c, BASE_DEPARTMENT d where c.OUTPROJECTID=d.DEPARTMENTID) b on a.engineerid=b.id";
pagination.sidx = "a.meetingdate";
pagination.sord = "desc";
pagination.conditionJson = " a.iscommit='1' ";
if (curUser.IsSystem || curUser.RoleName.Contains("厂级部门用户") || curUser.RoleName.Contains("公司级用户") || curUser.RoleName.Contains("公司管理员"))
{
pagination.conditionJson += string.Format(" and createuserorgcode = '{0}' ", curUser.OrganizeCode);
}
else
{
//发包部门查看所属承包商的开收工会、承包商查看发包部门创建的开收工会。
pagination.conditionJson += string.Format(@" and (engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid in(select departmentid from base_department where senddeptid='{0}')) or engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid='{0}') )", curUser.DeptId);
}
//外包工程
string engineerid = dy.engineerid ?? "";
if (!string.IsNullOrWhiteSpace(engineerid))
{
pagination.conditionJson += string.Format(@" and engineerid = '{0}' ", engineerid);
}
//外包单位
string engineerdeptid = dy.engineerdeptid ?? "";
if (!string.IsNullOrWhiteSpace(engineerdeptid))
{
pagination.conditionJson += string.Format(@" and engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid='{0}') ", engineerdeptid);
}
//发包部门
string senddeptid = dy.senddeptid ?? "";
if (!string.IsNullOrWhiteSpace(senddeptid) && !curUser.RoleName.Contains("承包商级用户"))
{
//发包部门下属外包单位的外包工程数据
pagination.conditionJson += string.Format(@" and engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid in(select departmentid from base_department where senddeptid='{0}')) ", senddeptid);
}
//开始时间
string startTime = dy.startTime ?? "";
if (!string.IsNullOrWhiteSpace(startTime))
{
pagination.conditionJson += string.Format(" and meetingdate >= to_date('{0}','yyyy-mm-dd hh24:mi:ss')", startTime.ToString());
}
//结束时间
string endTime = dy.endTime ?? "";
if (!string.IsNullOrWhiteSpace(endTime))
{
pagination.conditionJson += string.Format(" and meetingdate < to_date('{0}','yyyy-mm-dd hh24:mi:ss')", DateTime.Parse(endTime.ToString()).AddDays(1).ToString("yyyy-MM-dd"));
}
//类型
string meetingtype = dy.meetingtype ?? "";
if (!string.IsNullOrWhiteSpace(meetingtype))
{
pagination.conditionJson += string.Format(@" and meetingtype = '{0}'", meetingtype);
}
//会议名称
string meetingname = dy.meetingname ?? "";
if (!string.IsNullOrWhiteSpace(meetingname))
{
pagination.conditionJson += string.Format(@" and meetingname like '%{0}%'", meetingname);
}
var data = workMeetingbll.GetPageList(pagination, null);
var JsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
};
JsonSerializerSettings settings = new JsonSerializerSettings
{
//ContractResolver = new LowercaseContractResolver(dict_props), //转小写，并对指定的列进行自定义名进行更换
DateFormatString = "yyyy-MM-dd HH:mm:ss", //格式化日期
//NullValueHandling = NullValueHandling.Ignore 值为空则在JSON中体现
};
//return Json(new { code = 0, info = "获取数据成功", count = pagination.records, data = JsonData }, new JsonSerializerSettings() { DateFormatString = "yyyy-MM-dd HH:mm:ss" });
return(new { code = 0, info = "获取数据成功", count = pagination.records, data = JObject.Parse(JsonConvert.SerializeObject(JsonData, Formatting.None, settings)) });
}
