/// <summary> /// 获取管理员管理的阅览室 /// </summary> /// <param name="loginId">用户名</param> /// <returns>返回阅览室列表</returns> public string GetManagerPotencyReadingRoom(string loginId) { try { ManagerPotency modelManagerPotency = seatDataService.GetManagerPotencyByLoginID(loginId); List <ReadingRoomInfo> rightRoomList = modelManagerPotency.RightRoomList; List <string> roomNoList = new List <string>(); foreach (ReadingRoomInfo room in rightRoomList) { string no = ""; no = room.No; roomNoList.Add(no); } List <JM_ReadingRoom> rooms = new List <JM_ReadingRoom>(); if (roomNoList.Count > 0) { List <SeatManage.ClassModel.ReadingRoomInfo> roomListModel = seatDataService.GetReadingRoomInfo(roomNoList); for (int i = 0; i < roomListModel.Count; i++) { JM_ReadingRoom roomInfo = new JM_ReadingRoom(); roomInfo.RoomNum = roomListModel[i].No; roomInfo.RoomName = roomListModel[i].Name; //TODO:添加阅览室设置属性 //if (!String.IsNullOrEmpty(dr["ReadingSetting"].ToString())) //{ // roomInfo.Setting = new ReadingRoomSetting(dr["ReadingSetting"].ToString()); //} //else //{ // roomInfo.Setting = new ReadingRoomSetting(); //} rooms.Add(roomInfo); } JM_HandleResultObject result = new JM_HandleResultObject(); result.Result = true; result.Msg = rooms; return(SeatManageComm.JSONSerializer.Serialize(result)); } else { JM_HandleResultObject result = new JM_HandleResultObject(); result.Result = false; result.Msg = "当前没有可管理的阅览室"; return(SeatManageComm.JSONSerializer.Serialize(result)); } } catch (Exception ex) { SeatManage.SeatManageComm.WriteLog.Write("获取管理的阅览室列表异常:" + ex.Message); JM_HandleResultObject result = new JM_HandleResultObject(); result.Result = false; result.Msg = "执行遇到异常!"; return(SeatManage.SeatManageComm.JSONSerializer.Serialize(result)); } }
/// <summary> /// 根据用户ID获取对应权限的阅览室 /// </summary> /// <param name="LoginID"></param> /// <returns></returns> public ManagerPotency GetManagerPotencyByLoginID(string LoginID) { string strWhere = "LoginID='" + LoginID + "'"; try { DataSet ds = t_sm_managepotency.GetList(strWhere, null); ManagerPotency mp = new ManagerPotency(); mp.LoginID = LoginID; if (ds.Tables[0].Rows.Count > 0) { mp.UserName = ds.Tables[0].Rows[0]["UsrName"].ToString(); } List <string> roomNums = new List <string>(); foreach (DataRow dr in ds.Tables[0].Rows) { roomNums.Add(dr["ReadingRoomNo"].ToString()); } if (roomNums.Count == 0) { mp.RightRoomList = new List <ReadingRoomInfo>(); } else { mp.RightRoomList = GetReadingRoomInfo(roomNums); } return(mp); } catch { throw; } }
/// <summary> /// 根据用户权限绑定阅览室 /// </summary> /// <param name="loginId"></param> protected void BindReadingRoomList(string loginId) { ManagerPotency modelManagerPotency = T_SM_ManagerPotency.GetManangePotencyByLoginID(loginId); List <ReadingRoomInfo> list = modelManagerPotency.RightRoomList; for (int i = 0; i < list.Count; i++) { ListItem items = new ListItem(list[i].Name, list[i].No); selectReadingRomm.Items.Add(items); } }
/// <summary> /// 修改用户权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateManagerPotency(ManagerPotency model) { try { return(t_sm_managepotency.AddUpdate(model)); } catch { throw; } }
/// <summary> /// 增加一条数据 /// </summary> public bool AddUpdate(ManagerPotency model) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete T_SM_ManagerPotency "); strSql.Append(" where LoginID=@LoginID"); SqlParameter[] parameters = { new SqlParameter("@LoginID", model.LoginID) }; try { int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); rows = 0; //插入新数据 foreach (ReadingRoomInfo room in model.RightRoomList) { strSql = new StringBuilder(); strSql.Append("insert into T_SM_ManagerPotency("); strSql.Append("RoomNo,LoginID)"); strSql.Append(" values ("); strSql.Append("@RoomNo,@LoginID)"); SqlParameter[] parameters_new = { new SqlParameter("@RoomNo", room.No), new SqlParameter("@LoginID", model.LoginID) }; rows += DbHelperSQL.ExecuteSql(strSql.ToString(), parameters_new); } if (model.RightRoomList.Count == rows) { return(true); } else { return(false); } } catch { throw; } }