public List <MechanismSecondModel> MechanismSecondFY(int currentPage, int pageSize, out int rows)
{
var result4 = CreateContext().MechanismSeconds
.AsNoTracking()
.OrderBy(e => e.Id);
rows = result4.Count(); //总行数
var data = result4 //.Where(e=>e)
.Skip((currentPage - 1) * pageSize) //忽略多少条数
.Take(pageSize) //取多少条数
.ToList();
List <MechanismSecond> list = data.ToList();
List <MechanismSecondModel> list2 = new List <MechanismSecondModel>();
foreach (var p in list)
{
MechanismSecondModel pp = new MechanismSecondModel()
{
Id = p.Id,
FirstMid = p.FirstMid,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId,
SecondMid = p.SecondMid,
SecondMName = p.SecondMName
};
list2.Add(pp);
}
return(list2);
}
/// <summary>
/// 二级机构修改
/// </summary>
/// <param name="ms"></param>
/// <returns></returns>
public ActionResult Update(MechanismSecondModel ms)
{
if (imb.MechanismSecondUpdate(ms) > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("ToUpdate"));
}
}
/// <summary>
/// 二级机构添加
/// </summary>
/// <param name="ms"></param>
/// <returns></returns>
public ActionResult Add(MechanismSecondModel ms)
{
if (imb.MechanismSecondAdd(ms) > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("ToAdd"));
}
}
public int MechanismSecondUpdate(MechanismSecondModel p)
{
MechanismSecond ms = new MechanismSecond()
{
Id = p.Id,
FirstMid = p.FirstMid,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId,
SecondMid = p.SecondMid,
SecondMName = p.SecondMName
};
return(Update(ms));
}
public List <MechanismSecondModel> MechanismSecondSelect()
{
List <MechanismSecond> list = Select();
List <MechanismSecondModel> list2 = new List <MechanismSecondModel>();
foreach (var p in list)
{
MechanismSecondModel pp = new MechanismSecondModel()
{
Id = p.Id,
FirstMid = p.FirstMid,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId,
SecondMid = p.SecondMid,
SecondMName = p.SecondMName
};
list2.Add(pp);
}
return(list2);
}
public List <MechanismSecondModel> MechanismSecondSelectFirst(string firstId)
{
List <MechanismSecond> list = CreateContext().MechanismSeconds.AsNoTracking().Where(e => e.FirstMid == firstId).Select(e => e).ToList();
List <MechanismSecondModel> list2 = new List <MechanismSecondModel>();
foreach (var p in list)
{
MechanismSecondModel pp = new MechanismSecondModel()
{
Id = p.Id,
FirstMid = p.FirstMid,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId,
SecondMid = p.SecondMid,
SecondMName = p.SecondMName
};
list2.Add(pp);
}
return(list2);
}
/// <summary>
/// 二级机构修改页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult ToUpdate(int id)
{
MechanismSecondModel ms = imb.MechanismSecondBy(id);
return(View(ms));
}
public int MechanismSecondUpdate(MechanismSecondModel p)
{
return(imd.MechanismSecondUpdate(p));
}
public int MechanismSecondAdd(MechanismSecondModel p)
{
return(imd.MechanismSecondAdd(p));
}