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