public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_tableStyleId = Body.GetQueryInt("TableStyleID");
_relatedIdentities = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("RelatedIdentities"));
if (_relatedIdentities.Count == 0)
{
_relatedIdentities.Add(0);
}
_tableName = Body.GetQueryString("TableName");
_attributeName = Body.GetQueryString("AttributeName");
_tableStyle = ETableStyleUtils.GetEnumType(Body.GetQueryString("TableStyle"));
_redirectUrl = StringUtils.ValueFromUrl(Body.GetQueryString("RedirectUrl"));
if (_tableStyleId != 0)
{
_styleInfo = BaiRongDataProvider.TableStyleDao.GetTableStyleInfo(_tableStyleId);
}
else
{
_styleInfo = TableStyleManager.GetTableStyleInfo(_tableStyle, _tableName, _attributeName, _relatedIdentities);
}
if (!IsPostBack)
{
IsValidate.Items[0].Value = true.ToString();
IsValidate.Items[1].Value = false.ToString();
ControlUtils.SelectListItems(IsValidate, _styleInfo.Additional.IsValidate.ToString());
IsRequired.Items[0].Value = true.ToString();
IsRequired.Items[1].Value = false.ToString();
ControlUtils.SelectListItems(IsRequired, _styleInfo.Additional.IsRequired.ToString());
if (EInputTypeUtils.EqualsAny(_styleInfo.InputType, EInputType.Text, EInputType.TextArea))
{
phNum.Visible = true;
}
else
{
phNum.Visible = false;
}
MinNum.Text = _styleInfo.Additional.MinNum.ToString();
MaxNum.Text = _styleInfo.Additional.MaxNum.ToString();
EInputValidateTypeUtils.AddListItems(ValidateType);
ControlUtils.SelectListItems(ValidateType, EInputValidateTypeUtils.GetValue(_styleInfo.Additional.ValidateType));
RegExp.Text = _styleInfo.Additional.RegExp;
ErrorMessage.Text = _styleInfo.Additional.ErrorMessage;
Validate_SelectedIndexChanged(null, EventArgs.Empty);
}
}
public static void GetValidateAttributesForListItem(ListControl control, bool isValidate, string displayName, bool isRequire, int minNum, int maxNum, EInputValidateType validateType, string regExp, string errorMessage)
{
if (!isValidate)
{
return;
}
control.Attributes.Add("isValidate", true.ToString().ToLower());
control.Attributes.Add("displayName", displayName);
control.Attributes.Add("isRequire", isRequire.ToString().ToLower());
control.Attributes.Add("minNum", minNum.ToString());
control.Attributes.Add("maxNum", maxNum.ToString());
control.Attributes.Add("validateType", EInputValidateTypeUtils.GetValue(validateType));
control.Attributes.Add("regExp", regExp);
control.Attributes.Add("errorMessage", errorMessage);
control.Attributes.Add("isListItem", true.ToString().ToLower());
}
private bool InsertOrUpdateTableStyleInfo()
{
var isChanged = false;
_styleInfo.Additional.IsValidate = TranslateUtils.ToBool(IsValidate.SelectedValue);
_styleInfo.Additional.IsRequired = TranslateUtils.ToBool(IsRequired.SelectedValue);
_styleInfo.Additional.MinNum = TranslateUtils.ToInt(MinNum.Text);
_styleInfo.Additional.MaxNum = TranslateUtils.ToInt(MaxNum.Text);
_styleInfo.Additional.ValidateType = EInputValidateTypeUtils.GetEnumType(ValidateType.SelectedValue);
_styleInfo.Additional.RegExp = RegExp.Text.Trim('/');
_styleInfo.Additional.ErrorMessage = ErrorMessage.Text;
try
{
if (_tableStyleId == 0)//数据库中没有此项的表样式，但是有父项的表样式
{
var relatedIdentity = (int)_relatedIdentities[0];
_styleInfo.RelatedIdentity = relatedIdentity;
_styleInfo.TableStyleId = TableStyleManager.Insert(_styleInfo, _tableStyle);
}
if (_styleInfo.TableStyleId > 0)
{
TableStyleManager.Update(_styleInfo);
Body.AddSiteLog(PublishmentSystemId, "修改表单验证", $"类型:{ETableStyleUtils.GetText(_tableStyle)},字段:{_styleInfo.AttributeName}");
}
else
{
TableStyleManager.Insert(_styleInfo, _tableStyle);
Body.AddSiteLog(PublishmentSystemId, "新增表单验证", $"类型:{ETableStyleUtils.GetText(_tableStyle)},字段:{_styleInfo.AttributeName}");
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "设置表单验证失败：" + ex.Message);
}
return(isChanged);
}
public void Validate_SelectedIndexChanged(object sender, EventArgs e)
{
if (EBooleanUtils.Equals(EBoolean.False, IsValidate.SelectedValue))
{
phValidate.Visible = false;
}
else
{
phValidate.Visible = true;
}
var type = EInputValidateTypeUtils.GetEnumType(ValidateType.SelectedValue);
if (type == EInputValidateType.Custom)
{
phRegExp.Visible = true;
}
else
{
phRegExp.Visible = false;
}
}
void dgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var styleInfo = e.Item.DataItem as TableStyleInfo;
var ltlAttributeName = e.Item.FindControl("ltlAttributeName") as Literal;
var ltlDataType = e.Item.FindControl("ltlDataType") as Literal;
var ltlDisplayName = e.Item.FindControl("ltlDisplayName") as Literal;
var ltlInputType = e.Item.FindControl("ltlInputType") as Literal;
var ltlFieldType = e.Item.FindControl("ltlFieldType") as Literal;;
var ltlIsVisible = e.Item.FindControl("ltlIsVisible") as Literal;
var ltlValidate = e.Item.FindControl("ltlValidate") as Literal;
var ltlEditStyle = e.Item.FindControl("ltlEditStyle") as Literal;
var ltlEditValidate = e.Item.FindControl("ltlEditValidate") as Literal;
var upLinkButton = e.Item.FindControl("UpLinkButton") as HyperLink;
var downLinkButton = e.Item.FindControl("DownLinkButton") as HyperLink;
var showPopWinString = ModalTableMetadataView.GetOpenWindowString(_modelInfo.TableType,
_modelInfo.TableName, styleInfo.AttributeName);
ltlAttributeName.Text =
$"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">{styleInfo.AttributeName}</a>";
ltlDisplayName.Text = styleInfo.DisplayName;
ltlInputType.Text = EInputTypeUtils.GetText(EInputTypeUtils.GetEnumType(styleInfo.InputType));
if (TableManager.IsAttributeNameExists(_tableStyle, _modelInfo.TableName, styleInfo.AttributeName))
{
ltlFieldType.Text =
$"真实 {TableManager.GetTableMetadataDataType(_modelInfo.TableName, styleInfo.AttributeName)}";
}
else
{
ltlFieldType.Text = "虚拟字段";
}
ltlIsVisible.Text = StringUtils.GetTrueOrFalseImageHtml(styleInfo.IsVisible.ToString());
ltlValidate.Text = EInputValidateTypeUtils.GetValidateInfo(styleInfo);
showPopWinString = ModalTableStyleAdd.GetOpenWindowString(PublishmentSystemId, styleInfo.TableStyleId, _relatedIdentities, _modelInfo.TableName, styleInfo.AttributeName, _tableStyle, _redirectUrl);
var editText = "添加";
if (styleInfo.RelatedIdentity == _nodeInfo.NodeId)//数据库中有样式
{
editText = "修改";
}
ltlEditStyle.Text = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">{editText}</a>";
showPopWinString = ModalTableStyleValidateAdd.GetOpenWindowString(styleInfo.TableStyleId, _relatedIdentities, _modelInfo.TableName, styleInfo.AttributeName, _tableStyle, _redirectUrl);
ltlEditValidate.Text = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">设置</a>";
if (styleInfo.RelatedIdentity == _nodeInfo.NodeId)//数据库中有样式
{
var urlStyle = PageUtils.GetCmsUrl(nameof(PageTableStyleContent), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "DeleteStyle", true.ToString() },
{ "TableName", _modelInfo.TableName },
{ "AttributeName", styleInfo.AttributeName }
});
ltlEditStyle.Text +=
$@" <a href=""{urlStyle}"" onClick=""javascript:return confirm('此操作将删除对应显示样式，确认吗？');"">删除</a>";
}
var isTaxisVisible = true;
//if (TableStyleManager.IsMetadata(this.tableStyle, styleInfo.AttributeName) || styleInfo.RelatedIdentity != this.nodeInfo.NodeID)
//{
// isTaxisVisible = false;
//}
//else
//{
isTaxisVisible = !TableStyleManager.IsExistsInParents(_relatedIdentities, _modelInfo.TableName, styleInfo.AttributeName);
//}
if (!isTaxisVisible)
{
upLinkButton.Visible = downLinkButton.Visible = false;
}
else
{
var tableMetadataId = BaiRongDataProvider.TableMetadataDao.GetTableMetadataId(styleInfo.TableName, styleInfo.AttributeName);
upLinkButton.NavigateUrl = PageUtils.GetCmsUrl(nameof(PageTableStyleContent), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "SetTaxis", true.ToString() },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "UP" },
{ "TableMetadataId", tableMetadataId.ToString() }
});
downLinkButton.NavigateUrl = PageUtils.GetCmsUrl(nameof(PageTableStyleContent), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "SetTaxis", true.ToString() },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "DOWN" },
{ "TableMetadataId", tableMetadataId.ToString() }
});
}
}
}
public static string GetValidateAttributes(bool isValidate, string displayName, bool isRequire, int minNum, int maxNum, EInputValidateType validateType, string regExp, string errorMessage)
{
if (isValidate)
{
return
($@"isValidate=""{true.ToString().ToLower()}"" displayName=""{displayName}"" isRequire=""{isRequire
.ToString().ToLower()}"" minNum=""{minNum}"" maxNum=""{maxNum}"" validateType=""{EInputValidateTypeUtils
.GetValue(validateType)}"" regExp=""{regExp}"" errorMessage=""{errorMessage}""");
}
return(string.Empty);
}
void dgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var tableMetadataId = SqlUtils.EvalInt(e.Item.DataItem, "TableMetadataID");
var attributeName = SqlUtils.EvalString(e.Item.DataItem, "AttributeName");
var dataType = SqlUtils.EvalString(e.Item.DataItem, "DataType");
var dataLength = SqlUtils.EvalInt(e.Item.DataItem, "DataLength");
var isSystem = SqlUtils.EvalString(e.Item.DataItem, "IsSystem");
var ltlAttributeName = e.Item.FindControl("ltlAttributeName") as Literal;
var ltlDisplayName = e.Item.FindControl("ltlDisplayName") as Literal;
var ltlIsVisible = e.Item.FindControl("ltlIsVisible") as Literal;
var ltlValidate = e.Item.FindControl("ltlValidate") as Literal;
var ltlDataType = e.Item.FindControl("ltlDataType") as Literal;
var ltlInputType = e.Item.FindControl("ltlInputType") as Literal;
var upLinkButton = e.Item.FindControl("UpLinkButton") as HyperLink;
var downLinkButton = e.Item.FindControl("DownLinkButton") as HyperLink;
var ltlStyle = e.Item.FindControl("ltlStyle") as Literal;
var ltlEditValidate = e.Item.FindControl("ltlEditValidate") as Literal;
var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal;
var ltlDeleteUrl = e.Item.FindControl("ltlDeleteUrl") as Literal;
var showPopWinString = ModalTableMetadataView.GetOpenWindowString(_tableType, _tableName, attributeName);
ltlAttributeName.Text =
$"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">{attributeName}</a>";
var styleInfo = TableStyleManager.GetTableStyleInfo(EAuxiliaryTableTypeUtils.GetTableStyle(_tableType), _tableName, attributeName, null);
ltlDisplayName.Text = styleInfo.DisplayName;
ltlIsVisible.Text = StringUtils.GetTrueOrFalseImageHtml(styleInfo.IsVisible.ToString());
ltlValidate.Text = EInputValidateTypeUtils.GetValidateInfo(styleInfo);
ltlDataType.Text = EDataTypeUtils.GetTextByAuxiliaryTable(EDataTypeUtils.GetEnumType(dataType), dataLength);
ltlInputType.Text = EInputTypeUtils.GetText(EInputTypeUtils.GetEnumType(styleInfo.InputType));
if (IsSystem(isSystem))
{
if (upLinkButton != null)
{
upLinkButton.NavigateUrl = PageUtils.GetSysUrl(nameof(PageTableMetadata),
new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "SetTaxis", "True" },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "UP" },
{ "TableMetadataId", tableMetadataId.ToString() },
{ "ENName", _tableName },
{ "TableType", EAuxiliaryTableTypeUtils.GetValue(_tableType) }
});
}
if (downLinkButton != null)
{
downLinkButton.NavigateUrl = PageUtils.GetSysUrl(nameof(PageTableMetadata),
new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "SetTaxis", "True" },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "DOWN" },
{ "TableMetadataId", tableMetadataId.ToString() },
{ "ENName", _tableName },
{ "TableType", EAuxiliaryTableTypeUtils.GetValue(_tableType) }
});
}
}
ltlStyle.Text = GetEditStyleHtml(tableMetadataId, attributeName);
showPopWinString = ModalTableStyleValidateAdd.GetOpenWindowString(styleInfo.TableStyleId, _tableName, styleInfo.AttributeName, EAuxiliaryTableTypeUtils.GetTableStyle(_tableType), _redirectUrl);
ltlEditValidate.Text = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">设置</a>";
ltlEditUrl.Text = GetEditHtml(isSystem, tableMetadataId);
if (!IsSystem(isSystem))
{
var attributes = new NameValueCollection
{
{ "Delete", true.ToString() },
{ "TableMetadataID", tableMetadataId.ToString() }
};
var deleteUrl = PageUtils.AddQueryString(_redirectUrl, attributes);
ltlDeleteUrl.Text =
$@"<a href=""{deleteUrl}"" onClick=""javascript:return confirm('此操作将删除辅助字段“{attributeName}”，确认吗？');"">删除字段</a>";
}
}
}
private void DgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem)
{
return;
}
var styleInfo = (TableStyleInfo)e.Item.DataItem;
var ltlAttributeName = (Literal)e.Item.FindControl("ltlAttributeName");
var ltlDisplayName = (Literal)e.Item.FindControl("ltlDisplayName");
var ltlInputType = (Literal)e.Item.FindControl("ltlInputType");
var ltlFieldType = (Literal)e.Item.FindControl("ltlFieldType");
var ltlIsVisible = (Literal)e.Item.FindControl("ltlIsVisible");
var ltlValidate = (Literal)e.Item.FindControl("ltlValidate");
var ltlEditStyle = (Literal)e.Item.FindControl("ltlEditStyle");
var ltlEditValidate = (Literal)e.Item.FindControl("ltlEditValidate");
var upLinkButton = (HyperLink)e.Item.FindControl("UpLinkButton");
var downLinkButton = (HyperLink)e.Item.FindControl("DownLinkButton");
ltlAttributeName.Text = styleInfo.AttributeName;
ltlDisplayName.Text = styleInfo.DisplayName;
ltlInputType.Text = EInputTypeUtils.GetText(EInputTypeUtils.GetEnumType(styleInfo.InputType));
ltlFieldType.Text = "虚拟字段";
ltlIsVisible.Text = StringUtils.GetTrueOrFalseImageHtml(styleInfo.IsVisible.ToString());
ltlValidate.Text = EInputValidateTypeUtils.GetValidateInfo(styleInfo);
string showPopWinString = ModalTableStyleAdd.GetOpenWindowString(PublishmentSystemId, styleInfo.TableStyleId, _relatedIdentities, _tableName, styleInfo.AttributeName, ETableStyle.Channel, _redirectUrl);
var editText = "添加";
if (styleInfo.RelatedIdentity == _nodeInfo.NodeId)//数据库中有样式
{
editText = "修改";
}
ltlEditStyle.Text = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">{editText}</a>";
showPopWinString = ModalTableStyleValidateAdd.GetOpenWindowString(styleInfo.TableStyleId, _relatedIdentities, _tableName, styleInfo.AttributeName, ETableStyle.Channel, _redirectUrl);
ltlEditValidate.Text = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">设置</a>";
if (styleInfo.RelatedIdentity == _nodeInfo.NodeId)//数据库中有样式
{
var urlStyle = PageUtils.GetCmsUrl(nameof(PageTableStyleChannel), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "DeleteStyle", true.ToString() },
{ "TableName", _tableName },
{ "AttributeName", styleInfo.AttributeName }
});
ltlEditStyle.Text +=
$@" <a href=""{urlStyle}"" onClick=""javascript:return confirm('此操作将删除对应显示样式，确认吗？');"">删除</a>";
}
bool isTaxisVisible;
if (styleInfo.RelatedIdentity != _nodeInfo.NodeId)
{
isTaxisVisible = false;
}
else
{
isTaxisVisible = !TableStyleManager.IsExistsInParents(_relatedIdentities, _tableName, styleInfo.AttributeName);
}
if (!isTaxisVisible)
{
upLinkButton.Visible = downLinkButton.Visible = false;
}
else
{
upLinkButton.NavigateUrl = PageUtils.GetCmsUrl(nameof(PageTableStyleChannel), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "SetTaxis", true.ToString() },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "UP" }
});
downLinkButton.NavigateUrl = PageUtils.GetCmsUrl(nameof(PageTableStyleChannel), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "NodeID", _nodeInfo.NodeId.ToString() },
{ "SetTaxis", true.ToString() },
{ "TableStyleID", styleInfo.TableStyleId.ToString() },
{ "Direction", "DOWN" }
});
}
}
