/// <summary>
/// Fixed:
/// </summary>
public ExportSettingModel(
string referenceType,
long referenceId,
bool withTitle = false)
{
OnConstructing();
ReferenceType = referenceType;
ReferenceId = referenceId;
if (withTitle)
{
Title.Value = Forms.Data("ExportSettings_Title");
Get(where : Rds.ExportSettingsWhere()
.ReferenceType(ReferenceType)
.ReferenceId(ReferenceId)
.Title(Title.Value));
}
else
{
Get(where : Rds.ExportSettingsWhere()
.ReferenceType(ReferenceType)
.ReferenceId(ReferenceId),
orderBy: Rds.ExportSettingsOrderBy()
.Title(),
top: 1);
}
if (AccessStatus != Databases.AccessStatuses.Selected)
{
ExportColumns = new ExportColumns(ReferenceType);
}
SetByForm();
OnConstructed();
}
private void Set(DataRow dataRow)
{
AccessStatus = Databases.AccessStatuses.Selected;
foreach (DataColumn dataColumn in dataRow.Table.Columns)
{
var name = dataColumn.ColumnName;
switch (name)
{
case "ReferenceType": if (dataRow[name] != DBNull.Value)
{
ReferenceType = dataRow[name].ToString(); SavedReferenceType = ReferenceType;
}
break;
case "ReferenceId": if (dataRow[name] != DBNull.Value)
{
ReferenceId = dataRow[name].ToLong(); SavedReferenceId = ReferenceId;
}
break;
case "Title": if (dataRow[name] != DBNull.Value)
{
Title = new Title(dataRow, "ExportSettingId"); SavedTitle = Title.Value;
}
break;
case "ExportSettingId": if (dataRow[name] != DBNull.Value)
{
ExportSettingId = dataRow[name].ToLong(); SavedExportSettingId = ExportSettingId;
}
break;
case "Ver": Ver = dataRow[name].ToInt(); SavedVer = Ver; break;
case "AddHeader": AddHeader = dataRow[name].ToBool(); SavedAddHeader = AddHeader; break;
case "ExportColumns": ExportColumns = dataRow.String("ExportColumns").Deserialize <ExportColumns>() ?? new ExportColumns(ReferenceType); SavedExportColumns = ExportColumns.ToJson(); break;
case "Comments": Comments = dataRow["Comments"].ToString().Deserialize <Comments>() ?? new Comments(); SavedComments = Comments.ToJson(); break;
case "Creator": Creator = SiteInfo.User(dataRow.Int(name)); SavedCreator = Creator.Id; break;
case "Updator": Updator = SiteInfo.User(dataRow.Int(name)); SavedUpdator = Updator.Id; break;
case "CreatedTime": CreatedTime = new Time(dataRow, "CreatedTime"); SavedCreatedTime = CreatedTime.Value; break;
case "UpdatedTime": UpdatedTime = new Time(dataRow, "UpdatedTime"); Timestamp = dataRow.Field <DateTime>("UpdatedTime").ToString("yyyy/M/d H:m:s.fff"); SavedUpdatedTime = UpdatedTime.Value; break;
case "IsHistory": VerType = dataRow[name].ToBool() ? Versions.VerTypes.History : Versions.VerTypes.Latest; break;
}
}
}
/// <summary>
/// Fixed:
/// </summary>
private static HtmlBuilder Columns(
this HtmlBuilder hb, ExportColumns exportSettings, SiteSettings ss)
{
return(hb.FieldSet(
css: "fieldset enclosed-auto w500 h400",
legendText: Displays.ColumnList(),
action: () => hb
.FieldSelectable(
controlId: "ExportSettings_Columns",
fieldCss: "field-vertical w500",
controlContainerCss: "container-selectable",
controlWrapperCss: " h300",
listItemCollection: exportSettings.ExportColumnHash(ss),
selectedValueCollection: new List <string>(),
commandOptionAction: () => hb
.Div(css: "command-center", action: () => hb
.Button(
controlId: "ColumnToUp",
controlCss: "button-icon",
text: Displays.MoveUp(),
onClick: "$p.send($(this));",
icon: "ui-icon-circle-triangle-n",
action: "Set",
method: "post")
.Button(
controlId: "ColumnToDown",
controlCss: "button-icon",
text: Displays.MoveDown(),
onClick: "$p.send($(this));",
icon: "ui-icon-circle-triangle-s",
action: "Set",
method: "post")
.Button(
controlId: "ColumnToVisible",
controlCss: "button-icon",
text: Displays.Output(),
onClick: "$p.send($(this));",
icon: "ui-icon-image",
action: "Set",
method: "put")
.Button(
controlId: "ColumnToHide",
controlCss: "button-icon",
text: Displays.NotOutput(),
onClick: "$p.send($(this));",
icon: "ui-icon-close",
action: "Set",
method: "put")))));
}
private void SetBySession(Context context)
{
if (!context.Forms.Exists("ExportSettings_Title"))
{
Title = Session_Title(context: context);
}
if (!context.Forms.Exists("ExportSettings_AddHeader"))
{
AddHeader = Session_AddHeader(context: context);
}
if (!context.Forms.Exists("ExportSettings_ExportColumns"))
{
ExportColumns = Session_ExportColumns(context: context);
}
}
private void SetBySession()
{
if (!Forms.HasData("ExportSettings_Title"))
{
Title = Session_Title();
}
if (!Forms.HasData("ExportSettings_AddHeader"))
{
AddHeader = Session_AddHeader();
}
if (!Forms.HasData("ExportSettings_ExportColumns"))
{
ExportColumns = Session_ExportColumns();
}
}
public void SetByModel(ExportSettingModel exportSettingModel)
{
ReferenceType = exportSettingModel.ReferenceType;
ReferenceId = exportSettingModel.ReferenceId;
Title = exportSettingModel.Title;
AddHeader = exportSettingModel.AddHeader;
ExportColumns = exportSettingModel.ExportColumns;
Comments = exportSettingModel.Comments;
Creator = exportSettingModel.Creator;
Updator = exportSettingModel.Updator;
CreatedTime = exportSettingModel.CreatedTime;
UpdatedTime = exportSettingModel.UpdatedTime;
VerUp = exportSettingModel.VerUp;
Comments = exportSettingModel.Comments;
}
public virtual List <ReportColumn> GetColumnList()
{
if (ColumnList != null)
{
return(ColumnList);
}
if (ColumnsType != null)
{
return(GetColumnListFor(ColumnsType, ExportColumns, ServiceProvider));
}
return(ExportColumns.Select(x => new ReportColumn
{
Name = x
}).ToList());
}
public void SetByModel(ExportSettingModel exportSettingModel)
{
ReferenceType = exportSettingModel.ReferenceType;
ReferenceId = exportSettingModel.ReferenceId;
Title = exportSettingModel.Title;
AddHeader = exportSettingModel.AddHeader;
ExportColumns = exportSettingModel.ExportColumns;
Comments = exportSettingModel.Comments;
Creator = exportSettingModel.Creator;
Updator = exportSettingModel.Updator;
CreatedTime = exportSettingModel.CreatedTime;
UpdatedTime = exportSettingModel.UpdatedTime;
VerUp = exportSettingModel.VerUp;
Comments = exportSettingModel.Comments;
ClassHash = exportSettingModel.ClassHash;
NumHash = exportSettingModel.NumHash;
DateHash = exportSettingModel.DateHash;
DescriptionHash = exportSettingModel.DescriptionHash;
CheckHash = exportSettingModel.CheckHash;
AttachmentsHash = exportSettingModel.AttachmentsHash;
}
/// <summary>
/// Fixed:
/// </summary>
public string Set(SiteSettings ss, long id)
{
var invalid = ExportSettingValidator.OnExporting(ss);
switch (invalid)
{
case Error.Types.None: break;
default: return(invalid.MessageJson());
}
var res = new ExportSettingsResponseCollection(this);
ExportColumns = Session_ExportColumns();
ExportColumns.SetExport(
res,
Forms.ControlId(),
Forms.List("ExportSettings_Columns"),
GetSiteSettings());
ExportSettingUtilities.SetSessions(this);
return(res.ToJson());
}
private void Set(Context context, DataRow dataRow, string tableAlias = null)
{
AccessStatus = Databases.AccessStatuses.Selected;
foreach (DataColumn dataColumn in dataRow.Table.Columns)
{
var column = new ColumnNameInfo(dataColumn.ColumnName);
if (column.TableAlias == tableAlias)
{
switch (column.Name)
{
case "ReferenceType":
if (dataRow[column.ColumnName] != DBNull.Value)
{
ReferenceType = dataRow[column.ColumnName].ToString();
SavedReferenceType = ReferenceType;
}
break;
case "ReferenceId":
if (dataRow[column.ColumnName] != DBNull.Value)
{
ReferenceId = dataRow[column.ColumnName].ToLong();
SavedReferenceId = ReferenceId;
}
break;
case "Title":
if (dataRow[column.ColumnName] != DBNull.Value)
{
Title = new Title(dataRow, "ExportSettingId");
SavedTitle = Title.Value;
}
break;
case "ExportSettingId":
if (dataRow[column.ColumnName] != DBNull.Value)
{
ExportSettingId = dataRow[column.ColumnName].ToLong();
SavedExportSettingId = ExportSettingId;
}
break;
case "Ver":
Ver = dataRow[column.ColumnName].ToInt();
SavedVer = Ver;
break;
case "AddHeader":
AddHeader = dataRow[column.ColumnName].ToBool();
SavedAddHeader = AddHeader;
break;
case "ExportColumns":
ExportColumns = dataRow[column.ColumnName].ToString().Deserialize <ExportColumns>() ?? new ExportColumns(ReferenceType);
SavedExportColumns = ExportColumns.ToJson();
break;
case "Comments":
Comments = dataRow[column.ColumnName].ToString().Deserialize <Comments>() ?? new Comments();
SavedComments = Comments.ToJson();
break;
case "Creator":
Creator = SiteInfo.User(context: context, userId: dataRow.Int(column.ColumnName));
SavedCreator = Creator.Id;
break;
case "Updator":
Updator = SiteInfo.User(context: context, userId: dataRow.Int(column.ColumnName));
SavedUpdator = Updator.Id;
break;
case "CreatedTime":
CreatedTime = new Time(context, dataRow, column.ColumnName);
SavedCreatedTime = CreatedTime.Value;
break;
case "UpdatedTime":
UpdatedTime = new Time(context, dataRow, column.ColumnName); Timestamp = dataRow.Field <DateTime>(column.ColumnName).ToString("yyyy/M/d H:m:s.fff");
SavedUpdatedTime = UpdatedTime.Value;
break;
case "IsHistory":
VerType = dataRow.Bool(column.ColumnName)
? Versions.VerTypes.History
: Versions.VerTypes.Latest; break;
default:
switch (Def.ExtendedColumnTypes.Get(column.Name))
{
case "Class":
Class(
columnName: column.Name,
value: dataRow[column.ColumnName].ToString());
SavedClass(
columnName: column.Name,
value: Class(columnName: column.Name));
break;
case "Num":
Num(
columnName: column.Name,
value: dataRow[column.ColumnName].ToDecimal());
SavedNum(
columnName: column.Name,
value: Num(columnName: column.Name));
break;
case "Date":
Date(
columnName: column.Name,
value: dataRow[column.ColumnName].ToDateTime());
SavedDate(
columnName: column.Name,
value: Date(columnName: column.Name));
break;
case "Description":
Description(
columnName: column.Name,
value: dataRow[column.ColumnName].ToString());
SavedDescription(
columnName: column.Name,
value: Description(columnName: column.Name));
break;
case "Check":
Check(
columnName: column.Name,
value: dataRow[column.ColumnName].ToBool());
SavedCheck(
columnName: column.Name,
value: Check(columnName: column.Name));
break;
case "Attachments":
Attachments(
columnName: column.Name,
value: dataRow[column.ColumnName].ToString()
.Deserialize <Attachments>() ?? new Attachments());
SavedAttachments(
columnName: column.Name,
value: Attachments(columnName: column.Name).ToJson());
break;
}
break;
}
}
}
}
private ExportColumns GetExportColumns(List <GLExcelLine> items)
{
var exportColumns = new ExportColumns();
foreach (var item in items)
{
if (!string.IsNullOrWhiteSpace(item.CompanyNumber))
{
exportColumns.CompanyNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.RegionNumber))
{
exportColumns.RegionNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.SuperFundNumber))
{
exportColumns.SuperFundNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.FundNumber))
{
exportColumns.FundNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.LocationNumber))
{
exportColumns.LocationNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.CostCenterNumber))
{
exportColumns.CostCenterNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.DepartmentNumber))
{
exportColumns.DepartmentNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.AccountNumber))
{
exportColumns.AccountNumber = true;
}
if (!string.IsNullOrWhiteSpace(item.AccountSub))
{
exportColumns.AccountSub = true;
}
if (!string.IsNullOrWhiteSpace(item.Project))
{
exportColumns.Project = true;
}
if (!string.IsNullOrWhiteSpace(item.Note))
{
exportColumns.Note = true;
}
}
return(exportColumns);
}
