/// <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));
}
