/// <summary>
/// 获取单条数据
/// </summary>
/// <returns></returns>
public V_xy_sp_userspirit Get(Expression <Func <xy_sp_userspirit, bool> > predicate = null)
{
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
xy_sp_userspirit entity = dal.Get(predicate);
return(EntityToModel(entity));
}
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <returns></returns>
public V_xy_sp_userView GetCurrentUserStatebyUserID(string UserID)
{
V_xy_sp_userView userV = new V_xy_sp_userView();
tm_pm_userinfoBLL ubll = new tm_pm_userinfoBLL();
xy_sp_userspiritBLL upbll = new xy_sp_userspiritBLL();
xy_sp_spiritequipmentBLL sqBll = new xy_sp_spiritequipmentBLL();
xy_sp_spiritskillBLL skBll = new xy_sp_spiritskillBLL();
xy_sp_userspiritpackageBLL spBll = new xy_sp_userspiritpackageBLL();
xy_sp_taskBLL tkBll = new xy_sp_taskBLL();
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL())
{
userV.User = ubll.GetUserInfoByID(UserID);
xy_sp_userspirit entity = dal.GetSpiritbyUserID(UserID);
userV.Spirit = EntityToModel(entity);
//用户背包
userV.Spirit.packageList = spBll.GetSpPackageListBySpID(userV.Spirit.SpiritID);
//用户装备
userV.Spirit.spEquipmentList = sqBll.GetSpEqListBySpID(userV.Spirit.SpiritID);
//用户技能
userV.Spirit.spSkillList = skBll.GetListBySpID(userV.Spirit.SpiritID);
userV.Task = tkBll.getTaskContext(entity.CurrentTaskID);
return(userV);
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public IEnumerable <V_xy_sp_userspirit> GetList(PageInfo page)
{
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
var list = dal.Get();
return(list.Paging(ref page).Select(EntityToModel).ToList());
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Delete(string id)
{
if (string.IsNullOrEmpty(id))
{
return(false);
}
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
return(dal.Delete(id));
}
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public IEnumerable <V_xy_sp_userspirit> Get()
{
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
List <xy_sp_userspirit> entitys = dal.Get().ToList();
List <V_xy_sp_userspirit> list = new List <V_xy_sp_userspirit>();
foreach (xy_sp_userspirit item in entitys)
{
list.Add(EntityToModel(item));
}
return(list);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(V_xy_sp_userspirit model)
{
if (model == null)
{
return(false);
}
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
xy_sp_userspirit entitys = ModelToEntity(model);
return(dal.Edit(entitys));
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Add(V_xy_sp_userspirit model)
{
if (model == null)
{
return(string.Empty);
}
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
xy_sp_userspirit entity = ModelToEntity(model);
entity.UserSpiritID = string.IsNullOrEmpty(model.UserSpiritID) ? Guid.NewGuid().ToString("N") : model.UserSpiritID;
return(dal.Add(entity));
}
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public List <V_xy_sp_userspirit> GetAllSpiritOfTask(string taskId)
{
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL()){
List <xy_sp_userspirit> entitys = (from ent in dal.Get()
where ent.CurrentTaskID == taskId
select ent).ToList();
List <V_xy_sp_userspirit> list = new List <V_xy_sp_userspirit>();
foreach (xy_sp_userspirit item in entitys)
{
list.Add(EntityToModel(item));
}
return(list);
}
}
public V_xy_sp_task getTaskContext(string strTaskID)
{
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL())
{
xy_sp_spiritBLL spBll = new xy_sp_spiritBLL();
var q = from Task in dal._context.xy_sp_task
where Task.TaskID == strTaskID
select Task;
V_xy_sp_task task = EntityToModel(q.FirstOrDefault());
var taskSpirit = from TaskSpirit in dal._context.xy_sp_taskspirit
where TaskSpirit.TaskID == strTaskID
select TaskSpirit;
foreach (var item in taskSpirit)
{
V_xy_sp_spirit spirit = spBll.getSpiritContextByID(item.SpiritID);
task.SpiritsList.Add(spirit);
}
return(task);
}
}
public V_xy_sp_spirit getSpiritContextByID(string SpiritID)
{
xy_sp_equipmentBLL eqBll = new xy_sp_equipmentBLL();
xy_sp_skillBLL skBll = new xy_sp_skillBLL();
using (xy_sp_userspiritDAL dal = new xy_sp_userspiritDAL())
{
var q = from ent in dal._context.xy_sp_spirit
where ent.SpiritID == SpiritID
select ent;
V_xy_sp_spirit spiritV = EntityToModel(q.FirstOrDefault());
//查询装备
var sps = from spEq in dal._context.xy_sp_spiritequipment
join eq in dal._context.xy_sp_equipment on spEq.EquipmentID equals eq.EquipmentID
where spEq.SpiritID == SpiritID
select eq;
foreach (var spItem in sps)
{
spiritV.spiritEquipmentList.Add(eqBll.EntityToModel(spItem));
}
//查询技能
var sks = from SpiritSkill in dal._context.xy_sp_spiritskill
join Skill in dal._context.xy_sp_skill on SpiritSkill.SkillID equals Skill.SkillID
where SpiritSkill.SpiritID == SpiritID
select Skill;
foreach (var skItem in sks)
{
spiritV.spiritSkillList.Add(skBll.EntityToModel(skItem));
}
return(spiritV);
}
}