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));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
public DataTable GetEasyConsumeLogListByPage(Model.PersonnelManage.E_tb_InPersonnel CurrentUserInfo, int _cid, string _searchtext, string orderby, int startIndex, int endIndex, string _searchtext2)
{
String where2 = "";
if (!String.IsNullOrEmpty(_searchtext2))
{
where2 = " name like '%%" + _searchtext2 + "%%'";
}
DataTable dt = dal.GetListByPage(where2, orderby, startIndex, endIndex).Tables[0];
tb_EasyConsumeOUTBLL _outbll = new tb_EasyConsumeOUTBLL();
tb_EasyConsumeINBLL _inbll = new tb_EasyConsumeINBLL();
dt.Columns.Add("ruku");
dt.Columns.Add("chuku");
for (int i = 0; i < dt.Rows.Count; i++)
{
int eid = Convert.ToInt32(dt.Rows[i]["id"]);
string where = " 1 = 1 ";
if (!string.IsNullOrEmpty(_searchtext))
{
where += string.Format(" and (cast(OutDate as datetime)) = '{0}' ", _searchtext);
}
if (CurrentUserInfo.DataRange == 3)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", CurrentUserInfo.AreaID.Value, _userid);
}
else if (_cid > 0 || CurrentUserInfo.DataRange == 2)
{
int _userid = CurrentUserInfo.PersonnelID;
where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid);
}
where += " and eid=" + eid;
DataTable dtout = _outbll.GetEasyCOnsumeOUTSUMForLog(where);
if (dtout != null && dtout.Rows.Count > 0)
{
int inid = Convert.ToInt32(dtout.Rows[0]["temp2"]);
tb_EasyConsumeIN inmodel = _inbll.GetModel(inid);
dt.Rows[i]["chuku"] = dtout.Rows[0]["chuku"];
dt.Rows[i]["ruku"] = inmodel.amount;
dt.Rows[i]["amount"] = inmodel.temp2;
}
}
return(dt);
}
/// <summary>
/// 首页显示窗口
/// 作者：小朱
/// </summary>
/// <returns></returns>
public ActionResult Default()
{
//获取实验室数据
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 and AreaID=" + CurrentUserInfo.AreaID, "OrderID").Tables[0];
//ViewData["MinImgDt"] = MinImgDt;
DataTable MinImgDt = tShowImages.GetList(16, "ImgTypeID=2 ", "OrderID").Tables[0];
ViewData["MinImgDt"] = MinImgDt;
//获取电子杂志数据列表
//DataTable MagazineDt = tElectronicsMagazine.GetList(6, "AreaID=" + CurrentUserInfo.AreaID, "AddTime Desc").Tables[0];
//ViewData["MagazineDt"] = MagazineDt;
DataTable MagazineDt = tElectronicsMagazine.GetList(6, "", "AddTime Desc").Tables[0];
ViewData["MagazineDt"] = MagazineDt;
//公告 公告通知
//DataTable News2Dt = tNews.GetList(6, "NewTypeID=2 and AreaID=" + CurrentUserInfo.AreaID, "UpdateTime Desc").Tables[0];
//DataTable News2Dt = tNews.GetList(6, "AreaID=" + CurrentUserInfo.AreaID, "UpdateTime Desc").Tables[0];
//ViewData["News2Dt"] = News2Dt;
DataTable News2Dt = tNews.GetList(6, "", "UpdateTime Desc").Tables[0];
ViewData["News2Dt"] = News2Dt;
E_Default eDefault = new E_Default();
eDefault.MaxImgCount = MaxImgDt.Rows.Count + 1;
#region 药品、易耗品、计量管理、实验计划首页提醒
try
{
ViewData["expList"] = new List <Model.ExpePlan.E_tb_ExpePlan>();
string expwhere = " (InspectTime - getdate()) <= 2 and (InspectTime - getdate()) > 0 ";
expwhere += string.Format(" and AreaID = {0} ", CurrentUserInfo.AreaID);
List <Model.ExpePlan.E_tb_ExpePlan> expList = new BLL.ExpePlan.T_tb_ExpePlan().GetModelList(expwhere);
ViewData["expList"] = expList;
//ViewData["_expList"] = new BLL.ExpePlan.T_tb_ExpePlan().GetUNFinishList();
//张伟修改，增加统计委外未完成的数据
ViewData["_expList"] = new BLL.ExpePlan.T_tb_ExpePlan().GetAllUNFinishList();
}
catch
{
}
try
{
ViewData["drugList"] = new List <Model.tb_DrugIN>();
string durgwhere = " (validDate - getdate()) <= 9 and (validDate - getdate()) > 0 ";
durgwhere += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0})", CurrentUserInfo.AreaID);
List <Model.tb_DrugIN> druglist = new BLL.tb_DrugINBLL().GetModelList(durgwhere);
ViewData["drugList"] = druglist;
}
catch
{
}
try
{
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;
}
catch
{
}
try
{
ViewData["booklist"] = new List <Model.tb_BookBorrow>();
string bookwhere = " (convert(datetime,temp2) - getdate()) <= 9 and (convert(datetime,temp2) - getdate()) > 0 ";
bookwhere += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0})", CurrentUserInfo.AreaID);
List <Model.tb_BookBorrow> booklist = new BLL.tb_BookBorrowBLL().GetModelList(bookwhere);
ViewData["booklist"] = booklist;
}
catch
{
}
#endregion
return(View(eDefault));
}
