/// <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;
}
}
