/// <summary>
/// 获取列表
/// </summary>
/// <param name="connection"></param>
/// <param name="model"></param>
/// <returns></returns>
public static Tuple <int, List <BatteryLevelUpEntity> > GetBatteryLeveUpList(SqlConnection connection, BatteryLevelUpRequest model)
{
int totalCount = 0;
var parameters = new SqlParameter []
{
new SqlParameter("@PageIndex", model.PageIndex),
new SqlParameter("@PageSize", model.PageSize),
new SqlParameter("@pid", model.OriginalPID),
new SqlParameter("@totalCount", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
var sql = @" SELECT @totalCount = COUNT(1)
FROM BaoYang..BatteryLevelUp AS a
WHERE (
a.OriginalPID = @pid
OR @pid = ''
OR @pid IS NULL
)
OR
(
a.NewPID = @pid
OR @pid = ''
OR @pid IS NULL
);
SELECT a.OriginalPID,
a.NewPID,
a.Copywriting,
a.IsEnabled,
a.CreateDateTime,
a.LastUpdateDateTime,
a.PKID
FROM BaoYang.dbo.BatteryLevelUp AS a WITH (NOLOCK)
WHERE (
a.OriginalPID = @pid
OR @pid = ''
OR @pid IS NULL
)
OR
(
a.NewPID = @pid
OR @pid = ''
OR @pid IS NULL
)
ORDER BY a.PKID DESC OFFSET (@PageIndex - 1) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY; ";
var dt = SqlHelper.ExecuteDataTable2(connection, CommandType.Text, sql, parameters);
var list = dt.AsEnumerable().Select(x => new BatteryLevelUpEntity
{
Copywriting = x["Copywriting"].ToString(),
IsEnabled = Convert.ToBoolean(x["IsEnabled"]),
NewPID = x["NewPID"].ToString(),
OriginalPID = x["OriginalPID"].ToString(),
CreateDateTime = Convert.ToDateTime(x["CreateDateTime"]),
PKID = int.Parse(x["PKID"].ToString()),
LsatUpdateDateTime = Convert.ToDateTime(x["LastUpdateDateTime"])
}).ToList();
int.TryParse(parameters.Last().Value.ToString(), out totalCount);
return(new Tuple <int, List <BatteryLevelUpEntity> >(totalCount, list));
}
/// <summary>
/// 获取配置列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public BaoYangResultEntity <Tuple <int, List <BatteryLevelUpReslut> > > GetBatteryLeveUpList(BatteryLevelUpRequest model)
{
var result = new BaoYangResultEntity <Tuple <int, List <BatteryLevelUpReslut> > >()
{
Status = false
};
try
{
List <BatteryLevelUpReslut> list = new List <BatteryLevelUpReslut>();
var btaaeryTuple = dbScopeManagerBaoYangRead.Execute(conn =>
{
var data = DALBatteryLevelUp.GetBatteryLeveUpList(conn, model);
return(data);
});
var pids = btaaeryTuple.Item2.Select(x => x.NewPID).ToList();
pids.AddRange(btaaeryTuple.Item2.Select(x => x.OriginalPID).ToList());
pids = pids.Distinct().ToList();
var productDic = new ProductManager().SelectProductDetail(pids);
foreach (var item in btaaeryTuple.Item2)
{
BatteryLevelUpReslut resultModel = new BatteryLevelUpReslut()
{
Copywriting = item.Copywriting,
NewPID = item.NewPID,
OriginalPID = item.OriginalPID,
CreateDateTime = item.CreateDateTime,
IsEnabled = item.IsEnabled,
PKID = item.PKID,
LsatUpdateDateTime = item.LsatUpdateDateTime
};
if (productDic.ContainsKey(item.NewPID))
{
resultModel.NewDisplayName = productDic[item.NewPID].Name;
}
if (productDic.ContainsKey(item.OriginalPID))
{
resultModel.OriginalDisplayName = productDic[item.OriginalPID].Name;
}
list.Add(resultModel);
}
result.Data = Tuple.Create(btaaeryTuple.Item1, list);
result.Status = true;
return(result);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
result = new BaoYangResultEntity <Tuple <int, List <BatteryLevelUpReslut> > >()
{
Status = false, Msg = "获取失败"
};
}
return(result);
}
