public override void Submit_OnClick(object sender, EventArgs e) { var isChanged = false; try { if (_channelId == 0) { var parentId = TranslateUtils.ToInt(ParentID.SelectedValue); if (parentId == 0) { parentId = PublishmentSystemInfo.Additional.GovPublicNodeId; } var nodeId = DataProvider.NodeDao.InsertNodeInfo(PublishmentSystemId, parentId, ChannelName.Text, string.Empty, EContentModelTypeUtils.GetValue(EContentModelType.GovPublic)); var channelInfo = new GovPublicChannelInfo(nodeId, PublishmentSystemId, ChannelCode.Text, Summary.Text); DataProvider.GovPublicChannelDao.Insert(channelInfo); } else { var nodeInfo = NodeManager.GetNodeInfo(PublishmentSystemId, _channelId); nodeInfo.NodeName = ChannelName.Text; DataProvider.NodeDao.UpdateNodeInfo(nodeInfo); var channelInfo = DataProvider.GovPublicChannelDao.GetChannelInfo(_channelId); if (channelInfo == null) { channelInfo = new GovPublicChannelInfo(_channelId, PublishmentSystemId, ChannelCode.Text, Summary.Text); DataProvider.GovPublicChannelDao.Insert(channelInfo); } else { channelInfo.Code = ChannelCode.Text; channelInfo.Summary = Summary.Text; DataProvider.GovPublicChannelDao.Update(channelInfo); } } Body.AddAdminLog("维护分类信息"); SuccessMessage("分类设置成功!"); isChanged = true; } catch (Exception ex) { FailMessage(ex, "分类设置失败!"); } if (isChanged) { PageUtils.CloseModalPageAndRedirect(Page, _returnUrl); } }
public void Update(GovPublicChannelInfo channelInfo) { var parms = new IDataParameter[] { GetParameter(ParmCode, EDataType.VarChar, 50, channelInfo.Code), GetParameter(ParmSummary, EDataType.NVarChar, 255, channelInfo.Summary), GetParameter(ParmNodeId, EDataType.Integer, channelInfo.NodeID) }; ExecuteNonQuery(SqlUpdate, parms); }
public void Insert(GovPublicChannelInfo channelInfo) { var parms = new IDataParameter[] { GetParameter(ParmNodeId, EDataType.Integer, channelInfo.NodeID), GetParameter(ParmPublishmentsystemid, EDataType.Integer, channelInfo.PublishmentSystemID), GetParameter(ParmCode, EDataType.VarChar, 50, channelInfo.Code), GetParameter(ParmSummary, EDataType.NVarChar, 255, channelInfo.Summary) }; ExecuteNonQuery(SqlInsert, parms); }
public GovPublicChannelInfo GetChannelInfo(int nodeId) { GovPublicChannelInfo channelInfo = null; var parms = new IDataParameter[] { GetParameter(ParmNodeId, EDataType.Integer, nodeId) }; using (var rdr = ExecuteReader(SqlSelect, parms)) { if (rdr.Read()) { var i = 0; channelInfo = new GovPublicChannelInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i)); } rdr.Close(); } return(channelInfo); }