// Used by Janitor.Fody
private void DisposeManaged()
{
CellsCollection.Clear();
ColumnsCollection.Clear();
RowsCollection.Clear();
MergedRanges.RemoveAll();
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
// столбец Марка
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 10;
col[1, 0].TextString = "Марка отв.";
// столбец Размеры
col = columns[1];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
col[1, 1].TextString = "Размеры, мм";
// столбец Назначение
col = columns[2];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
col[1, 2].TextString = "Назначение";
// столбец Кол
col = columns[3];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 15;
col[1, 3].TextString = "Кол-во, шт.";
// столбец примечаение
col = columns[4];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 30;
col[1, 4].TextString = "Примечание";
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection AirlineCols = uwg.Bands[0].Columns;
ColumnsCollection WeightBreakCols = uwg.Bands[1].Columns;
AirlineCols.FromKey("airline").Hidden = true;
WeightBreakCols.FromKey("airline").Hidden = true;
AirlineCols.FromKey("dba_name").Header.Caption = "Airline";
AirlineCols.FromKey("carrier_code").Header.Caption = "Carrier Code";
AirlineCols.FromKey("share").Header.Caption = "Profit Share (%)";
WeightBreakCols.FromKey("weight_break").Header.Caption = "Weight Break";
WeightBreakCols.FromKey("kg_lb").Header.Caption = "Kg/Lb";
WeightBreakCols.FromKey("rate").Header.Caption = "Freight Charge Rate";
WeightBreakCols.FromKey("fl_rate").Header.Caption = "Fuel Surcharge Rate";
WeightBreakCols.FromKey("sec_rate").Header.Caption = "Securoty Surcharge Rate";
WeightBreakCols.FromKey("weight_break").Width = Unit.Pixel(100);
WeightBreakCols.FromKey("kg_lb").Width = Unit.Pixel(35);
WeightBreakCols.FromKey("rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("fl_rate").Width = Unit.Pixel(60);
WeightBreakCols.FromKey("sec_rate").Width = Unit.Pixel(60);
}
public void Init_from_grid(UltraGrid grid = null)
{
if (grid == null)
{
grid = this.mainGrid;
}
if (grid == null)
{
return;
}
if (grid.DisplayLayout == null || grid.DisplayLayout.Bands.Count < 1)
{
return;
}
this.mainGrid = grid;
ColumnsCollection columns = grid.DisplayLayout.Bands[0].Columns;
if (columns.Count < 1)
{
return;
}
else
{
this.colKey_list.Clear();
}
foreach (UltraGridColumn col in columns)
{
this.colKey_list.Add(new HssGridColumn(col));
}
this.colKey_list.Sort((a, b) => (a.visible_position - b.visible_position));
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 35;
col[1, 0].TextString = "Размер, (Высота х Ширина), мм";
int c = 1;
for (int i = 1; i <= data.Colors.Count; i++)
{
col = columns[i];
col.Width = 30;
col.Alignment = CellAlignment.MiddleCenter;
var cell = col[1, c];
cell.TextString = $"Цвет {data.Colors[i - 1].Item1.BlLayer}";
cell.BackgroundColor = data.Colors[i - 1].Item1.Color;
c++;
}
col = columns.Last();
col.Width = 30;
col.Alignment = CellAlignment.MiddleCenter;
col[1, c].TextString = "Итого";
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection InvoiceCols = e.Layout.Bands[0].Columns;
InvoiceCols.FromKey("invoice_no").Header.Caption = "I/V No.";
InvoiceCols.FromKey("customer_name").Header.Caption = "Customer";
InvoiceCols.FromKey("mawb_num").Header.Caption = "Master BL";
InvoiceCols.FromKey("hawb_num").Header.Caption = "House BL";
InvoiceCols.FromKey("entry_date").Header.Caption = "I/V Date";
InvoiceCols.FromKey("invoice_type").Header.Caption = "T";
InvoiceCols.FromKey("import_export").Header.Caption = "I/E";
InvoiceCols.FromKey("air_ocean").Header.Caption = "A/O";
InvoiceCols.FromKey("ref_no").Header.Caption = "Ref. No.";
InvoiceCols.FromKey("ref_no_our").Header.Caption = "File No.";
InvoiceCols.FromKey("total_pieces").Header.Caption = "PCS";
InvoiceCols.FromKey("total_gross_weight").Header.Caption = "G. Weight";
InvoiceCols.FromKey("total_charge_weight").Header.Caption = "Charge";
InvoiceCols.FromKey("agent_profit").Header.Caption = "Agent P/F";
InvoiceCols.FromKey("sale_tax").Header.Caption = "Tax";
InvoiceCols.FromKey("total_cost").Header.Caption = "Cost";
InvoiceCols.FromKey("subtotal").Header.Caption = "Sub Total";
InvoiceCols.FromKey("lock_ap").Header.Caption = "A/P";
InvoiceCols.FromKey("balance").Header.Caption = "Balance";
InvoiceCols.FromKey("pay_status").Header.Caption = "P";
InvoiceCols.FromKey("arrival_dept").Header.Caption = "Arrival/Departure";
}
/// <summary>
/// Apply config info to UltraGrid
/// </summary>
public void ConfigGrid(UltraGrid grid)
{
if (grid == null || grid.DisplayLayout.Bands.Count < 1)
{
return;
}
else
{
this.mainGrid = grid;
}
ColumnsCollection uColumns = grid.DisplayLayout.Bands[0].Columns;
HashSet <string> hs = new HashSet <string>(StringComparer.OrdinalIgnoreCase);
//int tempPos = 999;
foreach (UltraGridColumn uCol in uColumns)
{
hs.Add(uCol.Key);
//uCol.Hidden = true;
//Console.WriteLine(uCol.Key + " Position:" + uCol.Header.VisiblePosition);
}
foreach (HssGridColumn hgc in this.colKey_list)
{
if (!hs.Contains(hgc.column_key))
{
continue;
}
UltraGridColumn uCol = uColumns[hgc.column_key];
hgc.ConfigColumn(uCol);
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;
tmpCols.FromKey("auto_uid").Hidden = true;
tmpCols.FromKey("po_num").Header.Caption = "Pickup Order No";
tmpCols.FromKey("MAWB_NUM").Header.Caption = "Master AWB/BL";
tmpCols.FromKey("HAWB_NUM").Header.Caption = "House AWB/BL";
tmpCols.FromKey("Shipper_Name").Header.Caption = "Shipper";
tmpCols.FromKey("Pickup_Name").Header.Caption = "Pickup From";
tmpCols.FromKey("Carrier_Name").Header.Caption = "Delivery To";
tmpCols.FromKey("Origin_Port_Code").Header.Caption = "From";
tmpCols.FromKey("Dest_Port_Code").Header.Caption = "To";
tmpCols.FromKey("ModifiedDate").Header.Caption = "Last Modified";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
tmpCols.FromKey("ModifiedDate").Format = "MM/dd/yyyy";
tmpCols.FromKey("file_type").Width = Unit.Pixel(60);
tmpCols.FromKey("Shipper_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Pickup_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Carrier_Name").Width = Unit.Pixel(150);
tmpCols.FromKey("Origin_Port_Code").Width = Unit.Pixel(50);
tmpCols.FromKey("Dest_Port_Code").Width = Unit.Pixel(50);
tmpCols.FromKey("ModifiedDate").Width = Unit.Pixel(80);
}
public void Dispose()
{
CellsCollection.Clear();
ColumnsCollection.Clear();
RowsCollection.Clear();
MergedRanges.RemoveAll();
}
/// <summary>
/// 직급,직군 보이기 여부
/// </summary>
/// <param name="columnCollection"></param>
public static void VisiblePosColumn(ColumnsCollection columnCollection)
{
Biz_PositionInfos positionInfo = new Biz_PositionInfos();
DataTable dtPosNotUse = positionInfo.GetPositionInfoByUseYN("N").Tables[0];
foreach (DataRow dataRowPosNotUse in dtPosNotUse.Rows)
{
string col_key_id = string.Format("TGT_POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name = string.Format("TGT_POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
string col_key_id_1 = string.Format("POS_{0}_ID", dataRowPosNotUse["POS_ID"]);
string col_key_name_1 = string.Format("POS_{0}_NAME", dataRowPosNotUse["POS_ID"]);
if (columnCollection.Exists(col_key_id))
{
columnCollection.FromKey(col_key_id).Hidden = true;
}
if (columnCollection.Exists(col_key_name))
{
columnCollection.FromKey(col_key_name).Hidden = true;
}
if (columnCollection.Exists(col_key_id_1))
{
columnCollection.FromKey(col_key_id_1).Hidden = true;
}
if (columnCollection.Exists(col_key_name_1))
{
columnCollection.FromKey(col_key_name_1).Hidden = true;
}
}
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
// столбец Поз.
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 10;
//col[1, 0].TextString = "Поз.";
// столбец Артикул
col = columns[1];
col.Alignment = CellAlignment.MiddleLeft;
col.Width = 20;
//col[1, 1].TextString = "Артикул";
//col[1, 1].Alignment = CellAlignment.MiddleCenter;
// столбец Образец
col = columns[2];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 2].TextString = "Образец";
// столбец Расход, шт.
col = columns[3];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 3].TextString = "Расход, шт.";
// столбец Расход, м.кв.
col = columns[4];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 4].TextString = "Расход, м.кв.";
// столбец Цвет
col = columns[5];
col.Alignment = CellAlignment.MiddleLeft;
col.Width = 30;
//col[1, 5].TextString = "Цвет";
//col[1, 5].Alignment = CellAlignment.MiddleCenter;
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
// столбец Марка
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 15;
col[1, 0].TextString = "Марка";
// столбец Обозначение
col = columns[1];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 60;
col[1, 1].TextString = "Обозначение";
// столбец Наименование
col = columns[2];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 65;
col[1, 2].TextString = "Наименование";
// столбец Кол
col = columns[3];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 10;
col[1, 3].TextString = "Кол.";
// столбец Масса, ед. кг
col = columns[4];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 15;
col[1, 4].TextString = "Масса, ед. кг";
// столбец примечаение
col = columns[5];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
col[1, 5].TextString = "Примечание";
}
private void Init(string name)
{
Name = name;
Options = new DbEngineOptions();
Columns = new ColumnsCollection();
Constraints = new ConstraintsCollection(this);
Indexes = new IndexCollection(this);
ModifiedColumns = new ModifiedColumnsCollection(name);
}
public TableSchema(string name)
{
Name = name;
Options= new DbEngineOptions();
Columns= new ColumnsCollection();
Constraints = new ConstraintsCollection(this);
Indexes= new IndexCollection(this);
ModifiedColumns=new ModifiedColumnsCollection(name);
}
protected void WriteColumns(ColumnsCollection columns)
{
var writer = GetColumnWriter();
foreach (var col in columns)
{
Builder.AppendLine();
writer.Write(col);
Builder.Append(",");
}
Builder.RemoveLast();
}
private static void RemoveGridTitle(UltraGrid grid, string strOperName)
{
grid.DisplayLayout.Override.WrapHeaderText = DefaultableBoolean.True;
grid.DisplayLayout.Bands[0].UseRowLayout = true;
ColumnsCollection cc = grid.DisplayLayout.Bands[0].Columns;
grid.DisplayLayout.Bands[0].Columns.Remove("oper");
grid.DisplayLayout.Bands[0].Columns.Remove("date");
if (grid.DisplayLayout.Bands[0].Columns.Exists("title"))
{
grid.DisplayLayout.Bands[0].Columns.Remove("title");
}
for (int i = 0; i < cc.Count; i++)
{
UltraGridColumn gc = cc[i];
gc.RowLayoutColumnInfo.OriginX = i;
gc.RowLayoutColumnInfo.OriginY = gc.RowLayoutColumnInfo.OriginY + 1;
}
int iCC = cc.Count;
grid.DisplayLayout.Bands[0].Columns.Add("oper");
grid.DisplayLayout.Bands[0].Columns.Add("date");
grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.TextHAlign = HAlign.Left;
grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.BackColor = Color.White;
grid.DisplayLayout.Bands[0].Columns["oper"].Header.Appearance.BorderColor = Color.White;
grid.DisplayLayout.Bands[0].Columns["oper"].Header.Caption = "操作员：" + strOperName;
grid.DisplayLayout.Bands[0].Columns["oper"].CellActivation = Activation.Disabled;
grid.DisplayLayout.Bands[0].Columns["oper"].SortIndicator = SortIndicator.Disabled;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.OriginX = 0;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.OriginY = 1;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.SpanX = iCC - 2;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.SpanY = 1;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.PreferredCellSize = new Size(1, 1);
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.AllowCellSizing = RowLayoutSizing.None;
grid.DisplayLayout.Bands[0].Columns["oper"].RowLayoutColumnInfo.LabelPosition = LabelPosition.LabelOnly;
grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.TextHAlign = HAlign.Left;
grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.BackColor = Color.White;
grid.DisplayLayout.Bands[0].Columns["date"].Header.Appearance.BorderColor = Color.White;
grid.DisplayLayout.Bands[0].Columns["date"].Header.Caption = "操作时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm");//DateTime.Now.ToShortDateString()+" "+DateTime.Now.ToShortTimeString();
grid.DisplayLayout.Bands[0].Columns["date"].CellActivation = Activation.Disabled;
grid.DisplayLayout.Bands[0].Columns["date"].SortIndicator = SortIndicator.Disabled;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.OriginX = iCC - 2;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.OriginY = 1;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.SpanX = 2;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.SpanY = 1;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.PreferredCellSize = new Size(1, 1);
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.AllowCellSizing = RowLayoutSizing.None;
grid.DisplayLayout.Bands[0].Columns["date"].RowLayoutColumnInfo.LabelPosition = LabelPosition.LabelOnly;
}
protected void WriteColumns(ColumnsCollection columns)
{
var writer = GetColumnWriter();
foreach (var col in columns)
{
Builder.AppendLine();
writer.Write(col);
Builder.Append(",");
}
Builder.RemoveLast();
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 40;
col[1, 0].TextString = "Начало";
col = columns[1];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 40;
col[1, 1].TextString = "Конец";
}
public RallyTool(bool selectIssuesMode, string commonRoot)
{
UsageMetrics.IncrementUsage(UsageMetrics.UsageKind.RallyTool);
_selectIssuesMode = selectIssuesMode;
_commonRoot = commonRoot;
InitializeComponent();
Observable
.FromEventPattern<EventHandler, EventArgs>(h => textBoxNameFilter.TextChanged += h, h => textBoxNameFilter.TextChanged -= h)
.Do(_ => textBoxNameFilter.BackColor = ChangedFilter)
.Throttle(TimeSpan.FromMilliseconds(500))
.ObserveOn(SynchronizationContext.Current)
.Subscribe(_ => UpdateFilteredArtifactsList())
;
var ver = new NewVersionControl();
ver.Name = "VersionChecker";
ver.Anchor = versionPlaceholder.Anchor;
ver.Location = versionPlaceholder.Location;
ver.Size = versionPlaceholder.Size;
Controls.Add(ver);
Controls.Remove(versionPlaceholder);
_columns = InitColumns();
// try find external tools
try
{
using (var rk = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\VssPowerTools.exe", false))
{
_vssPowerToolsPath = (string)rk.GetValue(null);
}
}
catch (Exception ex)
{
_vssPowerToolsPath = null;
Logger.LogIt("Error: {0}", ex);
}
if(_vssPowerToolsPath == null)
{
sourceSafeCommitsToolStripMenuItem.Text += " (not installed)";
}
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
UltraWebGrid uwg = (UltraWebGrid)e.Layout.Grid;
ColumnsCollection disputeTotal = uwg.Bands[0].Columns;
ColumnsCollection disputeItem = uwg.Bands[1].Columns;
disputeTotal.FromKey("elt_account_number").Hidden = true;
disputeTotal.FromKey("org_account_number").Hidden = true;
disputeItem.FromKey("elt_account_number").Hidden = true;
disputeItem.FromKey("vendor_number").Hidden = true;
disputeItem.FromKey("memo").Hidden = true;
disputeTotal.FromKey("dba_name").Header.Caption = "Vendor";
disputeTotal.FromKey("class_code").Header.Caption = "Class";
disputeTotal.FromKey("business_phone").Header.Caption = "Phone";
disputeItem.FromKey("print_id").Header.Caption = "Tran No";
disputeItem.FromKey("bill_number").Header.Caption = "Bill No";
disputeItem.FromKey("bill_date").Header.Caption = "Tran Date";
disputeItem.FromKey("pmt_method").Header.Caption = "Payment";
disputeItem.FromKey("memo").Header.Caption = "Memo";
disputeItem.FromKey("file_no").Header.Caption = "File No";
disputeItem.FromKey("amt_due").Header.Caption = "Due Amount";
disputeItem.FromKey("amt_paid").Header.Caption = "Paid Amount";
disputeItem.FromKey("amt_dispute").Header.Caption = "Disputed Amount";
disputeTotal.FromKey("dba_name").Width = Unit.Pixel(267);
disputeTotal.FromKey("class_code").Width = Unit.Pixel(80);
disputeTotal.FromKey("business_phone").Width = Unit.Pixel(100);
disputeTotal.FromKey("Bill Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Paid Amount").Width = Unit.Pixel(100);
disputeTotal.FromKey("Balance").Width = Unit.Pixel(100);
disputeTotal.FromKey("Dispute Amount").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_number").Width = Unit.Pixel(100);
disputeItem.FromKey("print_id").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Width = Unit.Pixel(80);
disputeItem.FromKey("file_no").Width = Unit.Pixel(165);
disputeItem.FromKey("pmt_method").Width = Unit.Pixel(70);
disputeItem.FromKey("amt_due").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_paid").Width = Unit.Pixel(100);
disputeItem.FromKey("amt_dispute").Width = Unit.Pixel(100);
disputeItem.FromKey("bill_date").Format = "MM/dd/yyyy";
}
public void ColumnsCollectionJsonConverterTest()
{
ColumnsCollection columnsStrings = new();
ColumnsCollection columnsMixed = new();
columnsStrings.Key = "x";
columnsStrings.Values = new object[] { "2013-01-01", "2013-01-02", "2013-01-03", "2013-01-04" };
columnsMixed.Key = "data1";
columnsMixed.Values = new object[] { -30, 200, 100, 400 };
ColumnsCollection[] columns = new ColumnsCollection[] { columnsStrings, columnsMixed };
string json = JsonSerializer.Serialize(columns);
json.ShouldBe("[[\"x\",\"2013-01-01\",\"2013-01-02\",\"2013-01-03\",\"2013-01-04\"],[\"data1\",-30,200,100,400]]");
}
protected override void LoadDataIntoGridDetail(string refId)
{
var buTransfer = _model.GetBUTransferVoucher(refId, true);
if (buTransfer == null)
{
return;
}
bindingSourceDetail.DataSource = buTransfer.BUTransferDetailPurchases.OrderBy(c => c.SortOrder).ToList();
gridViewDetail.PopulateColumns(buTransfer.BUTransferDetailPurchases);
ColumnsCollection.Add(new XtraColumn {
ColumnName = "InventoryItemId", ColumnCaption = "Mã VT,HH", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 1, AllowEdit = true, RepositoryControl = _gridLookUpEditInventoryItem
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Description", ColumnCaption = "Diễn giải", ColumnVisible = true, ColumnWith = 250, ColumnPosition = 2
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "StockId", ColumnCaption = "Kho", ColumnVisible = true, ColumnWith = 150, ColumnPosition = 3, AllowEdit = true, RepositoryControl = _gridLookUpEditStock
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "DebitAccount", ColumnCaption = "TK nợ", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 4, AllowEdit = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "CreditAccount", ColumnCaption = "TK có", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 5, AllowEdit = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Unit", ColumnCaption = "ĐVT", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 6, AllowEdit = true,
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Quantity", ColumnCaption = "Số lượng", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 7, AllowEdit = true, IsNumeric = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "UnitPrice", ColumnCaption = "Đơn giá", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 8, AllowEdit = true, IsNumeric = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Amount", ColumnCaption = "Thành tiền", ColumnVisible = true, ColumnWith = 120, ColumnPosition = 9, AllowEdit = true, IsNumeric = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "TaxAmount", ColumnCaption = "Giá trị nhập kho", ColumnVisible = true, ColumnWith = 150, ColumnPosition = 10, AllowEdit = true, IsNumeric = true
});
XtraColumnCollectionHelper <BUTransferDetailPurchaselModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail);
}
protected override void LoadDataIntoGridDetail(string refId)
{
var buTransfer = _model.GetBUTransferVoucher(refId, true);
if (buTransfer == null)
{
return;
}
bindingSourceDetail.DataSource = buTransfer.BUTransferDetailFixedAssets.OrderBy(c => c.SortOrder).ToList();
gridViewDetail.PopulateColumns(buTransfer.BUTransferDetailFixedAssets);
var columnsCollection = new List <XtraColumn>();
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Description", ColumnVisible = true, ColumnWith = 320, ColumnCaption = "Diễn giải", ColumnPosition = 1,
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "DebitAccount", ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Nợ", ColumnPosition = 2
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "CreditAccount", ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Có", ColumnPosition = 3
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "Amount", ColumnVisible = true, ColumnWith = 120, ColumnCaption = "Số tiền", ColumnPosition = 4, IsNumeric = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "BudgetSourceId", ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Nguồn", ColumnPosition = 5, RepositoryControl = _gridLookUpEditBudgetSource
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "BudgetChapterCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Chương", ColumnPosition = 6
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "BudgetSubKindItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Khoản", ColumnPosition = 7
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "BudgetSubItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Tiểu mục", ColumnPosition = 8
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = "BudgetItemCode", ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Mục", ColumnPosition = 9
});
XtraColumnCollectionHelper <BUTransferDetailFixedAssetlModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail);
}
protected void FormatColumns(UltraWebGrid uwg)
{
ColumnsCollection routeCols = uwg.Bands[0].Columns;
ColumnsCollection airlineCols = uwg.Bands[1].Columns;
ColumnsCollection weightCols = uwg.Bands[2].Columns;
routeCols.FromKey("agent_no").Hidden = true;
airlineCols.FromKey("agent_no").Hidden = true;
weightCols.FromKey("agent_no").Hidden = true;
routeCols.FromKey("dba_name").Header.Caption = "Agent";
UltraGridColumn AgentCol = uwg.Bands[0].Columns.FromKey("dba_name");
AgentCol.EditorControlID = "TextAgent";
AgentCol.Type = ColumnType.Custom;
AgentCol.DataType = "System.String";
AgentCol.Width = Unit.Pixel(300);
}
protected void FormatColumns(UltraWebGrid uwg)
{
ColumnsCollection routeCols = uwg.Bands[0].Columns;
ColumnsCollection airlineCols = uwg.Bands[1].Columns;
ColumnsCollection weightCols = uwg.Bands[2].Columns;
// hiding uneccessary columns
routeCols.FromKey("customer_no").Hidden = true;
airlineCols.FromKey("customer_no").Hidden = true;
weightCols.FromKey("customer_no").Hidden = true;
// renaming headers
routeCols.FromKey("dba_name").Header.Caption = "Customer";
UltraGridColumn CustomerCol = uwg.Bands[0].Columns.FromKey("dba_name");
CustomerCol.EditorControlID = "TextCustomer";
CustomerCol.Type = ColumnType.Custom;
CustomerCol.DataType = "System.String";
CustomerCol.Width = Unit.Pixel(300);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection SBCols = e.Layout.Bands[0].Columns;
SBCols.FromKey("auto_uid").Hidden = true;
SBCols.FromKey("sb").Header.Caption = "Schedule B Code";
SBCols.FromKey("description").Header.Caption = "Item Description";
SBCols.FromKey("sb_unit1").Header.Caption = "Unit 1";
SBCols.FromKey("sb_unit2").Header.Caption = "Unit 2";
SBCols.FromKey("export_code").Header.Caption = "Export Code";
SBCols.FromKey("license_type").Header.Caption = "License Type";
SBCols.FromKey("eccn").Header.Caption = "ECCN";
SBCols.FromKey("sb").Width = Unit.Pixel(100);
SBCols.FromKey("description").Width = Unit.Pixel(250);
SBCols.FromKey("sb_unit1").Width = Unit.Pixel(60);
SBCols.FromKey("sb_unit2").Width = Unit.Pixel(60);
SBCols.FromKey("export_code").Width = Unit.Pixel(70);
SBCols.FromKey("license_type").Width = Unit.Pixel(70);
SBCols.FromKey("eccn").Width = Unit.Pixel(70);
}
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
FreightEasy.ClientProfiles.Clients clients = new FreightEasy.ClientProfiles.Clients();
clients.GetClientsByType(elt_account_number, "All");
UltraGridColumn ConsigneeCol = UltraWebGrid1.Bands[0].Columns.FromKey("consignee_acct");
ConsigneeCol.Type = ColumnType.DropDownList;
ConsigneeCol.ValueList.DataSource = clients.Tables["All"];
ConsigneeCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
ConsigneeCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
ConsigneeCol.ValueList.DataBind();
ConsigneeCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
UltraGridColumn ShipperCol = UltraWebGrid1.Bands[0].Columns.FromKey("customer_acct");
ShipperCol.Type = ColumnType.DropDownList;
ShipperCol.ValueList.DataSource = clients.Tables["All"];
ShipperCol.ValueList.DisplayMember = clients.Tables["All"].Columns["dba_name"].ToString();
ShipperCol.ValueList.ValueMember = clients.Tables["All"].Columns["org_account_number"].ToString();
ShipperCol.ValueList.DataBind();
ShipperCol.ValueList.ValueListItems.Insert(0, new ValueListItem("", ""));
ColumnsCollection tmpCols = e.Layout.Bands[0].Columns;
tmpCols.FromKey("created_date").Format = "MM/dd/yyyy";
tmpCols.FromKey("shipout_date").Format = "MM/dd/yyyy";
tmpCols.FromKey("auto_uid").Hidden = true;
tmpCols.FromKey("so_num").Header.Caption = "Shipout No";
tmpCols.FromKey("created_date").Header.Caption = "Created Date";
tmpCols.FromKey("shipout_date").Header.Caption = "Shipout Date";
tmpCols.FromKey("consignee_acct").Header.Caption = "Ship To";
tmpCols.FromKey("customer_acct").Header.Caption = "Customer";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
tmpCols.FromKey("house_num").Header.Caption = "House AWB/BL";
tmpCols.FromKey("master_num").Header.Caption = "Master AWB/BL";
tmpCols.FromKey("file_type").Header.Caption = "File Type";
}
protected override void LoadDataIntoGridDetail(string refId)
{
var pUInvoice = _model.GetPUInvoice(refId, true);
if (pUInvoice == null)
{
return;
}
var source = pUInvoice.PUInvoiceDetailFixedAssets ?? new List <PUInvoiceDetailFixedAssetModel>();
bindingSourceDetail.DataSource = source.OrderBy(c => c.SortOrder).ToList();;
gridViewDetail.PopulateColumns(source);
var columnsCollection = new List <XtraColumn>();
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.FixedAssetId), ColumnVisible = true, ColumnWith = 150, ColumnCaption = "Mã tài sản", ColumnPosition = 1, RepositoryControl = _gridLookUpEditFixedAsset
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.Description), ColumnVisible = true, ColumnWith = 320, ColumnCaption = "Diễn giải", ColumnPosition = 2,
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.DepartmentId), ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Phòng ban", ColumnPosition = 3, RepositoryControl = _gridLookUpEditDepartment
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.DebitAccount), ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Nợ", ColumnPosition = 4
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.CreditAccount), ColumnVisible = true, ColumnWith = 100, ColumnCaption = "TK Có", ColumnPosition = 5
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.Amount), ColumnVisible = true, ColumnWith = 120, ColumnCaption = "Số tiền", ColumnPosition = 6, IsNumeric = true
});
ColumnsCollection.Add(new XtraColumn {
ColumnName = nameof(PUInvoiceDetailFixedAssetModel.BankAccount), ColumnVisible = true, ColumnWith = 200, ColumnCaption = "Tài khoản NH, KB", ColumnPosition = 5, RepositoryControl = _gridLookUpEditBank
});
XtraColumnCollectionHelper <PUInvoiceDetailFixedAssetModel> .ShowXtraColumnInGridView(ColumnsCollection, gridViewDetail);
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
int colIndex = 0;
var col = columns[colIndex];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 10;
var cell = col[1, colIndex];
cell.TextString = "№ п/п";
colIndex++;
col = columns[colIndex];
col.Alignment = CellAlignment.MiddleLeft;
col.Width = 125;
col.Borders.Horizontal.Margin = 2;
cell = col[1, colIndex];
cell.TextString = "Наименование";
cell.Alignment = CellAlignment.MiddleCenter;
colIndex++;
col = columns[colIndex];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 25;
cell = col[1, colIndex];
cell.TextString = "Площадь, м" + AcadLib.General.Symbols.Square;
colIndex++;
col = columns[colIndex];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 25;
cell = col[1, colIndex];
cell.TextString = "Процент территории, %";
}
/// <summary>
/// Handles the InitializeLayout event of the UltraGrid controls.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs"/> instance containing the event data.</param>
private void Grid_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
e.Layout.Override.DefaultRowHeight = 30;
ColumnsCollection columns = e.Layout.Bands[0].Columns;
foreach (UltraGridColumn column in columns)
{
column.Header.Caption = GetLocalizedString(column.Header.Caption);
switch (column.Key)
{
case "Cost":
case "Price":
case "Sales":
case "Profit":
{
column.Format = "c";
column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.CurrencyNonNegative;
}
break;
}
}
// Hide the unnecessary columns
if (sender == this.gridInventory)
{
columns["Sales"].Hidden = true;
columns["Profit"].Hidden = true;
columns["IsNew"].Hidden = true;
}
else if (sender == this.gridReports)
{
columns["Quantity"].Hidden = true;
columns["IsNew"].Hidden = true;
}
}
protected override void SetColumnsAndCap(ColumnsCollection columns)
{
// столбец Поз.
var col = columns[0];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 10;
//col[1, 0].TextString = "Поз.";
// столбец Артикул
col = columns[1];
col.Alignment = CellAlignment.MiddleLeft;
col.Width = 20;
//col[1, 1].TextString = "Артикул";
//col[1, 1].Alignment = CellAlignment.MiddleCenter;
// столбец Образец
col = columns[2];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 2].TextString = "Образец";
// столбец Расход, шт.
col = columns[3];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 3].TextString = "Расход, шт.";
// столбец Расход, м.кв.
col = columns[4];
col.Alignment = CellAlignment.MiddleCenter;
col.Width = 20;
//col[1, 4].TextString = "Расход, м.кв.";
// столбец Цвет
col = columns[5];
col.Alignment = CellAlignment.MiddleLeft;
col.Width = 30;
//col[1, 5].TextString = "Цвет";
//col[1, 5].Alignment = CellAlignment.MiddleCenter;
}
protected abstract void SetColumnsAndCap(ColumnsCollection columns);
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e)
{
ColumnsCollection columns = e.Layout.Bands[0].Columns;
if (lstSearchType.SelectedValue == "house")
{
columns.FromKey("hawb_num").Header.Caption = "House AWB";
columns.FromKey("masterNo").Header.Caption = "Master AWB";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("sec").Header.Caption = "SEC";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("Shipper_name").Header.Caption = "Shipper";
columns.FromKey("consignee_name").Header.Caption = "Consingee";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("hawb_num").Width = Unit.Percentage(10);
columns.FromKey("masterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(10);
columns.FromKey("sec").Width = Unit.Percentage(4);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("Shipper_name").Width = Unit.Percentage(15);
columns.FromKey("consignee_name").Width = Unit.Percentage(15);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("Shipper_acct").Hidden = true;
columns.FromKey("consignee_acct").Hidden = true;
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("iType").Hidden = true;
columns.FromKey("lastF#").Hidden = true;
}
if (lstSearchType.SelectedValue == "master")
{
columns.FromKey("masterNo").Header.Caption = "Master AWB";
columns.FromKey("file#").Header.Caption = "File No.";
columns.FromKey("sec").Header.Caption = "SEC";
columns.FromKey("p1").Header.Caption = "Departure Port";
columns.FromKey("p2").Header.Caption = "Destination Port";
columns.FromKey("carrier").Header.Caption = "Carrier";
columns.FromKey("export_agent_name").Header.Caption = "Export Agent";
columns.FromKey("CreatedDate").Header.Caption = "Date";
columns.FromKey("masterNo").Width = Unit.Percentage(10);
columns.FromKey("file#").Width = Unit.Percentage(10);
columns.FromKey("sec").Width = Unit.Percentage(4);
columns.FromKey("p1").Width = Unit.Percentage(10);
columns.FromKey("p2").Width = Unit.Percentage(10);
columns.FromKey("carrier").Width = Unit.Percentage(15);
columns.FromKey("export_agent_name").Width = Unit.Percentage(15);
columns.FromKey("CreatedDate").Width = Unit.Percentage(7);
columns.FromKey("CreatedDate").Format = "MM/dd/yyyy";
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("carrier_code").Hidden = true;
columns.FromKey("agent_org_acct").Hidden = true;
columns.FromKey("iType").Hidden = true;
}
}
ColumnsCollection InitColumns()
{
// init list view with columns
var columns = new ColumnsCollection();
var cols = new List<ColumnBase> {
new FormattedIDColumn { Width = 90 },
new IterationColumn { Width = 150 },
new WorkItemNameColumn { Width = 400 },
new ParentColumn { Width = 400 }
};
columns.Columns = cols.ToArray();
listViewIssues.Columns.Clear();
var colHdrs = columns
.Columns
.Select(col => new ColumnHeader {
TextAlign = col.TextAlign,
Text = col.Header,
Width = col.Width,
Tag = col
})
.ToArray()
;
listViewIssues.Columns.AddRange(colHdrs);
return columns;
}
public VirtualListItemArtifact(Artifact workItem, ColumnsCollection columns)
{
WorkItem = workItem;
_columns = columns;
}
private static void ProcessSmallTable(Autodesk.AutoCAD.EditorInput.Editor editor, Table table, Transaction tr, ColumnsCollection columns, int i)
{
var smallTable = editor.GetEntity("Выделите малую таблицу\n");
if (smallTable.Status != Autodesk.AutoCAD.EditorInput.PromptStatus.OK)
{
throw new Exception();
}
var smallTableObj = tr.GetObject(smallTable.ObjectId, OpenMode.ForWrite, false) as Table;
var numOfRow = smallTableObj.Rows.Count;
for (int j = 1; j < numOfRow - 4; j++)
{
if (smallTableObj.Cells[j, 0].TextString != string.Empty)
{
var grunt = smallTableObj.Cells[j, 0].TextString;
var area = smallTableObj.Cells[j, 1].TextString;
for (int k = 1; k < columns.Count; k++)
{
var title = table.Cells[0, k].TextString;
var formattedArea = area.Replace(".", ",").Replace("м2", "");
if (title != string.Empty)
{
if (title == grunt)
{
table.Cells[i, k].TextString = formattedArea;
break;
}
}
else
{
table.Cells[0, k].TextString = grunt;
table.Cells[i, k].TextString = formattedArea;
break;
}
}
}
}
}
private static void UpdateTableWithValues(Autodesk.AutoCAD.EditorInput.Editor editor, Table table, Transaction tr, ColumnsCollection columns)
{
for (int i = 1; i < int.MaxValue; i++)
{
try
{
CommonMethods.FillPiket(editor, table, tr, i);
ProcessSmallTable(editor, table, tr, columns, i);
}
catch (Exception)
{
editor.WriteMessage("Завершение программы. Дай Бог вам здоровья\n");
break;
}
}
}
