public ActionResult ExportCrmEvaData(CrmEvaMstrQuery query)
{
try
{
_crmEvaMstrService.ExportCrmEvaData(query);
return(Success());
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
public ActionResult GetCrmEvaPageList(CrmEvaMstrQuery query)
{
try
{
var result = _crmEvaMstrRepository.GetCrmEvaPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
public ActionResult GetMessageCenterPageList(CrmEvaMstrQuery query)
{
try
{
query.CREATE_ORG_NO = AbpSession.ORG_NO;
var result = _crmEvaMstrRepository.GetMessageCenterPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail(ex.Message));
}
}
public PagerList <dynamic> GetCrmEvaPageList(CrmEvaMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "mstr.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
if (!string.IsNullOrEmpty(query.START_DATE))
{
if (!string.IsNullOrEmpty(where))
{
where += " and to_char(mstr.EVA_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'";
}
else
{
where += " to_char(mstr.EVA_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'";
}
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += " and to_char(mstr.EVA_DATE,'yyyy-MM-dd')<='" + query.END_DATE + "'";
}
return(_sqlQuery.Select(@"mstr.EVA_ID,
mstr.EVA_TYPE,
mstr.EVA_DATE,
mstr.EVA_OBJ_TYPE,
mstr.EVA_CONTENT,
mstr.EVA_OBJ_NAME,
mstr.EVA_TOTAL_VALUE,
mstr.CREATE_ORG_NO,
mstr.EVA_REF_NO1,
mstr.EVA_REF_NO,
mstr.UDF4,
bu.bu_name,
bu.parent_bu_name,
(SELECT USR_JOB FROM SYS_USR_MSTR WHERE USR_ID = TO_NUMBER(REGEXP_REPLACE(mstr.EVA_OBJ_NO, '[^0-9]', '')))UsrJob")
.Filter("mstr.DEL_FLAG", 1)
.NotEqual("mstr.EVA_TYPE", "聊天信息")
.And(where)
.Contains("mstr.EVA_OBJ_TYPE", query.EVA_OBJ_TYPE)
.Contains("mstr.EVA_OBJ_NAME", query.EVA_OBJ_NAME)
.Filter("bu.PARENT_BU_NO", query.AREA_NO)
.Filter("bu.BU_NO", query.BU_NO)
.In("EVA_TYPE", query.EVA_TYPES)
.OrderBy("mstr.EVA_DATE desc")
.GetPageList <dynamic>(@" CRM_EVA_MSTR mstr
LEFT JOIN mdm_bu_mstr bu ON mstr.CREATE_ORG_NO = bu.bu_no", Context.Database.GetDbConnection(), query));
}
public PagerList <dynamic> GetMessageCenterPageList(CrmEvaMstrQuery query)
{
string where = "";
if (!string.IsNullOrEmpty(query.START_DATE))
{
where += "to_char(a.create_date,'yyyy-MM-dd')>=" + query.START_DATE;
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += string.IsNullOrEmpty(where) ? "to_char(a.create_date,'yyyy-MM-dd')<=" + query.END_DATE + "" : " and to_char(a.create_date,'yyyy-MM-dd')<=" + query.END_DATE + "";
}
return(_sqlQuery.Select(@"SELECT a.EVA_ID,a.EVA_CONTENT,a.eva_ref_no2 as OpenId,a.CREATE_DATE,(CASE WHEN a.EVA_REF_NO3 = '1' THEN '是' ELSE '否' end) as MessageStatus,(SELECT b.UDF3 FROM sys_usr_wct b where b.open_id=a.eva_ref_no2 and b.bu_no='" + AbpSession.ORG_NO + @"' and b.del_flag!=0 and rownum=1)NICKNAME")
.Filter("DEL_FLAG", 1)
.Filter("a.EVA_TYPE", "聊天信息")
.Filter("a.create_org_no", AbpSession.ORG_NO)
//.And("to_char(a.create_date,'yyyy-MM-dd')>=" + query.START_DATE)
//.And("to_char(a.create_date,'yyyy-MM-dd')<=" + query.END_DATE)
.And(where)
.Filter("a.EVA_REF_NO3", query.REPLY_STATUS)
.Contains("a.UDF3", query.UDF3)
.GetPageList <dynamic>("CRM_EVA_MSTR a", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 导出评价数据
/// </summary>
/// <param name="query"></param>
public void ExportCrmEvaData(CrmEvaMstrQuery query)
{
}
