public List <MechanismFirstModel> MechanismFirstFY(int currentPage, int pageSize, out int rows)
{
var result4 = CreateContext().MechanismFirsts
.AsNoTracking()
.OrderBy(e => e.Id);
rows = result4.Count(); //总行数
var data = result4 //.Where(e=>e)
.Skip((currentPage - 1) * pageSize) //忽略多少条数
.Take(pageSize) //取多少条数
.ToList();
List <MechanismFirst> list = data.ToList();
List <MechanismFirstModel> list2 = new List <MechanismFirstModel>();
foreach (var p in list)
{
MechanismFirstModel pp = new MechanismFirstModel()
{
Id = p.Id,
FirstMId = p.FirstMId,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId
};
list2.Add(pp);
}
return(list2);
}
/// <summary>
/// 一级机构修改
/// </summary>
/// <param name="mf"></param>
/// <returns></returns>
public ActionResult Update(MechanismFirstModel mf)
{
if (imb.MechanismFirstUpdate(mf) > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("ToUpdate"));
}
}
/// <summary>
/// 一级机构添加
/// </summary>
/// <param name="mf"></param>
/// <returns></returns>
public ActionResult Add(MechanismFirstModel mf)
{
if (imb.MechanismFirstAdd(mf) > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("ToAdd"));
}
}
public int MechanismFirstAdd(MechanismFirstModel p)
{
MechanismFirst mf = new MechanismFirst()
{
Id = p.Id,
FirstMId = p.FirstMId,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId
};
return(Add(mf));
}
public MechanismFirstModel MechanismFirstBy(int id)
{
MechanismFirst p = CreateContext().MechanismFirsts.AsNoTracking().Where(e => e.Id == id).SingleOrDefault();
MechanismFirstModel mf = new MechanismFirstModel()
{
Id = p.Id,
FirstMId = p.FirstMId,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId
};
return(mf);
}
public List <MechanismFirstModel> MechanismFirstSelect()
{
List <MechanismFirst> list = Select();
List <MechanismFirstModel> list2 = new List <MechanismFirstModel>();
foreach (var p in list)
{
MechanismFirstModel pp = new MechanismFirstModel()
{
Id = p.Id,
FirstMId = p.FirstMId,
FirstMName = p.FirstMName,
SalaryId = p.SalaryId,
SalesId = p.SalesId
};
list2.Add(pp);
}
return(list2);
}
public int MechanismFirstUpdate(MechanismFirstModel p)
{
return(imd.MechanismFirstUpdate(p));
}
public int MechanismFirstAdd(MechanismFirstModel p)
{
return(imd.MechanismFirstAdd(p));
}
/// <summary>
/// 一级机构修改页面
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult ToUpdate(int id)
{
MechanismFirstModel mf = imb.MechanismFirstBy(id);
return(View(mf));
}
