D_Task dTask = new D_Task(); //工作任务
// GET: /Home/
public ActionResult Index()
{
//获取实验室数据
int total = 0;
DataTable LaboratoryDt = tLaboratory.GetListByPage("AreaID=" + CurrentUserInfo.AreaID, "", 1, 8, ref total).Tables[0];
ViewData["LaboratoryDt"] = LaboratoryDt;
//获取大图数据列表
DataTable MaxImgDt = tShowImages.GetList(4, "ImgTypeID=1 and AreaID=" + CurrentUserInfo.AreaID, "OrderID").Tables[0];
ViewData["MaxImgDt"] = MaxImgDt;
//获取小图数据列表
DataTable MinImgDt = tShowImages.GetList(16, "ImgTypeID=2 ", "OrderID").Tables[0];
ViewData["MinImgDt"] = MinImgDt;
//获取电子杂志数据列表
DataTable MagazineDt = tElectronicsMagazine.GetList(6, "", "AddTime Desc").Tables[0];
ViewData["MagazineDt"] = MagazineDt;
//公告 公告通知
DataTable News2Dt = tNews.GetList(6, "", "UpdateTime Desc").Tables[0];
ViewData["News2Dt"] = News2Dt;
E_Default eDefault = new E_Default();
eDefault.MaxImgCount = MaxImgDt.Rows.Count + 1;
//超时实验计划
ViewBag.timeoutplan = dExpePlan.GetTimeOutPlan(Convert.ToInt32(CurrentUserInfo.AreaID));
//未超时实验计划
ViewBag.notimeoutplan = dExpePlan.GetNoTimeOutPlan(Convert.ToInt32(CurrentUserInfo.AreaID));
//工作任务
ViewBag.tasklist = dTask.GetIndexTaskList();
ViewData["easyConsumelist"] = new List <Model.tb_EasyConsumeIN>();
string easyConsumewhere = " (validDate - getdate()) <= 9 and (validDate - getdate()) > 0 ";
easyConsumewhere += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", CurrentUserInfo.AreaID);
List <Model.tb_EasyConsumeIN> easyConsumelist = new BLL.tb_EasyConsumeINBLL().GetModelList(easyConsumewhere);
ViewData["easyConsumelist"] = easyConsumelist;
//ViewData["measurelist"] = new tb_MeasureBLL().GetList(7, string.Format(" createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0})", CurrentUserInfo.AreaID), " nextVerification desc");
ViewData["testreportlist"] = new T_tb_TestReport().GetList(3, " examinePersonnelID >0 and issecrecy=0", " UpdateTime desc");
return(View(eDefault));
}
