public void Insert(AuxiliaryTableInfo info)
{
var insertParms = new IDataParameter[]
{
GetParameter(ParmTableEnname, EDataType.VarChar, 50, info.TableEnName),
GetParameter(ParmTableCnname, EDataType.NVarChar, 50, info.TableCnName),
GetParameter(ParmAttributeNum, EDataType.Integer, info.AttributeNum),
GetParameter(ParmTableType, EDataType.VarChar, 50, EAuxiliaryTableTypeUtils.GetValue(info.AuxiliaryTableType)),
GetParameter(ParmIsCreatedInDb, EDataType.VarChar, 18, false.ToString()),
GetParameter(ParmIsChangedAfterCreatedInDb, EDataType.VarChar, 18, false.ToString()),
GetParameter(ParmIsDefault, EDataType.VarChar, 18, info.IsDefault.ToString()),
GetParameter(ParmDescription, EDataType.NText, info.Description)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SqlInsertTable, insertParms);
BaiRongDataProvider.TableMetadataDao.InsertSystemItems(info.TableEnName, info.AuxiliaryTableType, trans);
TableManager.IsChanged = true;
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
public List <AuxiliaryTableInfo> GetAuxiliaryTableListCreatedInDbByAuxiliaryTableType(params EAuxiliaryTableType[] eAuxiliaryTableTypeArray)
{
var auxiliaryTableTypeList = new List <string>();
foreach (var eAuxiliaryTableType in eAuxiliaryTableTypeArray)
{
auxiliaryTableTypeList.Add(EAuxiliaryTableTypeUtils.GetValue(eAuxiliaryTableType));
}
string sqlString =
$"SELECT TableENName, TableCNName, AttributeNum, AuxiliaryTableType, IsCreatedInDB, IsChangedAfterCreatedInDB, IsDefault, Description FROM bairong_TableCollection WHERE AuxiliaryTableType IN ({TranslateUtils.ToSqlInStringWithQuote(auxiliaryTableTypeList)}) AND IsCreatedInDB = '{true}' ORDER BY IsCreatedInDB DESC, TableENName";
var list = new List <AuxiliaryTableInfo>();
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var info = new AuxiliaryTableInfo(GetString(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), EAuxiliaryTableTypeUtils.GetEnumType(GetString(rdr, i++)), GetBool(rdr, i++), GetBool(rdr, i++), GetBool(rdr, i++), GetString(rdr, i));
list.Add(info);
}
rdr.Close();
}
return(list);
}
public static ETableStyle GetTableStyle(PublishmentSystemInfo publishmentSystemInfo, NodeInfo nodeInfo)
{
var modelInfo = ContentModelManager.GetContentModelInfo(publishmentSystemInfo, nodeInfo.ContentModelId);
if (!string.IsNullOrEmpty(modelInfo?.TableName))
{
return(EAuxiliaryTableTypeUtils.GetTableStyle(modelInfo.TableType));
}
var tableStyle = ETableStyle.BackgroundContent;
if (EContentModelTypeUtils.Equals(EContentModelType.GovPublic, nodeInfo.ContentModelId))
{
tableStyle = ETableStyle.GovPublicContent;
}
else if (EContentModelTypeUtils.Equals(EContentModelType.GovInteract, nodeInfo.ContentModelId))
{
tableStyle = ETableStyle.GovInteractContent;
}
else if (EContentModelTypeUtils.Equals(EContentModelType.Vote, nodeInfo.ContentModelId))
{
tableStyle = ETableStyle.VoteContent;
}
else if (EContentModelTypeUtils.Equals(EContentModelType.Job, nodeInfo.ContentModelId))
{
tableStyle = ETableStyle.JobContent;
}
else if (EContentModelTypeUtils.Equals(EContentModelType.UserDefined, nodeInfo.ContentModelId))
{
tableStyle = ETableStyle.UserDefined;
}
return(tableStyle);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("PublishmentSystemID");
if (!IsPostBack)
{
rblTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.BackgroundContent, true));
rblTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.UserDefined, false));
if (Body.IsQueryExists("ModelID"))
{
tbModelID.Enabled = false;
var modelId = Body.GetQueryString("ModelID");
var modelInfo = BaiRongDataProvider.ContentModelDao.GetContentModelInfo(modelId, PublishmentSystemId);
if (modelInfo != null)
{
tbModelID.Text = modelId;
tbModelName.Text = modelInfo.ModelName;
tbIconUrl.Text = modelInfo.IconUrl;
ControlUtils.SelectListItemsIgnoreCase(rblTableType, EAuxiliaryTableTypeUtils.GetValue(modelInfo.TableType));
rblTableType_SelectedIndexChanged(null, null);
ControlUtils.SelectListItemsIgnoreCase(ddlTableName, modelInfo.TableName);
tbDescription.Text = modelInfo.Description;
}
}
else
{
rblTableType_SelectedIndexChanged(null, null);
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("TableName", "TableType");
_tableName = Body.GetQueryString("TableName");
_tableType = EAuxiliaryTableTypeUtils.GetEnumType(Body.GetQueryString("TableType"));
if (!IsPostBack)
{
EDataTypeUtils.AddListItemsToAuxiliaryTable(DataType);
if (Body.IsQueryExists("TableMetadataID"))
{
var tableMetadataId = Body.GetQueryInt("TableMetadataID");
var info = BaiRongDataProvider.TableMetadataDao.GetTableMetadataInfo(tableMetadataId);
if (info != null)
{
AttributeName.Text = info.AttributeName;
AttributeName.Enabled = false;
ControlUtils.SelectListItemsIgnoreCase(DataType, info.DataType.ToString());
DataLength.Text = info.DataLength.ToString();
}
}
}
}
public string GetEditStyleHtml(int tableMetadataId, string attributeName)
{
var tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(_tableType);
var styleInfo = TableStyleManager.GetTableStyleInfo(tableStyle, _tableName, attributeName, null);
var showPopWinString = ModalTableStyleAdd.GetOpenWindowString(0, _tableName, attributeName, tableStyle, _redirectUrl);
var editText = "设置";
if (styleInfo.TableStyleId != 0)//数据库中有样式
{
editText = "修改";
}
string retval = $"<a href=\"javascript:void 0;\" onClick=\"{showPopWinString}\">{editText}</a>";
if (styleInfo.TableStyleId == 0)
{
return(retval);
}
var attributes = new NameValueCollection
{
{ "DeleteStyle", true.ToString() },
{ "TableMetadataID", tableMetadataId.ToString() },
{ "AttributeName", attributeName }
};
var deleteUrl = PageUtils.AddQueryString(_redirectUrl, attributes);
retval +=
$@" <a href=""{deleteUrl}"" onClick=""javascript:return confirm('此操作将删除对应显示样式，确认吗？');"">删除</a>";
return(retval);
}
public List <string> GetTableEnNameListCreatedInDbByAuxiliaryTableType(params EAuxiliaryTableType[] eAuxiliaryTableTypeArray)
{
var auxiliaryTableTypeList = new List <string>();
foreach (var eAuxiliaryTableType in eAuxiliaryTableTypeArray)
{
auxiliaryTableTypeList.Add(EAuxiliaryTableTypeUtils.GetValue(eAuxiliaryTableType));
}
string sqlString =
$"SELECT TableENName FROM bairong_TableCollection WHERE AuxiliaryTableType IN ({TranslateUtils.ToSqlInStringWithQuote(auxiliaryTableTypeList)}) AND IsCreatedInDB = '{true}' ORDER BY IsCreatedInDB DESC, TableENName";
var list = new List <string>();
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
list.Add(GetString(rdr, 0));
}
rdr.Close();
}
return(list);
}
public int GetTableUsedNum(string tableENName, string auxiliaryTableType)
{
var tableType = EAuxiliaryTableTypeUtils.GetEnumType(auxiliaryTableType);
var usedNum = BaiRongDataProvider.TableCollectionDao.GetTableUsedNum(tableENName, tableType);
return(usedNum);
}
public static string GetOpenWindowStringToAdd(string tableName, EAuxiliaryTableType tableType)
{
return(PageUtils.GetOpenWindowString("添加辅助表字段", PageUtils.GetSysUrl(nameof(ModalTableMetadataAdd), new NameValueCollection
{
{ "TableName", tableName },
{ "TableType", EAuxiliaryTableTypeUtils.GetValue(tableType) }
}), 400, 360));
}
public static string GetRedirectUrl(string tableName, EAuxiliaryTableType tableType)
{
return(PageUtils.GetSysUrl(nameof(PageTableStyle), new NameValueCollection
{
{ "tableName", tableName },
{ "tableType", EAuxiliaryTableTypeUtils.GetValue(tableType) }
}));
}
public override void Submit_OnClick(object sender, EventArgs e)
{
if (Page.IsPostBack && Page.IsValid)
{
if (Body.IsQueryExists("ENName"))
{
var tableEnName = Body.GetQueryString("ENName");
var info = BaiRongDataProvider.TableCollectionDao.GetAuxiliaryTableInfo(tableEnName);
info.TableCnName = TableCNName.Text;
info.Description = Description.Text;
try
{
BaiRongDataProvider.TableCollectionDao.Update(info);
Body.AddAdminLog("修改辅助表", $"辅助表:{tableEnName}");
SuccessMessage("辅助表修改成功！");
}
catch (Exception ex)
{
FailMessage(ex, "辅助表修改失败！");
}
}
else
{
var TableENNameList = BaiRongDataProvider.TableCollectionDao.GetTableEnNameList();
if (TableENNameList.IndexOf(TableENName.Text) != -1)
{
FailMessage("辅助表添加失败，辅助表标识已存在！");
}
else if (BaiRongDataProvider.TableStructureDao.IsTableExists(TableENName.Text))
{
FailMessage("辅助表添加失败，数据库中已存在此表！");
}
else
{
var info = new AuxiliaryTableInfo();
info.TableEnName = TableENName.Text;
info.TableCnName = TableCNName.Text;
info.Description = Description.Text;
info.AuxiliaryTableType = EAuxiliaryTableTypeUtils.GetEnumType(AuxiliaryTableType.SelectedValue);
try
{
BaiRongDataProvider.TableCollectionDao.Insert(info);
Body.AddAdminLog("添加辅助表",
$"辅助表:{TableENName.Text}");
SuccessMessage("辅助表添加成功！");
}
catch (Exception ex)
{
FailMessage(ex, "辅助表添加失败！");
}
}
}
}
}
public static string GetRedirectUrl(string tableName, EAuxiliaryTableType tableType, int publishmentSystemId)
{
return(PageUtils.GetSysUrl(nameof(PageTableMetadata), new NameValueCollection
{
{ "ENName", tableName },
{ "TableType", EAuxiliaryTableTypeUtils.GetValue(tableType) },
{ "PublishmentSystemID", publishmentSystemId.ToString() }
}));
}
public static string GetOpenWindowString(EAuxiliaryTableType tableType, string tableName, string attributeName)
{
return(PageUtils.GetOpenWindowString("辅助表字段查看", PageUtils.GetSysUrl(nameof(ModalTableMetadataView), new NameValueCollection
{
{ "TableType", EAuxiliaryTableTypeUtils.GetValue(tableType) },
{ "TableName", tableName },
{ "AttributeName", attributeName }
}), 480, 510, true));
}
public IEnumerable GetDataSourceCreatedInDbByAuxiliaryTableType(EAuxiliaryTableType type)
{
var parms = new IDataParameter[]
{
GetParameter(ParmTableType, EDataType.VarChar, 50, EAuxiliaryTableTypeUtils.GetValue(type)),
GetParameter(ParmIsCreatedInDb, EDataType.VarChar, 18, true.ToString())
};
var enumerable = (IEnumerable)ExecuteReader(SqlSelectAllTableCreatedInDbByAuxiliaryType, parms);
return(enumerable);
}
public void rblTableType_SelectedIndexChanged(object sender, EventArgs e)
{
ddlTableName.Items.Clear();
var tableType = EAuxiliaryTableTypeUtils.GetEnumType(rblTableType.SelectedValue);
var tableList = BaiRongDataProvider.TableCollectionDao.GetAuxiliaryTableListCreatedInDbByAuxiliaryTableType(tableType);
foreach (AuxiliaryTableInfo tableInfo in tableList)
{
var li = new ListItem(tableInfo.TableCnName + "(" + tableInfo.TableEnName + ")", tableInfo.TableEnName);
ddlTableName.Items.Add(li);
}
}
public void ImportContentModelInfo(bool overwrite)
{
if (!FileUtils.IsFileExists(_filePath))
{
return;
}
var feed = AtomFeed.Load(FileUtils.GetFileStreamReadOnly(_filePath));
foreach (AtomEntry entry in feed.Entries)
{
var modelId = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ModelID");
if (!string.IsNullOrEmpty(modelId))
{
var contentModelInfo = new ContentModelInfo
{
ModelId = modelId,
SiteId = _publishmentSystemId,
ModelName = AtomUtility.GetDcElementContent(entry.AdditionalElements, "ModelName"),
IsSystem =
TranslateUtils.ToBool(AtomUtility.GetDcElementContent(entry.AdditionalElements, "IsSystem")),
TableName = AtomUtility.GetDcElementContent(entry.AdditionalElements, "TableName"),
TableType =
EAuxiliaryTableTypeUtils.GetEnumType(
AtomUtility.GetDcElementContent(entry.AdditionalElements, "TableType")),
IconUrl = AtomUtility.GetDcElementContent(entry.AdditionalElements, "IconUrl"),
Description = AtomUtility.GetDcElementContent(entry.AdditionalElements, "Description")
};
var auxiliaryTableInfo = BaiRongDataProvider.TableCollectionDao.GetAuxiliaryTableInfo(modelId);
if (auxiliaryTableInfo != null && auxiliaryTableInfo.TableEnName == modelId)
{
if (overwrite)
{
BaiRongDataProvider.ContentModelDao.Update(contentModelInfo);
}
else
{
var importContentModelId = BaiRongDataProvider.ContentModelDao.GetImportContentModelId(_publishmentSystemId, contentModelInfo.ModelId);
contentModelInfo.ModelId = importContentModelId;
BaiRongDataProvider.ContentModelDao.Insert(contentModelInfo);
}
}
else
{
BaiRongDataProvider.ContentModelDao.Insert(contentModelInfo);
}
}
}
}
private static AtomFeed GetAtomFeed(AuxiliaryTableInfo tableInfo)
{
var feed = AtomUtility.GetEmptyFeed();
AtomUtility.AddDcElement(feed.AdditionalElements, "TableENName", tableInfo.TableEnName);
AtomUtility.AddDcElement(feed.AdditionalElements, "TableCNName", tableInfo.TableCnName);
AtomUtility.AddDcElement(feed.AdditionalElements, "AttributeNum", tableInfo.AttributeNum.ToString());
AtomUtility.AddDcElement(feed.AdditionalElements, "AuxiliaryTableType", EAuxiliaryTableTypeUtils.GetValue(tableInfo.AuxiliaryTableType));
AtomUtility.AddDcElement(feed.AdditionalElements, "IsCreatedInDB", tableInfo.IsCreatedInDb.ToString());
AtomUtility.AddDcElement(feed.AdditionalElements, "IsChangedAfterCreatedInDB", tableInfo.IsChangedAfterCreatedInDb.ToString());
AtomUtility.AddDcElement(feed.AdditionalElements, "Description", tableInfo.Description);
//表唯一序列号
AtomUtility.AddDcElement(feed.AdditionalElements, "SerializedString", TableManager.GetSerializedString(tableInfo.TableEnName));
return(feed);
}
public void Update(AuxiliaryTableInfo info)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmTableCnname, EDataType.NVarChar, 50, info.TableCnName),
GetParameter(ParmAttributeNum, EDataType.Integer, info.AttributeNum),
GetParameter(ParmTableType, EDataType.VarChar, 50, EAuxiliaryTableTypeUtils.GetValue(info.AuxiliaryTableType)),
GetParameter(ParmIsCreatedInDb, EDataType.VarChar, 18, info.IsCreatedInDb.ToString()),
GetParameter(ParmIsChangedAfterCreatedInDb, EDataType.VarChar, 18, info.IsChangedAfterCreatedInDb.ToString()),
GetParameter(ParmIsDefault, EDataType.VarChar, 18, info.IsDefault.ToString()),
GetParameter(ParmDescription, EDataType.NText, info.Description),
GetParameter(ParmTableEnname, EDataType.VarChar, 50, info.TableEnName)
};
ExecuteNonQuery(SqlUpdateTable, updateParms);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("TableName", "TableType");
_tableName = Body.GetQueryString("TableName");
_tableType = EAuxiliaryTableTypeUtils.GetEnumType(Body.GetQueryString("TableType"));
if (!IsPostBack)
{
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
var enName = Body.GetQueryString("ENName");
if (!IsPostBack)
{
var pageTitle = !string.IsNullOrEmpty(enName) ? "编辑辅助表" : "添加辅助表";
BreadCrumbSys(AppManager.Sys.LeftMenu.Auxiliary, pageTitle, AppManager.Sys.Permission.SysAuxiliary);
ltlPageTitle.Text = pageTitle;
//cms
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.BackgroundContent, true));
if (AppManager.IsWcm())
{
//wcm
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.GovPublicContent, false));
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.GovInteractContent, false));
}
//others
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.VoteContent, false));
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.JobContent, false));
AuxiliaryTableType.Items.Add(EAuxiliaryTableTypeUtils.GetListItem(EAuxiliaryTableType.UserDefined, false));
if (!string.IsNullOrEmpty(enName))
{
var info = BaiRongDataProvider.TableCollectionDao.GetAuxiliaryTableInfo(enName);
if (info != null)
{
TableENName.Text = info.TableEnName;
TableENName.Enabled = false;
TableCNName.Text = info.TableCnName;
Description.Text = info.Description;
ControlUtils.SelectListItems(AuxiliaryTableType, EAuxiliaryTableTypeUtils.GetValue(info.AuxiliaryTableType));
AuxiliaryTableType.Enabled = false;
}
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
var nodeId = Body.GetQueryInt("NodeID", PublishmentSystemId);
_nodeInfo = NodeManager.GetNodeInfo(PublishmentSystemId, nodeId);
_modelInfo = ContentModelManager.GetContentModelInfo(PublishmentSystemInfo, _nodeInfo.ContentModelId);
_tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(_modelInfo.TableType);
_redirectUrl = GetRedirectUrl(PublishmentSystemId, nodeId);
_relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(PublishmentSystemId, nodeId);
if (!IsPostBack)
{
BreadCrumb(AppManager.Cms.LeftMenu.IdConfigration, AppManager.Cms.LeftMenu.Configuration.IdConfigurationContentModel, "内容字段管理", AppManager.Cms.Permission.WebSite.Configration);
//删除样式
if (Body.IsQueryExists("DeleteStyle"))
{
DeleteStyle();
}
else if (Body.IsQueryExists("SetTaxis"))
{
SetTaxis();
}
InfoMessage(
$"在此编辑内容模型字段,子栏目默认继承父栏目字段设置; 辅助表:{BaiRongDataProvider.TableCollectionDao.GetTableCnName(_modelInfo.TableName)}({_modelInfo.TableName}); 内容模型:{_modelInfo.ModelName}");
NodeManager.AddListItems(NodeIDDropDownList.Items, PublishmentSystemInfo, false, true, true, Body.AdministratorName);
ControlUtils.SelectListItems(NodeIDDropDownList, nodeId.ToString());
var styleInfoList = TableStyleManager.GetTableStyleInfoList(_tableStyle, _modelInfo.TableName, _relatedIdentities);
dgContents.DataSource = styleInfoList;
dgContents.ItemDataBound += dgContents_ItemDataBound;
dgContents.DataBind();
AddStyle.Attributes.Add("onclick", ModalTableStyleAdd.GetOpenWindowString(PublishmentSystemId, 0, _relatedIdentities, _modelInfo.TableName, string.Empty, _tableStyle, _redirectUrl));
AddStyles.Attributes.Add("onclick", ModalTableStylesAdd.GetOpenWindowString(PublishmentSystemId, _relatedIdentities, _modelInfo.TableName, _tableStyle, _redirectUrl));
Import.Attributes.Add("onclick", ModalTableStyleImport.GetOpenWindowString(_modelInfo.TableName, _tableStyle, PublishmentSystemId, nodeId));
Export.Attributes.Add("onclick", ModalExportMessage.GetOpenWindowStringToSingleTableStyle(_tableStyle, _modelInfo.TableName, PublishmentSystemId, nodeId));
}
}
public void CreateAllAuxiliaryTableIfNotExists()
{
//添加后台内容表
if (!IsTableExists(EAuxiliaryTableType.BackgroundContent))
{
var tableName = EAuxiliaryTableTypeUtils.GetDefaultTableName(EAuxiliaryTableType.BackgroundContent);
var tableInfo = new AuxiliaryTableInfo(tableName, "后台内容表", 0, EAuxiliaryTableType.BackgroundContent, false, false, true, string.Empty);
BaiRongDataProvider.TableCollectionDao.Insert(tableInfo);
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(tableInfo.TableEnName);
}
//添加招聘内容表
if (!IsTableExists(EAuxiliaryTableType.JobContent))
{
var tableName = EAuxiliaryTableTypeUtils.GetDefaultTableName(EAuxiliaryTableType.JobContent);
var tableInfo = new AuxiliaryTableInfo(tableName, "招聘内容表", 0, EAuxiliaryTableType.JobContent, false, false, true, string.Empty);
BaiRongDataProvider.TableCollectionDao.Insert(tableInfo);
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(tableInfo.TableEnName);
}
//添加投票内容表
if (!IsTableExists(EAuxiliaryTableType.VoteContent))
{
var tableName = EAuxiliaryTableTypeUtils.GetDefaultTableName(EAuxiliaryTableType.VoteContent);
var tableInfo = new AuxiliaryTableInfo(tableName, "投票内容表", 0, EAuxiliaryTableType.VoteContent, false, false, true, string.Empty);
BaiRongDataProvider.TableCollectionDao.Insert(tableInfo);
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(tableInfo.TableEnName);
}
//添加信息公开内容表
if (!IsTableExists(EAuxiliaryTableType.GovPublicContent))
{
var tableName = EAuxiliaryTableTypeUtils.GetDefaultTableName(EAuxiliaryTableType.GovPublicContent);
var tableInfo = new AuxiliaryTableInfo(tableName, "信息公开内容表", 0, EAuxiliaryTableType.GovPublicContent, false, false, true, string.Empty);
BaiRongDataProvider.TableCollectionDao.Insert(tableInfo);
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(tableInfo.TableEnName);
}
//添加互动交流内容表
if (!IsTableExists(EAuxiliaryTableType.GovInteractContent))
{
var tableName = EAuxiliaryTableTypeUtils.GetDefaultTableName(EAuxiliaryTableType.GovInteractContent);
var tableInfo = new AuxiliaryTableInfo(tableName, "互动交流内容表", 0, EAuxiliaryTableType.GovInteractContent, false, false, true, string.Empty);
BaiRongDataProvider.TableCollectionDao.Insert(tableInfo);
BaiRongDataProvider.TableMetadataDao.CreateAuxiliaryTable(tableInfo.TableEnName);
}
}
private void LoadDisplayAttributeCheckBoxList()
{
var nodeInfo = NodeManager.GetNodeInfo(PublishmentSystemId, _nodeId);
var relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(PublishmentSystemId, _nodeId);
var modelInfo = ContentModelManager.GetContentModelInfo(PublishmentSystemInfo, nodeInfo.ContentModelId);
var tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(modelInfo.TableType);
var styleInfoList = TableStyleManager.GetTableStyleInfoList(tableStyle, modelInfo.TableName, relatedIdentities);
styleInfoList = ContentUtility.GetAllTableStyleInfoList(PublishmentSystemInfo, tableStyle, styleInfoList);
foreach (var styleInfo in styleInfoList)
{
var listItem = new ListItem(styleInfo.DisplayName, styleInfo.AttributeName);
listItem.Selected = styleInfo.IsVisible;
cblDisplayAttributes.Items.Add(listItem);
}
}
public void Update(ContentModelInfo contentModelInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmModelName, EDataType.NVarChar, 50, contentModelInfo.ModelName),
GetParameter(ParmTableName, EDataType.VarChar, 200, contentModelInfo.TableName),
GetParameter(ParmTableType, EDataType.VarChar, 50, EAuxiliaryTableTypeUtils.GetValue(contentModelInfo.TableType)),
GetParameter(ParmIconUrl, EDataType.VarChar, 50, contentModelInfo.IconUrl),
GetParameter(ParmDescription, EDataType.NVarChar, 255, contentModelInfo.Description),
GetParameter(ParmModelId, EDataType.VarChar, 50, contentModelInfo.ModelId),
GetParameter(ParmSiteId, EDataType.Integer, contentModelInfo.SiteId)
};
ExecuteNonQuery(SqlUpdate, parms);
ContentModelUtils.RemoveCache(contentModelInfo.SiteId);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_tableName = Body.GetQueryString("tableName");
_tableType = EAuxiliaryTableTypeUtils.GetEnumType(Body.GetQueryString("tableType"));
_tableStyle = ETableStyleUtils.GetStyleType(_tableType);
_redirectUrl = GetRedirectUrl(_tableName, _tableType);
_attributeNames = TableManager.GetAttributeNameList(_tableStyle, _tableName);
if (IsPostBack)
{
return;
}
BreadCrumbSys(AppManager.Sys.LeftMenu.Auxiliary, $"虚拟字段管理（{_tableName}）", AppManager.Sys.Permission.SysAuxiliary);
//删除样式
if (Body.IsQueryExists("DeleteStyle"))
{
DeleteStyle();
}
else if (Body.IsQueryExists("SetTaxis"))
{
SetTaxis();
}
var styleInfoList = TableStyleManager.GetTableStyleInfoList(_tableStyle, _tableName, new List <int> {
0
});
DgContents.DataSource = styleInfoList;
DgContents.ItemDataBound += dgContents_ItemDataBound;
DgContents.DataBind();
AddStyle.Attributes.Add("onclick", ModalTableStyleAdd.GetOpenWindowString(0, _tableName, string.Empty, _tableStyle, _redirectUrl));
AddStyles.Attributes.Add("onclick", ModalTableStylesAdd.GetOpenWindowString(_tableName, _tableStyle, _redirectUrl));
Import.Attributes.Add("onclick", ModalTableStyleImport.GetOpenWindowString(_tableName, _tableStyle));
Export.Attributes.Add("onclick", ModalExportMessage.GetOpenWindowStringToSingleTableStyle(_tableStyle, _tableName));
}
public EAuxiliaryTableType GetTableType(string tableEnName)
{
var type = EAuxiliaryTableType.BackgroundContent;
var parms = new IDataParameter[]
{
GetParameter(ParmTableEnname, EDataType.VarChar, 50, tableEnName),
};
using (var rdr = ExecuteReader(SqlSelectTableType, parms))
{
if (rdr.Read())
{
type = EAuxiliaryTableTypeUtils.GetEnumType(GetString(rdr, 0));
}
rdr.Close();
}
return(type);
}
public static List <BackgroundContentInfo> GetContentsByCsvFile(string filePath, PublishmentSystemInfo publishmentSystemInfo,
NodeInfo nodeInfo)
{
var contentInfoList = new List <BackgroundContentInfo>();
List <string> head;
List <List <string> > rows;
CsvUtils.Import(filePath, out head, out rows);
if (rows.Count > 0)
{
var relatedidentityes =
RelatedIdentities.GetChannelRelatedIdentities(
publishmentSystemInfo.PublishmentSystemId, nodeInfo.NodeId);
var modelInfo = ContentModelManager.GetContentModelInfo(publishmentSystemInfo,
nodeInfo.ContentModelId);
var tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(modelInfo.TableType);
// ArrayList tableStyleInfoArrayList = TableStyleManager.GetTableStyleInfoArrayList(ETableStyle.BackgroundContent, publishmentSystemInfo.AuxiliaryTableForContent, relatedidentityes);
var tableStyleInfoList = TableStyleManager.GetTableStyleInfoList(tableStyle,
modelInfo.TableName, relatedidentityes);
tableStyleInfoList = ContentUtility.GetAllTableStyleInfoList(publishmentSystemInfo,
tableStyle, tableStyleInfoList);
var nameValueCollection = new NameValueCollection();
foreach (var styleInfo in tableStyleInfoList)
{
nameValueCollection[styleInfo.DisplayName] = styleInfo.AttributeName.ToLower();
}
var attributeNames = new List <string>();
foreach (var columnName in head)
{
if (!string.IsNullOrEmpty(nameValueCollection[columnName]))
{
attributeNames.Add(nameValueCollection[columnName]);
}
else
{
attributeNames.Add(columnName);
}
}
foreach (var row in rows)
{
var contentInfo = new BackgroundContentInfo();
if (row.Count != attributeNames.Count)
{
continue;
}
for (var i = 0; i < attributeNames.Count; i++)
{
var attributeName = attributeNames[i];
if (!string.IsNullOrEmpty(attributeName))
{
var value = row[i];
contentInfo.SetExtendedAttribute(attributeName, value);
}
}
if (!string.IsNullOrEmpty(contentInfo.Title))
{
contentInfo.PublishmentSystemId = publishmentSystemInfo.PublishmentSystemId;
contentInfo.NodeId = nodeInfo.NodeId;
contentInfo.LastEditDate = DateTime.Now;
contentInfoList.Add(contentInfo);
}
}
}
return(contentInfoList);
}
public string GetAuxiliatyTableType(string auxiliaryTableType)
{
return(EAuxiliaryTableTypeUtils.GetText(EAuxiliaryTableTypeUtils.GetEnumType(auxiliaryTableType)));
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var attributeNameList = TranslateUtils.StringCollectionToStringList(Request.Form["attributeName"]);
var dataTypeList = TranslateUtils.StringCollectionToStringList(Request.Form["dataType"]);
var dataLengthList = TranslateUtils.StringCollectionToStringList(Request.Form["dataLength"]);
for (var i = 0; i < attributeNameList.Count; i++)
{
if (dataTypeList.Count < attributeNameList.Count)
{
dataTypeList.Add(string.Empty);
}
if (dataLengthList.Count < attributeNameList.Count)
{
dataLengthList.Add(string.Empty);
}
}
var tableStyle = EAuxiliaryTableTypeUtils.GetTableStyle(_tableType);
var attributeNameArrayList = TableManager.GetAttributeNameList(tableStyle, _tableName, true);
attributeNameArrayList.AddRange(TableManager.GetHiddenAttributeNameList(tableStyle));
for (var i = 0; i < attributeNameList.Count; i++)
{
var attributeName = attributeNameList[i];
var dataType = dataTypeList[i];
var dataLength = dataLengthList[i];
if (attributeNameArrayList.IndexOf(attributeName.Trim().ToLower()) != -1)
{
FailMessage("字段添加失败，字段名已存在！");
}
else if (!SqlUtils.IsAttributeNameCompliant(attributeName))
{
FailMessage("字段名不符合系统要求！");
}
else
{
var info = new TableMetadataInfo
{
AuxiliaryTableEnName = _tableName,
AttributeName = attributeName,
DataType = EDataTypeUtils.GetEnumType(dataType)
};
var hashtable = new Hashtable
{
[EDataType.DateTime] = new[] { "8", "false" },
[EDataType.Integer] = new[] { "4", "false" },
[EDataType.NChar] = new[] { "50", "true" },
[EDataType.NText] = new[] { "16", "false" },
[EDataType.NVarChar] = new[] { "255", "true" }
};
var strArr = (string[])hashtable[EDataTypeUtils.GetEnumType(dataType)];
if (strArr[1].Equals("false"))
{
dataLength = strArr[0];
}
if (string.IsNullOrEmpty(dataLength))
{
dataLength = strArr[0];
}
info.DataLength = int.Parse(dataLength);
if (info.DataType == EDataType.NVarChar || info.DataType == EDataType.NChar)
{
var maxLength = SqlUtils.GetMaxLengthForNVarChar();
if (info.DataLength <= 0 || info.DataLength > maxLength)
{
FailMessage($"字段修改失败，数据长度的值必须位于 1 和 {maxLength} 之间");
return;
}
}
info.IsSystem = false;
try
{
BaiRongDataProvider.TableMetadataDao.Insert(info);
Body.AddAdminLog("添加辅助表字段",
$"辅助表:{_tableName},字段名:{info.AttributeName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, ex.Message);
}
}
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
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);
}
}
}
}
