public static string GetText(EAuxiliaryTableType type)
{
if (type == EAuxiliaryTableType.BackgroundContent)
{
return("内容");
}
else if (type == EAuxiliaryTableType.GovPublicContent)
{
return("信息公开");
}
else if (type == EAuxiliaryTableType.GovInteractContent)
{
return("互动交流");
}
else if (type == EAuxiliaryTableType.VoteContent)
{
return("投票");
}
else if (type == EAuxiliaryTableType.JobContent)
{
return("招聘");
}
else if (type == EAuxiliaryTableType.UserDefined)
{
return("自定义");
}
else
{
throw new Exception();
}
}
public static string GetValue(EAuxiliaryTableType type)
{
if (type == EAuxiliaryTableType.BackgroundContent)
{
return("BackgroundContent");
}
else if (type == EAuxiliaryTableType.GovPublicContent)
{
return("GovPublicContent");
}
else if (type == EAuxiliaryTableType.GovInteractContent)
{
return("GovInteractContent");
}
else if (type == EAuxiliaryTableType.VoteContent)
{
return("VoteContent");
}
else if (type == EAuxiliaryTableType.JobContent)
{
return("JobContent");
}
else if (type == EAuxiliaryTableType.UserDefined)
{
return("UserDefined");
}
else
{
throw new Exception();
}
}
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 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 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 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 void ReCreateAuxiliaryTable(string tableEnName, EAuxiliaryTableType tableType)
{
var defaultTableMetadataInfoList = BaiRongDataProvider.AuxiliaryTableDataDao.GetDefaultTableMetadataInfoList(tableEnName, tableType);
if (BaiRongDataProvider.TableStructureDao.IsTableExists(tableEnName))
{
var updateParms = new IDataParameter[]
{
GetParameter("@IsCreatedInDB", EDataType.VarChar, 18, true.ToString()),
GetParameter("@IsChangedAfterCreatedInDB", EDataType.VarChar, 18, false.ToString()),
GetParameter("@TableENName", EDataType.VarChar, 50, tableEnName)
};
var taxis = GetMaxTaxis(tableEnName) + 1;
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
foreach (var tableMetadataInfo in defaultTableMetadataInfoList)
{
if (GetTableMetadataId(tableEnName, tableMetadataInfo.AttributeName) == 0)
{
InsertWithTransaction(tableMetadataInfo, tableType, taxis++, trans);
}
}
string dropTableSqlString = $"DROP TABLE [{tableEnName}]";
var createTableSqlString = BaiRongDataProvider.AuxiliaryTableDataDao.GetCreateAuxiliaryTableSqlString(tableEnName);
ExecuteNonQuery(trans, dropTableSqlString);
var reader = new System.IO.StringReader(createTableSqlString);
string sql;
while (null != (sql = SqlUtils.ReadNextStatementFromStream(reader)))
{
ExecuteNonQuery(trans, sql.Trim());
}
ExecuteNonQuery(trans, "UPDATE bairong_TableCollection SET IsCreatedInDB = @IsCreatedInDB, IsChangedAfterCreatedInDB = @IsChangedAfterCreatedInDB WHERE TableENName = @TableENName", updateParms);
TableManager.IsChanged = true;
SqlUtils.Cache_RemoveTableColumnInfoListCache();
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
}
public static ListItem GetListItem(EAuxiliaryTableType type, bool selected)
{
var item = new ListItem(GetText(type), GetValue(type));
if (selected)
{
item.Selected = true;
}
return(item);
}
public ContentModelInfo(string modelId, int siteId, string modelName, bool isSystem, string tableName, EAuxiliaryTableType tableType, string iconUrl, string description)
{
ModelId = modelId;
SiteId = siteId;
ModelName = modelName;
IsSystem = isSystem;
TableName = tableName;
TableType = tableType;
IconUrl = iconUrl;
Description = description;
}
public AuxiliaryTableInfo(string tableEnName, string tableCnName, int attributeNum, EAuxiliaryTableType auxiliaryTableType, bool isCreatedInDb, bool isChangedAfterCreatedInDb, bool isDefault, string description)
{
TableEnName = tableEnName;
TableCnName = tableCnName;
AttributeNum = attributeNum;
AuxiliaryTableType = auxiliaryTableType;
IsCreatedInDb = isCreatedInDb;
IsChangedAfterCreatedInDb = isChangedAfterCreatedInDb;
IsDefault = isDefault;
Description = description;
}
public static bool Equals(EAuxiliaryTableType type, string typeStr)
{
if (string.IsNullOrEmpty(typeStr))
{
return(false);
}
if (string.Equals(GetValue(type).ToLower(), typeStr.ToLower()))
{
return(true);
}
return(false);
}
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 InsertSystemItems(string tableEnName, EAuxiliaryTableType tableType, IDbTransaction trans)
{
var list = BaiRongDataProvider.AuxiliaryTableDataDao.GetDefaultTableMetadataInfoList(tableEnName, tableType);
if (list != null && list.Count > 0)
{
var taxis = 1;
foreach (var info in list)
{
InsertWithTransaction(info, tableType, taxis++, trans);
}
}
}
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 string GetFirstTableNameByTableType(EAuxiliaryTableType tableType)
{
var tableName = string.Empty;
string sqlString =
$"SELECT TableENName FROM bairong_TableCollection WHERE AuxiliaryTableType = '{EAuxiliaryTableTypeUtils.GetValue(tableType)}' AND IsCreatedInDB = 'True'";
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read())
{
tableName = GetString(rdr, 0);
}
rdr.Close();
}
return(tableName);
}
public bool IsTableExists(EAuxiliaryTableType tableType)
{
var isExists = false;
string sqlString =
$"SELECT TableENName FROM bairong_TableCollection WHERE AuxiliaryTableType = '{EAuxiliaryTableTypeUtils.GetValue(tableType)}' AND IsCreatedInDB = 'True'";
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read() && !rdr.IsDBNull(0))
{
isExists = true;
}
rdr.Close();
}
return(isExists);
}
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 static ETableStyle GetTableStyle(EAuxiliaryTableType tableType)
{
if (tableType == EAuxiliaryTableType.GovPublicContent)
{
return(ETableStyle.GovPublicContent);
}
else if (tableType == EAuxiliaryTableType.GovInteractContent)
{
return(ETableStyle.GovInteractContent);
}
else if (tableType == EAuxiliaryTableType.VoteContent)
{
return(ETableStyle.VoteContent);
}
else if (tableType == EAuxiliaryTableType.JobContent)
{
return(ETableStyle.JobContent);
}
else if (tableType == EAuxiliaryTableType.UserDefined)
{
return(ETableStyle.UserDefined);
}
return(ETableStyle.BackgroundContent);
}
internal void InsertWithTransaction(TableMetadataInfo info, EAuxiliaryTableType tableType, int taxis, IDbTransaction trans)
{
var sqlString = "INSERT INTO bairong_TableMetadata (AuxiliaryTableENName, AttributeName, DataType, DataLength, Taxis, IsSystem) VALUES (@AuxiliaryTableENName, @AttributeName, @DataType, @DataLength, @Taxis, @IsSystem)";
var insertParms = new IDataParameter[]
{
GetParameter(ParmAuxiliaryTableEnname, EDataType.VarChar, 50, info.AuxiliaryTableEnName),
GetParameter(ParmAttributeName, EDataType.VarChar, 50, info.AttributeName),
GetParameter(ParmDataType, EDataType.VarChar, 50, EDataTypeUtils.GetValue(info.DataType)),
GetParameter(ParmDataLength, EDataType.Integer, info.DataLength),
GetParameter(ParmTaxis, EDataType.Integer, taxis),
GetParameter(ParmIsSystem, EDataType.VarChar, 18, info.IsSystem.ToString())
};
ExecuteNonQuery(trans, sqlString, insertParms);
if (info.StyleInfo != null)
{
info.StyleInfo.TableName = info.AuxiliaryTableEnName;
info.StyleInfo.AttributeName = info.AttributeName;
BaiRongDataProvider.TableStyleDao.InsertWithTransaction(info.StyleInfo, EAuxiliaryTableTypeUtils.GetTableStyle(tableType), trans);
TableStyleManager.IsChanged = true;
}
TableManager.IsChanged = true;
}
public static string GetDefaultTableName(EAuxiliaryTableType tableType)
{
if (tableType == EAuxiliaryTableType.GovPublicContent)
{
return("model_WCM_GovPublic");
}
else if (tableType == EAuxiliaryTableType.GovInteractContent)
{
return("model_WCM_GovInteract");
}
else if (tableType == EAuxiliaryTableType.VoteContent)
{
return("model_Vote");
}
else if (tableType == EAuxiliaryTableType.JobContent)
{
return("model_Job");
}
else if (tableType == EAuxiliaryTableType.UserDefined)
{
return("model_UserDefined");
}
return("model_Content");
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_tableType = EAuxiliaryTableTypeUtils.GetEnumType(Body.GetQueryString("TableType"));
_tableName = Body.GetQueryString("TableName");
_attributeName = Body.GetQueryString("AttributeName");
if (!IsPostBack)
{
var metadataInfo = TableManager.GetTableMetadataInfo(_tableName, _attributeName);
if (metadataInfo != null)
{
lblAttributeName.Text = metadataInfo.AttributeName;
AuxiliaryTableENName.Text = metadataInfo.AuxiliaryTableEnName;
DataType.Text = metadataInfo.DataType.ToString();
DataLength.Text = metadataInfo.DataLength.ToString();
var styleInfo = TableStyleManager.GetTableStyleInfo(EAuxiliaryTableTypeUtils.GetTableStyle(_tableType), metadataInfo.AuxiliaryTableEnName, metadataInfo.AttributeName, new List <int> {
0
});
if (EInputTypeUtils.EqualsAny(styleInfo.InputType, EInputType.CheckBox, EInputType.Radio, EInputType.SelectMultiple, EInputType.SelectOne))
{
RowDefaultValue.Visible = RowIsHorizontal.Visible = false;
RowSetItems.Visible = true;
if (EInputTypeUtils.EqualsAny(styleInfo.InputType, EInputType.CheckBox, EInputType.Radio))
{
RowIsHorizontal.Visible = true;
}
}
else if (EInputTypeUtils.EqualsAny(styleInfo.InputType, EInputType.Text, EInputType.TextArea, EInputType.TextEditor))
{
RowDefaultValue.Visible = true;
RowSetItems.Visible = RowIsHorizontal.Visible = false;
}
else
{
RowDefaultValue.Visible = RowIsHorizontal.Visible = RowSetItems.Visible = false;
}
if (metadataInfo.IsSystem)
{
RowDefaultValue.Visible = RowIsHorizontal.Visible = RowSetItems.Visible = false;
}
DisplayName.Text = styleInfo.DisplayName;
HelpText.Text = styleInfo.HelpText;
IsVisible.Text = StringUtils.GetTrueOrFalseImageHtml(styleInfo.IsVisible.ToString());
IsValidate.Text = StringUtils.GetTrueImageHtml(styleInfo.Additional.IsValidate);
InputType.Text = EInputTypeUtils.GetText(EInputTypeUtils.GetEnumType(styleInfo.InputType));
DefaultValue.Text = styleInfo.DefaultValue;
IsHorizontal.Text = StringUtils.GetBoolText(styleInfo.IsHorizontal);
var styleItems = BaiRongDataProvider.TableStyleDao.GetStyleItemInfoList(styleInfo.TableStyleId);
MyRepeater.DataSource = TableStyleManager.GetStyleItemDataSet(styleItems.Count, styleItems);
MyRepeater.ItemDataBound += MyRepeater_ItemDataBound;
MyRepeater.DataBind();
}
else
{
FailMessage("此字段为虚拟字段，在数据库中不存在！");
phAttribute.Visible = false;
}
}
}
/// <summary>
/// 获取表的使用次数，不抛出错误
/// </summary>
/// <param name="tableEnName"></param>
/// <param name="tableType"></param>
/// <returns></returns>
public int GetTableUsedNum(string tableEnName, EAuxiliaryTableType tableType)
{
var count = 0;
if (tableType == EAuxiliaryTableType.BackgroundContent)
{
string sqlString =
$"SELECT COUNT(*) FROM siteserver_PublishmentSystem WHERE (AuxiliaryTableForContent = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString);
}
catch
{
// ignored
}
}
else if (tableType == EAuxiliaryTableType.GovPublicContent)
{
string sqlString =
$"SELECT COUNT(*) FROM siteserver_PublishmentSystem WHERE (AuxiliaryTableForGovPublic = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString);
}
catch
{
// ignored
}
}
else if (tableType == EAuxiliaryTableType.GovInteractContent)
{
string sqlString =
$"SELECT COUNT(*) FROM siteserver_PublishmentSystem WHERE (AuxiliaryTableForGovInteract = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString);
}
catch
{
// ignored
}
}
else if (tableType == EAuxiliaryTableType.VoteContent)
{
string sqlString =
$"SELECT COUNT(*) FROM siteserver_PublishmentSystem WHERE (AuxiliaryTableForVote = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString);
}
catch
{
// ignored
}
}
else if (tableType == EAuxiliaryTableType.JobContent)
{
string sqlString =
$"SELECT COUNT(*) FROM siteserver_PublishmentSystem WHERE (AuxiliaryTableForJob = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString);
}
catch
{
// ignored
}
}
string sqlString2 =
$"SELECT COUNT(*) FROM bairong_ContentModel WHERE (TableName = '{PageUtils.FilterSql(tableEnName)}')";
try
{
count += BaiRongDataProvider.DatabaseDao.GetIntResult(sqlString2);
}
catch
{
// ignored
}
return(count);
}
public List <TableMetadataInfo> GetDefaultTableMetadataInfoList(string tableName, EAuxiliaryTableType tableType)
{
var arraylist = new List <TableMetadataInfo>();
if (tableType == EAuxiliaryTableType.BackgroundContent)
{
var metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.SubTitle, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.ImageUrl, EDataType.VarChar, 200, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.VideoUrl, EDataType.VarChar, 200, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.FileUrl, EDataType.VarChar, 200, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.LinkUrl, EDataType.NVarChar, 200, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.Content, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.Summary, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.Author, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.Source, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.IsRecommend, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.IsHot, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, BackgroundContentAttribute.IsColor, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.IsTop, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.AddDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
}
else if (tableType == EAuxiliaryTableType.GovPublicContent)
{
var metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.Identifier, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.Description, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.PublishDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.EffectDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.IsAbolition, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.AbolitionDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.DocumentNo, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.Publisher, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.Keywords, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.ImageUrl, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.FileUrl, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.IsRecommend, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.IsHot, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.IsColor, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.IsTop, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovPublicContentAttribute.Content, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.AddDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
}
else if (tableType == EAuxiliaryTableType.GovInteractContent)
{
var metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.RealName, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Organization, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.CardType, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.CardNo, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Phone, EDataType.VarChar, 50, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.PostCode, EDataType.VarChar, 50, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Address, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Email, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Fax, EDataType.VarChar, 50, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.TypeId, EDataType.Integer, 38, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.IsPublic, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.Content, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.FileUrl, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, GovInteractContentAttribute.DepartmentId, EDataType.Integer, 38, 0, true);
arraylist.Add(metadataInfo);
}
else if (tableType == EAuxiliaryTableType.VoteContent)
{
var metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.SubTitle, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.MaxSelectNum, EDataType.Integer, 38, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.ImageUrl, EDataType.VarChar, 200, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.Content, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.Summary, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.AddDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.EndDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.IsVotedView, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, VoteContentAttribute.HiddenContent, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
}
else if (tableType == EAuxiliaryTableType.JobContent)
{
var metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.Department, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.Location, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.NumberOfPeople, EDataType.NVarChar, 50, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.Responsibility, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.Requirement, EDataType.NText, 16, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, JobContentAttribute.IsUrgent, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.IsTop, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.AddDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
}
else if (tableType == EAuxiliaryTableType.UserDefined)
{
var metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.Title, EDataType.NVarChar, 255, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.IsTop, EDataType.VarChar, 18, 0, true);
arraylist.Add(metadataInfo);
metadataInfo = new TableMetadataInfo(0, tableName, ContentAttribute.AddDate, EDataType.DateTime, 8, 0, true);
arraylist.Add(metadataInfo);
}
return(arraylist);
}
public static string GetTableName(PublishmentSystemInfo publishmentSystemInfo, EAuxiliaryTableType tableType)
{
var tableName = string.Empty;
if (Equals(EAuxiliaryTableType.BackgroundContent, tableType))
{
tableName = publishmentSystemInfo.AuxiliaryTableForContent;
}
else if (Equals(EAuxiliaryTableType.GovInteractContent, tableType))
{
tableName = publishmentSystemInfo.AuxiliaryTableForGovInteract;
}
else if (Equals(EAuxiliaryTableType.GovPublicContent, tableType))
{
tableName = publishmentSystemInfo.AuxiliaryTableForGovPublic;
}
else if (Equals(EAuxiliaryTableType.JobContent, tableType))
{
tableName = publishmentSystemInfo.AuxiliaryTableForJob;
}
else if (Equals(EAuxiliaryTableType.VoteContent, tableType))
{
tableName = publishmentSystemInfo.AuxiliaryTableForVote;
}
return(tableName);
}
public static bool Equals(string typeStr, EAuxiliaryTableType type)
{
return(Equals(type, typeStr));
}
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));
}
}
