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)); } }