/// <summary>
/// 获取机构列表
/// </summary>
/// <returns></returns>
public List <dynamic> GetMdmBuMstrList(MdmBuMstrQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "BU_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
perssion = query.BU_TYPE != 0 ? string.IsNullOrEmpty(perssion) ? "BU_TYPE=" + query.BU_TYPE + "" : perssion + " and BU_TYPE=" + query.BU_TYPE + "" : perssion;
return(_sqlQuery.Select(@"BU_NO,BU_NAME")
.Filter("PARENT_BU_NO", query.PARENT_BU_NO)
.Filter("BU_STATUS", "1")
.Filter("DEL_FLAG", "1")
.And(perssion)
.OrderBy("BU_TYPE")
.GetList <dynamic>("MDM_BU_MSTR", Context.Database.GetDbConnection()));
}
/// <summary>
/// 获取公众号分页列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetWctPaMstrPageList(WctPaMstrQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "WCT_PA_MSTR.PA_ID_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"
WCT_PA_MSTR.PA_ID,
WCT_PA_MSTR.PA_NAME,
WCT_PA_MSTR.PA_ORIGINAL_ID,
WCT_PA_MSTR.CREATE_DATE,
SYS_USR_MSTR.USR_NAME,
BU.BU_NAME,
PABU.BU_NAME BG_NAME,
PA_APPID,
CASE PA_TYPE_ID
WHEN 1 THEN
'服务号'
WHEN 2 THEN
'订阅号'
WHEN 3 THEN
'企业号'
WHEN 4 THEN
'小程序'
END PA_TYPE_ID")
.Filter("WCT_PA_MSTR.PA_TYPE_ID", query.PA_TYPE_ID)
.Filter("WCT_PA_MSTR.PA_NAME", query.PA_NAME, Operator.Contains)
.Filter("WCT_PA_MSTR.PA_ORIGINAL_ID", query.PA_ORIGINAL_ID)
.Filter("WCT_PA_MSTR.DEL_FLAG", "1")
.And(perssion)
.OrderBy("WCT_PA_MSTR.UPDATE_DATE desc")
.GetPageList <dynamic>(@"WCT_PA_MSTR
LEFT JOIN SYS_USR_MSTR ON WCT_PA_MSTR.CREATE_PSN = SYS_USR_MSTR.USR_ID
LEFT JOIN MDM_BU_MSTR BU ON WCT_PA_MSTR.PA_ID_NO=BU.BU_NO
LEFT JOIN MDM_BU_MSTR PABU ON PABU.BU_NO=BU.PARENT_BU_NO", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 获取素材分页列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetMaterialMstrPageList(CmsMaterialMstrQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "a.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"
a.MATERIAL_ID,
a.MATERIAL_COVER_URL,
a.MATERIAL_TITLE,
a.CREATE_DATE,
a.UPDATE_DATE,
a.MATERIAL_STATUS,
a.MATERIAL_AUTHOR,
b.MATERIAL_TYPE_NAME,
c.BU_NAME")
.Filter("b.MATERIAL_ATTR", query.MATERIAL_ATTR)
.Filter("a.MATERIAL_TYPE_ID", query.MATERIAL_TYPE_ID)
.Filter("a.MATERIAL_TITLE", query.MATERIAL_TITLE, Operator.Contains)
.Filter("a.UDF2", query.UDF2)
.Filter("a.DEL_FLAG", 1)
.In("a.MATERIAL_ID", query.MATERIAL_IDS)
//.Filter("b.DEL_FLAG", 1)
.Filter("c.DEL_FLAG", 1)
.And(perssion)
.OrderBy("a.UPDATE_DATE desc")
.GetPageList <dynamic>(@"CMS_MATERIAL_MSTR a
LEFT JOIN CMS_MATERIAL_TYPE b ON a.MATERIAL_TYPE_ID = b.MATERIAL_TYPE_ID
LEFT JOIN MDM_BU_MSTR c ON a.CREATE_ORG_NO=c.BU_NO", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 分页获取粉丝信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetWctInfoPageList(SysUsrWctQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "wct.bu_no", AbpSession.ORG_NO, AbpSession.BG_NO);
var joinSql = query.FOLLOW_STATUS == null ? "" : "wct.follow_status=" + query.FOLLOW_STATUS + "";
return(_sqlQuery.Select(@"
wct.Wct_Id,
wct.bu_no,
wct.usr_id,
wct.open_id,
wct.cus_svc_code,
wct.usr_source,
wct.reg_date,
wct.referee_usr_id,
wct.create_date,
wct.update_date,
usr.usr_name,
usr.usr_real_name,
usr.usr_mobile,
wct.UDF1 unfollow_date,
wct.UDF2 sex,
wct.UDF3 nickname,
(
CASE wct.follow_status
WHEN 1 THEN
'已关注'
ELSE
'取消关注'
END
) AS follow_status,
(
CASE wct.UDF4
WHEN '1' THEN
'是'
ELSE
'否'
END
) AS IsBlack,
wct.WX_AVATAR_URL,
wct.tag_name,
bu.BU_NAME,
bu.PARENT_BU_NAME" )
.Filter("wct.UDF3", query.nickName, Operator.Contains)
.Filter("usr.usr_real_name", query.realName, Operator.Contains)
.Filter("bu.PARENT_BU_NO", query.parentorgNo)
.Filter("bu.BU_NO", query.orgNo)
.Filter("wct.TAG_NAME", query.TAG_NAME)
.Filter("usr.usr_mobile", query.mobile)
.Filter("wct.reg_date", query.BEGIN_REG_DATE, Operator.GreaterEqual)
.Filter("wct.reg_date", query.END_REG_DATE, Operator.LessEqual)
.Filter("wct.del_flag", "1")
.And(perssion)
.And(joinSql)
.OrderBy("wct.create_date,wct.wct_id desc")
.GetPageList <dynamic>(@"sys_usr_wct wct
left join sys_usr_mstr usr on wct.usr_id=usr.usr_id
left join mdm_bu_mstr bu on wct.bu_no=bu.bu_no", Context.Database.GetDbConnection(), query));
}
public PagerList <dynamic> GetCrmQpaperMstrPageList(CrmQpaperMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"PAPER_ID, PAPER_NAME, PAPER_TYPE, INCLUDE_QUESTION_IDS, PAPER_SDATE, PAPER_EDATE, PAPER_DESC, PAPER_STATUS")
.Filter("DEL_FLAG", 1)
.Contains("PAPER_NAME", query.PAPER_NAME)
.Filter("PAPER_TYPE", query.PAPER_TYPE)
.Filter("PAPER_STATUS", query.PAPER_STATUS)
.And(where)
.OrderBy("CREATE_DATE desc")
.GetPageList <dynamic>(" CRM_QPAPER_MSTR", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 获取秒杀商品分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic GetMsGoodsPageList(MdmGoodsMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "good.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"good.goods_id,good.GOODS_RMK ,good.goods_name,gl.UDF2 Pic,gl.GL_STATUS,good.sp_sdate,good.sp_edate,good.sp_qty,good.SP_PRICE,gs.PL_SELL_PRICE,gs.PL_PROMO_PRICE")
.Filter("good.sp_flag", 1)
.Filter("gl.GL_STATUS", 1)
.Contains("good.GOODS_RMK", query.GOODS_RMK)
.And(where)
.OrderBy("good.CREATE_DATE DESC")
.GetPageList <dynamic>(@"mdm_goods_mstr good
left join mdm_goods_list gl on good.gl_id = gl.gl_id
left join MDM_GOODS_SPL gs on gs.pl_goods_no = good.goods_no", Context.Database.GetDbConnection(), query));
}
public PagerList <dynamic> GetCrmQpaperQuPageList(CrmQpaperQuQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"QU_ID, QU_SN, QU_TYPE, QU_NAME, QU_ENABLED, QU_ANSWER, PAPER_TYPE")
.Filter("DEL_FLAG", 1)
.Filter("QU_SN", query.QU_SN)
.Contains("QU_NAME", query.QU_NAME)
.Filter("PAPER_TYPE", query.PAPER_TYPE)
.Filter("QU_TYPE", query.QU_TYPE)
.Filter("QU_ENABLED", query.QU_ENABLED)
.OrderBy("CREATE_DATE desc")
.GetPageList <dynamic>(" CRM_QPAPER_QU", Context.Database.GetDbConnection(), query));
}
public PagerList <dynamic> GetHelpInfoPageList(WctHelpTelMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
var list = _sqlQuery.Select(@"TEL_ID, TEL_NAME, TEL_NO,TEL_ID_NO, CREATE_ORG_NO, CREATE_PSN, CREATE_DATE, UPDATE_PSN, UPDATE_DATE, BG_NO,
case TEL_TYPE when 'insurance' then '保险' when 'help' then '救援' else '' end as TEL_TYPE")
.Filter("DEL_FLAG", 1)
.Filter("CREATE_ORG_NO", query.CREATE_ORG_NO)
.Contains("TEL_NO", query.TEL_NO)
.And(where)
.OrderBy("CREATE_DATE DESC")
.GetPageList <dynamic>(" WCT_HELP_TEL_MSTR", Context.Database.GetDbConnection(), query);
return(list);
}
/// <summary>
/// 获取金融政策分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic GetFinancePolicyList(CarFinancePolicyQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select("*")
.Filter("DEL_FLAG", 1)
.Filter("BIZ_TYPE", query.BIZ_TYPE)
.Filter("BRAND_CODE", query.BRAND_CODE)
.Filter("CLASS_CODE", query.CLASS_CODE)
.Filter("TYPE_CODE", query.TYPE_CODE)
.Filter("SUBTYPE_CODE", query.SUBTYPE_CODE)
.Contains("TAG_IDS", query.TAG_IDS)
.And(where)
.OrderBy("CREATE_DATE desc")
.GetPageList <dynamic>("CAR_FINANCE_POLICY", Context.Database.GetDbConnection(), query));
}
/// <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));
}
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> GetStoreAdvertisePageList(StoreAdvertiseMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "BU_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"ADVERTISE_ID,
ADVERTISE_THEME,
ADVERTISE_TYPE,
ADVERTISE_CONTENT,
ADVERTISE_POSTER_URL,
STORE_CONTRACT,
ADVERTISE_STATUS,
ADVERTISE_CATEGORY，
UPDATE_DATE")
.Filter("DEL_FLAG", 1)
.Contains("ADVERTISE_THEME", query.ADVERTISE_THEME)
.Filter("ADVERTISE_TYPE", query.ADVERTISE_TYPE)
.Filter("ADVERTISE_STATUS", query.ADVERTISE_STATUS)
.Filter("ADVERTISE_CATEGORY", query.ADVERTISE_CATEGORY)
.And(where)
.And("ADVERTISE_TYPE!='0'")
.OrderBy("UPDATE_DATE DESC")
.GetPageList <dynamic>(" store_advertise_mstr", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 获取用户分页列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public PagerList <dynamic> GetSysUsrPageList(SysUsrMstrQuery query)
{
var perssion = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "usr.ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"
usr.USR_ID,
usr.USR_AVATAR_PATH,
usr.USR_NAME,
usr.USR_REAL_NAME,
usr.USR_EMAIL,
usr.UDF1 WeiXin,
(
CASE usr.USR_STATUS
WHEN 1 THEN
'启用'
ELSE
'禁用'
END
) AS USR_STATUS,
usr.USR_DESC,
dept.DEPT_NAME,
duty.DUTY_NAME,
bu.BU_SHORT_NAME,
usr.CREATE_DATE")
.Filter("usr.USR_NAME", query.USR_NAME, Operator.Contains)
.Filter("usr.USR_REAL_NAME", query.USR_REAL_NAME, Operator.Contains)
.Filter("usr.USR_TYPE", query.USR_TYPE)
.Filter("duty.DUTY_NAME", query.DUTY_NAME, Operator.Contains)
.Filter("usr.DEL_FLAG", "1")
.And("USR_TYPE!='0'")
.And(perssion)
.OrderBy("usr.CREATE_DATE desc")
.GetPageList <dynamic>(@"SYS_USR_MSTR usr
LEFT JOIN MDM_BU_MSTR bu ON usr.ORG_NO=bu.BU_NO
LEFT JOIN MDM_DEPT_MSTR dept ON usr.DEPT_ID=dept.DEPT_ID
LEFT JOIN MDM_DUTY_MSTR duty ON usr.DUTY_ID=duty.DUTY_ID", Context.Database.GetDbConnection(), query));
}
public PagerList <dynamic> GetSurveyRsltPageList(CrmSurveyRsltMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "sur.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
if (!string.IsNullOrEmpty(query.START_DATE))
{
where += string.IsNullOrEmpty(where) ? "to_char(sur.CREATE_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'" : "and to_char(sur.CREATE_DATE,'yyyy-MM-dd')>='" + query.START_DATE + "'";
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += string.IsNullOrEmpty(where) ? "to_char(sur.CREATE_DATE,'yyyy-MM-dd')<='" + query.END_DATE + "'" : "and to_char(sur.CREATE_DATE,'yyyy-MM-dd')<='" + query.END_DATE + "'";
}
return(_sqlQuery.Select(@" sur.RSLT_ID,sur.SURVEY_TITLE,sur.ANSWER_SCORE,sur.REPORT_NAME,sur.REPORT_DATE,sur.CREATE_DATE,sur.ANSWER_JSON,bu.BU_NAME,BU.PARENT_BU_NAME")
.Filter("sur.DEL_FLAG", 1)
.Filter("bu.PARENT_BU_NO", query.AREA_NO)
.Filter("bu.BU_NO", query.BU_NO)
//.Filter("to_char(sur.CREATE_DATE,'yyyy-MM-dd')>=", query.START_DATE)
//.Filter("to_char(sur.CREATE_DATE,'yyyy-MM-dd')<=", query.END_DATE)
.And(where)
.Contains("sur.REPORT_NAME", query.REPORT_NAME)
.OrderBy("CREATE_DATE desc")
.GetPageList <dynamic>(@"CRM_SURVEY_RSLT_MSTR sur left join mdm_bu_mstr bu on sur.CREATE_ORG_NO=bu.bu_no", Context.Database.GetDbConnection(), query));
}
/// <summary>
/// 获取订单分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic GetOrderPageList(TxnSoMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "so.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
if (!string.IsNullOrEmpty(query.START_DATE))
{
where += string.IsNullOrEmpty(where) ? " and TO_char(so.CREATE_DATE,'yyyy-mm-dd') >= '" + query.START_DATE + "'" : "TO_char(so.CREATE_DATE, 'yyyy-mm-dd') >= '" + query.START_DATE + "'";
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += string.IsNullOrEmpty(where) ? " and TO_char(so.CREATE_DATE,'yyyy-mm-dd') <= '" + query.END_DATE + "'" : "TO_char(so.CREATE_DATE,'yyyy-mm-dd') <= '" + query.END_DATE + "'";
}
return(_sqlQuery.Select(@"so.*,cus.ERP_MEMBER_NO,bu.bu_name,mbm.bu_name as BG_NAME")
.Filter("so.DEL_FLAG", 1)
.Filter("so.STATUS", query.STATUS)
.Filter("so.SO_NO", query.SO_NO)
.Filter("cus.ERP_MEMBER_NO", query.ERP_MEMBER_NO)
.Filter("so.QUEUE_NO", query.QUEUE_NO)
.Filter("so.CUS_NAME", query.CUS_NAME)
.Filter("so.EXPRESS_NO", query.EXPRESS_NO)
.In("so.biz_type", new string[] { "DS", "MS" })
.And(where)
.OrderBy("so.CREATE_DATE desc")
.GetPageList <dynamic>(@"TXN_SO_MSTR so left join sys_usr_mstr cus on so.CREATE_PSN = cus.usr_id left join MDM_BU_MSTR bu on bu.bu_no = so.ORG_NO left join MDM_BU_MSTR mbm on mbm.bu_no = bu.parent_bu_no", Context.Database.GetDbConnection(), query));
}
