/// <summary>
/// 根据历史明细ID获取历史明细
/// </summary>
/// <param name="managerDetailId"></param>
/// <returns></returns>
public ManagerDetailInfo GetManagerDetailById(int managerDetailId)
{
if (ManagerDetailIdExists(managerDetailId))
{
var entity = ManagerDetailRepository.GetManagerDetailById(managerDetailId);
var model = new ManagerDetailInfo
{
ManagerDetailId = entity.ManagerDetailId,
ManagerId = entity.ManagerId,
ManagerName = entity.Manager.ManagerName,
CurrentChannelId = entity.CurrentChannelId,
CurrentChannel = ChannelManageBll.GetChannelById(entity.CurrentChannelId).ChannelName,
OldChannelId = entity.OldChannelId,
OldChannel = ChannelManageBll.GetChannelById(entity.OldChannelId).ChannelName,
CurrentRank = entity.CurrentRank,
OldRank = entity.OldRank,
RankStatus = entity.RankStatus,
CreatedTime = entity.CreatedTime,
ModifiedTime = entity.ModifiedTime
};
return(model);
}
return(new ManagerDetailInfo());
}
/// <summary>
/// 删除历史明细
/// </summary>
/// <param name="managerDetailId"></param>
/// <returns></returns>
public bool DeleteManagerDetail(int managerDetailId)
{
try
{
var entity = ManagerDetailRepository.GetManagerDetailById(managerDetailId);
if (ManagerDetailRepository.DeleteManagerDetail(entity) == 1)
{
return(true);
}
return(false);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 获取历史明细列表
/// </summary>
/// <param name="pager"></param>
/// <returns></returns>
public List <ManagerDetailInfo> GetManagerDetailList(ref GridPager pager)
{
var queryData = ManagerDetailRepository.GetManagerDetailList();
// 排序
//if (pager.Order == "desc")
//{
// switch (pager.Order)
// {
// case "ModifiedTime":
// queryData = queryData.OrderByDescending(c => c.ModifiedTime);
// break;
// case "ManagerId":
// queryData = queryData.OrderByDescending(c => c.ManagerId);
// break;
// default:
// queryData = queryData.OrderByDescending(c => c.ManagerDetailId);
// break;
// }
//}
//else
//{
// switch (pager.Order)
// {
// case "ModifiedTime":
// queryData = queryData.OrderBy(c => c.ModifiedTime);
// break;
// case "ManagerId":
// queryData = queryData.OrderBy(c => c.ManagerId);
// break;
// default:
// queryData = queryData.OrderBy(c => c.ManagerDetailId);
// break;
// }
//}
queryData = LinqHelper.DataSorting(queryData, pager.Sort, pager.Order);
return(CreateModelList(ref pager, ref queryData));
}
/// <summary>
/// 判断历史明细ID是否存在
/// </summary>
/// <param name="managerDetailId"></param>
/// <returns></returns>
public bool ManagerDetailIdExists(int managerDetailId)
{
return(ManagerDetailRepository.ManagerDetailIdExists(managerDetailId));
}
public List <ManagerDetailInfo> GetManagerDetailListByQuery(string queryStr, ref GridPager pager)
{
var queryData = ManagerDetailRepository.GetManagerDetailList();
// *负责人* / 当前渠道级别 / 历史渠道级别 / 渠道等级状态
string[] queryArr = queryStr.Split(new char[] { '/' });
string queryByName = queryArr[0];
string queryByCurRank = queryArr[1];
int curRank = Convert.ToInt32(Enum.Parse(typeof(ChannelRank), queryByCurRank));
string queryByOldRank = queryArr[2];
int oldRank = Convert.ToInt32(Enum.Parse(typeof(ChannelRank), queryByOldRank));
string queryByRankStatus = queryArr[3];
int rankStatus = Convert.ToInt32(Enum.Parse(typeof(ChannelRankChangeStatus), queryByRankStatus));
if (!string.IsNullOrEmpty(queryByName) && !queryByName.Equals("输入*负责人*关键字"))
{
queryData = queryData.Where(d => d.Manager.ManagerName.Contains(queryByName));
}
if (!string.IsNullOrEmpty(queryByCurRank) && !queryByCurRank.Equals("-1"))
{
queryData = queryData.Where(d => d.CurrentRank == curRank);
}
if (!string.IsNullOrEmpty(queryByOldRank) && !queryByOldRank.Equals("-1"))
{
queryData = queryData.Where(d => d.OldRank == oldRank);
}
if (!string.IsNullOrEmpty(queryByRankStatus) && !queryByRankStatus.Equals("-1"))
{
queryData = queryData.Where(d => d.RankStatus == rankStatus);
}
// 排序
//if (pager.Order == "desc")
//{
// switch (pager.Order)
// {
// case "ModifiedTime":
// queryData = queryData.OrderByDescending(c => c.ModifiedTime);
// break;
// case "ManagerId":
// queryData = queryData.OrderByDescending(c => c.ManagerId);
// break;
// default:
// queryData = queryData.OrderByDescending(c => c.ManagerDetailId);
// break;
// }
//}
//else
//{
// switch (pager.Order)
// {
// case "ModifiedTime":
// queryData = queryData.OrderBy(c => c.ModifiedTime);
// break;
// case "ManagerId":
// queryData = queryData.OrderBy(c => c.ManagerId);
// break;
// default:
// queryData = queryData.OrderBy(c => c.ManagerDetailId);
// break;
// }
//}
queryData = LinqHelper.DataSorting(queryData, pager.Sort, pager.Order);
return(CreateModelList(ref pager, ref queryData));
}
