public string GetEditHtml(string isSystem, int tableMetadataId)
{
var retval = string.Empty;
if (!IsSystem(isSystem))
{
retval =
$@"<a href=""javascript:;"" onclick=""{ModalTableMetadataAdd.GetOpenWindowStringToEdit(_tableName,
_tableType, tableMetadataId)}"">修改字段</a>";
}
return(retval);
}
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));
}
}
