public void DeleteAndInsertStyleItems(IDbTransaction trans, int tableStyleId, List <TableStyleItemInfo> styleItems)
{
var parms = new IDataParameter[]
{
GetParameter(ParmTableStyleId, DataType.Integer, tableStyleId)
};
var sqlString = $"DELETE FROM {TableName} WHERE {nameof(TableStyleItemInfo.TableStyleId)} = @{nameof(TableStyleItemInfo.TableStyleId)}";
ExecuteNonQuery(trans, sqlString, parms);
if (styleItems == null || styleItems.Count == 0)
{
return;
}
sqlString =
$"INSERT INTO {TableName} ({nameof(TableStyleItemInfo.TableStyleId)}, {nameof(TableStyleItemInfo.ItemTitle)}, {nameof(TableStyleItemInfo.ItemValue)}, {nameof(TableStyleItemInfo.IsSelected)}) VALUES (@{nameof(TableStyleItemInfo.TableStyleId)}, @{nameof(TableStyleItemInfo.ItemTitle)}, @{nameof(TableStyleItemInfo.ItemValue)}, @{nameof(TableStyleItemInfo.IsSelected)})";
foreach (var itemInfo in styleItems)
{
var insertItemParms = new IDataParameter[]
{
GetParameter(ParmTableStyleId, DataType.Integer, itemInfo.TableStyleId),
GetParameter(ParmItemTitle, DataType.VarChar, 255, itemInfo.ItemTitle),
GetParameter(ParmItemValue, DataType.VarChar, 255, itemInfo.ItemValue),
GetParameter(ParmIsSelected, DataType.VarChar, 18, itemInfo.IsSelected.ToString())
};
ExecuteNonQuery(trans, sqlString, insertItemParms);
}
TableStyleManager.ClearCache();
}
public void Delete(int relatedIdentity, string tableName, string attributeName)
{
var parms = new IDataParameter[]
{
GetParameter(ParmRelatedIdentity, DataType.Integer, relatedIdentity),
GetParameter(ParmTableName, DataType.VarChar, 50, tableName),
GetParameter(ParmAttributeName, DataType.VarChar, 50, attributeName)
};
ExecuteNonQuery(SqlDeleteTableStyle, parms);
TableStyleManager.ClearCache();
}
public void Delete(List <int> relatedIdentities, string tableName)
{
if (relatedIdentities == null || relatedIdentities.Count <= 0)
{
return;
}
var sqlString =
$"DELETE FROM siteserver_TableStyle WHERE RelatedIdentity IN ({TranslateUtils.ToSqlInStringWithoutQuote(relatedIdentities)}) AND TableName = '{AttackUtils.FilterSql(tableName)}'";
ExecuteNonQuery(sqlString);
TableStyleManager.ClearCache();
}
public int Insert(TableStyleInfo styleInfo)
{
int id;
var insertParms = new IDataParameter[]
{
GetParameter(ParmRelatedIdentity, DataType.Integer, styleInfo.RelatedIdentity),
GetParameter(ParmTableName, DataType.VarChar, 50, styleInfo.TableName),
GetParameter(ParmAttributeName, DataType.VarChar, 50, styleInfo.AttributeName),
GetParameter(ParmTaxis, DataType.Integer, styleInfo.Taxis),
GetParameter(ParmDisplayName, DataType.VarChar, 255, styleInfo.DisplayName),
GetParameter(ParmHelpText, DataType.VarChar, 255, styleInfo.HelpText),
GetParameter(ParmIsVisibleInList, DataType.VarChar, 18, styleInfo.IsVisibleInList.ToString()),
GetParameter(ParmInputType, DataType.VarChar, 50, styleInfo.InputType.Value),
GetParameter(ParmDefaultValue, DataType.VarChar, 255, styleInfo.DefaultValue),
GetParameter(ParmIsHorizontal, DataType.VarChar, 18, styleInfo.IsHorizontal.ToString()),
GetParameter(ParmExtendValues, DataType.Text, styleInfo.Additional.ToString())
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
id = ExecuteNonQueryAndReturnId(TableName, nameof(TableStyleInfo.Id), trans, SqlInsertTableStyle, insertParms);
DataProvider.TableStyleItemDao.Insert(trans, id, styleInfo.StyleItems);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
TableStyleManager.ClearCache();
return(id);
}
public void Update(TableStyleInfo info, bool deleteAndInsertStyleItems = true)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmAttributeName, DataType.VarChar, 50, info.AttributeName),
GetParameter(ParmTaxis, DataType.Integer, info.Taxis),
GetParameter(ParmDisplayName, DataType.VarChar, 255, info.DisplayName),
GetParameter(ParmHelpText, DataType.VarChar, 255, info.HelpText),
GetParameter(ParmIsVisibleInList, DataType.VarChar, 18, info.IsVisibleInList.ToString()),
GetParameter(ParmInputType, DataType.VarChar, 50, info.InputType.Value),
GetParameter(ParmDefaultValue, DataType.VarChar, 255, info.DefaultValue),
GetParameter(ParmIsHorizontal, DataType.VarChar, 18, info.IsHorizontal.ToString()),
GetParameter(ParmExtendValues, DataType.Text, info.Additional.ToString()),
GetParameter(ParmId, DataType.Integer, info.Id)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SqlUpdateTableStyle, updateParms);
if (deleteAndInsertStyleItems)
{
DataProvider.TableStyleItemDao.DeleteAndInsertStyleItems(trans, info.Id, info.StyleItems);
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
TableStyleManager.ClearCache();
}
