public int Insert(IdentifierRuleInfo ruleInfo)
{
ruleInfo.Taxis = GetMaxTaxis(ruleInfo.SiteId) + 1;
return(_repository.Insert(ruleInfo));
// var sqlString = $@"INSERT INTO {TableName}
// (
// {nameof(IdentifierRuleInfo.SiteId)},
// {nameof(IdentifierRuleInfo.RuleName)},
// {nameof(IdentifierRuleInfo.IdentifierType)},
// {nameof(IdentifierRuleInfo.MinLength)},
// {nameof(IdentifierRuleInfo.Suffix)},
// {nameof(IdentifierRuleInfo.FormatString)},
// {nameof(IdentifierRuleInfo.AttributeName)},
// {nameof(IdentifierRuleInfo.Sequence)},
// {nameof(IdentifierRuleInfo.Taxis)},
// {nameof(IdentifierRuleInfo.IsSequenceChannelZero)},
// {nameof(IdentifierRuleInfo.IsSequenceDepartmentZero)},
// {nameof(IdentifierRuleInfo.IsSequenceYearZero)}
// ) VALUES (
// @{nameof(IdentifierRuleInfo.SiteId)},
// @{nameof(IdentifierRuleInfo.RuleName)},
// @{nameof(IdentifierRuleInfo.IdentifierType)},
// @{nameof(IdentifierRuleInfo.MinLength)},
// @{nameof(IdentifierRuleInfo.Suffix)},
// @{nameof(IdentifierRuleInfo.FormatString)},
// @{nameof(IdentifierRuleInfo.AttributeName)},
// @{nameof(IdentifierRuleInfo.Sequence)},
// @{nameof(IdentifierRuleInfo.Taxis)},
// @{nameof(IdentifierRuleInfo.IsSequenceChannelZero)},
// @{nameof(IdentifierRuleInfo.IsSequenceDepartmentZero)},
// @{nameof(IdentifierRuleInfo.IsSequenceYearZero)}
// )";
// var parameters = new[]
// {
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.SiteId), ruleInfo.SiteId),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.RuleName), ruleInfo.RuleName),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IdentifierType), ruleInfo.IdentifierType),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.MinLength), ruleInfo.MinLength),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Suffix), ruleInfo.Suffix),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.FormatString), ruleInfo.FormatString),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.AttributeName), ruleInfo.AttributeName),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Sequence), ruleInfo.Sequence),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Taxis), ruleInfo.Taxis),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceChannelZero), ruleInfo.IsSequenceChannelZero),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceDepartmentZero), ruleInfo.IsSequenceDepartmentZero),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceYearZero), ruleInfo.IsSequenceYearZero)
// };
// return Context.DatabaseApi.ExecuteNonQueryAndReturnId(TableName, nameof(IdentifierRuleInfo.Id), Context.ConnectionString, sqlString, parameters);
}
public void Update(IdentifierRuleInfo ruleInfo)
{
_repository.Update(ruleInfo);
// var sqlString = $@"UPDATE {TableName} SET
// {nameof(IdentifierRuleInfo.SiteId)} = @{nameof(IdentifierRuleInfo.SiteId)},
// {nameof(IdentifierRuleInfo.RuleName)} = @{nameof(IdentifierRuleInfo.RuleName)},
// {nameof(IdentifierRuleInfo.IdentifierType)} = @{nameof(IdentifierRuleInfo.IdentifierType)},
// {nameof(IdentifierRuleInfo.MinLength)} = @{nameof(IdentifierRuleInfo.MinLength)},
// {nameof(IdentifierRuleInfo.Suffix)} = @{nameof(IdentifierRuleInfo.Suffix)},
// {nameof(IdentifierRuleInfo.FormatString)} = @{nameof(IdentifierRuleInfo.FormatString)},
// {nameof(IdentifierRuleInfo.AttributeName)} = @{nameof(IdentifierRuleInfo.AttributeName)},
// {nameof(IdentifierRuleInfo.Sequence)} = @{nameof(IdentifierRuleInfo.Sequence)},
// {nameof(IdentifierRuleInfo.Taxis)} = @{nameof(IdentifierRuleInfo.Taxis)},
// {nameof(IdentifierRuleInfo.IsSequenceChannelZero)} = @{nameof(IdentifierRuleInfo.IsSequenceChannelZero)},
// {nameof(IdentifierRuleInfo.IsSequenceDepartmentZero)} = @{nameof(IdentifierRuleInfo.IsSequenceDepartmentZero)},
// {nameof(IdentifierRuleInfo.IsSequenceYearZero)} = @{nameof(IdentifierRuleInfo.IsSequenceYearZero)}
// WHERE {nameof(IdentifierRuleInfo.Id)} = @{nameof(IdentifierRuleInfo.Id)}";
// var parameters = new[]
// {
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.SiteId), ruleInfo.SiteId),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.RuleName), ruleInfo.RuleName),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IdentifierType), ruleInfo.IdentifierType),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.MinLength), ruleInfo.MinLength),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Suffix), ruleInfo.Suffix),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.FormatString), ruleInfo.FormatString),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.AttributeName), ruleInfo.AttributeName),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Sequence), ruleInfo.Sequence),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Taxis), ruleInfo.Taxis),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceChannelZero), ruleInfo.IsSequenceChannelZero),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceDepartmentZero), ruleInfo.IsSequenceDepartmentZero),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.IsSequenceYearZero), ruleInfo.IsSequenceYearZero),
// Context.DatabaseApi.GetParameter(nameof(IdentifierRuleInfo.Id), ruleInfo.Id)
// };
// Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString, parameters);
}
public void Submit_OnClick(object sender, EventArgs e)
{
var ruleInfoList = Main.IdentifierRuleRepository.GetRuleInfoList(SiteId);
if (_ruleId > 0)
{
var ruleInfo = Main.IdentifierRuleRepository.GetIdentifierRuleInfo(_ruleId);
var identifierType = EIdentifierTypeUtils.GetEnumType(ruleInfo.IdentifierType);
ruleInfo.RuleName = TbRuleName.Text;
ruleInfo.IdentifierType = 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 (identifierType == EIdentifierType.Sequence)
{
ruleInfo.IsSequenceChannelZero = TranslateUtils.ToBool(DdlIsSequenceChannelZero.SelectedValue);
ruleInfo.IsSequenceDepartmentZero = TranslateUtils.ToBool(DdlIsSequenceDepartmentZero.SelectedValue);
ruleInfo.IsSequenceYearZero = TranslateUtils.ToBool(DdlIsSequenceYearZero.SelectedValue);
}
foreach (var identifierRuleInfo in ruleInfoList)
{
if (identifierRuleInfo.Id == ruleInfo.Id)
{
continue;
}
if (identifierType != EIdentifierType.Attribute && identifierRuleInfo.IdentifierType == ruleInfo.IdentifierType)
{
LtlMessage.Text = Utils.GetMessageHtml("规则修改失败，本类型规则只能添加一次！", false);
return;
}
if (identifierRuleInfo.RuleName == TbRuleName.Text)
{
LtlMessage.Text = Utils.GetMessageHtml("规则修改失败，规则名称已存在！", false);
return;
}
}
Main.IdentifierRuleRepository.Update(ruleInfo);
}
else
{
var identifierType = EIdentifierTypeUtils.GetEnumType(DdlIdentifierType.SelectedValue);
foreach (var thrRuleInfo in ruleInfoList)
{
var ruleIdentifierType = EIdentifierTypeUtils.GetEnumType(thrRuleInfo.IdentifierType);
if (identifierType != EIdentifierType.Attribute && identifierType == ruleIdentifierType)
{
LtlMessage.Text = Utils.GetMessageHtml("规则添加失败，本类型规则只能添加一次！", false);
return;
}
if (thrRuleInfo.RuleName == TbRuleName.Text)
{
LtlMessage.Text = Utils.GetMessageHtml("规则添加失败，规则名称已存在！", false);
return;
}
}
var ruleInfo = new IdentifierRuleInfo
{
SiteId = SiteId,
RuleName = TbRuleName.Text,
IdentifierType = EIdentifierTypeUtils.GetValue(identifierType),
MinLength = TranslateUtils.ToInt(TbMinLength.Text),
Suffix = TbSuffix.Text,
FormatString = TbFormatString.Text,
AttributeName = DdlAttributeName.SelectedValue,
Sequence = TranslateUtils.ToInt(TbSequence.Text)
};
if (identifierType == EIdentifierType.Sequence)
{
ruleInfo.IsSequenceChannelZero = TranslateUtils.ToBool(DdlIsSequenceChannelZero.SelectedValue);
ruleInfo.IsSequenceDepartmentZero = TranslateUtils.ToBool(DdlIsSequenceDepartmentZero.SelectedValue);
ruleInfo.IsSequenceYearZero = TranslateUtils.ToBool(DdlIsSequenceYearZero.SelectedValue);
}
Main.IdentifierRuleRepository.Insert(ruleInfo);
}
Utils.CloseModalPage(Page);
}
