public Dictionary <int, List <TableStyleItemInfo> > GetAllTableStyleItems()
{
var allDict = new Dictionary <int, List <TableStyleItemInfo> >();
using (var rdr = ExecuteReader("SELECT Id, TableStyleID, ItemTitle, ItemValue, IsSelected FROM siteserver_TableStyleItem"))
{
while (rdr.Read())
{
var i = 0;
var item = new TableStyleItemInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i));
allDict.TryGetValue(item.TableStyleId, out var list);
if (list == null)
{
list = new List <TableStyleItemInfo>();
}
list.Add(item);
allDict[item.TableStyleId] = list;
}
rdr.Close();
}
return(allDict);
}
private static AtomEntry ExportTableStyleItemInfo(TableStyleItemInfo styleItemInfo)
{
var entry = AtomUtility.GetEmptyEntry();
AtomUtility.AddDcElement(entry.AdditionalElements, "TableStyleItemID", styleItemInfo.TableStyleItemId.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, "TableStyleID", styleItemInfo.TableStyleId.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, "ItemTitle", styleItemInfo.ItemTitle);
AtomUtility.AddDcElement(entry.AdditionalElements, "ItemValue", styleItemInfo.ItemValue);
AtomUtility.AddDcElement(entry.AdditionalElements, "IsSelected", styleItemInfo.IsSelected.ToString());
return(entry);
}
private bool UpdateTableStyleInfo(TableStyleInfo styleInfo, TableStyleInfo body, bool isRapid, List <string> rapidValues, out string errorMessage)
{
errorMessage = string.Empty;
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, styleInfo.Id, 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, styleInfo.Id, styleItem.ItemTitle, styleItem.ItemValue, styleItem.IsSelected);
styleInfo.StyleItems.Add(itemInfo);
}
}
}
DataProvider.TableStyleDao.Update(styleInfo);
return(true);
}
private static AtomEntry ExportTableStyleItemInfo(TableStyleItemInfo styleItemInfo)
{
var entry = AtomUtility.GetEmptyEntry();
AtomUtility.AddDcElement(entry.AdditionalElements, new List <string> {
nameof(TableStyleItemInfo.Id), "TableStyleItemID"
}, styleItemInfo.Id.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, new List <string> {
nameof(TableStyleItemInfo.TableStyleId), "TableStyleID"
}, styleItemInfo.TableStyleId.ToString());
AtomUtility.AddDcElement(entry.AdditionalElements, nameof(TableStyleItemInfo.ItemTitle), styleItemInfo.ItemTitle);
AtomUtility.AddDcElement(entry.AdditionalElements, nameof(TableStyleItemInfo.ItemValue), styleItemInfo.ItemValue);
AtomUtility.AddDcElement(entry.AdditionalElements, nameof(TableStyleItemInfo.IsSelected), styleItemInfo.IsSelected.ToString());
return(entry);
}
public List <TableStyleItemInfo> GetStyleItemInfoList(int tableStyleId)
{
var styleItems = new List <TableStyleItemInfo>();
var parms = new IDataParameter[]
{
GetParameter(ParmTableStyleId, EDataType.Integer, tableStyleId)
};
using (var rdr = ExecuteReader(SqlSelectAllStyleItem, parms))
{
while (rdr.Read())
{
var i = 0;
var info = new TableStyleItemInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i));
styleItems.Add(info);
}
rdr.Close();
}
return(styleItems);
}
public static TableStyleInfo GetJobContentTableStyleInfo(string tableName, string attributeName)
{
var lowerAttributeName = attributeName.ToLower();
if (ContentAttribute.HiddenAttributes.Contains(lowerAttributeName))
{
return(GetContentHiddenTableStyleInfo(tableName, attributeName));
}
var styleInfo = new TableStyleInfo(0, 0, tableName, attributeName, 0, attributeName, string.Empty, true, false, true, EInputTypeUtils.GetValue(EInputType.Text), string.Empty, true, string.Empty);
var styleItems = new List <TableStyleItemInfo>();
if (lowerAttributeName == ContentAttribute.Title.ToLower())
{
styleInfo.DisplayName = "标题";
styleInfo.HelpText = "标题的名称";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.Text);
styleInfo.Additional.IsFormatString = true;
styleInfo.Additional.IsValidate = true;
styleInfo.Additional.IsRequired = true;
}
else if (lowerAttributeName == JobContentAttribute.Department.ToLower())
{
styleInfo.DisplayName = "所属部门";
styleInfo.HelpText = "所属部门";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.Text);
styleInfo.Additional.IsValidate = true;
styleInfo.Additional.IsRequired = true;
}
else if (lowerAttributeName == JobContentAttribute.Location.ToLower())
{
styleInfo.DisplayName = "工作地点";
styleInfo.HelpText = "工作地点";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.Text);
styleInfo.Additional.IsValidate = true;
styleInfo.Additional.IsRequired = true;
}
else if (lowerAttributeName == JobContentAttribute.NumberOfPeople.ToLower())
{
styleInfo.DisplayName = "招聘人数";
styleInfo.HelpText = "招聘人数";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.Text);
styleInfo.DefaultValue = "不限";
styleInfo.Additional.Width = "60px";
}
else if (lowerAttributeName == JobContentAttribute.Responsibility.ToLower())
{
styleInfo.DisplayName = "工作职责";
styleInfo.HelpText = "工作职责";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.TextEditor);
}
else if (lowerAttributeName == JobContentAttribute.Requirement.ToLower())
{
styleInfo.DisplayName = "工作要求";
styleInfo.HelpText = "工作要求";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.TextEditor);
}
else if (lowerAttributeName == JobContentAttribute.IsUrgent.ToLower())
{
styleInfo.DisplayName = "是否急聘";
styleInfo.HelpText = "是否急聘";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.CheckBox);
var itemInfo = new TableStyleItemInfo(0, styleInfo.TableStyleId, "急聘", true.ToString(), false);
styleItems.Add(itemInfo);
styleInfo.StyleItems = styleItems;
}
else if (lowerAttributeName == ContentAttribute.IsTop.ToLower())
{
styleInfo.DisplayName = "置顶";
styleInfo.HelpText = "是否为置顶内容";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.CheckBox);
}
else if (lowerAttributeName == ContentAttribute.AddDate.ToLower())
{
styleInfo.DisplayName = "添加日期";
styleInfo.HelpText = "内容的添加日期";
styleInfo.InputType = EInputTypeUtils.GetValue(EInputType.DateTime);
styleInfo.DefaultValue = Current;
}
return(styleInfo);
}
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);
}
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 UpdateTableStyleInfo(EInputType inputType)
{
var isChanged = false;
_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;
ArrayList styleItems = null;
if (inputType == EInputType.CheckBox || inputType == EInputType.Radio || inputType == EInputType.SelectMultiple || inputType == EInputType.SelectOne)
{
styleItems = new ArrayList();
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);
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, _styleInfo.TableStyleId, itemTitle.Text, itemValue.Text, isSelected.Checked);
styleItems.Add(itemInfo);
}
}
}
try
{
TableStyleManager.Update(_styleInfo);
TableStyleManager.DeleteAndInsertStyleItems(_styleInfo.TableStyleId, styleItems);
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);
}
private bool UpdateTableStyleInfo(InputType inputType)
{
var isChanged = false;
_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;
List <TableStyleItemInfo> styleItems = null;
if (inputType == InputType.CheckBox || inputType == InputType.Radio || inputType == InputType.SelectMultiple || inputType == InputType.SelectOne)
{
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);
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, _styleInfo.Id, tbTitle.Text, tbValue.Text, cbIsSelected.Checked);
styleItems.Add(itemInfo);
}
}
}
try
{
TableStyleManager.Update(_styleInfo);
TableStyleManager.DeleteAndInsertStyleItems(_styleInfo.Id, styleItems);
if (SiteId > 0)
{
AuthRequest.AddSiteLog(SiteId, "修改表单显示样式", $"字段名:{_styleInfo.AttributeName}");
}
else
{
AuthRequest.AddAdminLog("修改表单显示样式", $"字段名:{_styleInfo.AttributeName}");
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "显示样式修改失败：" + ex.Message);
}
return(isChanged);
}
