// Создание фиксированного набора колонок
protected void CreateFixedColumn()
{
MilestoneReportData tmp;
var column = new GridViewDataTextColumn {
Caption = @" ", Name = nameof(tmp.Prd), FieldName = nameof(tmp.Prd), Width = Unit.Pixel(40)
};
this.MSGridView.Columns.Add(column);
column = new GridViewDataTextColumn {
Caption = @"№", Name = nameof(tmp.Dog), FieldName = nameof(tmp.Dog), Width = Unit.Pixel(50)
};
this.MSGridView.Columns.Add(column);
column = new GridViewDataTextColumn {
Caption = @"Ст.", Name = nameof(tmp.Ct), FieldName = nameof(tmp.Ct), Width = Unit.Pixel(50)
};
this.MSGridView.Columns.Add(column);
column = new GridViewDataTextColumn {
Caption = @"Наменование", Name = nameof(tmp.Npr), FieldName = nameof(tmp.Npr), Width = Unit.Pixel(300)
};
this.MSGridView.Columns.Add(column);
column = new GridViewDataTextColumn {
Caption = @"График в<br>MSProject", Name = $"{nameof(tmp.MsProjectInfo)}.{nameof(tmp.MsProjectInfo.IsExists)}", FieldName = $"{nameof(tmp.MsProjectInfo)}.{nameof(tmp.MsProjectInfo.IsExists)}", Width = Unit.Pixel(80)
};
this.MSGridView.Columns.Add(column);
}
private void AddTextColumn(string fieldName)
{
GridViewDataTextColumn c = new GridViewDataTextColumn();
c.FieldName = fieldName;
grid.Columns.Add(c);
}
protected void btnXlsExport_Click(object sender, EventArgs e)
{
ASPxGridView1.Columns.RemoveAt(26);
ASPxGridView1.Columns.RemoveAt(25);
ASPxGridView1.Columns.RemoveAt(24);
ASPxGridView1.Columns.RemoveAt(23);
ASPxGridView1.Columns.RemoveAt(22);
ASPxGridView1.Columns.RemoveAt(21);
ASPxGridView1.Columns.RemoveAt(20);
ASPxGridView1.Columns.RemoveAt(19);
ASPxGridView1.Columns.RemoveAt(18);
ASPxGridView1.Columns.RemoveAt(17);
ASPxGridView1.Columns.RemoveAt(16);
ASPxGridView1.Columns.RemoveAt(15);
ASPxGridView1.Columns.RemoveAt(14);
ASPxGridView1.Columns.RemoveAt(13);
ASPxGridView1.Columns.RemoveAt(12);
ASPxGridView1.Columns.RemoveAt(11);
GridViewDataTextColumn d3 = new GridViewDataTextColumn();
d3.Caption = "客户";
d3.VisibleIndex = 7;
d3.FieldName = "CUSTOMER_NAME";
ASPxGridView1.Columns.Add(d3);
GridViewDataTextColumn d1 = new GridViewDataTextColumn();
d1.Caption = "备注";
d1.VisibleIndex = 17;
d1.FieldName = "REMARK";
ASPxGridView1.Columns.Add(d1);
ASPxGridViewExporter1.WriteXlsToResponse("导出计划");
}
private void InitSubjectList()
{
ucListManager.ID = "SubjectList";
ucListManager.IsChildList = false;
ucListManager.ListLabel = "Subject List";
ucListManager.AllowEditAll = true;
ucListManager.GridPageSize = 30;
ucListManager.NeedListInstances += new NeedListInstancesEventHandler(ucListManager_NeedListInstances);
GridViewHyperLinkColumn hc = new GridViewHyperLinkColumn();
ucListManager.Columns.Add(hc);
hc.Caption = "Subject Type";
hc.DataTextField = SubjectDto.FLD_SubjectType;
hc.DataNavigateUrlFormatString = string.Format("{0}?{1}={{0}}", ServerPath + SubjectManager.PageUrl, SubjectManager.QrySubjectId);
hc.DataNavigateUrlFields = new string[] { SubjectDto.FLD_StringId };
ucListManager.Columns.Add(new GridViewDataTextColumn("Subject Label", SubjectDto.FLD_SubjectLabel));
ucListManager.Columns.Add(new GridViewDataTextColumn("SubjectId Field", SubjectDto.FLD_SubjectIdField));
ucListManager.Columns.Add(new GridViewDataTextColumn("MasterSubjectId Field", SubjectDto.FLD_MasterSubjectIdField));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListAdd", SubjectDto.FLD_AllowListAdd));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Is AddInGrid", SubjectDto.FLD_IsAddInGrid));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListEdit", SubjectDto.FLD_AllowListEdit));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Is Grid InForm Edit", SubjectDto.FLD_IsGridInFormEdit));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListDelete", SubjectDto.FLD_AllowListDelete));
ucListManager.Columns.Add(new GridViewDataCheckColumn("Allow ListFiltering", SubjectDto.FLD_AllowListFiltering));
GridViewDataTextColumn rc = new GridViewDataTextColumn("RowIndex Max", SubjectDto.FLD_RowIndexMax);
ucListManager.Columns.Add(rc);
rc.IsReadOnly = true;
GridViewDataTextColumn cc = new GridViewDataTextColumn("ColIndex Max", SubjectDto.FLD_ColIndexMax);
ucListManager.Columns.Add(cc);
cc.IsReadOnly = true;
}
private void CreateDetailColumns(ASPxGridView detailGrid)
{
GridViewCommandColumn colCmd = new GridViewCommandColumn();
colCmd.ShowEditButton = true;
colCmd.ShowNewButton = true;
colCmd.ShowDeleteButton = true;
detailGrid.Columns.Add(colCmd);
GridViewDataColumn colProductID = new GridViewDataColumn();
colProductID.FieldName = "ProductID";
colProductID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
detailGrid.Columns.Add(colProductID);
detailGrid.Columns.Add(new GridViewDataColumn("ProductName"));
GridViewDataTextColumn colCategoryID = new GridViewDataTextColumn();
colCategoryID.FieldName = "CategoryID";
colCategoryID.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
detailGrid.Columns.Add(colCategoryID);
detailGrid.Columns.Add(new GridViewDataColumn("UnitPrice"));
GridViewDataCheckColumn colDiscontinued = new GridViewDataCheckColumn();
colDiscontinued.FieldName = "Discontinued";
detailGrid.Columns.Add(colDiscontinued);
}
private void GetTitle()
{
gridview.GetTitle(ASPxGridView1, tablename);
ReportData rep = new ReportData();
DataTable dt = rep.Report5_1();
for (int i = 0; i < dt.Rows.Count; i++)
{
GridViewDataTextColumn col = new GridViewDataTextColumn();
col.FieldName = dt.Rows[i]["cInvCName"].ToString();
col.Caption = dt.Rows[i]["cInvCName"].ToString();
ASPxGridView1.Columns.Add(col);
ASPxSummaryItem sum = new ASPxSummaryItem();
sum.SummaryType = DevExpress.Data.SummaryItemType.Sum;
sum.FieldName = dt.Rows[i]["cInvCName"].ToString();
sum.DisplayFormat = "{0,2}";
ASPxGridView1.TotalSummary.Add(sum);
//ASPxSummaryItem sum = new ASPxSummaryItem();
//sum.FieldName = dt.Rows[i]["cInvCName"].ToString();
//sum.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//ASPxGridView1.TotalSummary.Add(sum);
}
//GridViewDataTextColumn col1 = new GridViewDataTextColumn();
//col1.FieldName = "合计";
//col1.Caption = "合计";
//ASPxGridView1.Columns.Add(col1);
//GridViewDataTextColumn col2 = new GridViewDataTextColumn();
//col2.FieldName = "百分比";
//col2.Caption = "百分比";
//ASPxGridView1.Columns.Add(col2);
}
protected override object CreateControlsCore()
{
grid = new ASPxGridView();
grid.ID = Model.Id;
foreach (var c in Model.Columns.Where(x => x.Index > -1))
{
var column = new GridViewDataTextColumn();
column.FieldName = c.PropertyName;
column.Caption = c.Caption;
grid.Columns.Add(column);
}
grid.KeyFieldName = Model.ModelClass.KeyProperty;
grid.SettingsEditing.Mode = GridViewEditingMode.Batch;
var m = this.Model as IModelListViewNewItemRow;
if (m != null && m.NewItemRowPosition != NewItemRowPosition.None)
{
grid.SettingsEditing.NewItemRowPosition = m.NewItemRowPosition == NewItemRowPosition.Bottom ? GridViewNewItemRowPosition.Bottom : GridViewNewItemRowPosition.Top; // GridViewNewItemRowPosition.Top;
}
grid.Templates.StatusBar = new StatusBarTemplate(grid);
grid.ClientInstanceName = grid.ID;
return(grid);
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "BillId";
gridlookup.TextFormatString = "{0}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Số phiếu bán",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "IssuedDate",
Caption = "Ngày",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
protected override void OnViewControlsCreated()
{
base.OnViewControlsCreated();
// Access and customize the target View control.
// Thêm số thứ tự
ListView dv = (ListView)View;
ASPxGridListEditor gridListEditor = dv.Editor as ASPxGridListEditor;
if (gridListEditor != null)
{
ASPxGridView gridView = gridListEditor.Grid;
// reset the VisibleIndxe start from 1, 0 will be use for ItemNo
for (int j = gridView.VisibleColumns.Count - 1; j >= 0; j--)
{
if (gridView.VisibleColumns[j].VisibleIndex > 0)
{
gridView.VisibleColumns[j].VisibleIndex = gridView.VisibleColumns[j].VisibleIndex + 1;
}
}
// to add the ItemNo for each row
if (gridView.Columns["itemNo"] == null)
{
GridViewDataTextColumn itemNo = new GridViewDataTextColumn();
itemNo.Caption = "STT";
itemNo.ReadOnly = true;
itemNo.UnboundType = UnboundColumnType.String;
itemNo.Width = 32;
gridView.Columns.Add(itemNo);
itemNo.VisibleIndex = 1;
}
gridView.CustomColumnDisplayText += GridView_CustomColumnDisplayText;;
}
}
private void LoadColumns(bool isProvider)
{
GrLookProvider.GridView.Columns.Clear();
GridViewColumn column1 = new GridViewBandColumn();
GridViewColumn column2 = new GridViewBandColumn();
if (isProvider)
{
ASPxLabel2.Text = "Proveedor:";
column1 = new GridViewDataTextColumn {
FieldName = "CODE_PROVIDER", Caption = "Codigo"
};
GrLookProvider.GridView.Columns.Add(column1);
column2 = new GridViewDataTextColumn {
FieldName = "NAME_PROVIDER", Caption = "Nombre"
};
GrLookProvider.GridView.Columns.Add(column2);
GrLookProvider.KeyFieldName = "CODE_PROVIDER";
}
else
{
ASPxLabel2.Text = "Cliente:";
column1 = new GridViewDataTextColumn {
FieldName = "CODE_CUSTOMER", Caption = "Codigo"
};
GrLookProvider.GridView.Columns.Add(column1);
column2 = new GridViewDataTextColumn {
FieldName = "NAME_CUSTOMER", Caption = "Nombre Cliente"
};
GrLookProvider.GridView.Columns.Add(column2);
GrLookProvider.KeyFieldName = "CODE_CUSTOMER";
}
}
public void grid_header()
{
GridViewBandColumn bandColumn;
GridViewDataTextColumn fieldColumn = new GridViewDataTextColumn {
FieldName = "stt", Caption = "Số TT"
};
GridView_S04b4DN.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "tk_no", Caption = "Các TK ghi nợ"
};
GridView_S04b4DN.Columns.Add(fieldColumn);
bandColumn = new GridViewBandColumn("Các TK ghi có");
foreach (string column_name in list_header())
{
fieldColumn = new GridViewDataTextColumn {
FieldName = column_name, Caption = column_name
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
}
fieldColumn = new GridViewDataTextColumn {
FieldName = "cong_tt", Caption = "Tổng cộng"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
GridView_S04b4DN.Columns.Add(bandColumn);
}
public void GridView_header(int FinancialAccountDimId)
{
try
{
GridViewDataTextColumn GVDTC = new GridViewDataTextColumn();
FinancialAccountDim FAD = session.GetObjectByKey <FinancialAccountDim>(FinancialAccountDimId);
if (FAD != null)
{
GVDTC = new GridViewDataTextColumn {
FieldName = "TK", Caption = "Ghi Có các TK, đối xứng Nợ TK " + FAD.Code
};
xGridView.Columns.Add(GVDTC);
for (int i = 1; i <= 12; i++)
{
GVDTC = new GridViewDataTextColumn {
FieldName = i.ToString(), Caption = "Tháng " + i
};
GVDTC.PropertiesEdit.DisplayFormatString = ("#,#");
xGridView.Columns.Add(GVDTC);
}
}
}
catch (Exception) { }
}
private void CreateGrid()
{
ASPxGridView grid = new ASPxGridView();
grid.ID = "grid";
this.Form.Controls.Add(grid);
grid.EnableCallBacks = false;
grid.KeyFieldName = "Id";
grid.DataBinding += grid_DataBinding;
grid.RowDeleting += grid_RowDeleting;
grid.RowUpdating += grid_RowUpdating;
grid.RowInserting += grid_RowInserting;
grid.DataBound += grid_DataBound;
grid.RowValidating += new ASPxDataValidationEventHandler(grid_RowValidating);
grid.DataBind();
if (!this.IsPostBack)
{
GridViewCommandColumn c = new GridViewCommandColumn();
grid.Columns.Add(c);
c.ShowEditButton = true;
c.ShowUpdateButton = true;
c.ShowNewButtonInHeader = true;
}
GridViewDataTextColumn col = grid.Columns["Id"] as GridViewDataTextColumn;
col.PropertiesTextEdit.ValidationSettings.RegularExpression.ValidationExpression = "\\d{1,9}";
}
public override void InitGridLookup(ASPxGridLookup gridlookup)
{
gridlookup.KeyFieldName = "OrganizationId";
gridlookup.TextFormatString = "{0} - {1}";
gridlookup.Columns.Clear();
GridViewColumn selectionColumn = new GridViewCommandColumn()
{
ShowSelectCheckbox = true,
VisibleIndex = 0
};
GridViewColumn codeColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Code",
Caption = "Mã khách hàng",
VisibleIndex = 1
};
GridViewColumn nameColumn = new GridViewDataTextColumn()
{
ShowInCustomizationForm = true,
FieldName = "Name",
Caption = "Tên khách hàng",
VisibleIndex = 2
};
gridlookup.Columns.Add(selectionColumn);
gridlookup.Columns.Add(codeColumn);
gridlookup.Columns.Add(nameColumn);
}
public virtual void Custom_GridView()
{
if (this.MyGV == null)
{
return;
}
var gvData = this.MyGV;
// Thiết lập chung...
gvData.ClientInstanceName = this.MyClientInstanceName;
try
{
var arrColumn = this.MySett.Columns.Where(p => !string.IsNullOrEmpty(p.FieldName))
.OrderBy(p => p.VisibleIndex);
gvData.Width = new Unit(arrColumn.Sum(p => p.Width + 50), UnitType.Pixel);
// Xóa các Column dữ liệu
gvData.Columns.Clear();
// Thêm cột số thứ tự
var colLine = new GridViewDataTextColumn
{
Name = "colLine",
Caption = "No",
FieldName = "#",
VisibleIndex = 0,
Width = new Unit(50, UnitType.Pixel),
UnboundType = DevExpress.Data.UnboundColumnType.Integer,
};
gvData.KeyFieldName = "#";
gvData.SettingsBehavior.AllowFocusedRow = true;
gvData.SettingsBehavior.EnableRowHotTrack = true;
if (!this.IsDemo)
{
gvData.SettingsBehavior.AllowSort = true;
gvData.SettingsBehavior.AllowDragDrop = false;
}
gvData.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Disabled;
colLine.PropertiesTextEdit.DisplayFormatString = "#,##0";
colLine.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
colLine.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
gvData.Columns.Add(colLine);
var lstFields = this.MySett.Get_ColumnFields();
foreach (var field in arrColumn)
{
var col = new GridViewDataTextColumn();
col.Name = field.Name;
col.Caption = field.Caption;
var objField = lstFields.FirstOrDefault(p => p.Prop2 == field.FieldName);
col.FieldName = objField.Prop3;
col.VisibleIndex = field.VisibleIndex;
col.Width = new Unit(field.Width, UnitType.Pixel);
col.CellStyle.HorizontalAlign = field.Align;
col.PropertiesEdit.DisplayFormatString = field.DisplayF;
this.FormatGridColumn(col, objField.Prop1);
gvData.Columns.Add(col);
}
}
catch { }
}
public void grid_header()
{
GridViewBandColumn bandColumn;
GridViewDataTextColumn fieldColumn = new GridViewDataTextColumn {
FieldName = "stt", Caption = "Số TT"
};
GridView_S12DN.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "date", Caption = "Ngày tháng"
};
GridView_S12DN.Columns.Add(fieldColumn);
bandColumn = new GridViewBandColumn("Số hiệu chứng từ");
fieldColumn = new GridViewDataTextColumn {
FieldName = "nhap_dau", Caption = "Nhập"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "xuat_dau", Caption = "Xuất"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
GridView_S12DN.Columns.Add(bandColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "dien_giai", Caption = "Diễn giải"
};
GridView_S12DN.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "date_nhap_xuat", Caption = "Ngày nhập xuất"
};
GridView_S12DN.Columns.Add(fieldColumn);
bandColumn = new GridViewBandColumn("Số lượng");
fieldColumn = new GridViewDataTextColumn {
FieldName = "nhap_cuoi", Caption = "Nhập"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "xuat_cuoi", Caption = "Xuất"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "ton_cuoi", Caption = "Tồn"
};
fieldColumn.PropertiesEdit.DisplayFormatString = "#,#";
bandColumn.Columns.Add(fieldColumn);
GridView_S12DN.Columns.Add(bandColumn);
fieldColumn = new GridViewDataTextColumn {
FieldName = "ky", Caption = "Ký xác nhận của kế toán"
};
GridView_S12DN.Columns.Add(fieldColumn);
}
private GridViewDataTextColumn createGrid(string caption, string fieldName)
{
GridViewDataTextColumn g = new GridViewDataTextColumn();
g.Caption = caption;
g.FieldName = fieldName;
return(g);
}
private object GetColor()
{
GridViewDataTextColumn col = grid.Columns["DxColor"] as GridViewDataTextColumn;
ASPxColorEdit colorEdit = grid.FindEditRowCellTemplateControl(col, "colorEdit") as ASPxColorEdit;
Color color = colorEdit.Color;
return(color.ToArgb().ToString());
}
private void initializeGridView()
{
GridViewDataTextColumn column;
column = new GridViewDataTextColumn()
{
FieldName = "AttributeKey", Caption = "AttributeKey"
};
column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat;
gdvPartyAttribute.Columns.Add(column);
column = new GridViewDataTextColumn()
{
Name = "EffectiveFrom", Caption = ResGeneral.EffectiveFrom
};
column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat;
gdvPartyAttribute.Columns.Add(column);
column = new GridViewDataTextColumn()
{
Name = "EffectiveTo", Caption = ResGeneral.EffectiveTo
};
column.PropertiesEdit.DisplayFormatString = base.DateOutputFormat;
gdvPartyAttribute.Columns.Add(column);
gdvPartyAttribute.ClientSideEvents.EndCallback = @"
function(s,e)
{
var objs = eval('(' + s." + KEY_CP_RESULT + @" + ')');
if(objs == null)return;
if(objs.Message != '')
{
alert(objs.Message);
}
var index = s.GetFocusedRowIndex();
if(index > -1)
{
" + btnAdd.ClientInstanceName + @".SetEnabled(true);
" + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @";' + index);
}else
{
" + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @"');
}
//" + hddPartyAttribute.ClientInstanceName + @".Set('" + HKEY_VALUE_IMG + @"', '');
s." + KEY_CP_RESULT + @" = null;
}
";
gdvPartyAttribute.ClientSideEvents.FocusedRowChanged = @"function(s,e)
{
if(typeof(" + cbpEdit.ClientInstanceName + @") != 'undefined' && " + cbpEdit.ClientInstanceName + @" != null)
{
var index = s.GetFocusedRowIndex();
if(index > -1)
{
" + btnExpire.ClientInstanceName + @".SetEnabled(false);
" + cbpEdit.ClientInstanceName + @".PerformCallback('" + KEY_DISPLAY + @";' + index);
}
}
}";
}
private GridViewDataTextColumn createGrid(string caption, string fieldName, string columnFormat)
{
GridViewDataTextColumn g = new GridViewDataTextColumn();
g.Caption = caption;
g.FieldName = fieldName;
g.PropertiesTextEdit.DisplayFormatString = columnFormat;
return(g);
}
/// <summary>
/// Returns <see cref="GridViewEditDataColumn"/> instance based on meta data passed in column argument.
/// </summary>
/// <param name="column">An instance of <see cref="ColumnMeta"/> containing meta data of column to be created.</param>
/// <param name="connectionString">Connection string to underlying database.</param>
/// <returns></returns>
internal static GridViewEditDataColumn AddGridViewDataColumn(ColumnMeta column, string connectionString)
{
GridViewEditDataColumn dataColumn = null;
// As per 11 Oct 2016, the following evaluation criteria for data type and its column editor are not yet complete.
// We still has some works to do to deal with picture and blob/document. (--github.com/ganagus)
// ---
if ((new TypeCode[] { TypeCode.String, TypeCode.Int64, TypeCode.Int32, TypeCode.Single, TypeCode.Decimal })
.Contains(column.DataType) && !column.IsForeignKey && string.IsNullOrEmpty(column.EnumTypeName))
{
// regular text column, editor => text box
dataColumn = AddGridViewDataTextColumn(column, dataColumn);
}
else if (!string.IsNullOrEmpty(column.EnumTypeName))
{
// enum data type column, editor => check box
dataColumn = AddGridViewEnumColumn(column, dataColumn);
}
// foreign key should be rendered in combo box column
else if (column.IsForeignKey)
{
// foreign key column, it's a look up to other table, editor => combo box
dataColumn = AddGridViewForeignKeyColumn(column, dataColumn, connectionString);
}
else if (column.DataType == TypeCode.DateTime)
{
// date / datetime column, editor => DevExpress date editor
dataColumn = new GridViewDataDateColumn();
if (column.Name.ToLower() == "createddate" || column.Name.ToLower() == "modifieddate")
{
//hide createdby, createddate, modifiedby, modifieddate from edit form
//dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
}
}
else if (column.DataType == TypeCode.Boolean)
{
// boolean column, editor => check box
dataColumn = new GridViewDataCheckColumn();
}
else
{
// other data type, default to text box
dataColumn = new GridViewDataTextColumn();
}
if (column.IsIdentity)
{
dataColumn.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False;
}
dataColumn.FieldName = column.Name;
dataColumn.Caption = column.Caption;
dataColumn.VisibleIndex = column.OrderNo;
return(dataColumn);
}
private void AddColumnsFondAmortizationGrid()
{
var columnInventory = new GridViewDataTextColumn { FieldName = "Inventory", Caption = "Инв. №", VisibleIndex = 0, Width = 110 };
var columnName = new GridViewDataTextColumn { FieldName = "NameFond", Caption = "Наименование ОС", VisibleIndex = 1 };
var columnNameGroup = new GridViewDataTextColumn { FieldName = "NameGroup", Caption = "Группа", VisibleIndex = 2 };
var columnSpir = new GridViewDataTextColumn { FieldName = "Spir", Caption = "Ост. СПИ", VisibleIndex = 3 };
var columnIsFiled = new GridViewDataTextColumn { FieldName = "IsFilled", Caption = "Заполнен", VisibleIndex = 4, Visible = false};
gridFondSpi.Columns.AddRange(columnInventory, columnName, columnNameGroup, columnSpir, columnIsFiled);
}
protected void Page_Load(object sender, EventArgs e)
{
string DSN = "PostgreSQL30";
OdbcConnection connection = new OdbcConnection("Dsn=" + DSN);
loginErrorLabel.Text = "State: " + connection.State.ToString();
string query = "SELECT * FROM q1;";
GridViewDataTextColumn myCol0 = new GridViewDataTextColumn();
GridViewDataTextColumn myCol1 = new GridViewDataTextColumn();
GridViewDataTextColumn myCol2 = new GridViewDataTextColumn();
GridViewDataTextColumn myCol3 = new GridViewDataTextColumn();
try
{
OdbcDataAdapter adapter = new OdbcDataAdapter(query, connection);
DataTable dt = new DataTable();
connection.Open();
adapter.Fill(dt);
myCol0.FieldName = dt.Columns[0].ColumnName;
myCol0.VisibleIndex = 0;
myCol1.FieldName = dt.Columns[1].ColumnName;
myCol1.VisibleIndex = 1;
myCol2.FieldName = dt.Columns[2].ColumnName;
myCol2.VisibleIndex = 2;
myCol3.FieldName = dt.Columns[3].ColumnName;
myCol3.VisibleIndex = 3;
grid.Columns.Clear();
grid.Columns.Add(myCol0);
grid.Columns.Add(myCol1);
grid.Columns.Add(myCol2);
grid.Columns.Add(myCol3);
grid.DataSource = dt;
grid.DataBind();
Chart1.DataSource = dt;
Chart1.DataBind();
Chart1.Series["Series1"].XValueMember = dt.Columns[0].ColumnName;
Chart1.Series["Series1"].YValueMembers = dt.Columns[2].ColumnName;
Chart1.ChartAreas["ChartArea1"].AxisY.Title = dt.Columns[2].ColumnName;
Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Time Stamp";
//connection.Close();
}
catch (Exception exp)
{
loginErrorLabel.Text = exp.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
LogCallMethod(true);
if (!IsPostBack)
{
NavControl1.gv = gvStockImport.gridControl;
GridViewDataTextColumn A4 = new GridViewDataTextColumn();
A4.Caption = "In A4";
A4.VisibleIndex = 13;
A4.DataItemTemplate = new MyHyperlinkTemplate();
gvStockImport.gridControl.Columns.Add(A4);
}
LogCallMethod(false);
}
private void AddColumnsGridPostingLoadBalance()
{
var columnDescription = new GridViewDataTextColumn { FieldName = "EventName", Caption = "Проводки", VisibleIndex = 1 };
var columnDateEvent = new GridViewDataTextColumn { FieldName = "DateEvent", Caption = "Дата сброса", VisibleIndex = 2 };
var columnFilePath = new GridViewDataTextColumn { FieldName = "NamePostingFile", Caption = "Имя файла", VisibleIndex = 3 };
var columnMonth = new GridViewDataTextColumn { FieldName = "Month", Caption = "Месяц", VisibleIndex = 4 };
var columnYear = new GridViewDataTextColumn { FieldName = "Year", Caption = "Год", VisibleIndex = 5 };
var columnFioUser = new GridViewDataTextColumn { FieldName = "FioUser", Caption = "ФИО пользователя", VisibleIndex = 6 };
var columnIsSuccessfully = new GridViewDataTextColumn { FieldName = "IsSuccessfully", Caption = "Успешно", VisibleIndex = 7 };
var columnMessage = new GridViewDataTextColumn { FieldName = "Message", Caption = "Сообщение", VisibleIndex = 8 };
gridPostingLoadBalance.Columns.AddRange(columnDescription,columnDateEvent,columnFilePath, columnMonth, columnYear,
columnFioUser, columnIsSuccessfully, columnMessage);
}
public void PopulateColumns()
{
GridViewDataTextColumn colID = new GridViewDataTextColumn();
colID.FieldName = "ID";
ASPxGridView1.Columns.Add(colID);
GridViewDataTextColumn colItemTemplate = new GridViewDataTextColumn();
colItemTemplate.DataItemTemplate = new MyHyperlinkTemplate(); // Create a template
colItemTemplate.Name = "colItemTemplate";
colItemTemplate.Caption = "Template Column";
ASPxGridView1.Columns.Add(colItemTemplate);
}
public void PopulateColumns()
{
GridViewDataTextColumn colID = new GridViewDataTextColumn();
colID.FieldName = "ID";
ASPxGridView1.Columns.Add(colID);
GridViewDataHyperLinkColumn colItemName = new GridViewDataHyperLinkColumn();
colItemName.FieldName = "ItemName";
colItemName.PropertiesHyperLinkEdit.NavigateUrlFormatString = "~/details.aspx?Device={0}";
colItemName.PropertiesHyperLinkEdit.TextFormatString = "Get details about device {0}";
colItemName.PropertiesHyperLinkEdit.TextField = "ItemName";
ASPxGridView1.Columns.Add(colItemName);
}
protected void grid_DataBound(object sender, EventArgs e)
{
ASPxGridView g = sender as ASPxGridView;
for (int i = 0; i < g.Columns.Count; i++)
{
GridViewDataTextColumn c = g.Columns[i] as GridViewDataTextColumn;
if (c == null)
{
continue;
}
c.PropertiesTextEdit.ValidationSettings.RequiredField.IsRequired = true;
}
}
private void ReCreateColumns()
{
ASPxGridView1.Columns.Clear();
DataTable table = GetCurrentTable();
foreach (DataColumn dataColumn in table.Columns)
{
GridViewDataTextColumn column = new GridViewDataTextColumn();
column.FieldName = dataColumn.ColumnName;
// set additional column properties
column.Caption = dataColumn.ColumnName;
ASPxGridView1.Columns.Add(column);
}
}
protected void gdvPayments_Init(object sender, EventArgs e)
{
ASPxGridView gdv = (ASPxGridView)sender;
GridViewDataTextColumn column = gdv.Columns["Amount"] as GridViewDataTextColumn;
if (column != null)
{
column.PropertiesEdit.DisplayFormatString = base.CurrencyFormat;
}
gdv.TotalSummary.Add(new ASPxSummaryItem("Amount", DevExpress.Data.SummaryItemType.Sum)
{
DisplayFormat = base.CurrencyFormat
});
gdv.Templates.PreviewRow = new PaymentTemplate(iSabayaContext);
}
protected override void AddGridViewColumns(DevExpress.Web.ASPxGridLookup.ASPxGridLookup control)
{
GridViewDataTextColumn colFirstName = new GridViewDataTextColumn();
colFirstName.Caption = "First Name";
colFirstName.FieldName = "FirstName";
colFirstName.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
control.Columns.Add(colFirstName);
GridViewDataTextColumn colLastName = new GridViewDataTextColumn();
colLastName.Caption = "Last Name";
colLastName.FieldName = "LastName";
control.Columns.Add(colLastName);
}
public void ColumnsForGridview(int creditAccount, string owner, int month, int year, string currency)
{
//khai báo space, cân chỉnh report
// int a = DataTable_ContraAccount(creditAccount, owner, month, year, currency).Columns.Count;
// String space = new String(' ', 180 - a*5);
//1.Add Column1:"Số TT"
GridViewColumn column1 = new GridViewDataTextColumn {
FieldName = "Số TT", Caption = "Số TT"
};
ASPxGridViewS04a2.Columns.Add(column1);
//2.Add Column2:"Chứng từ" là BandColumn chứa các column:"Số hiệu", "Ngày,tháng"
GridViewColumn column2 = new GridViewBandColumn("Chứng từ");
(column2 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn {
FieldName = "Số hiệu"
});
(column2 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn {
FieldName = "Ngày,tháng"
});
ASPxGridViewS04a2.Columns.Add(column2);
//3.Add Column3:"Diễn Giải"
GridViewColumn column3 = new GridViewDataTextColumn {
FieldName = "Diễn giải"
};
ASPxGridViewS04a2.Columns.Add(column3);
//4.Add Column4 là BandColumns("Tài khoản có 112, Nợ các tài khoản...") chứa các Column:"TK đối ứng"
GridViewColumn column4 = new GridViewBandColumn("Tài Khoản Có " + creditAccount + ", Nợ các tài khoản");
//lấy ra tên các tài khoản đối ứng tìm được ở trên, cho vào các columns: "nợ các tài khoản..."
foreach (DataColumn ContraAccount in DataTable_ContraAccount(creditAccount, owner, month, year, currency).Columns)
{
(column4 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn {
FieldName = ContraAccount.ColumnName, Caption = ContraAccount.ColumnName
});
}
//ASPxGridViewS04a2.Columns.Add(column4);
//5.Add Colum5:"Cộng có TK"
(column4 as GridViewBandColumn).Columns.Add(new GridViewDataTextColumn {
FieldName = "Cộng có TK " + creditAccount + "", Caption = space + "Cộng có TK " + creditAccount
}); //add column:"Cộng có tài khoản 112"
ASPxGridViewS04a2.Columns.Add(column4);
}
public GridViewDataTextColumn kolumnaDoTabeli(string Napis, int rowSpan)
{
GridViewDataTextColumn kolumna_ = new GridViewDataTextColumn
{
Caption = Napis,
CellRowSpan = rowSpan,
};
kolumna_.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
kolumna_.CellStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
kolumna_.CellStyle.CssClass = "normal center ";
kolumna_.HeaderStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
return(kolumna_);
}
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
var kpi = this.Get_DefineInfo();
var inq = kpi.ReFilter_InqMDX();
inq.Reset_SummariesID();
foreach (var f in inq.Fields.OrderBy(P => P.Level))
{
var col = new GridViewDataTextColumn();
col.Name = f.KeyField;
col.Caption = f.ColAliasVI;
col.FieldName = f.ColName;
if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName))
{
this.Format_GridColumn(col, ValueFormat.DateTime);
}
else
{
this.Format_GridColumn(col, ValueFormat.Normal);
}
this.gvPreViewData.Columns.Add(col);
}
foreach (var f in inq.Summaries)
{
var col = new GridViewDataTextColumn();
col.Name = f.Field.KeyField;
col.Caption = f.FieldAlias;
col.FieldName = f.Get_SummaryKeyField();
this.Format_GridColumn(col, ValueFormat.Numeric);
this.gvPreViewData.Columns.Add(col);
}
foreach (var f in inq.CalcMembers)
{
var col = new GridViewDataTextColumn();
col.Name = f.Code;
col.Caption = f.Cat;
col.FieldName = f.Code;
this.Format_GridColumn(col, ValueFormat.Numeric);
this.gvPreViewData.Columns.Add(col);
}
var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX());
this.gvPreViewData.DataSource = ds;
this.gvPreViewData.DataBind();
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NavControl.gv = gvInvoiceN.gridControl;
Session["ssFromDate"] = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd");
Session["ssTodate"] = DateTime.Now.ToString("yyyy-MM-dd");
GridViewDataTextColumn A4 = new GridViewDataTextColumn();
A4.Caption = "In A4";
A4.VisibleIndex = 13;
A4.DataItemTemplate = new MyHyperlinkTemplate();
gvInvoiceN.gridControl.Columns.Add(A4);
GridViewDataTextColumn A5 = new GridViewDataTextColumn();
A5.Caption = "In A5";
A5.VisibleIndex = 14;
A5.DataItemTemplate = new MyHyperlinkTemplate();
gvInvoiceN.gridControl.Columns.Add(A5);
}
}
public void Format_GridColumn(GridViewDataTextColumn col, ValueFormat valF)
{
col.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
col.HeaderStyle.Font.Bold = true;
col.HeaderStyle.Font.Name = "Arial";
col.HeaderStyle.Font.Size = new FontUnit(9, UnitType.Point);
col.CellStyle.Font.Name = "Arial";
col.CellStyle.Font.Size = new FontUnit(9, UnitType.Point);
switch (valF)
{
case ValueFormat.Date:
case ValueFormat.DateTime:
case ValueFormat.ShortTime:
case ValueFormat.Time:
col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
break;
case ValueFormat.Numeric:
col.PropertiesEdit.DisplayFormatString = "#,##0";
col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
break;
}
}
public virtual void Custom_GridView()
{
if (this.MyGV == null) return;
var gvData = this.MyGV;
// Thiết lập chung...
gvData.ClientInstanceName = this.MyClientInstanceName;
try
{
var arrColumn = this.MySett.Columns.Where(p => !string.IsNullOrEmpty(p.FieldName))
.OrderBy(p => p.VisibleIndex);
gvData.Width = new Unit(arrColumn.Sum(p => p.Width + 50), UnitType.Pixel);
// Xóa các Column dữ liệu
gvData.Columns.Clear();
// Thêm cột số thứ tự
var colLine = new GridViewDataTextColumn
{
Name = "colLine",
Caption = "No",
FieldName = "#",
VisibleIndex = 0,
Width = new Unit(50, UnitType.Pixel),
UnboundType = DevExpress.Data.UnboundColumnType.Integer,
};
gvData.KeyFieldName = "#";
gvData.SettingsBehavior.AllowFocusedRow = true;
gvData.SettingsBehavior.EnableRowHotTrack = true;
if (!this.IsDemo)
{
gvData.SettingsBehavior.AllowSort = true;
gvData.SettingsBehavior.AllowDragDrop = false;
}
gvData.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Disabled;
colLine.PropertiesTextEdit.DisplayFormatString = "#,##0";
colLine.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
colLine.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
gvData.Columns.Add(colLine);
var lstFields = this.MySett.Get_ColumnFields();
foreach (var field in arrColumn)
{
var col = new GridViewDataTextColumn();
col.Name = field.Name;
col.Caption = field.Caption;
var objField = lstFields.FirstOrDefault(p => p.Prop2 == field.FieldName);
col.FieldName = objField.Prop3;
col.VisibleIndex = field.VisibleIndex;
col.Width = new Unit(field.Width, UnitType.Pixel);
col.CellStyle.HorizontalAlign = field.Align;
col.PropertiesEdit.DisplayFormatString = field.DisplayF;
this.FormatGridColumn(col, objField.Prop1);
gvData.Columns.Add(col);
}
}
catch { }
}
internal static void BuildColumnsByEntity(BusinessMapper.eEntities entidad, ASPxGridView gv)
{
if (BusinessMapper.AbmConfigXmlPath == null || BusinessMapper.AbmConfigXmlPath == string.Empty)
throw new Exception("Path del archivo AbmConfig.xml sin definir.");
XmlDocument xDoc = new XmlDocument();
xDoc.Load(BusinessMapper.AbmConfigXmlPath);
gv.Columns.Clear();
if (xDoc.SelectSingleNode(
"Entities/Entity[@EntityName='" + entidad.ToString() + "']") == null)
throw new AbmConfigXMLException("No existe la configuración de mapeo para la entidad: " + entidad.ToString());
foreach (XmlNode nodeControl in xDoc.SelectSingleNode(
"Entities/Entity[@EntityName='" + entidad.ToString() + "']").ChildNodes)
{
if (nodeControl.Attributes["ControlType"].Value == "ComboBox")
{
GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();
gvc.Name = nodeControl.Attributes["FieldName"].Value;
gvc.Caption = nodeControl.Attributes["Title"].Value;
gvc.FieldName = nodeControl.Attributes["FieldName"].Value;
var mapInfo = BusinessMapper.GetMapInfo(nodeControl.Attributes["EntityName"].Value);
gvc.PropertiesComboBox.TextField = mapInfo.EntityTextField;
gvc.PropertiesComboBox.ValueField = mapInfo.EntityValueField;
gvc.PropertiesComboBox.DataSource = mapInfo.DAOHandler.ReadAll("");
gv.Columns.Add(gvc);
}
else if (nodeControl.Attributes["ControlType"].Value == "RadioButtonList")
{
GridViewDataComboBoxColumn gvc = new GridViewDataComboBoxColumn();
gvc.Name = nodeControl.Attributes["FieldName"].Value;
gvc.Caption = nodeControl.Attributes["Title"].Value;
gvc.FieldName = nodeControl.Attributes["FieldName"].Value;
gvc.PropertiesComboBox.Items.Clear();
foreach (XmlNode item in nodeControl.ChildNodes[0].ChildNodes)
{
gvc.PropertiesComboBox.Items.Add(item.Attributes["Name"].Value, item.Attributes["Value"].Value);
}
gv.Columns.Add(gvc);
}
else if (nodeControl.Attributes["ControlType"].Value == "TextBox"
|| nodeControl.Attributes["ControlType"].Value == "SpinEdit"
|| nodeControl.Attributes["ControlType"].Value == "TimeEdit")
{
GridViewDataTextColumn gvc = new GridViewDataTextColumn();
gvc.Name = nodeControl.Attributes["FieldName"].Value;
gvc.Caption = nodeControl.Attributes["Title"].Value;
gvc.FieldName = nodeControl.Attributes["FieldName"].Value;
gv.Columns.Add(gvc);
}
else if (nodeControl.Attributes["ControlType"].Value == "DateEdit")
{
GridViewDataDateColumn gvc = new GridViewDataDateColumn();
gvc.Name = nodeControl.Attributes["FieldName"].Value;
gvc.Caption = nodeControl.Attributes["Title"].Value;
gvc.FieldName = nodeControl.Attributes["FieldName"].Value;
gv.Columns.Add(gvc);
}
else if (nodeControl.Attributes["ControlType"].Value == "CheckBox")
{
GridViewDataCheckColumn gvc = new GridViewDataCheckColumn();
gvc.Name = nodeControl.Attributes["FieldName"].Value;
gvc.Caption = nodeControl.Attributes["Title"].Value;
gvc.FieldName = nodeControl.Attributes["FieldName"].Value;
gv.Columns.Add(gvc);
}
}
}
public virtual void FormatGridColumn(GridViewDataTextColumn col, string tinyDataTypeStr)
{
col.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
col.HeaderStyle.Font.Bold = true;
col.HeaderStyle.Font.Name = "Arial";
col.HeaderStyle.Font.Size = new FontUnit(9, UnitType.Point);
col.CellStyle.Font.Name = "Arial";
col.CellStyle.Font.Size = new FontUnit(9, UnitType.Point);
switch (tinyDataTypeStr.ToUpper())
{
case "NORMAL":
col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left;
break;
case "TIME":
col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
break;
case "NUM":
col.PropertiesEdit.DisplayFormatString = "#,##0";
col.CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
break;
}
}
private void proccessCreateColumnGridLookup(string type,string select ,string colSetting, ASPxGridLookup gl)
{
if (type == "query" && select.IndexOf('*')<0)
colSetting = colSetting.ToLower();
DataTable dtLiscolSetting = JsonConvert.DeserializeObject<DataTable>(colSetting);
for (int i = 0; i < dtLiscolSetting.Rows.Count; i++)
{
string colname = dtLiscolSetting.Rows[i]["colname"].ToString();
string caption = string.Format("{0}{1}", dtLiscolSetting.Rows[i]["caption"].ToString().Substring(0, 1).ToUpper(), dtLiscolSetting.Rows[i]["caption"].ToString().Remove(0, 1));
GridViewDataTextColumn cl = new GridViewDataTextColumn();
cl.Caption = string.Format("<Center>{0}<Center>", caption);
cl.FieldName = colname;
cl.VisibleIndex = i;
cl.Width = 150;
cl.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
gl.Columns.Add(cl);
}
}
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
var kpi = this.Get_DefineInfo();
var inq = kpi.ReFilter_InqMDX();
inq.Reset_SummariesID();
foreach (var f in inq.Fields.OrderBy(P => P.Level))
{
var col = new GridViewDataTextColumn();
col.Name = f.KeyField;
col.Caption = f.ColAliasVI;
col.FieldName = f.ColName;
if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName))
this.Format_GridColumn(col, ValueFormat.DateTime);
else
this.Format_GridColumn(col, ValueFormat.Normal);
this.gvPreViewData.Columns.Add(col);
}
foreach (var f in inq.Summaries)
{
var col = new GridViewDataTextColumn();
col.Name = f.Field.KeyField;
col.Caption = f.FieldAlias;
col.FieldName = f.Get_SummaryKeyField();
this.Format_GridColumn(col, ValueFormat.Numeric);
this.gvPreViewData.Columns.Add(col);
}
foreach (var f in inq.CalcMembers)
{
var col = new GridViewDataTextColumn();
col.Name = f.Code;
col.Caption = f.Cat;
col.FieldName = f.Code;
this.Format_GridColumn(col, ValueFormat.Numeric);
this.gvPreViewData.Columns.Add(col);
}
var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX());
this.gvPreViewData.DataSource = ds;
this.gvPreViewData.DataBind();
}
catch { }
}
/// <summary>
/// Ham tạo Column cho Gridview loại GridViewDataTextColumn
/// </summary>
/// <param name="Caption">Tiêu đề cho column</param>
/// <param name="FieldName">FieldName cho column</param>
/// <param name="Width">Độ rộng cho column</param>
/// <param name="Format">Định dạng của column</param>
/// <param name="typeTemp">Loại Template cho column</param>
/// <returns>GridViewDataTextColumn</returns>
public GridViewDataTextColumn BuildTextColumn(string Caption, string FieldName, string Alias, int Width,
string Format, string tempeditor, int moduleid, string tablename, string datasource, bool ishyperlinkrelate, string keyFieldName, string objectnamefk)
{
GridViewDataTextColumn textColumn = new GridViewDataTextColumn();
textColumn.Caption = Caption;
if (datasource == "")
{
if (tempeditor.ToLower() != "hyperlinkbutton")
textColumn.FieldName = Alias + FieldName;
}
else
{
textColumn.FieldName = Caption;
}
if (Width != 0)
textColumn.Width = Unit.Pixel(Width);
else
textColumn.MinWidth = 80;
textColumn.Name = FieldName;
textColumn.PropertiesTextEdit.DisplayFormatString = Format;
textColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
textColumn.Settings.HeaderFilterMode = HeaderFilterMode.CheckedList;
switch (tempeditor.ToLower())
{
case "textbox":
textColumn.DataItemTemplate = new EditorTemplate("textedit", moduleid, tablename);
break;
case "checkbox":
textColumn.DataItemTemplate = new EditorTemplate("checkbox", moduleid, tablename);
break;
case "spinedit":
textColumn.DataItemTemplate = new EditorTemplate("spinedit", moduleid, tablename);
break;
case "hyperlink":
if (ishyperlinkrelate == false)
textColumn.DataItemTemplate = new EditorTemplate("hyperlink", moduleid, tablename, FieldName, keyFieldName, objectnamefk);
else
textColumn.DataItemTemplate = new EditorTemplate("hyperlinkrl", moduleid, tablename, FieldName, keyFieldName, objectnamefk);//moduleid= modulerelateid
break;
case "hyperlinkbutton":
textColumn.DataItemTemplate = new EditorTemplate("hyperlinkbutton", moduleid, tablename);
break;
}
return textColumn;
}
protected void Page_Init()
{
grid.ClientSideEvents.RowDblClick = "GridRowDoubleClick";
grid.ClientSideEvents.EndCallback = "PrintMulti";
NavControl.gv = grid;
GridViewDataTextColumn A4 = new GridViewDataTextColumn();
A4.Caption = "In A4";
A4.VisibleIndex = 17;
A4.DataItemTemplate = new MyHyperlinkTemplate();
grid.Columns.Add(A4);
}
protected void gvPreViewData_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
try
{
var inq = this.Get_DefineSource();
foreach (var f in inq.Fields.OrderBy(P => P.Level))
{
var col = new GridViewDataTextColumn();
col.Name = f.KeyField;
col.Caption = f.ColAliasVI;
col.FieldName = f.ColName;
if (new[] { "DateKey", "Period", "Quarter", "Year" }.Contains(f.ColName))
this.Format_GridColumn(col, ValueFormat.DateTime);
else
this.Format_GridColumn(col, ValueFormat.Normal);
this.gvPreViewData.Columns.Add(col);
}
foreach (var f in inq.Summaries)
{
var col = new GridViewDataTextColumn();
col.Name = f.Field.KeyField;
col.Caption = f.FieldAlias;
col.FieldName = f.Get_SummaryKeyField();
this.Format_GridColumn(col, ValueFormat.Numeric);
this.gvPreViewData.Columns.Add(col);
}
var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, inq.ToMDX());
//var ds = Lib.Db.ExecuteMDX(GlobalVar.DbOLAP_ConnectionStr_Tiny, "WITH MEMBER [Measures].[QuantitySUM1] AS COALESCEEMPTY([Measures].[Quantity],0) SELECT {[ARDimItem].[ItemGroupName].MEMBERS * [ARDimItem].[ItemName].MEMBERS} ON ROWS,{[Measures].[QuantitySUM1]} ON COLUMNS FROM [ARCube]");
this.gvPreViewData.DataSource = ds;
this.gvPreViewData.DataBind();
}
catch { }
}
protected void Bind()
{
if ((!this.IsCallback) && (!this.IsPostBack))
{
//Restore filter from cookies
this.LoadFilterFromCookies();
this.InitialFilterBind();
SessionManager.CurrentCategories = this.GetListOfCategories();
}
//Get main results
try
{
List<int> channelIds = (SessionManager.CurrentChannels.Count==0)?this.GetListOfChannels()
:SessionManager.CurrentChannels;
List<int> categoryIds = (SessionManager.CurrentCategories.Count==0)?this.GetListOfCategories()
:SessionManager.CurrentCategories;
SessionManager.CurrentChannels = channelIds;
SessionManager.CurrentCategories = categoryIds;
CanonMainMonitor monitor = new CanonMainMonitor(Cdb.ConnectionString);
monitor.Date = deDate.Date;
monitor.ChannelIds = channelIds;
monitor.PriceCondition = this.GetPriceCondition();
if (categoryIds != null)
monitor.CategoryIds = categoryIds;
if (!string.IsNullOrEmpty(txtProduct.Text.Trim()))
monitor.ProductName = Memos.Framework.Utilities.TruncateString(txtProduct.Text.Trim(), 300);
mappingRules = monitor.GetMappingRules();
DataSet ds = monitor.GetMainMonitorValues();
//get sorting settings before columns clearing
DevExpress.Data.ColumnSortOrder sortOrder = DevExpress.Data.ColumnSortOrder.None;
string sortColumn = string.Empty;
foreach (GridViewColumn gvc in gridMainMonitor.Columns)
{
GridViewDataColumn gvdc = gvc as GridViewDataColumn;
if (gvdc != null)
if (gvdc.SortOrder != DevExpress.Data.ColumnSortOrder.None)
{
sortColumn = gvdc.FieldName;
sortOrder = gvdc.SortOrder;
}
}
gridMainMonitor.Columns.Clear();
GridViewCommandColumn col0 = new GridViewCommandColumn();
col0.ShowSelectCheckbox = true;
col0.VisibleIndex = 0;
col0.HeaderTemplate = new CommandColumnHeaderTemplate(gridMainMonitor, "selCheckbox", "gridMainMonitorSelectionBox");
col0.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
col0.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
gridMainMonitor.Columns.Add(col0);
int visIndex = 1;
foreach (DataColumn dc in ds.Tables[0].Columns)
{
GridViewDataTextColumn col1 = new GridViewDataTextColumn();
col1.Caption = this.LocalizeColumnName(dc.ColumnName);
col1.FieldName = dc.ColumnName;
col1.VisibleIndex = visIndex++;
if (dc.ColumnName == "ProductId")
col1.Visible = false;
if ((!string.IsNullOrEmpty(sortColumn)) && (col1.FieldName == sortColumn))
col1.SortOrder = sortOrder;
col1.Settings.SortMode = DevExpress.XtraGrid.ColumnSortMode.Custom;
gridMainMonitor.Columns.Add(col1);
}
gridMainMonitor.SettingsPager.PageSize = int.Parse(cbPageSize.SelectedItem.Value.ToString());
gridMainMonitor.DataSource = ds.Tables[0];
gridMainMonitor.DataBind();
gridMainMonitor.JSProperties["cpRowsCount"] = gridMainMonitor.VisibleRowCount;
}
catch (Exception ex)
{
Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error);
gridMainMonitor.Columns.Clear();
gridMainMonitor.DataSource = null;
gridMainMonitor.DataBind();
}
}
protected void ReCreateColumns()
{
gridLogRecords.Columns.Clear();
//create columns
switch (this.LogType)
{
case LogTypesEnum.ProductMappingHistory:
gridLogRecords.KeyFieldName = "RecordId";
GridViewDataDateColumn dateColumn = new GridViewDataDateColumn();
dateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
dateColumn.FieldName = "LogDate";
dateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
dateColumn.VisibleIndex = 0;
gridLogRecords.Columns.Add(dateColumn);
GridViewDataTextColumn stateColumn = new GridViewDataTextColumn();
stateColumn.Caption = Utilities.GetResourceString("Common", "LogStatus");
stateColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
stateColumn.VisibleIndex = 1;
gridLogRecords.Columns.Add(stateColumn);
break;
case LogTypesEnum.ChannelMonitoringHistory:
gridLogRecords.KeyFieldName = "LogId";
GridViewDataDateColumn logDateColumn = new GridViewDataDateColumn();
logDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
logDateColumn.FieldName = "LogDate";
logDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
logDateColumn.VisibleIndex = 0;
gridLogRecords.Columns.Add(logDateColumn);
GridViewDataTextColumn statusColumn = new GridViewDataTextColumn();
statusColumn.Caption = Utilities.GetResourceString("Common", "LogStatus");
statusColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
statusColumn.VisibleIndex = 1;
gridLogRecords.Columns.Add(statusColumn);
break;
case LogTypesEnum.ProductImportHistory:
GridViewDataDateColumn impDateColumn = new GridViewDataDateColumn();
impDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
impDateColumn.FieldName = "LogDate";
impDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy HH:mm";
impDateColumn.VisibleIndex = 0;
gridLogRecords.Columns.Add(impDateColumn);
GridViewDataTextColumn userColumn = new GridViewDataTextColumn();
userColumn.Caption = Utilities.GetResourceString("Common", "FullName");
userColumn.FieldName = "FullName";
userColumn.VisibleIndex = 1;
gridLogRecords.Columns.Add(userColumn);
break;
case LogTypesEnum.RecommendedPriceHistory:
gridLogRecords.KeyFieldName = "LogId";
GridViewDataDateColumn recDateColumn = new GridViewDataDateColumn();
recDateColumn.Caption = Utilities.GetResourceString("Common", "LogDate");
recDateColumn.FieldName = "RecomDate";
recDateColumn.PropertiesDateEdit.DisplayFormatString = "dd.MM.yyyy";
recDateColumn.VisibleIndex = 0;
gridLogRecords.Columns.Add(recDateColumn);
GridViewDataTextColumn recUserColumn = new GridViewDataTextColumn();
recUserColumn.Caption = Utilities.GetResourceString("Common", "FullName");
recUserColumn.FieldName = "User.FullName";
recUserColumn.VisibleIndex = 1;
gridLogRecords.Columns.Add(recUserColumn);
GridViewDataTextColumn recTypeColumn = new GridViewDataTextColumn();
recTypeColumn.Caption = Utilities.GetResourceString("Common", "ChangeType");
recTypeColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
recTypeColumn.VisibleIndex = 2;
gridLogRecords.Columns.Add(recTypeColumn);
GridViewDataTextColumn recPriceColumn = new GridViewDataTextColumn();
recPriceColumn.Caption = Utilities.GetResourceString("Common", "NewPrice");
recPriceColumn.FieldName = "Price";
recPriceColumn.VisibleIndex = 3;
gridLogRecords.Columns.Add(recPriceColumn);
break;
case LogTypesEnum.ChannelLog:
gridLogRecords.KeyFieldName = "ErrorId";
GridViewDataTextColumn errorColumn = new GridViewDataTextColumn();
errorColumn.Caption = Utilities.GetResourceString("Common", "ErrorType");
errorColumn.FieldName = string.Format("Enum.Name{0}", SessionManager.CurrentShortLanguage);
errorColumn.VisibleIndex = 0;
gridLogRecords.Columns.Add(errorColumn);
GridViewDataTextColumn prodColumn = new GridViewDataTextColumn();
prodColumn.Caption = Utilities.GetResourceString("Common", "ProductName");
prodColumn.FieldName = "ProductName";
prodColumn.VisibleIndex = 1;
gridLogRecords.Columns.Add(prodColumn);
break;
}
}
