public ActionResult GetCrmCasePageList(CrmCaseMstrQuery query)
{
try
{
var result = _crmCaseMstrRepository.GetCrmCasePageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail("获取失败：" + ex.Message));
}
}
/// <summary>
/// 获取客户反馈分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetCrmCasePageList(CrmCaseMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "cm.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
if (!string.IsNullOrEmpty(query.START_DATE))
{
where += string.IsNullOrEmpty(where) ? "to_char(apt.APT_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'" : "and to_char(apt.APT_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'";
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += string.IsNullOrEmpty(where) ? "to_char(apt.APT_DATE,'yyyy-MM-dd')<='" + query.END_DATE + "'" : "and to_char(apt.APT_DATE,'yyyy-MM-dd')<='" + query.END_DATE + "'";
}
if (query.CASE_TYPE > 0)
{
where += string.IsNullOrEmpty(where) ? "cm.CASE_TYPE='" + query.CASE_TYPE + "'" : " and cm.CASE_TYPE='" + query.CASE_TYPE + "'";
}
return(_sqlQuery.Select(@"cm.CASE_NO,
cm.UDF1,
cm.CASE_DATE,
cm.CASE_CLASS,
cm.CASE_TYPE,
CASE
WHEN cm.CASE_TYPE = 10 THEN '表扬员工'
WHEN cm.CASE_TYPE = 11 THEN '表扬店铺'
WHEN cm.CASE_TYPE = 20 THEN '投诉员工'
WHEN cm.CASE_TYPE = 21 THEN '投诉店铺'
END CASE_TYPE_TEXT,
cm.CASE_CONTENT,
bu.bu_name,
bu.parent_bu_name,
(
SELECT wct.udf3 FROM sys_usr_wct wct WHERE wct.bu_no = cm.CREATE_ORG_NO AND wct.open_id = cm.REF_CASE_NO AND rownum = 1
) WXName,
(SELECT USR_JOB FROM SYS_USR_MSTR WHERE USR_ID=TO_NUMBER(REGEXP_REPLACE(cm.RESPONSIBLE_PSN,'[^0-9]','')))UsrJob")
.Filter("cm.DEL_FLAG", 1)
.And("cm.CASE_TYPE>0")
//.Filter("cm.CASE_TYPE", query.CASE_TYPE)
.Contains("cm.UDF1", query.UDF1)
.And(where)
//.Filter("to_char(cm.CASE_DATE,'yyyy-MM-dd')>=", query.START_DATE)
//.Filter("to_char(cm.CASE_DATE,'yyyy-MM-dd')<=", query.END_DATE)
.Filter("bu.PARENT_BU_NO", query.AREA_NO)
.Filter("bu.BU_NO", query.BU_NO)
.OrderBy("cm.CASE_DATE desc")
.GetPageList <dynamic>(@"CRM_CASE_MSTR cm
LEFT JOIN mdm_bu_mstr bu ON cm.CREATE_ORG_NO = bu.bu_no", Context.Database.GetDbConnection(), query));
}
