public static bool CreateAccessFileForContents(string filePath, SiteInfo siteInfo, ChannelInfo nodeInfo, List <int> contentIdList, List <string> displayAttributes, bool isPeriods, string dateFrom, string dateTo, ETriState checkedState)
{
DirectoryUtils.CreateDirectoryIfNotExists(DirectoryUtils.GetDirectoryPath(filePath));
FileUtils.DeleteFileIfExists(filePath);
var sourceFilePath = SiteServerAssets.GetPath(SiteServerAssets.Default.AccessMdb);
FileUtils.CopyFile(sourceFilePath, filePath);
var tableName = ChannelManager.GetTableName(siteInfo, nodeInfo);
var styleInfoList = TableStyleManager.GetContentStyleInfoList(siteInfo, nodeInfo);
styleInfoList = ContentUtility.GetAllTableStyleInfoList(styleInfoList);
var accessDao = new AccessDao(filePath);
var createTableSqlString = accessDao.GetCreateTableSqlString(nodeInfo.ChannelName, styleInfoList, displayAttributes);
accessDao.ExecuteSqlString(createTableSqlString);
bool isExport;
var insertSqlList = accessDao.GetInsertSqlStringList(nodeInfo.ChannelName, siteInfo.Id, nodeInfo.Id, tableName, styleInfoList, displayAttributes, contentIdList, isPeriods, dateFrom, dateTo, checkedState, out isExport);
foreach (var insertSql in insertSqlList)
{
accessDao.ExecuteSqlString(insertSql);
}
return(isExport);
}
public static bool CreateAccessFileForContents(string filePath, PublishmentSystemInfo publishmentSystemInfo, NodeInfo nodeInfo, List <int> contentIDArrayList, List <string> displayAttributes, bool isPeriods, string dateFrom, string dateTo, ETriState checkedState)
{
DirectoryUtils.CreateDirectoryIfNotExists(DirectoryUtils.GetDirectoryPath(filePath));
FileUtils.DeleteFileIfExists(filePath);
var sourceFilePath = SiteServerAssets.GetPath(SiteServerAssets.Default.AccessMdb);
FileUtils.CopyFile(sourceFilePath, filePath);
var relatedidentityes = RelatedIdentities.GetChannelRelatedIdentities(publishmentSystemInfo.PublishmentSystemId, nodeInfo.NodeId);
var modelInfo = ContentModelManager.GetContentModelInfo(publishmentSystemInfo, nodeInfo.ContentModelId);
var tableStyle = NodeManager.GetTableStyle(publishmentSystemInfo, nodeInfo);
var styleInfoList = TableStyleManager.GetTableStyleInfoList(tableStyle, modelInfo.TableName, relatedidentityes);
styleInfoList = ContentUtility.GetAllTableStyleInfoList(publishmentSystemInfo, tableStyle, styleInfoList);
var tableName = NodeManager.GetTableName(publishmentSystemInfo, nodeInfo);
var accessDAO = new AccessDao(filePath);
var createTableSqlString = accessDAO.GetCreateTableSqlString(nodeInfo.NodeName, styleInfoList, displayAttributes);
accessDAO.ExecuteSqlString(createTableSqlString);
bool isExport;
var insertSqlArrayList = accessDAO.GetInsertSqlStringArrayList(nodeInfo.NodeName, publishmentSystemInfo.PublishmentSystemId, nodeInfo.NodeId, tableStyle, tableName, styleInfoList, displayAttributes, contentIDArrayList, isPeriods, dateFrom, dateTo, checkedState, out isExport);
foreach (string insertSql in insertSqlArrayList)
{
accessDAO.ExecuteSqlString(insertSql);
}
return(isExport);
}
