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 GovPublicIdentifierRuleInfo GetIdentifierRuleInfo(int ruleId)
{
GovPublicIdentifierRuleInfo ruleInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmRuleId, EDataType.Integer, ruleId)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
var i = 0;
ruleInfo = new GovPublicIdentifierRuleInfo(GetInt(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), EGovPublicIdentifierTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(ruleInfo);
}
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);
}
public ArrayList GetRuleInfoArrayList(int publishmentSystemId)
{
var arraylist = new ArrayList();
var selectParms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(SqlSelectAll, selectParms))
{
while (rdr.Read())
{
var i = 0;
var ruleInfo = new GovPublicIdentifierRuleInfo(GetInt(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), EGovPublicIdentifierTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
arraylist.Add(ruleInfo);
}
rdr.Close();
}
return(arraylist);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var ruleInfoArrayList = DataProvider.GovPublicIdentifierRuleDao.GetRuleInfoArrayList(PublishmentSystemId);
if (_ruleId > 0)
{
try
{
var ruleInfo = DataProvider.GovPublicIdentifierRuleDao.GetIdentifierRuleInfo(_ruleId);
ruleInfo.RuleName = tbRuleName.Text;
ruleInfo.IdentifierType = EGovPublicIdentifierTypeUtils.GetEnumType(ddlIdentifierType.SelectedValue);
ruleInfo.MinLength = TranslateUtils.ToInt(tbMinLength.Text);
ruleInfo.Suffix = tbSuffix.Text;
ruleInfo.FormatString = tbFormatString.Text;
ruleInfo.AttributeName = ddlAttributeName.SelectedValue;
ruleInfo.Sequence = TranslateUtils.ToInt(tbSequence.Text);
if (ruleInfo.IdentifierType == EGovPublicIdentifierType.Sequence)
{
ruleInfo.Additional.IsSequenceChannelZero = TranslateUtils.ToBool(rblIsSequenceChannelZero.SelectedValue);
ruleInfo.Additional.IsSequenceDepartmentZero = TranslateUtils.ToBool(rblIsSequenceDepartmentZero.SelectedValue);
ruleInfo.Additional.IsSequenceYearZero = TranslateUtils.ToBool(rblIsSequenceYearZero.SelectedValue);
}
foreach (GovPublicIdentifierRuleInfo identifierRuleInfo in ruleInfoArrayList)
{
if (identifierRuleInfo.RuleID == ruleInfo.RuleID)
{
continue;
}
if (identifierRuleInfo.IdentifierType != EGovPublicIdentifierType.Attribute && identifierRuleInfo.IdentifierType == ruleInfo.IdentifierType)
{
FailMessage("规则修改失败，本类型规则只能添加一次！");
return;
}
if (identifierRuleInfo.RuleName == tbRuleName.Text)
{
FailMessage("规则修改失败，规则名称已存在！");
return;
}
}
DataProvider.GovPublicIdentifierRuleDao.Update(ruleInfo);
Body.AddSiteLog(PublishmentSystemId, "修改规则", $"规则:{ruleInfo.RuleName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "规则修改失败！");
}
}
else
{
var identifierType = EGovPublicIdentifierTypeUtils.GetEnumType(ddlIdentifierType.SelectedValue);
foreach (GovPublicIdentifierRuleInfo ruleInfo in ruleInfoArrayList)
{
if (ruleInfo.IdentifierType != EGovPublicIdentifierType.Attribute && ruleInfo.IdentifierType == identifierType)
{
FailMessage("规则添加失败，本类型规则只能添加一次！");
return;
}
if (ruleInfo.RuleName == tbRuleName.Text)
{
FailMessage("规则添加失败，规则名称已存在！");
return;
}
}
try
{
var ruleInfo = new GovPublicIdentifierRuleInfo(0, tbRuleName.Text, PublishmentSystemId, identifierType, TranslateUtils.ToInt(tbMinLength.Text), tbSuffix.Text, tbFormatString.Text, ddlAttributeName.SelectedValue, TranslateUtils.ToInt(tbSequence.Text), 0, string.Empty);
if (ruleInfo.IdentifierType == EGovPublicIdentifierType.Sequence)
{
ruleInfo.Additional.IsSequenceChannelZero = TranslateUtils.ToBool(rblIsSequenceChannelZero.SelectedValue);
ruleInfo.Additional.IsSequenceDepartmentZero = TranslateUtils.ToBool(rblIsSequenceDepartmentZero.SelectedValue);
ruleInfo.Additional.IsSequenceYearZero = TranslateUtils.ToBool(rblIsSequenceYearZero.SelectedValue);
}
DataProvider.GovPublicIdentifierRuleDao.Insert(ruleInfo);
Body.AddSiteLog(PublishmentSystemId, "添加规则", $"规则:{ruleInfo.RuleName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "规则添加失败！");
}
}
if (isChanged)
{
PageUtils.CloseModalPageAndRedirect(Page, PageGovPublicIdentifierRule.GetRedirectUrl(PublishmentSystemId));
}
}
