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