public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_ruleId = TranslateUtils.ToInt(Request.QueryString["RuleID"]);
if (!IsPostBack)
{
EGovPublicIdentifierTypeUtils.AddListItems(ddlIdentifierType);
var styleInfoList = TableStyleManager.GetTableStyleInfoList(ETableStyle.GovPublicContent, PublishmentSystemInfo.AuxiliaryTableForGovPublic, null);
foreach (var tableStyleInfo in styleInfoList)
{
if (tableStyleInfo.AttributeName == ContentAttribute.Title || tableStyleInfo.AttributeName == GovPublicContentAttribute.Content || tableStyleInfo.AttributeName == GovPublicContentAttribute.DepartmentId || tableStyleInfo.AttributeName == GovPublicContentAttribute.Description || tableStyleInfo.AttributeName == GovPublicContentAttribute.ImageUrl || tableStyleInfo.AttributeName == GovPublicContentAttribute.FileUrl || tableStyleInfo.AttributeName == GovPublicContentAttribute.Identifier || tableStyleInfo.AttributeName == GovPublicContentAttribute.Keywords || tableStyleInfo.AttributeName == GovPublicContentAttribute.DocumentNo || tableStyleInfo.AttributeName == GovPublicContentAttribute.Publisher)
{
continue;
}
ddlAttributeName.Items.Add(new ListItem(tableStyleInfo.DisplayName + "(" + tableStyleInfo.AttributeName + ")", tableStyleInfo.AttributeName));
}
EBooleanUtils.AddListItems(rblIsSequenceChannelZero);
EBooleanUtils.AddListItems(rblIsSequenceDepartmentZero);
EBooleanUtils.AddListItems(rblIsSequenceYearZero);
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceChannelZero, true.ToString());
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceDepartmentZero, false.ToString());
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceYearZero, true.ToString());
if (_ruleId > 0)
{
var ruleInfo = DataProvider.GovPublicIdentifierRuleDao.GetIdentifierRuleInfo(_ruleId);
if (ruleInfo != null)
{
tbRuleName.Text = ruleInfo.RuleName;
ControlUtils.SelectListItems(ddlIdentifierType, EGovPublicIdentifierTypeUtils.GetValue(ruleInfo.IdentifierType));
ControlUtils.SelectListItems(ddlAttributeName, ruleInfo.AttributeName);
tbMinLength.Text = ruleInfo.MinLength.ToString();
tbFormatString.Text = ruleInfo.FormatString;
tbSuffix.Text = ruleInfo.Suffix;
tbSequence.Text = ruleInfo.Sequence.ToString();
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceChannelZero, ruleInfo.Additional.IsSequenceChannelZero.ToString());
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceDepartmentZero, ruleInfo.Additional.IsSequenceDepartmentZero.ToString());
ControlUtils.SelectListItemsIgnoreCase(rblIsSequenceYearZero, ruleInfo.Additional.IsSequenceYearZero.ToString());
}
}
ddlIdentifierType.SelectedIndexChanged += ddlIdentifierType_SelectedIndexChanged;
ddlIdentifierType_SelectedIndexChanged(null, EventArgs.Empty);
}
}
public void Update(GovPublicIdentifierRuleInfo ruleInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmRuleName, EDataType.NVarChar, 255, ruleInfo.RuleName),
GetParameter(ParmIdentifierType, EDataType.VarChar, 50, EGovPublicIdentifierTypeUtils.GetValue(ruleInfo.IdentifierType)),
GetParameter(ParmMinLength, EDataType.Integer, ruleInfo.MinLength),
GetParameter(ParmSuffix, EDataType.VarChar, 50, ruleInfo.Suffix),
GetParameter(ParmFormatString, EDataType.VarChar, 50, ruleInfo.FormatString),
GetParameter(ParmAttributeName, EDataType.VarChar, 50, ruleInfo.AttributeName),
GetParameter(ParmSequence, EDataType.Integer, ruleInfo.Sequence),
GetParameter(ParmSettingsXml, EDataType.NText, ruleInfo.Additional.ToString()),
GetParameter(ParmRuleId, EDataType.Integer, ruleInfo.RuleID)
};
ExecuteNonQuery(SqlUpdate, parms);
}
public void Insert(GovPublicIdentifierRuleInfo ruleInfo)
{
var taxis = GetMaxTaxis(ruleInfo.PublishmentSystemID) + 1;
var sqlInsert = "INSERT INTO wcm_GovPublicIdentifierRule (RuleName, PublishmentSystemID, IdentifierType, MinLength, Suffix, FormatString, AttributeName, Sequence, Taxis, SettingsXML) VALUES (@RuleName, @PublishmentSystemID, @IdentifierType, @MinLength, @Suffix, @FormatString, @AttributeName, @Sequence, @Taxis, @SettingsXML)";
var parms = new IDataParameter[]
{
GetParameter(ParmRuleName, EDataType.NVarChar, 255, ruleInfo.RuleName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, ruleInfo.PublishmentSystemID),
GetParameter(ParmIdentifierType, EDataType.VarChar, 50, EGovPublicIdentifierTypeUtils.GetValue(ruleInfo.IdentifierType)),
GetParameter(ParmMinLength, EDataType.Integer, ruleInfo.MinLength),
GetParameter(ParmSuffix, EDataType.VarChar, 50, ruleInfo.Suffix),
GetParameter(ParmFormatString, EDataType.VarChar, 50, ruleInfo.FormatString),
GetParameter(ParmAttributeName, EDataType.VarChar, 50, ruleInfo.AttributeName),
GetParameter(ParmSequence, EDataType.Integer, ruleInfo.Sequence),
GetParameter(ParmTaxis, EDataType.Integer, taxis),
GetParameter(ParmSettingsXml, EDataType.NText, ruleInfo.Additional.ToString())
};
ExecuteNonQuery(sqlInsert, parms);
}