设置表头统一居中
//Near左对齐;Center居中对齐;Far右对齐;Default默认对齐
gvList.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
设置内容统一居中
gvList.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
设置某列内容居中
gvList.Columns["规格"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
循环设置多列内容居中
感谢<飞天凤凰601>的指点
for (int i = 0; i <= gvList.Columns.Count - 2; i++)//Count计数从1开始,Columns计数从0开始,故-1,备注不居中,故-2
{
gvList.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
循环设置指定列内容居中
感谢<贵阳老马马善福专业维修游泳池堵漏防水工程>的指点
string[] arr = { "序号", "日期", "单位", "进厂", "出厂", "票管员", "仓管员", "责任人" };
foreach(var i in arr)
{
gvList.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
所有列自动列宽
for (int i = 0; i < gvList.Columns.Count; i++)
{
gvList.BestFitColumns();
gvList.Columns[i].BestFit();
}
自动设置某列列宽
gvList.Columns["备注"].BestFit();
手动设置某列列宽
gvList.Columns["规格"].Width = 150;
页脚汇总
private void btnOK_Click_1(object sender, EventArgs e)
{
sql = "select pk_account,cSpecs 规格,dDate 日期,cWorkName 单位,cAccept 进厂,cFinish 出厂," +
"cTicketController 票管员,cPostLeader 岗长,cResponsible 责任人,cMemo 备注 " +
"from CM_ElectronicAccount where cAccountName = '结晶器铜管' ";
DataTable dt = m_cUser.GetTable(sql);
gcList.DataSource = dt;
gvList.OptionsView.ShowFooter = true;
gvList.Columns["进厂"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gvList.Columns["进厂"].SummaryItem.DisplayFormat = "{0}";
gvList.Columns["出厂"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gvList.Columns["出厂"].SummaryItem.DisplayFormat = "{0}";
}
合并单元格
gvList.OptionsView.AllowCellMerge = true;//合并所有列相邻行的相同单元格
gvList.Columns["日期"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;//指定某行无需合并