public ActionResult GetListJson(Pagination pagination, string queryJson)
{
pagination.p_kid = "t.ID";
pagination.p_fields = @"e.departmentid,t.engineername,e.fullname,t.planenddate,t.actualenddate,t.createuserorgcode";
pagination.p_tablename = @" epg_outsouringengineer t left join base_department e on t.outprojectid=e.departmentid";
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
string role = user.RoleName;
if (role.Contains("省级"))
{
pagination.conditionJson = string.Format(@" t.createuserorgcode in (select encode
from BASE_DEPARTMENT d
where d.deptcode like '{0}%' and d.nature = '厂级' and d.description is null)", user.NewDeptCode);
}
else if (role.Contains("公司级用户") || role.Contains("厂级部门用户"))
{
pagination.conditionJson = string.Format(" t.createuserorgcode = '{0}'", user.OrganizeCode);
}
else
{
pagination.conditionJson = string.Format(" t.engineerletdeptid = '{0}'", user.DeptId);
}
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["txtSearch"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.engineername like '%{0}%'", queryParam["txtSearch"].ToString());
}
var watch = CommonHelper.TimerStart();
var data = protocolbll.GetList(pagination, queryJson);
var jsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(ToJsonResult(jsonData));
}
public ActionResult GetListJson(Pagination pagination, string queryJson)
{
pagination.p_kid = "t.ID";
pagination.p_fields = @" e.fullname,r.ENGINEERNAME,t.FirstParty,t.SecondParty,t.SignPlace,to_char(SignDate,'yyyy-MM-dd') as SignDate,r.outprojectid,e.senddeptid,t.MODIFYUSERID,t.createuserid,t.createuserorgcode ";
pagination.p_tablename = @"epg_protocol t left join EPG_OutSouringEngineer r
on t.projectid=r.id left join base_department e on r.outprojectid=e.departmentid ";
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
string role = user.RoleName;
if (role.Contains("省级"))
{
pagination.conditionJson = string.Format(@" t.createuserorgcode in (select encode
from BASE_DEPARTMENT d
where d.deptcode like '{0}%' and d.nature = '厂级' and d.description is null)", user.NewDeptCode);
}
else if (role.Contains("公司级用户") || role.Contains("厂级部门用户"))
{
pagination.conditionJson = string.Format(" t.CREATEUSERORGCODE = '{0}'", user.OrganizeCode);
}
else if (role.Contains("承包商级用户"))
{
pagination.conditionJson = string.Format(" (e.departmentid = '{0}' or r.SUPERVISORID='{0}')", user.DeptId);
}
else
{
var deptentity = departmentbll.GetEntity(user.DeptId);
while (deptentity.Nature == "班组" || deptentity.Nature == "专业")
{
deptentity = departmentbll.GetEntity(deptentity.ParentId);
}
pagination.conditionJson = string.Format(" r.engineerletdeptid in (select departmentid from base_department where encode like '{0}%') ", deptentity.EnCode);
//pagination.conditionJson = string.Format(" r.engineerletdeptid = '{0}'", user.DeptId);
}
var queryParam = queryJson.ToJObject();
//时间范围
if (!queryParam["sTime"].IsEmpty() || !queryParam["eTime"].IsEmpty())
{
string startTime = queryParam["sTime"].ToString();
string endTime = queryParam["eTime"].ToString();
if (queryParam["sTime"].IsEmpty())
{
startTime = "1899-01-01";
}
if (queryParam["eTime"].IsEmpty())
{
endTime = DateTime.Now.ToString("yyyy-MM-dd");
}
pagination.conditionJson += string.Format(" and to_date(to_char(SignDate,'yyyy-MM-dd'),'yyyy-MM-dd') between to_date('{0}','yyyy-MM-dd') and to_date('{1}','yyyy-MM-dd')", startTime, endTime);
}
////查询条件
//if (!queryParam["txtSearch"].IsEmpty())
//{
// pagination.conditionJson += string.Format(" and r.ENGINEERNAME like '%{0}%'", queryParam["txtSearch"].ToString());
//}
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["txtSearch"].IsEmpty())
{
pagination.conditionJson += string.Format(" and {0} like '%{1}%'", queryParam["condition"].ToString(), queryParam["txtSearch"].ToString());
}
if (!queryParam["outengineerid"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.projectid ='{0}' ", queryParam["outengineerid"].ToString());
}
if (!queryParam["orgCode"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.createuserorgcode ='{0}' ", queryParam["orgCode"].ToString());
}
if (!queryParam["projectid"].IsEmpty())
{
pagination.conditionJson += string.Format(" and r.id ='{0}' ", queryParam["projectid"].ToString());
}
var watch = CommonHelper.TimerStart();
var data = protocolbll.GetList(pagination, queryJson);
var jsonData = new
{
rows = data,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(ToJsonResult(jsonData));
}
