public AssembleFormatController(int formatId, AssembleMode mode, string connectionParameter, bool isCustomerCode, AssembleLocation fixedLocation, DatabaseType dbType = DatabaseType.SqlServer)
: base(connectionParameter, isCustomerCode, dbType)
{
UseFixedLocation = true;
FixedLocation = fixedLocation;
FillController(formatId, mode);
}
public void FillController(int formatId, AssembleMode mode, string sqlQuery, DataTable data)
{
FormatId = formatId;
CurrentAssembleMode = mode;
if (data != null)
{
Info = new AssembleInfo(this, data);
}
else if (!string.IsNullOrEmpty(sqlQuery))
{
Info = new AssembleInfo(this, sqlQuery);
}
}
private void FillController(int formatId, AssembleMode mode)
{
var sqlQuery =
" SELECT pt.*, p.*, s.*, obj.object_id, obj.object_name, objf.format_name " + Renames +
" FROM object_format objf " +
" INNER JOIN object obj on objf.object_id = obj.object_id" +
" INNER JOIN page_template AS pt ON pt.page_template_id=obj.page_template_id" +
" LEFT JOIN page AS p ON p.page_id=obj.page_id" +
" INNER JOIN site AS s ON pt.site_id = s.site_id" +
" WHERE objf.object_format_id=" + formatId;
FillController(formatId, mode, sqlQuery, null);
}
public AssembleFormatController(int formatId, AssembleMode mode, DataTable data)
{
FillController(formatId, mode, string.Empty, data);
}
public AssembleFormatController(int formatId, AssembleMode mode, string connectionParameter, DatabaseType dbType = DatabaseType.SqlServer)
: base(connectionParameter, dbType)
{
FillController(formatId, mode);
}
public override void Default()
{
FlipbookNumU = 5;
FlipbookNumV = 5;
Mode = AssembleMode.FullSpriteSheet;
}