public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; var permissionsInfo = DataProvider.GovInteractPermissionsDao.GetPermissionsInfo(_userName, _nodeId); try { if (permissionsInfo == null) { permissionsInfo = new GovInteractPermissionsInfo(_userName, _nodeId, ControlUtils.GetSelectedListControlValueCollection(cblPermissions)); DataProvider.GovInteractPermissionsDao.Insert(PublishmentSystemId, permissionsInfo); } else { permissionsInfo.Permissions = ControlUtils.GetSelectedListControlValueCollection(cblPermissions); DataProvider.GovInteractPermissionsDao.Update(permissionsInfo); } Body.AddSiteLog(PublishmentSystemId, "设置互动交流管理员权限", $"互动交流类别:{NodeManager.GetNodeName(PublishmentSystemId, _nodeId)}"); isChanged = true; } catch (Exception ex) { FailMessage(ex, "互动交流权限设置失败!"); } if (isChanged) { PageUtils.CloseModalPageAndRedirect(Page, PageGovInteractPermissions.GetRedirectUrl(PublishmentSystemId, _nodeId)); } }
public void Update(GovInteractPermissionsInfo permissionsInfo) { var parms = new IDataParameter[] { GetParameter(ParmPermissions, EDataType.Text, permissionsInfo.Permissions), GetParameter(ParmUsername, EDataType.NVarChar, 50, permissionsInfo.UserName), GetParameter(ParmNodeId, EDataType.Integer, permissionsInfo.NodeID) }; ExecuteNonQuery(SqlUpdate, parms); }
public void Insert(int publishmentSystemId, GovInteractPermissionsInfo permissionsInfo) { if (!DataProvider.GovInteractChannelDao.IsExists(permissionsInfo.NodeID)) { var channelInfo = new GovInteractChannelInfo(permissionsInfo.NodeID, publishmentSystemId, 0, 0, string.Empty, string.Empty); DataProvider.GovInteractChannelDao.Insert(channelInfo); } var parms = new IDataParameter[] { GetParameter(ParmUsername, EDataType.NVarChar, 50, permissionsInfo.UserName), GetParameter(ParmNodeId, EDataType.Integer, permissionsInfo.NodeID), GetParameter(ParmPermissions, EDataType.Text, permissionsInfo.Permissions) }; ExecuteNonQuery(SqlInsert, parms); }
public ArrayList GetPermissionsInfoArrayList(string userName) { var arraylist = new ArrayList(); var parms = new IDataParameter[] { GetParameter(ParmUsername, EDataType.NVarChar, 50, userName) }; using (var rdr = ExecuteReader(SqlSelectAll, parms)) { while (rdr.Read()) { var i = 0; var permissionsInfo = new GovInteractPermissionsInfo(GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i)); arraylist.Add(permissionsInfo); } rdr.Close(); } return(arraylist); }
public GovInteractPermissionsInfo GetPermissionsInfo(string userName, int nodeId) { GovInteractPermissionsInfo permissionsInfo = null; var parms = new IDataParameter[] { GetParameter(ParmUsername, EDataType.NVarChar, 50, userName), GetParameter(ParmNodeId, EDataType.Integer, nodeId) }; using (var rdr = ExecuteReader(SqlSelect, parms)) { if (rdr.Read()) { var i = 0; permissionsInfo = new GovInteractPermissionsInfo(GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i)); } rdr.Close(); } return(permissionsInfo); }