/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod public DataTable GetDrugForCheckByInAndOut(DateTime _sDate, DateTime _eDate, int _cid, string _auditstatus, string whereInPersonnel, Model.PersonnelManage.E_tb_InPersonnel _user, string _searchtext2) { try { string sql = ""; sql += string.Format(@" outDate BETWEEN '{0}' and '{1}' and temp1='通过' ", _sDate.ToShortDateString(), _eDate.ToShortDateString()); int _userid = _user.PersonnelID; if (_user.DataRange == 3) { sql += string.Format(" and createUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", _cid, _userid); } else if (_cid > 0 || _user.DataRange == 2) { sql += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid); } var outlist = new tb_DrugOUTBLL().GetModelList(sql); //DataSet ds = dal.GetDrugForCheckByInAndOut(_sDate, _eDate, _cid, _auditstatus, whereInPersonnel); string where = string.Format(" outDate BETWEEN '{0}' and '{1}' ", _sDate.ToShortDateString(), _eDate.ToShortDateString()); where += whereInPersonnel; if (outlist != null && outlist.Count > 0) { tb_DrugINBLL _druginbll = new tb_DrugINBLL(); tb_DrugBLL _drugbll = new tb_DrugBLL(); tb_BaseBLL _basebll = new tb_BaseBLL(); List <tb_DrugCheck> listcheck = GetModelList(where); for (int i = 0; i < outlist.Count; i++) { tb_DrugOUT drugout = outlist[i]; int druginid = Convert.ToInt32(drugout.temp2); var templist = listcheck.Where(w => w.drugId.Value == drugout.drugId && w.drugInId.Value == druginid && w.drugOutId.Value == drugout.id); if (templist == null || templist.Count() == 0) { try { tb_DrugIN drugin = _druginbll.GetModel(druginid); tb_DrugCheck model = new tb_DrugCheck(); model.amount = Convert.ToInt32(drugin.temp2); model.amountIN = Convert.ToInt32(drugin.amount); model.amountOUT = Convert.ToInt32(drugout.amount); model.auditstatus = "未审核"; model.drugCode = drugout.drugCode; model.drugId = drugout.drugId; model.drugInId = drugin.id; tb_Drug drug = _drugbll.GetModel(drugout.drugId.Value); model.drugName = drug.drugName; model.drugOutId = drugout.id; model.isDelete = false; model.outDate = drugout.outDate; model.riskLevel = _basebll.GetModel(Convert.ToInt32(drug.riskLevel)).baseName; model.unit = _basebll.GetModel(drug.unit.Value).baseName; model.createUser = _user.PersonnelID; model.createDate = DateTime.Now; model.updateUser = _user.PersonnelID; model.updateDate = DateTime.Now; Add(model); } catch { continue; } } } } where += "and auditstatus = '" + _auditstatus + "' "; if (!String.IsNullOrEmpty(_searchtext2)) { where += "and drugName like '%%" + _searchtext2 + "%%' "; } return(GetList(where).Tables[0]); } catch { return(new DataTable()); } }
/// <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)); }