/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod /// <summary> /// 获取未选择权限的用户列表 /// 作者:章建国 /// </summary> /// <param name="_fid"></param> /// <returns></returns> public DataTable GetUNSelectList(string _fid, int _userid) { try { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("userORgroup")); dt.Columns.Add(new DataColumn("id")); dt.Columns.Add(new DataColumn("limittype")); dt.Columns.Add(new DataColumn("areaid")); var limitList = GetModelList(" fileId = " + _fid); if (limitList != null && limitList.Count > 0) { string userids = ""; string areaids = ""; foreach (var item in limitList) { switch (item.limitType) { case "用户": userids += item.limitId + ","; break; case "用户组": areaids += item.limitId + ","; break; } } userids = !string.IsNullOrEmpty(userids) ? " PersonnelID not in (" + userids.Substring(0, userids.Length - 1) + "," + _userid + ")" : "PersonnelID <> " + _userid; areaids = !string.IsNullOrEmpty(areaids) ? " AreaID not in (" + areaids.Substring(0, areaids.Length - 1) + ")" : ""; var inpersonlist = new BLL.PersonnelManage.T_tb_InPersonnel().GetModelList(userids); var areaList = new BLL.RoleManage.T_tb_Area().GetModelList(areaids); dt = GetUNSelectResultDataTable(dt, inpersonlist, areaList); } else { var inpersonlist = new BLL.PersonnelManage.T_tb_InPersonnel().GetModelList(" PersonnelID <> " + _userid); var areaList = new BLL.RoleManage.T_tb_Area().GetModelList(""); dt = GetUNSelectResultDataTable(dt, inpersonlist, areaList); } return(dt); } catch { return(new DataTable()); } }
/// <summary> /// 获取已加入权限的用户和用户组 /// 作者:章建国 /// </summary> /// <param name="_fid">文件ID</param> /// <returns></returns> public JsonResult GetSelectedList(string _fid) { var limitlist = new tb_LimitBLL().GetModelList(" fileId = " + _fid); if (limitlist != null && limitlist.Count > 0) { BLL.PersonnelManage.T_tb_InPersonnel inpersonnelDAL = new BLL.PersonnelManage.T_tb_InPersonnel(); BLL.Laboratory.T_tb_Laboratory laboratoryDAL = new BLL.Laboratory.T_tb_Laboratory(); for (int i = 0; i < limitlist.Count; i++) { if (limitlist[i].limitType.Equals("用户")) { limitlist[i].limitType = inpersonnelDAL.GetModel(Convert.ToInt32(limitlist[i].limitId)).PersonnelName; } else if (limitlist[i].limitType.Equals("用户组")) { limitlist[i].limitType = laboratoryDAL.GetModel(Convert.ToInt32(limitlist[i].limitId)).LaboratoryName; } continue; } } return(Json(limitlist, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出药品入库 /// 作者:章建国 /// </summary> /// <returns></returns> public FileResult Export_Sample(string _search, string _searchtype, int _companyid) { DataTable dt = new DataTable(); System.IO.MemoryStream stream = new MemoryStream(); try { string where = " 1=1 "; switch (_searchtype) { case "样品名称": where += string.Format(" and name like '%%{0}%%' ", _search); break; case "样品人": where += string.Format(" and detectionUser like '%%{0}%%' ", _search); break; case "抽样日期": var times = _search.Split(','); where += string.Format(" and detectionDate >= '{0}' and detectionDate <= '{1}' ", times[0], times[1]); break; } if (_companyid > 0) { where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _companyid); } else { if (CurrentUserInfo.AreaID > 0 && 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, _userid); } else if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 2) { int _userid = CurrentUserInfo.PersonnelID; where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", CurrentUserInfo.AreaID); } } dt = _samplebll.GetList(where).Tables[0]; BLL.PersonnelManage.T_tb_InPersonnel inpersonnel = new BLL.PersonnelManage.T_tb_InPersonnel(); BLL.ClientManage.T_tb_ClientManage clientManage = new BLL.ClientManage.T_tb_ClientManage(); for (int i = 0; i < dt.Rows.Count; i++) { try { int userid = Convert.ToInt32(dt.Rows[i]["handleUser"]); dt.Rows[i]["handleUser"] = inpersonnel.GetModel(userid).PersonnelName; } catch { } try { int InspectCompany = Convert.ToInt32(dt.Rows[i]["InspectCompany"]); dt.Rows[i]["InspectCompany"] = clientManage.GetModel(InspectCompany).ClientName; } catch { } } stream = PublicClass.ExportSampleToExcel(dt); } catch { } string filename = "样品列表" + DateTime.Now.ToFileTime() + ".xls"; return(File(stream, "application/vnd.ms-excel", filename)); }
/// <summary> /// 获取所有数据列表 /// 作者:章建国 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public string GetSampleList(int pageNumber, int pageSize, string _searchtext, string _searchtype, int _cid) { DataTable dt = new DataTable(); int total = 0; try { string where = " 1=1 "; switch (_searchtype) { case "样品名称": where += string.Format(" and name like '%%{0}%%' ", _searchtext); break; case "样品人": where += string.Format(" and detectionUser like '%%{0}%%' ", _searchtext); break; case "抽样日期": var times = _searchtext.Split(','); where += string.Format(" and detectionDate >= '{0}' and detectionDate <= '{1}' ", times[0], times[1]); break; } if (_cid > 0) { where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid); } else { if (CurrentUserInfo.AreaID > 0 && 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, _userid); } else if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 2) { int _userid = CurrentUserInfo.PersonnelID; where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", CurrentUserInfo.AreaID); } } dt = _samplebll.GetListByPage(where, "createDate desc", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize).Tables[0]; BLL.PersonnelManage.T_tb_InPersonnel inpersonnel = new BLL.PersonnelManage.T_tb_InPersonnel(); BLL.ClientManage.T_tb_ClientManage clientManage = new BLL.ClientManage.T_tb_ClientManage(); for (int i = 0; i < dt.Rows.Count; i++) { try { int userid = Convert.ToInt32(dt.Rows[i]["handleUser"]); dt.Rows[i]["handleUser"] = inpersonnel.GetModel(userid).PersonnelName; } catch { } try { int InspectCompany = Convert.ToInt32(dt.Rows[i]["InspectCompany"]); dt.Rows[i]["InspectCompany"] = clientManage.GetModel(InspectCompany).ClientName; } catch { } } total = dt.Rows.Count; total = _samplebll.GetModelList(where).Count; } catch { } return(PublicClass.ToJson(dt, total)); }
/// <summary> /// 获取所有数据列表 /// 作者:章建国 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public string GetEasyConsumeOUTList(int pageNumber, int pageSize, int _cid, string _searchtext, string _searchtype, string _datetype, string _txtdate) { DataTable dt = new DataTable(); int total = 0; try { string where = " 1 = 1 "; switch (_searchtype) { case "名称": if (string.IsNullOrEmpty(_searchtext)) { break; } where += string.Format(" and tb_EasyConsume.name like '%%{0}%%' ", _searchtext); break; case "厂家与场地": if (string.IsNullOrEmpty(_searchtext)) { break; } where += string.Format(" and product like '%%{0}%%' ", _searchtext); break; case "经手人": if (string.IsNullOrEmpty(_searchtext)) { break; } var listperson = new BLL.PersonnelManage.T_tb_InPersonnel().GetModelList(" PersonnelName like '%%" + _searchtext + "%%'"); string personids = ""; foreach (var item in listperson) { personids += item.PersonnelID + ","; } if (!string.IsNullOrEmpty(personids)) { where += string.Format(" and user1 in({0}) ", personids.Substring(0, personids.Length - 1)); } break; } switch (_datetype) { case "年": if (string.IsNullOrEmpty(_txtdate)) { break; } where += string.Format(" and year(createDate) ={0} ", _txtdate); break; case "月": if (string.IsNullOrEmpty(_txtdate)) { break; } DateTime _dtime = DateTime.Parse("1949-10-01"); DateTime.TryParse(_txtdate, out _dtime); where += _dtime.Year > 1949 ? string.Format(" and year(createDate) = {0} and month(createDate) = {1} ", _dtime.Year, _dtime.Month) : ""; break; } if (CurrentUserInfo.DataRange == 3) { int _userid = CurrentUserInfo.PersonnelID; where += string.Format(" and T.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 T.createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid); } dt = _easyconsumeoutbll.GetListByPage(where, "updateDate desc", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize).Tables[0]; //dt.Columns.Add("name"); //dt.Columns.Add("type"); //dt.Columns.Add("danwei"); //dt.Columns.Add("PersonnelName"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // DataRow dr = dt.Rows[i]; // int eid = Convert.ToInt32(dr["eId"]); // tb_EasyConsume _easyconsume = _easyconsumebll.GetModel(eid); // dt.Rows[i]["name"] = _easyconsume.name; // dt.Rows[i]["type"] = _easyconsume.type; // dt.Rows[i]["danwei"] = new tb_BaseBLL().GetModel(_easyconsume.unit.Value).baseName; // dt.Rows[i]["PersonnelName"] = new BLL.PersonnelManage.T_tb_InPersonnel().GetModel(Convert.ToInt32(dr["user1"])).PersonnelName; //} total = dt.Rows.Count; total = _easyconsumeoutbll.GetEasyConsumeOUTCount(where); } catch { } return(PublicClass.ToJson(dt, total)); }