public NamedColumnsJoinImpl(SQLVendorImpl vendor, ColumnNameList cols)
: base(vendor)
{
ArgumentValidator.ValidateNotNull(nameof(cols), cols);
this._columns = cols;
}
public ColumnSourceByValuesImpl(SQLVendorImpl vendor, ColumnNameList columns, ImmutableArray <ImmutableArray <ValueExpression> > values)
: base(vendor, columns)
{
values.ValidateNotEmpty(nameof(values));
this._values = values;
}
public ColumnSourceByQueryImpl(SQLVendorImpl vendor, ColumnNameList columns, QueryExpression query)
: base(vendor, columns)
{
ArgumentValidator.ValidateNotNull(nameof(query), query);
this._query = query;
}
public UniqueConstraintImpl(SQLVendorImpl vendor, ColumnNameList columns, UniqueSpecification spec)
: base(vendor)
{
ArgumentValidator.ValidateNotNull(nameof(columns), columns);
this._columns = columns;
this._uniqueSpec = spec;
}
public TableAliasImpl(SQLVendorImpl vendor, String tableAlias, ColumnNameList columnAliases)
: base(vendor)
{
ArgumentValidator.ValidateNotEmpty(nameof(tableAlias), tableAlias);
this._tableAlias = tableAlias;
this._columnAliases = columnAliases;
}
public ForeignKeyConstraintImpl(SQLVendorImpl vendor, ColumnNameList sourceColumns, TableNameDirect targetTable, ColumnNameList targetColumns, MatchType?matchType, ReferentialAction?onDelete, ReferentialAction?onUpdate)
: base(vendor)
{
ArgumentValidator.ValidateNotNull(nameof(sourceColumns), sourceColumns);
ArgumentValidator.ValidateNotNull(nameof(targetTable), targetTable);
this._sourceColumns = sourceColumns;
this._targeTableName = targetTable;
this._targetColumns = targetColumns;
this._matchType = matchType;
this._onDelete = onDelete;
this._onUpdate = onUpdate;
}
/// <summary>
/// Creates instance of the <see cref="FastWindowGridModel<T>"/>
/// </summary>
public FastWindowGridModel(int rowCount)
{
RowCount = rowCount;
//Store the column names via reflection
ColumnPropertyInfoList = typeof(T).GetProperties().ToList();
for (var i = 0; i < ColumnPropertyInfoList.Count; i++)
{
//Store the display and server column name
var attribs = ColumnPropertyInfoList[i].GetCustomAttributes(typeof(ColumnNameAttribute)).ToList();
if (attribs.Any())
{
var attrib = (ColumnNameAttribute)attribs.First();
ColumnNameList.Add(attrib.DisplayName);
ServerNameList.Add(attrib.ServerName);
}
else
{
var name = ColumnPropertyInfoList[i].Name;
ColumnNameList.Add(name);
ServerNameList.Add(name);
}
//See if there is a width override
attribs = ColumnPropertyInfoList[i].GetCustomAttributes(typeof(ColumnWidthAttribute)).ToList();
if (attribs.Any())
{
var attrib = (ColumnWidthAttribute)attribs.First();
ColumnWidthOverrides[i] = attrib.Width;
}
}
ColumnCount = ColumnPropertyInfoList.Count;
//Fill the default filter strings
for (var i = 0; i < ColumnCount; i++)
{
ColumnFilters.Add(string.Empty);
}
//Fill the grid with blank rows
ClearGridRows(0, true);
}
public RegularViewSpecificationImpl(SQLVendorImpl vendor, ColumnNameList columns)
: base(vendor)
{
this._columns = columns;
}
public CorrespondingSpecImpl(SQLVendorImpl vendor, ColumnNameList cols)
: base(vendor)
{
this._columns = cols;
}
private void SetGridData()
{
var checkCell = new CheckBoxCell();
var textCellName = new GcTextBoxCell();
var numberCellOrder = new GcNumberCell();
var checkCellIndex = 0;
var numberCellIndex = 2;
var useContractNumber = UseLongTermAdvanceReceived && RegisterContractInAdvance;
var tableName = InputGridTypeId == InputGridType.Billing ? nameof(Billing) : nameof(Receipt);
var note1 = "備考1";
var note2 = "備考2";
var note3 = "備考3";
var note4 = "備考4";
foreach (var names in ColumnNameList.Where(x => x.TableName == tableName))
{
if (names.ColumnName == "Note1")
{
note1 = names.DisplayColumnName;
}
if (names.ColumnName == "Note2")
{
note2 = names.DisplayColumnName;
}
if (names.ColumnName == "Note3")
{
note3 = names.DisplayColumnName;
}
if (names.ColumnName == "Note4")
{
note4 = names.DisplayColumnName;
}
}
if (InputControlList.Count > 0)
{
foreach (var input in InputControlList)
{
if (input.ColumnName == "Note1")
{
input.ColumnNameJp = note1;
}
if (input.ColumnName == "Note2")
{
input.ColumnNameJp = note2;
}
if (input.ColumnName == "Note3")
{
input.ColumnNameJp = note3;
}
if (input.ColumnName == "Note4")
{
input.ColumnNameJp = note4;
}
}
if (!UseDiscount && InputGridTypeId.Equals(InputGridType.Billing))
{
var discountIndex = InputControlList.FindIndex(
x => x.ColumnName.Equals(DiscountName) &&
x.ColumnNameJp.Equals(DiscountJpName));
InputControlList.RemoveAt(discountIndex);
}
if (!useContractNumber && InputGridTypeId.Equals(InputGridType.Billing))
{
var contractIndex = InputControlList.FindIndex(
x => x.ColumnName.Equals(ContractName) &&
x.ColumnNameJp.Equals(ContractJpName));
InputControlList.RemoveAt(contractIndex);
}
grid.RowCount = InputControlList.Count;
for (var i = 0; i < InputControlList.Count; i++)
{
var inputControl = new InputControl();
inputControl = InputControlList[i];
checkCell = (CheckBoxCell)grid.Rows[i].Cells[0];
checkCell.Value = inputControl.TabStop;
textCellName = (GcTextBoxCell)grid.Rows[i].Cells[1];
textCellName.Value = inputControl.ColumnNameJp;
numberCellOrder = (GcNumberCell)grid.Rows[i].Cells[2];
numberCellOrder.Value = inputControl.TabIndex;
OnCheckedChanged(i, checkCellIndex, numberCellIndex);
}
}
else
{
var columnBillingName = new List <string> {
nameof(Billing.SalesAt),
nameof(Billing.BillingCategoryId),
nameof(Billing.TaxClassId),
nameof(Billing.DebitAccountTitleId),
nameof(Billing.UseDiscount),
nameof(Billing.Note1),
nameof(Billing.ContractNumber),
nameof(Billing.Quantity),
nameof(Billing.UnitSymbol),
nameof(Billing.UnitPrice),
nameof(Billing.Price),
nameof(Billing.TaxAmount),
nameof(Billing.BillingAmount),
};
var columnBillingNameJp = new List <string>
{
"売上日", "請求区分", "税区", "債権科目", "歩引計算",
note1, "契約番号", "数量", "単位", "単価",
"金額(抜)", "消費税", "請求額"
};
var columnReceiptName = new List <string>
{
"ReceiptCategory", "Note1", "DueAt", "ReceiptAmount", "BillNumber",
"BillBankCode", "BillBranchCode", "BillDrawAt", "BillDrawer",
"Note2", "Note3", "Note4"
};
var columnReceiptNameJp = new List <string>
{
"入金区分", note1, "期日", "金額", "手形番号",
"銀行コード", "支店コード", "振出日", "振出人",
note2, note3, note4
};
if (!UseDiscount && InputGridTypeId == InputGridType.Billing)
{
var nameIndex = columnBillingName.FindIndex(x => x.Equals(DiscountName));
var jpNameIndex = columnBillingNameJp.FindIndex(x => x.Equals(DiscountJpName));
columnBillingName.RemoveAt(nameIndex);
columnBillingNameJp.RemoveAt(jpNameIndex);
}
if (!useContractNumber && InputGridTypeId == InputGridType.Billing)
{
var nameIndex = columnBillingName.FindIndex(x => x.Equals(ContractName));
var jpNameIndex = columnBillingNameJp.FindIndex(x => x.Equals(ContractJpName));
columnBillingName.RemoveAt(nameIndex);
columnBillingNameJp.RemoveAt(jpNameIndex);
}
var columnName = InputGridTypeId == InputGridType.Billing
? columnBillingName : columnReceiptName;
var columnNameJp = InputGridTypeId == InputGridType.Billing
? columnBillingNameJp : columnReceiptNameJp;
grid.RowCount = columnName.Count;
for (var i = 0; i < grid.RowCount; i++)
{
checkCell = (CheckBoxCell)grid.Rows[i].Cells[0];
checkCell.Value = true;
textCellName = (GcTextBoxCell)grid.Rows[i].Cells[1];
textCellName.Value = columnNameJp[i];
numberCellOrder = (GcNumberCell)grid.Rows[i].Cells[2];
numberCellOrder.Value = i + 1;
OnCheckedChanged(i, checkCellIndex, numberCellIndex);
var inputControl = new InputControl();
inputControl.CompanyId = CompanyId;
inputControl.LoginUserId = Login.UserId;
inputControl.InputGridTypeId = InputGridTypeId;
inputControl.ColumnName = columnName[i];
inputControl.ColumnNameJp = columnNameJp[i];
inputControl.ColumnOrder = i + 1;
inputControl.TabIndex = i + 1;
inputControl.TabStop = 1;
InputControlList.Add(inputControl);
}
}
}
public virtual ColumnSourceByValues NewColumnSourceByValues(ImmutableArray <ImmutableArray <ValueExpression> > values, ColumnNameList names = null)
{
return(new ColumnSourceByValuesImpl(this.vendor, names, values));
}
protected DynamicColumnSourceImpl(SQLVendorImpl vendor, ColumnNameList columns)
: base(vendor)
{
this._columns = columns;
}
public static ColumnSourceByValues NewColumnSourceByValuesMultiple(this ModificationFactory factory, ColumnNameList names, params ValueExpression[][] values)
{
return(factory.NewColumnSourceByValues(values.Select(v => v.NewAQ()).NewAQ()));
}
public static ColumnSourceByValues NewColumnSourceByValues(this ModificationFactory factory, ColumnNameList names, params ValueExpression[] values)
{
return(factory.NewColumnSourceByValues(new[] { values.NewAQ() }.NewAQ(false), names));
}
