/// <summary> /// 获取配置列表查询条件 /// </summary> /// <param name="con"></param> /// <returns></returns> private List <string> GetNotifySettingConditionList(NotifyInterfaceSettingCondition con) { List <string> list = new List <string>(); list.Add(" 1=1 "); if (con != null) { if (!Null.IsNull(con.MessageType)) { list.Add(" MessageType = @MessageType "); } if (!Null.IsNull(con.Status)) { list.Add(" Status = @Status "); } if (!Null.IsNull(con.AppId)) { list.Add(" AppId = @AppId "); } if (!Null.IsNull(con.SettingId)) { list.Add(" SettingId = @SettingId "); } } return(list); }
/// <summary> /// 获取配置信息总数 /// </summary> /// <param name="con"></param> /// <returns></returns> public int GetNotifyInterfaceSettingCount(NotifyInterfaceSettingCondition con) { const string sql = @"SELECT COUNT(0) FROM NotifyInterfaceSetting WHERE {0}"; string trueSql = string.Format(sql, string.Join(" AND ", GetNotifySettingConditionList(con).ToArray())); using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT) { return(conn.Query <int>(trueSql, con).FirstOrDefault()); } }
/// <summary> /// 获取配置信息 /// </summary> /// <param name="condition"></param> /// <returns></returns> public ActionResult List(NotifyInterfaceSettingCondition condition) { NotifyInterfaceSettingBusiness business = new NotifyInterfaceSettingBusiness(); var rows = business.GetList(condition); var json = JsonConvert.SerializeObject(new { rows = rows, total = condition.RecordCount }, JsonConvertHelper.IsoDateTimeConverter); return(Content(json)); }
/// <summary> /// 获取配置信息(分页) /// </summary> /// <param name="con"></param> /// <returns></returns> public List <NotifyInterfaceSettingEntity> GetNotifyInterfaceSettingList(NotifyInterfaceSettingCondition con) { using (IDbConnection conn = ConnectionFactory.JinRiNotify_SELECT) { const string sql = @"SELECT * FROM (SELECT SettingId, AppId, MessageType, Address, Method, PushLimitCount, PushInternalRule, Encoding, CreateTime, LastModifyTime, Status FROM NotifyInterfaceSetting WHERE {2} ORDER BY {0} {1} LIMIT @Offset, @PageSize) AS TMP "; string condition = string.Join(" AND ", GetNotifySettingConditionList(con).ToArray()); string _sql = string.Format("SELECT COUNT(0) FROM NotifyInterfaceSetting WHERE {0}", condition); con.RecordCount = conn.Query <int>(_sql, con).FirstOrDefault(); //总记录数 string trueSql = string.Format(sql, con.OrderBy, con.OrderDirection, condition); return(conn.Query <NotifyInterfaceSettingEntity>(trueSql, con).ToList()); } }
/// <summary> /// 获取配置信息 /// </summary> /// <param name="con">查询条件</param> /// <returns></returns> public List <NotifyInterfaceSettingModel> GetList(NotifyInterfaceSettingCondition condition) { NotifyMessageBusiness business = new NotifyMessageBusiness(); var messageTypeList = business.GetNotifyMessageTypeListFromCache(new NotifyMessageTypeCondition()); List <NotifyInterfaceSettingEntity> entityList = JinRiNotifyFacade.Instance.GetNotifyInterfaceSettingList(condition); List <NotifyInterfaceSettingModel> messageList = new List <NotifyInterfaceSettingModel>(); entityList.ForEach((x) => { var model = MappingHelper.From <NotifyInterfaceSettingModel, NotifyInterfaceSettingEntity>(x); var messageType = messageTypeList.Where(t => t.MessageType == model.MessageType).FirstOrDefault(); if (messageType != null) { model.MessageTypeName = messageType.Remark; } model.MessageTypeEName = x.MessageType.ToString(); messageList.Add(model); }); return(messageList); }
/// <summary> /// 获取配置信息总数 /// </summary> /// <param name="con"></param> /// <returns></returns> public int GetNotifyInterfaceSettingCount(NotifyInterfaceSettingCondition con) { return(JinRiNotifyFacade.Instance.GetNotifyInterfaceSettingCount(con)); }
/// <summary> /// 获取配置信息(分页) /// </summary> /// <returns></returns> public List <NotifyInterfaceSettingEntity> GetNotifyInterfaceSettingList(NotifyInterfaceSettingCondition con) { return(JinRiNotifyQuery.Instance.GetNotifyInterfaceSettingList(con)); }