public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_tableName = DataProvider.SiteDao.TableName;
_itemId = AuthRequest.GetQueryInt("itemID");
_relatedIdentities = TableStyleManager.GetRelatedIdentities(SiteId);
_attributeNames = TableColumnManager.GetTableColumnNameList(_tableName);
_returnUrl = StringUtils.ValueFromUrl(AuthRequest.GetQueryString("ReturnUrl"));
if (IsPostBack)
{
return;
}
VerifySitePermissions(ConfigManager.WebSitePermissions.Configration);
//删除样式
if (AuthRequest.IsQueryExists("DeleteStyle"))
{
var attributeName = AuthRequest.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(SiteId, _tableName, attributeName))
{
try
{
DataProvider.TableStyleDao.Delete(SiteId, _tableName, attributeName);
AuthRequest.AddSiteLog(SiteId, "删除数据表单样式", $"表单:{_tableName},字段:{attributeName}");
SuccessDeleteMessage();
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
if (!string.IsNullOrEmpty(_returnUrl))
{
BtnReturn.Attributes.Add("onclick", $"location.href='{_returnUrl}';return false;");
}
else
{
BtnReturn.Visible = false;
}
RptContents.DataSource = TableStyleManager.GetSiteStyleInfoList(SiteId);
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
var redirectUrl = GetRedirectUrl(SiteId, _itemId, _returnUrl);
BtnAddStyle.Attributes.Add("onclick", ModalTableStyleAdd.GetOpenWindowString(SiteId, 0, _relatedIdentities, _tableName, string.Empty, redirectUrl));
BtnAddStyles.Attributes.Add("onclick", ModalTableStylesAdd.GetOpenWindowString(SiteId, _relatedIdentities, _tableName, redirectUrl));
BtnImport.Attributes.Add("onclick", ModalTableStyleImport.GetOpenWindowString(_tableName, SiteId, SiteId));
BtnExport.Attributes.Add("onclick", ModalExportMessage.GetOpenWindowStringToSingleTableStyle(_tableName, SiteId, SiteId));
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
var channelId = AuthRequest.GetQueryInt("channelId", SiteId);
_channelInfo = ChannelManager.GetChannelInfo(SiteId, channelId);
_tableName = ChannelManager.GetTableName(SiteInfo, _channelInfo);
_redirectUrl = GetRedirectUrl(SiteId, channelId);
_relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(SiteId, channelId);
if (IsPostBack)
{
return;
}
VerifySitePermissions(ConfigManager.WebSitePermissions.Configration);
//删除样式
if (AuthRequest.IsQueryExists("DeleteStyle"))
{
var attributeName = AuthRequest.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(_channelInfo.Id, _tableName, attributeName))
{
try
{
TableStyleManager.Delete(_channelInfo.Id, _tableName, attributeName);
AuthRequest.AddSiteLog(SiteId, "删除数据表单样式", $"表单:{_tableName},字段:{attributeName}");
SuccessDeleteMessage();
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
InfoMessage(
$"在此编辑内容模型字段,子栏目默认继承父栏目字段设置; 内容表:{DataProvider.TableDao.GetDisplayName(_tableName)}({_tableName})");
ChannelManager.AddListItems(DdlChannelId.Items, SiteInfo, false, true, AuthRequest.AdminPermissions);
ControlUtils.SelectSingleItem(DdlChannelId, channelId.ToString());
RptContents.DataSource = TableStyleManager.GetTableStyleInfoList(_tableName, _relatedIdentities);
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
BtnAddStyle.Attributes.Add("onclick", ModalTableStyleAdd.GetOpenWindowString(SiteId, 0, _relatedIdentities, _tableName, string.Empty, _redirectUrl));
BtnAddStyles.Attributes.Add("onclick", ModalTableStylesAdd.GetOpenWindowString(SiteId, _relatedIdentities, _tableName, _redirectUrl));
BtnImport.Attributes.Add("onclick", ModalTableStyleImport.GetOpenWindowString(_tableName, SiteId, channelId));
BtnExport.Attributes.Add("onclick", ModalExportMessage.GetOpenWindowStringToSingleTableStyle(_tableName, SiteId, channelId));
}
public static void SingleImportTableStyle(ETableStyle tableStyle, string tableName, string styleDirectoryPath, int relatedIdentity)
{
if (!DirectoryUtils.IsDirectoryExists(styleDirectoryPath))
{
return;
}
var filePaths = DirectoryUtils.GetFilePaths(styleDirectoryPath);
foreach (var filePath in filePaths)
{
var feed = AtomFeed.Load(FileUtils.GetFileStreamReadOnly(filePath));
var attributeName = AtomUtility.GetDcElementContent(feed.AdditionalElements, "AttributeName");
var taxis = TranslateUtils.ToInt(AtomUtility.GetDcElementContent(feed.AdditionalElements, "Taxis"), 0);
var displayName = AtomUtility.GetDcElementContent(feed.AdditionalElements, "DisplayName");
var helpText = AtomUtility.GetDcElementContent(feed.AdditionalElements, "HelpText");
var isVisible = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsVisible"));
var isVisibleInList = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsVisibleInList"));
var isSingleLine = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsSingleLine"));
var inputType = EInputTypeUtils.GetEnumType(AtomUtility.GetDcElementContent(feed.AdditionalElements, "InputType"));
var defaultValue = AtomUtility.GetDcElementContent(feed.AdditionalElements, "DefaultValue");
var isHorizontal = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsHorizontal"));
//SettingsXML
var extendValues = AtomUtility.GetDcElementContent(feed.AdditionalElements, "ExtendValues");
var styleInfo = new TableStyleInfo(0, relatedIdentity, tableName, attributeName, taxis, displayName, helpText, isVisible, isVisibleInList, isSingleLine, EInputTypeUtils.GetValue(inputType), defaultValue, isHorizontal, extendValues);
var styleItems = new List <TableStyleItemInfo>();
foreach (AtomEntry entry in feed.Entries)
{
var itemTitle = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ItemTitle");
var itemValue = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ItemValue");
var isSelected = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(entry.AdditionalElements, "IsSelected"));
styleItems.Add(new TableStyleItemInfo(0, 0, itemTitle, itemValue, isSelected));
}
if (styleItems.Count > 0)
{
styleInfo.StyleItems = styleItems;
}
if (TableStyleManager.IsExists(relatedIdentity, tableName, attributeName))
{
TableStyleManager.Delete(relatedIdentity, tableName, attributeName);
}
TableStyleManager.InsertWithTaxis(styleInfo, tableStyle);
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_tableName = Body.GetQueryString("tableName");
_redirectUrl = GetRedirectUrl(_tableName);
if (IsPostBack)
{
return;
}
VerifyAdministratorPermissions(ConfigManager.Permissions.Settings.Site);
if (Body.IsQueryExists("DeleteStyle"))
{
var attributeName = Body.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(0, _tableName, attributeName))
{
TableStyleManager.Delete(0, _tableName, attributeName);
Body.AddAdminLog("删除数据表单样式", $"表单:{_tableName},字段:{attributeName}");
SuccessDeleteMessage();
}
}
var styleInfoList = TableStyleManager.GetTableStyleInfoList(_tableName, new List <int> {
0
});
RptContents.DataSource = styleInfoList;
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
BtnAddStyle.Attributes.Add("onclick", ModalTableStyleAdd.GetOpenWindowString(0, 0, new List <int> {
0
}, _tableName, string.Empty, _redirectUrl));
BtnAddStyles.Attributes.Add("onclick",
ModalTableStylesAdd.GetOpenWindowString(0, new List <int> {
0
}, _tableName, _redirectUrl));
BtnImport.Attributes.Add("onclick", ModalTableStyleImport.GetOpenWindowString(_tableName, 0, 0));
BtnExport.Attributes.Add("onclick", ModalExportMessage.GetOpenWindowStringToSingleTableStyle(_tableName));
}
private void DeleteStyle()
{
var attributeName = Body.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(_nodeInfo.NodeId, _modelInfo.TableName, attributeName))
{
try
{
TableStyleManager.Delete(_nodeInfo.NodeId, _modelInfo.TableName, attributeName);
Body.AddSiteLog(PublishmentSystemId, "删除数据表单样式", $"表单:{_modelInfo.TableName},字段:{attributeName}");
SuccessDeleteMessage();
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
private void DeleteStyle()
{
var attributeName = Body.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(0, _tableName, attributeName))
{
try
{
TableStyleManager.Delete(0, _tableName, attributeName);
Body.AddAdminLog("删除数据表单样式", $"表单:{_tableName},字段:{attributeName}");
SuccessDeleteMessage();
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("ENName");
_showSqlTable = AuthRequest.IsQueryExists("ShowCrateDBCommand");
_tableName = AuthRequest.GetQueryString("ENName").Trim();
_redirectUrl = GetRedirectUrl(_tableName);
var tableInfo = DataProvider.TableDao.GetTableCollectionInfo(_tableName);
if (AuthRequest.IsQueryExists("Delete"))
{
var tableMetadataId = AuthRequest.GetQueryInt("TableMetadataID");
try
{
var tableMetadataInfo = DataProvider.TableMetadataDao.GetTableMetadataInfo(tableMetadataId);
DataProvider.TableMetadataDao.Delete(tableMetadataId);
AuthRequest.AddAdminLog("删除辅助表字段", $"辅助表:{_tableName},字段名:{tableMetadataInfo.AttributeName}");
SuccessDeleteMessage();
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
else if (AuthRequest.IsQueryExists("DeleteStyle"))//删除样式
{
var attributeName = AuthRequest.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(0, _tableName, attributeName))
{
try
{
TableStyleManager.Delete(0, _tableName, attributeName);
AuthRequest.AddAdminLog("删除辅助表字段样式", $"辅助表:{_tableName},字段名:{attributeName}");
SuccessDeleteMessage();
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
else if (AuthRequest.IsQueryExists("CreateDB"))
{
try
{
DataProvider.TableDao.CreateDbTable(_tableName);
tableInfo.IsChangedAfterCreatedInDb = false;
AuthRequest.AddAdminLog("创建辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表创建成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表创建失败，失败原因为：" + ex.Message + "<br>请检查创建表SQL命令");
var sqlString = DataProvider.ContentDao.GetCreateTableCollectionInfoSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
_showSqlTable = true;
}
}
else if (AuthRequest.IsQueryExists("DeleteDB"))
{
try
{
DataProvider.TableDao.DeleteDbTable(_tableName);
tableInfo.IsChangedAfterCreatedInDb = false;
AuthRequest.AddAdminLog("删除辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表删除成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表删除失败，失败原因为：" + ex.Message + "<br>");
}
}
else if (AuthRequest.IsQueryExists("ReCreateDB"))
{
try
{
DataProvider.TableDao.ReCreateDbTable(_tableName);
DataProvider.ChannelDao.UpdateContentNumToZero(_tableName);
tableInfo.IsChangedAfterCreatedInDb = false;
AuthRequest.AddAdminLog("重建辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表重建成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表重建失败，失败原因为：" + ex.Message + "<br>请检查创建表SQL命令");
var sqlString = DataProvider.ContentDao.GetCreateTableCollectionInfoSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
_showSqlTable = true;
}
}
else if (AuthRequest.IsQueryExists("ShowCrateDBCommand"))
{
var sqlString = DataProvider.ContentDao.GetCreateTableCollectionInfoSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
}
else if (AuthRequest.IsQueryExists("SetTaxis"))
{
var direction = AuthRequest.GetQueryString("Direction");
var tableMetadataId = AuthRequest.GetQueryInt("TableMetadataId");
switch (direction.ToUpper())
{
case "UP":
DataProvider.TableMetadataDao.TaxisDown(tableMetadataId, _tableName);
break;
case "DOWN":
DataProvider.TableMetadataDao.TaxisUp(tableMetadataId, _tableName);
break;
}
SuccessMessage("排序成功！");
}
_tableIsRealCreated = DataProvider.DatabaseDao.IsTableExists(_tableName);
_isTableUsed = DataProvider.SiteDao.IsTableUsed(_tableName);
PhSyncTable.Visible = _tableIsRealCreated && tableInfo.IsChangedAfterCreatedInDb;
PhSqlString.Visible = _showSqlTable;
if (IsPostBack)
{
return;
}
VerifyAdministratorPermissions(ConfigManager.SettingsPermissions.Site);
RptContents.DataSource = DataProvider.TableMetadataDao.GetDataSource(_tableName);
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
BtnAdd.Attributes.Add("onclick", ModalTableMetadataAdd.GetOpenWindowStringToAdd(_tableName));
var redirectUrl = GetRedirectUrl(_tableName);
bool isBtnCreateDb;
if (string.IsNullOrEmpty(_tableName))
{
isBtnCreateDb = false;
}
else
{
isBtnCreateDb = !_tableIsRealCreated;
}
if (isBtnCreateDb)
{
BtnCreateDb.Attributes.Add("onclick", $"location.href='{redirectUrl}&CreateDB={true}';return false;");
}
else
{
BtnCreateDb.Visible = false;
}
bool isBtnDelete;
if (_tableName == null)
{
isBtnDelete = false;
}
else
{
isBtnDelete = !_isTableUsed;
}
if (isBtnDelete)
{
BtnDelete.Attributes.Add("onclick", $"if (confirm('此操作将删除辅助表“{_tableName}”，确认吗？'))location.href='{redirectUrl}&DeleteDB={true}';return false;");
}
else
{
BtnDelete.Visible = false;
}
if (isBtnCreateDb)
{
BtnReCreateDb.Attributes.Add("onclick", $"if (confirm('此操作将覆盖已建立的辅助表，表中已存数据将丢失，确认吗？'))location.href='{redirectUrl}&ReCreateDB={true}';return false;");
}
else
{
BtnReCreateDb.Visible = false;
}
var isSqlString = !string.IsNullOrEmpty(_tableName);
if (isSqlString)
{
BtnSqlString.Attributes.Add("onclick", $"location.href='{redirectUrl}&ShowCrateDBCommand={true}';return false;");
}
else
{
BtnSqlString.Visible = false;
}
}
private bool InsertTableStyleInfo(InputType inputType)
{
var isChanged = false;
var attributeNameArray = TbAttributeNames.Text.Split('\n');
var relatedIdentity = _relatedIdentities[0];
var styleInfoArrayList = new ArrayList();
foreach (var itemString in attributeNameArray)
{
if (string.IsNullOrEmpty(itemString))
{
continue;
}
var attributeName = itemString;
var displayName = string.Empty;
if (StringUtils.Contains(itemString, "(") && StringUtils.Contains(itemString, ")"))
{
var length = itemString.IndexOf(')') - itemString.IndexOf('(');
if (length > 0)
{
displayName = itemString.Substring(itemString.IndexOf('(') + 1, length);
attributeName = itemString.Substring(0, itemString.IndexOf('('));
}
}
attributeName = attributeName.Trim();
displayName = displayName.Trim(' ', '(', ')');
if (string.IsNullOrEmpty(displayName))
{
displayName = attributeName;
}
if (string.IsNullOrEmpty(attributeName))
{
FailMessage("操作失败，字段名不能为空！");
return(false);
}
if (TableStyleManager.IsExists(relatedIdentity, _tableName, attributeName))
{
FailMessage($@"显示样式添加失败：字段名""{attributeName}""已存在");
return(false);
}
var styleInfo = new TableStyleInfo(0, relatedIdentity, _tableName, attributeName, 0, displayName, string.Empty, false, inputType, TbDefaultValue.Text, TranslateUtils.ToBool(DdlIsHorizontal.SelectedValue), string.Empty);
styleInfo.Additional.Columns = TranslateUtils.ToInt(TbColumns.Text);
styleInfo.Additional.Height = TranslateUtils.ToInt(TbHeight.Text);
styleInfo.Additional.Width = TbWidth.Text;
if (inputType == InputType.CheckBox || inputType == InputType.Radio || inputType == InputType.SelectMultiple || inputType == InputType.SelectOne)
{
styleInfo.StyleItems = new List <TableStyleItemInfo>();
var rapidValues = TranslateUtils.StringCollectionToStringList(TbRapidValues.Text);
foreach (var rapidValue in rapidValues)
{
var itemInfo = new TableStyleItemInfo(0, styleInfo.Id, rapidValue, rapidValue, false);
styleInfo.StyleItems.Add(itemInfo);
}
}
styleInfoArrayList.Add(styleInfo);
}
try
{
var attributeNames = new ArrayList();
foreach (TableStyleInfo styleInfo in styleInfoArrayList)
{
attributeNames.Add(styleInfo.AttributeName);
TableStyleManager.Insert(styleInfo);
}
if (SiteId > 0)
{
Body.AddSiteLog(SiteId, "批量添加表单显示样式", $"字段名: {TranslateUtils.ObjectCollectionToString(attributeNames)}");
}
else
{
Body.AddAdminLog("批量添加表单显示样式", $"字段名: {TranslateUtils.ObjectCollectionToString(attributeNames)}");
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "显示样式添加失败：" + ex.Message);
}
return(isChanged);
}
public void ImportTableStyles(int publishmentSystemId)
{
if (!DirectoryUtils.IsDirectoryExists(_directoryPath))
{
return;
}
var publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(publishmentSystemId);
var importObject = new ImportObject(publishmentSystemId);
var tableNameCollection = importObject.GetTableNameCache();
var styleDirectoryPaths = DirectoryUtils.GetDirectoryPaths(_directoryPath);
foreach (var styleDirectoryPath in styleDirectoryPaths)
{
var tableName = PathUtils.GetDirectoryName(styleDirectoryPath);
if (!string.IsNullOrEmpty(tableNameCollection?[tableName]))
{
tableName = tableNameCollection[tableName];
}
ETableStyle tableStyle;
if (BaiRongDataProvider.TableCollectionDao.IsTableExists(tableName))
{
var tableType = BaiRongDataProvider.TableCollectionDao.GetTableType(tableName);
tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(tableType);
}
else
{
tableStyle = PublishmentSystemManager.GetTableStyle(publishmentSystemInfo, tableName);
}
var attributeNamePaths = DirectoryUtils.GetDirectoryPaths(styleDirectoryPath);
foreach (var attributeNamePath in attributeNamePaths)
{
var attributeName = PathUtils.GetDirectoryName(attributeNamePath);
var filePaths = DirectoryUtils.GetFilePaths(attributeNamePath);
foreach (var filePath in filePaths)
{
var feed = AtomFeed.Load(FileUtils.GetFileStreamReadOnly(filePath));
var taxis = TranslateUtils.ToInt(AtomUtility.GetDcElementContent(feed.AdditionalElements, "Taxis"), 0);
var displayName = AtomUtility.GetDcElementContent(feed.AdditionalElements, "DisplayName");
var helpText = AtomUtility.GetDcElementContent(feed.AdditionalElements, "HelpText");
var isVisible = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsVisible"));
var isVisibleInList = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsVisibleInList"));
var isSingleLine = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsSingleLine"));
var inputType = EInputTypeUtils.GetEnumType(AtomUtility.GetDcElementContent(feed.AdditionalElements, "InputType"));
var defaultValue = AtomUtility.GetDcElementContent(feed.AdditionalElements, "DefaultValue");
var isHorizontal = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, "IsHorizontal"));
var extendValues = AtomUtility.GetDcElementContent(feed.AdditionalElements, "ExtendValues");
int relatedIdentity;
if (tableStyle == ETableStyle.Site)
{
relatedIdentity = publishmentSystemId;
}
else
{
var orderString = AtomUtility.GetDcElementContent(feed.AdditionalElements, "OrderString");
if (!string.IsNullOrEmpty(orderString))
{
relatedIdentity = DataProvider.NodeDao.GetNodeId(publishmentSystemId, orderString);
}
else
{
relatedIdentity = publishmentSystemId;
}
}
if (relatedIdentity <= 0 ||
TableStyleManager.IsExists(relatedIdentity, tableName, attributeName))
{
continue;
}
var styleInfo = new TableStyleInfo(0, relatedIdentity, tableName, attributeName, taxis, displayName, helpText, isVisible, isVisibleInList, isSingleLine, EInputTypeUtils.GetValue(inputType), defaultValue, isHorizontal, extendValues);
var styleItems = new List <TableStyleItemInfo>();
foreach (AtomEntry entry in feed.Entries)
{
var itemTitle = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ItemTitle");
var itemValue = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ItemValue");
var isSelected = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(entry.AdditionalElements, "IsSelected"));
styleItems.Add(new TableStyleItemInfo(0, 0, itemTitle, itemValue, isSelected));
}
if (styleItems.Count > 0)
{
styleInfo.StyleItems = styleItems;
}
TableStyleManager.InsertWithTaxis(styleInfo, tableStyle);
}
}
}
}
public void ImportTableStyles(int siteId)
{
if (!DirectoryUtils.IsDirectoryExists(_directoryPath))
{
return;
}
var importObject = new ImportObject(siteId, _adminName);
var tableNameCollection = importObject.GetTableNameCache();
var styleDirectoryPaths = DirectoryUtils.GetDirectoryPaths(_directoryPath);
foreach (var styleDirectoryPath in styleDirectoryPaths)
{
var tableName = PathUtils.GetDirectoryName(styleDirectoryPath, false);
if (tableName == "siteserver_PublishmentSystem")
{
tableName = DataProvider.SiteDao.TableName;
}
if (!string.IsNullOrEmpty(tableNameCollection?[tableName]))
{
tableName = tableNameCollection[tableName];
}
var attributeNamePaths = DirectoryUtils.GetDirectoryPaths(styleDirectoryPath);
foreach (var attributeNamePath in attributeNamePaths)
{
var attributeName = PathUtils.GetDirectoryName(attributeNamePath, false);
var filePaths = DirectoryUtils.GetFilePaths(attributeNamePath);
foreach (var filePath in filePaths)
{
var feed = AtomFeed.Load(FileUtils.GetFileStreamReadOnly(filePath));
var taxis = TranslateUtils.ToInt(AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.Taxis)), 0);
var displayName = AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.DisplayName));
var helpText = AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.HelpText));
var isVisibleInList = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.IsVisibleInList)));
var inputType = InputTypeUtils.GetEnumType(AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.InputType)));
var defaultValue = AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.DefaultValue));
var isHorizontal = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.IsHorizontal)));
var extendValues = AtomUtility.GetDcElementContent(feed.AdditionalElements, nameof(TableStyleInfo.ExtendValues));
var orderString = AtomUtility.GetDcElementContent(feed.AdditionalElements, "OrderString");
var relatedIdentity = !string.IsNullOrEmpty(orderString) ? DataProvider.ChannelDao.GetId(siteId, orderString) : siteId;
if (relatedIdentity <= 0 || TableStyleManager.IsExists(relatedIdentity, tableName, attributeName))
{
continue;
}
var styleInfo = new TableStyleInfo(0, relatedIdentity, tableName, attributeName, taxis, displayName, helpText, isVisibleInList, inputType, defaultValue, isHorizontal, extendValues);
var styleItems = new List <TableStyleItemInfo>();
foreach (AtomEntry entry in feed.Entries)
{
var itemTitle = AtomUtility.GetDcElementContent(entry.AdditionalElements, nameof(TableStyleItemInfo.ItemTitle));
var itemValue = AtomUtility.GetDcElementContent(entry.AdditionalElements, nameof(TableStyleItemInfo.ItemValue));
var isSelected = TranslateUtils.ToBool(AtomUtility.GetDcElementContent(entry.AdditionalElements, nameof(TableStyleItemInfo.IsSelected)));
styleItems.Add(new TableStyleItemInfo(0, 0, itemTitle, itemValue, isSelected));
}
if (styleItems.Count > 0)
{
styleInfo.StyleItems = styleItems;
}
DataProvider.TableStyleDao.Insert(styleInfo);
}
}
}
}
private bool InsertTableStyleInfo(EInputType inputType)
{
var isChanged = false;
var attributeNameArray = AttributeNames.Text.Split('\n');
var relatedIdentity = (int)_relatedIdentities[0];
var styleInfoArrayList = new ArrayList();
foreach (var itemString in attributeNameArray)
{
if (!string.IsNullOrEmpty(itemString))
{
var attributeName = itemString;
var displayName = string.Empty;
if (StringUtils.Contains(itemString, "(") && StringUtils.Contains(itemString, ")"))
{
var length = itemString.IndexOf(')') - itemString.IndexOf('(');
if (length > 0)
{
displayName = itemString.Substring(itemString.IndexOf('(') + 1, length);
attributeName = itemString.Substring(0, itemString.IndexOf('('));
}
}
attributeName = attributeName.Trim();
displayName = displayName.Trim(' ', '(', ')');
if (string.IsNullOrEmpty(displayName))
{
displayName = attributeName;
}
if (TableStyleManager.IsExists(relatedIdentity, _tableName, attributeName) || TableStyleManager.IsExistsInParents(_relatedIdentities, _tableName, attributeName))
{
FailMessage($@"显示样式添加失败：字段名""{attributeName}""已存在");
return(false);
}
var styleInfo = new TableStyleInfo(0, relatedIdentity, _tableName, attributeName, 0, displayName, string.Empty, TranslateUtils.ToBool(IsVisible.SelectedValue), false, TranslateUtils.ToBool(IsSingleLine.SelectedValue), EInputTypeUtils.GetValue(inputType), DefaultValue.Text, TranslateUtils.ToBool(IsHorizontal.SelectedValue), string.Empty);
styleInfo.Additional.Columns = TranslateUtils.ToInt(Columns.Text);
styleInfo.Additional.Height = TranslateUtils.ToInt(Height.Text);
styleInfo.Additional.Width = Width.Text;
if (inputType == EInputType.CheckBox || inputType == EInputType.Radio || inputType == EInputType.SelectMultiple || inputType == EInputType.SelectOne)
{
styleInfo.StyleItems = new List <TableStyleItemInfo>();
var isHasSelected = false;
foreach (RepeaterItem item in MyRepeater.Items)
{
var ItemTitle = (TextBox)item.FindControl("ItemTitle");
var ItemValue = (TextBox)item.FindControl("ItemValue");
var IsSelected = (CheckBox)item.FindControl("IsSelected");
if ((inputType != EInputType.SelectMultiple && inputType != EInputType.CheckBox) && isHasSelected && IsSelected.Checked)
{
FailMessage("操作失败，只能有一个初始化时选定项！");
return(false);
}
if (IsSelected.Checked)
{
isHasSelected = true;
}
var itemInfo = new TableStyleItemInfo(0, 0, ItemTitle.Text, ItemValue.Text, IsSelected.Checked);
styleInfo.StyleItems.Add(itemInfo);
}
}
styleInfoArrayList.Add(styleInfo);
}
}
try
{
var attributeNames = new ArrayList();
foreach (TableStyleInfo styleInfo in styleInfoArrayList)
{
attributeNames.Add(styleInfo.AttributeName);
TableStyleManager.Insert(styleInfo, _tableStyle);
}
Body.AddSiteLog(PublishmentSystemId, "批量添加表单显示样式", $"类型:{ETableStyleUtils.GetText(_tableStyle)},字段名: {TranslateUtils.ObjectCollectionToString(attributeNames)}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "显示样式添加失败：" + ex.Message);
}
return(isChanged);
}
private bool InsertTableStyleInfo(EInputType inputType)
{
var isChanged = false;
var relatedIdentity = _relatedIdentities[0];
if (TableStyleManager.IsExists(relatedIdentity, _tableName, TbAttributeName.Text))
//|| TableStyleManager.IsExistsInParents(this.relatedIdentities, this.tableName, this.tbAttributeName.Text)
{
FailMessage($@"显示样式添加失败：字段名""{TbAttributeName.Text}""已存在");
return(false);
}
_styleInfo = TableStyleManager.IsMetadata(_tableStyle, TbAttributeName.Text) ? TableStyleManager.GetTableStyleInfo(_tableStyle, _tableName, TbAttributeName.Text, _relatedIdentities) : new TableStyleInfo();
_styleInfo.RelatedIdentity = relatedIdentity;
_styleInfo.TableName = _tableName;
_styleInfo.AttributeName = TbAttributeName.Text;
_styleInfo.DisplayName = PageUtils.FilterXss(TbDisplayName.Text);
_styleInfo.HelpText = TbHelpText.Text;
_styleInfo.IsVisible = TranslateUtils.ToBool(RblIsVisible.SelectedValue);
_styleInfo.IsSingleLine = TranslateUtils.ToBool(RblIsSingleLine.SelectedValue);
_styleInfo.InputType = EInputTypeUtils.GetValue(inputType);
_styleInfo.DefaultValue = TbDefaultValue.Text;
_styleInfo.IsHorizontal = TranslateUtils.ToBool(DdlIsHorizontal.SelectedValue);
_styleInfo.Additional.Columns = TranslateUtils.ToInt(TbColumns.Text);
_styleInfo.Additional.Height = TranslateUtils.ToInt(TbHeight.Text);
_styleInfo.Additional.Width = TbWidth.Text;
_styleInfo.Additional.IsFormatString = TranslateUtils.ToBool(RblIsFormatString.SelectedValue);
_styleInfo.Additional.RelatedFieldId = TranslateUtils.ToInt(DdlRelatedFieldId.SelectedValue);
_styleInfo.Additional.RelatedFieldStyle = DdlRelatedFieldStyle.SelectedValue;
if (inputType == EInputType.CheckBox || inputType == EInputType.Radio || inputType == EInputType.SelectMultiple || inputType == EInputType.SelectOne)
{
_styleInfo.StyleItems = new List <TableStyleItemInfo>();
var isRapid = TranslateUtils.ToBool(DdlItemType.SelectedValue);
if (isRapid)
{
var itemArrayList = TranslateUtils.StringCollectionToStringList(TbItemValues.Text);
foreach (string itemValue in itemArrayList)
{
var itemInfo = new TableStyleItemInfo(0, _styleInfo.TableStyleId, itemValue, itemValue, false);
_styleInfo.StyleItems.Add(itemInfo);
}
}
else
{
var isHasSelected = false;
foreach (RepeaterItem item in RptItems.Items)
{
var itemTitle = (TextBox)item.FindControl("ItemTitle");
var itemValue = (TextBox)item.FindControl("ItemValue");
var isSelected = (CheckBox)item.FindControl("IsSelected");
if (inputType != EInputType.SelectMultiple && inputType != EInputType.CheckBox && isHasSelected && isSelected.Checked)
{
FailMessage("操作失败，只能有一个初始化时选定项！");
return(false);
}
if (isSelected.Checked)
{
isHasSelected = true;
}
var itemInfo = new TableStyleItemInfo(0, 0, itemTitle.Text, itemValue.Text, isSelected.Checked);
_styleInfo.StyleItems.Add(itemInfo);
}
}
}
try
{
TableStyleManager.Insert(_styleInfo, _tableStyle);
Body.AddSiteLog(PublishmentSystemId, "添加表单显示样式", $"类型:{ETableStyleUtils.GetText(_tableStyle)},字段名:{_styleInfo.AttributeName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "显示样式添加失败：" + ex.Message);
}
return(isChanged);
}
private bool InsertTableStyleInfo(string tableName, List <int> relatedIdentities, TableStyleInfo body, bool isRapid, List <string> rapidValues, out string errorMessage)
{
errorMessage = string.Empty;
var relatedIdentity = relatedIdentities[0];
if (string.IsNullOrEmpty(body.AttributeName))
{
errorMessage = "操作失败，字段名不能为空！";
return(false);
}
if (TableStyleManager.IsExists(relatedIdentity, tableName, body.AttributeName))
{
errorMessage = $@"显示样式添加失败：字段名""{body.AttributeName}""已存在";
return(false);
}
var styleInfo = TableColumnManager.IsAttributeNameExists(tableName, body.AttributeName) ? TableStyleManager.GetTableStyleInfo(tableName, body.AttributeName, relatedIdentities) : new TableStyleInfo();
styleInfo.RelatedIdentity = relatedIdentity;
styleInfo.TableName = tableName;
styleInfo.AttributeName = body.AttributeName;
styleInfo.DisplayName = AttackUtils.FilterXss(body.DisplayName);
styleInfo.HelpText = body.HelpText;
styleInfo.Taxis = body.Taxis;
styleInfo.InputType = body.InputType;
styleInfo.DefaultValue = body.DefaultValue;
styleInfo.IsHorizontal = body.IsHorizontal;
styleInfo.ExtendValues = body.Additional.ToString();
styleInfo.StyleItems = new List <TableStyleItemInfo>();
if (body.InputType == InputType.CheckBox || body.InputType == InputType.Radio || body.InputType == InputType.SelectMultiple || body.InputType == InputType.SelectOne)
{
if (isRapid)
{
foreach (var rapidValue in rapidValues)
{
var itemInfo = new TableStyleItemInfo(0, 0, rapidValue, rapidValue, false);
styleInfo.StyleItems.Add(itemInfo);
}
}
else
{
var isHasSelected = false;
foreach (var styleItem in body.StyleItems)
{
if (body.InputType != InputType.SelectMultiple && body.InputType != InputType.CheckBox && isHasSelected && styleItem.IsSelected)
{
errorMessage = "操作失败，只能有一个初始化时选定项！";
return(false);
}
if (styleItem.IsSelected)
{
isHasSelected = true;
}
var itemInfo = new TableStyleItemInfo(0, 0, styleItem.ItemTitle, styleItem.ItemValue, styleItem.IsSelected);
styleInfo.StyleItems.Add(itemInfo);
}
}
}
DataProvider.TableStyleDao.Insert(styleInfo);
return(true);
}
private bool InsertTableStyleInfo(InputType inputType)
{
var isChanged = false;
var relatedIdentity = _relatedIdentities[0];
if (string.IsNullOrEmpty(TbAttributeName.Text))
{
FailMessage("操作失败，字段名不能为空！");
return(false);
}
if (TableStyleManager.IsExists(relatedIdentity, _tableName, TbAttributeName.Text))
{
FailMessage($@"显示样式添加失败：字段名""{TbAttributeName.Text}""已存在");
return(false);
}
_styleInfo = DataProvider.TableMetadataDao.IsExists(_tableName, TbAttributeName.Text) ? TableStyleManager.GetTableStyleInfo(_tableName, TbAttributeName.Text, _relatedIdentities) : new TableStyleInfo();
_styleInfo.RelatedIdentity = relatedIdentity;
_styleInfo.TableName = _tableName;
_styleInfo.AttributeName = TbAttributeName.Text;
_styleInfo.DisplayName = PageUtils.FilterXss(TbDisplayName.Text);
_styleInfo.HelpText = TbHelpText.Text;
_styleInfo.Taxis = TranslateUtils.ToInt(TbTaxis.Text);
_styleInfo.InputType = inputType;
_styleInfo.DefaultValue = TbDefaultValue.Text;
_styleInfo.IsHorizontal = TranslateUtils.ToBool(DdlIsHorizontal.SelectedValue);
_styleInfo.Additional.Columns = TranslateUtils.ToInt(TbColumns.Text);
_styleInfo.Additional.Height = TranslateUtils.ToInt(TbHeight.Text);
_styleInfo.Additional.Width = TbWidth.Text;
_styleInfo.Additional.IsFormatString = TranslateUtils.ToBool(DdlIsFormatString.SelectedValue);
_styleInfo.Additional.RelatedFieldId = TranslateUtils.ToInt(DdlRelatedFieldId.SelectedValue);
_styleInfo.Additional.RelatedFieldStyle = DdlRelatedFieldStyle.SelectedValue;
_styleInfo.Additional.CustomizeLeft = TbCustomizeLeft.Text;
_styleInfo.Additional.CustomizeRight = TbCustomizeRight.Text;
if (inputType == InputType.CheckBox || inputType == InputType.Radio || inputType == InputType.SelectMultiple || inputType == InputType.SelectOne)
{
_styleInfo.StyleItems = new List <TableStyleItemInfo>();
var isRapid = TranslateUtils.ToBool(DdlIsRapid.SelectedValue);
if (isRapid)
{
var rapidValues = TranslateUtils.StringCollectionToStringList(TbRapidValues.Text);
foreach (var rapidValue in rapidValues)
{
var itemInfo = new TableStyleItemInfo(0, _styleInfo.Id, rapidValue, rapidValue, false);
_styleInfo.StyleItems.Add(itemInfo);
}
}
else
{
var isHasSelected = false;
foreach (RepeaterItem item in RptItems.Items)
{
var tbTitle = (TextBox)item.FindControl("tbTitle");
var tbValue = (TextBox)item.FindControl("tbValue");
var cbIsSelected = (CheckBox)item.FindControl("cbIsSelected");
if (inputType != InputType.SelectMultiple && inputType != InputType.CheckBox && isHasSelected && cbIsSelected.Checked)
{
FailMessage("操作失败，只能有一个初始化时选定项！");
return(false);
}
if (cbIsSelected.Checked)
{
isHasSelected = true;
}
var itemInfo = new TableStyleItemInfo(0, 0, tbTitle.Text, tbValue.Text, cbIsSelected.Checked);
_styleInfo.StyleItems.Add(itemInfo);
}
}
}
try
{
TableStyleManager.Insert(_styleInfo);
if (SiteId > 0)
{
AuthRequest.AddSiteLog(SiteId, "添加表单显示样式", $"字段名:{_styleInfo.AttributeName}");
}
else
{
AuthRequest.AddAdminLog("添加表单显示样式", $"字段名:{_styleInfo.AttributeName}");
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "显示样式添加失败：" + ex.Message);
}
return(isChanged);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("ENName", "TableType");
_showSqlTable = Body.IsQueryExists("ShowCrateDBCommand");
_tableName = Body.GetQueryString("ENName").Trim();
_tableType = EAuxiliaryTableTypeUtils.GetEnumType(Body.GetQueryString("TableType"));
_redirectUrl = GetRedirectUrl(_tableName, _tableType, PublishmentSystemId);
var tableInfo = BaiRongDataProvider.TableCollectionDao.GetAuxiliaryTableInfo(_tableName);
if (Body.IsQueryExists("Delete"))
{
var tableMetadataId = Body.GetQueryInt("TableMetadataID");
try
{
var tableMetadataInfo = BaiRongDataProvider.TableMetadataDao.GetTableMetadataInfo(tableMetadataId);
BaiRongDataProvider.TableMetadataDao.Delete(tableMetadataId);
Body.AddAdminLog("删除辅助表字段", $"辅助表:{_tableName},字段名:{tableMetadataInfo.AttributeName}");
SuccessDeleteMessage();
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
else if (Body.IsQueryExists("DeleteStyle"))//删除样式
{
var attributeName = Body.GetQueryString("AttributeName");
if (TableStyleManager.IsExists(0, _tableName, attributeName))
{
try
{
TableStyleManager.Delete(0, _tableName, attributeName);
Body.AddAdminLog("删除辅助表字段样式", $"辅助表:{_tableName},字段名:{attributeName}");
SuccessDeleteMessage();
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
}
else if (Body.IsQueryExists("CreateDB"))
{
try
{
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(_tableName);
tableInfo.IsChangedAfterCreatedInDb = false;
Body.AddAdminLog("创建辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表创建成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表创建失败，失败原因为：" + ex.Message + "<br>请检查创建表SQL命令");
var sqlString = BaiRongDataProvider.AuxiliaryTableDataDao.GetCreateAuxiliaryTableSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
_showSqlTable = true;
}
}
else if (Body.IsQueryExists("DeleteDB"))
{
try
{
BaiRongDataProvider.TableMetadataDao.DeleteAuxiliaryTable(_tableName);
tableInfo.IsChangedAfterCreatedInDb = false;
Body.AddAdminLog("删除辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表删除成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表删除失败，失败原因为：" + ex.Message + "<br>");
}
}
else if (Body.IsQueryExists("ReCreateDB"))
{
try
{
BaiRongDataProvider.TableMetadataDao.ReCreateAuxiliaryTable(_tableName, tableInfo.AuxiliaryTableType);
DataProvider.NodeDao.UpdateContentNumToZero(_tableName, tableInfo.AuxiliaryTableType);
tableInfo.IsChangedAfterCreatedInDb = false;
Body.AddAdminLog("重建辅助表", $"辅助表:{_tableName}");
SuccessMessage("辅助表重建成功！");
PageUtils.Redirect(_redirectUrl);
}
catch (Exception ex)
{
FailMessage(ex, "<br>辅助表重建失败，失败原因为：" + ex.Message + "<br>请检查创建表SQL命令");
var sqlString = BaiRongDataProvider.AuxiliaryTableDataDao.GetCreateAuxiliaryTableSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
_showSqlTable = true;
}
}
else if (Body.IsQueryExists("ShowCrateDBCommand"))
{
var sqlString = BaiRongDataProvider.AuxiliaryTableDataDao.GetCreateAuxiliaryTableSqlString(_tableName);
LtlSqlString.Text = sqlString.Replace("\r\n", "<br>").Replace("\t", " ");
}
else if (Body.IsQueryExists("SetTaxis"))
{
SetTaxis();
}
_tableIsRealCreated = BaiRongDataProvider.TableStructureDao.IsTableExists(_tableName);
_usedNum = BaiRongDataProvider.TableCollectionDao.GetTableUsedNum(_tableName, tableInfo.AuxiliaryTableType);
DivSyncTable.Visible = IsNeedSync(_tableIsRealCreated, tableInfo.IsChangedAfterCreatedInDb);
if (!IsPostBack)
{
BreadCrumbSys(AppManager.Sys.LeftMenu.Auxiliary, $"辅助表字段管理（{_tableName}）", AppManager.Sys.Permission.SysAuxiliary);
DgContents.DataSource = BaiRongDataProvider.TableMetadataDao.GetDataSource(_tableName);
DgContents.ItemDataBound += dgContents_ItemDataBound;
DgContents.DataBind();
BtnAddColumn.Attributes.Add("onclick", ModalTableMetadataAdd.GetOpenWindowStringToAdd(_tableName, _tableType));
BtnBatchAddColumn.Attributes.Add("onclick", ModalTableMetadataAddBatch.GetOpenWindowStringToAdd(_tableName, _tableType));
}
}
