public void CreateSizeGrid(DevExpress.XtraGrid.GridControl gridControl, BandedGridView gridView, DataTable dt)
{
//gridControl.Hide();
gridView.BeginDataUpdate();
try
{
bool flag = false;
gridView.OptionsView.ShowGroupPanel = false;
gridView.OptionsView.AllowCellMerge = true;
gridView.Columns.Clear();
gridView.Bands.Clear();
gridView.OptionsView.ShowColumnHeaders = false;
gridView.OptionsView.ColumnAutoWidth = false;
DevExpress.XtraGrid.Views.BandedGrid.GridBand[] band_parent = new DevExpress.XtraGrid.Views.BandedGrid.GridBand[dt.Columns.Count];
DevExpress.XtraGrid.Views.BandedGrid.GridBand[] band_child = new DevExpress.XtraGrid.Views.BandedGrid.GridBand[dt.Columns.Count - 2];
int i_arr = 0;
for (int i = 0; i < dt.Columns.Count; i++)
{
//if (i<=1)
//{
band_parent[i] = new GridBand()
{
Caption = dt.Columns[i].ColumnName.ToString()
};
gridView.Bands.Add(band_parent[i]);
band_parent[i].Columns.Add(new BandedGridColumn()
{
FieldName = dt.Columns[i].ColumnName.ToString(), Visible = true, Caption = band_parent[i].Caption
});
//}
// else
////{
// if (!flag)
// {
// band_parent[i] = new GridBand() { Caption = "COMPONENT INCOMING" };
// gridView.Bands.Add(band_parent[i]);
// band_parent[i].Children.Add(new GridBand() { Caption = dt.Columns[i].ColumnName.ToString() });
// band_parent[i].Children[i_arr].Columns.Add(new BandedGridColumn() { FieldName = dt.Columns[i].ColumnName.ToString(), Visible = true, Caption = dt.Columns[i].ColumnName.ToString() });
// i_arr++;
// band_parent[i].Children[0].RowCount = 2;
// flag = true;
// }
// else
// {
// band_parent[band_parent.Count() - 1].Children.Add(new GridBand() { Caption = dt.Columns[i].ColumnName.ToString() });
// band_parent[band_parent.Count() - 1].Children[i_arr].Columns.Add(new BandedGridColumn() { FieldName = dt.Columns[i].ColumnName.ToString(), Visible = true, Caption = dt.Columns[i].ColumnName.ToString() });
// i_arr++;
// }
////}
}
band_parent[0].RowCount = 2;
gridView.OptionsView.ColumnAutoWidth = false;
}
catch (Exception EX)
{
//throw EX;
}
gridView.EndDataUpdate();
gridView.ExpandAllGroups();
}
//初始化
public virtual void Initialize(BandedGridView view)
{
gridView = view;
if (gridView == null)
{
return;
}
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
InitGridView();
CreateGridBand();
CreateGridColumns();
view.Columns.AddRange(this.Columns);
//绑定列
BindingBandColumn();
dataTable = GetDataSource();
view.EndDataUpdate();
view.EndUpdate();
}
public static void RemoveDynamicBand(BandedGridView onThisView, BandOptions bandOptions)
{
if (onThisView == null)
{
throw new ArgumentException("View required");
}
if (bandOptions.BandIdentifier == null)
{
throw new ArgumentException("BandIdentifier required");
}
onThisView.BeginDataUpdate();
GridBand bandToDelete = null;
foreach (GridBand childBand in onThisView.Bands)
{
if (childBand.Tag != null)
{
var keyValue = childBand.Tag as string;
if (keyValue == bandOptions.BandIdentifier.Key)
{
bandToDelete = childBand;
break;
}
}
}
if (bandToDelete != null)
{
for (int i = bandToDelete.Columns.Count - 1; i >= 0; i--)
{
bandToDelete.Columns.RemoveAt(i);
}
onThisView.Bands.Remove(bandToDelete);
}
onThisView.EndDataUpdate();
}
///初始化表格
private void InitGrid()
{
// advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
BandedGridView view = advBandedGridView1 as BandedGridView;
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
//修改附加选项
view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
view.OptionsCustomization.AllowGroup = false; //是否允许分组
view.OptionsCustomization.AllowFilter = false; //是否允许过滤
view.OptionsCustomization.AllowSort = true; //是否允许排序
view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
view.OptionsBehavior.Editable = false; //是否允许用户编辑单元格
view.OptionsView.ColumnAutoWidth = true;
//添加列标题
GridBand bandID = view.Bands.AddBand("ID");
bandID.Visible = false; //隐藏ID列
GridBand bandName = view.Bands.AddBand("姓名");
GridBand bandSex = view.Bands.AddBand("性别");
GridBand bandBirth = view.Bands.AddBand("出生日期");
GridBand bandScore = view.Bands.AddBand("分数");
GridBand bandMath = bandScore.Children.AddBand("数学");
GridBand bandChinese = bandScore.Children.AddBand("语文");
GridBand bandEnglish = bandScore.Children.AddBand("英语");
//列标题对齐方式
bandName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSex.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandBirth.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandScore.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandMath.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandChinese.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandEnglish.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
////模拟几个数据
List <Record> listDataSource = new List <Record>();
listDataSource.Add(new Record(1, "张三", "男", Convert.ToDateTime("1989-5-6"), 115.5f, 101, 96, ""));
listDataSource.Add(new Record(2, "李四", "女", Convert.ToDateTime("1987-12-23"), 92, 85, 87, ""));
listDataSource.Add(new Record(3, "王五", "女", Convert.ToDateTime("1990-2-11"), 88, 69, 41.5f, ""));
listDataSource.Add(new Record(4, "赵六", "男", Convert.ToDateTime("1988-9-1"), 119, 108, 110, "备注行"));
//////绑定数据源并显示
gridControl1.DataSource = listDataSource;
gridControl1.MainView.PopulateColumns();
//将标题列和数据列对应
view.Columns["ID"].OwnerBand = bandID;
view.Columns["Name"].OwnerBand = bandName;
view.Columns["Sex"].OwnerBand = bandSex;
view.Columns["Birth"].OwnerBand = bandBirth;
view.Columns["Math"].OwnerBand = bandMath;
view.Columns["Chinese"].OwnerBand = bandChinese;
view.Columns["English"].OwnerBand = bandEnglish;
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
}
///初始化表格
private void InitGridData(List <QueryCafcModel> list)
{
// advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
BandedGridView view = advBandedGridView1 as BandedGridView;
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
//修改附加选项
view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
view.OptionsCustomization.AllowGroup = false; //是否允许分组
view.OptionsCustomization.AllowFilter = false; //是否允许过滤
view.OptionsCustomization.AllowSort = true; //是否允许排序
view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
view.OptionsBehavior.Editable = false; //是否允许用户编辑单元格
view.OptionsView.ColumnAutoWidth = true;
//添加列标题
GridBand bandID = view.Bands.AddBand("ID");
bandID.Visible = false; //隐藏ID列
GridBand bandYear = view.Bands.AddBand("年份");
GridBand bandN = view.Bands.AddBand("计入新能源核算结果");
GridBand bandN_SL = bandN.Children.AddBand("乘用车生产/进口量");
GridBand bandN_ZBZL = bandN.Children.AddBand("平均整备质量");
GridBand bandN_MBZ = bandN.Children.AddBand("目标值");
GridBand bandN_DBZ = bandN.Children.AddBand("达标值");
GridBand bandN_SJZ = bandN.Children.AddBand("实际值");
GridBand bandT = view.Bands.AddBand("不计新能源核算结果");
GridBand bandT_SL = bandT.Children.AddBand("乘用车生产/进口量");
GridBand bandT_ZBZL = bandT.Children.AddBand("平均整备质量");
GridBand bandT_MBZ = bandT.Children.AddBand("目标值");
GridBand bandT_DBZ = bandT.Children.AddBand("达标值");
GridBand bandT_SJZ = bandT.Children.AddBand("实际值");
GridBand bandS = view.Bands.AddBand("达标情况");
GridBand bandS_FLG = bandS.Children.AddBand("是否达标");
GridBand bandS_Value = bandS.Children.AddBand("实际值/达标值(%)");
GridBand bandS_Raing = bandS.Children.AddBand("排名");
#region
//列标题对齐方式
bandYear.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT_SL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT_ZBZL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT_MBZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT_DBZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandT_SJZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN_SL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN_ZBZL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN_MBZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN_DBZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandN_SJZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandS.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandS_FLG.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandS_Value.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandS_Raing.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//绑定数据源并显示
gridControl1.DataSource = list;
gridControl1.MainView.PopulateColumns();
#endregion
//将标题列和数据列对应
view.Columns["ID"].OwnerBand = bandID;
view.Columns["bandYear"].OwnerBand = bandYear;
view.Columns["bandT_SL"].OwnerBand = bandT_SL;
view.Columns["bandT_ZBZL"].OwnerBand = bandT_ZBZL;
view.Columns["bandT_MBZ"].OwnerBand = bandT_MBZ;
view.Columns["bandT_DBZ"].OwnerBand = bandT_DBZ;
view.Columns["bandT_SJZ"].OwnerBand = bandT_SJZ;
view.Columns["bandN_SL"].OwnerBand = bandN_SL;
view.Columns["bandN_ZBZL"].OwnerBand = bandN_ZBZL;
view.Columns["bandN_MBZ"].OwnerBand = bandN_MBZ;
view.Columns["bandN_DBZ"].OwnerBand = bandN_DBZ;
view.Columns["bandN_SJZ"].OwnerBand = bandN_SJZ;
view.Columns["bandS_FLG"].OwnerBand = bandS_FLG;
view.Columns["bandS_Value"].OwnerBand = bandS_Value;
view.Columns["bandS_Raing"].OwnerBand = bandS_Raing;
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
}
/// <summary>
/// 初始化表格
/// </summary>
private void InitGrid()
{
BandedGridView view = CafcbandedGridView as BandedGridView;
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
//修改附加选项
view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
view.OptionsCustomization.AllowGroup = false; //是否允许分组
view.OptionsCustomization.AllowFilter = true; //是否允许过滤
view.OptionsCustomization.AllowSort = true; //是否允许排序
view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
view.OptionsBehavior.Editable = false; //是否允许用户编辑单元格
view.OptionsView.ColumnAutoWidth = false; //是否显示水平滚动条
view.OptionsView.ShowFooter = true; //是否显示表底部
//view.OptionsView.AllowCellMerge = true;
//添加列标题
GridBand bandJbxx = view.Bands.AddBand("");
GridBand bandNO = bandJbxx.Children.AddBand("NO");
bandNO.MinWidth = 20;
GridBand bandTymc = bandJbxx.Children.AddBand("通用名称");
bandTymc.MinWidth = 60;
GridBand bandPfbz = bandJbxx.Children.AddBand("排放标准");
bandPfbz.MinWidth = 60;
GridBand bandClxh = bandJbxx.Children.AddBand("车辆型号");
bandClxh.MinWidth = 60;
GridBand bandPl = bandJbxx.Children.AddBand("排量");
bandPl.MinWidth = 60;
GridBand bandZczbzl = bandJbxx.Children.AddBand("整车整备质量");
bandZczbzl.MinWidth = 100;
GridBand bandScbl = bandJbxx.Children.AddBand("生产比例");
bandScbl.MinWidth = 60;
GridBand bandScl = bandJbxx.Children.AddBand("生产量");
bandScl.MinWidth = 60;
GridBand bandHj = bandJbxx.Children.AddBand("合计");
bandHj.MinWidth = 60;
GridBand bandDyk = bandJbxx.Children.AddBand("DYK油耗申报值(L/100km)");
bandDyk.MinWidth = 180;
GridBand bandSjdbzmbz = bandJbxx.Children.AddBand("4阶段标准目标值(L/100km)");
bandSjdbzmbz.MinWidth = 200;
GridBand bandDycxyhdcl = bandJbxx.Children.AddBand("单一车型油耗达成率");
bandDycxyhdcl.MinWidth = 150;
GridBand bandCAFC = view.Bands.AddBand("企业平均燃料消耗量(CAFC)(L/100km)");
bandCAFC.MinWidth = 160;
//bandCAFC.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandDykScl = bandCAFC.Children.AddBand("DYK申报值×生产量");
bandDykScl.MinWidth = 240;
GridBand bandDykValues = bandCAFC.Children.AddBand("6.3109");
bandDykValues.Caption = "";
GridBand bandTCafc = view.Bands.AddBand("企业平均燃料消耗量目标值(TCAFC)(L/100km)");
bandTCafc.MinWidth = 220;
//bandTCafc.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandTSum = bandTCafc.Children.AddBand("4阶段目标值×生产量");
bandTSum.MinWidth = 200;
GridBand bandTcafcValues = bandTCafc.Children.AddBand("4.9429");
bandTcafcValues.Caption = "";
GridBand bandZczbzlAvg = view.Bands.AddBand("企业平均整备质量(kg)");
bandZczbzlAvg.MinWidth = 220;
//bandZczbzlAvg.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandDykSum = bandZczbzlAvg.Children.AddBand("DYK申报值×生产量");
bandDykSum.MinWidth = 200;
GridBand bandDykSumValue = bandZczbzlAvg.Children.AddBand("1284.714");
bandDykSumValue.Caption = "";
#region //列标题对齐方式
bandJbxx.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandNO.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTymc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandPfbz.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandClxh.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandPl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandZczbzl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandScbl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandScl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandHj.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDyk.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSjdbzmbz.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDycxyhdcl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandCAFC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykScl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykValues.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTCafc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTSum.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTcafcValues.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandZczbzlAvg.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykSum.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykSumValue.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
#endregion
}
//初始化表格
private void InitGridCafcData()
{
// advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
BandedGridView view = CafcbandedGridView as BandedGridView;
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
//修改附加选项
view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
view.OptionsCustomization.AllowGroup = false; //是否允许分组
view.OptionsCustomization.AllowFilter = true; //是否允许过滤
view.OptionsCustomization.AllowSort = true; //是否允许排序
view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
view.OptionsBehavior.Editable = false; //是否允许用户编辑单元格
view.OptionsView.ColumnAutoWidth = false; //是否显示水平滚动条
view.OptionsView.ShowFooter = true; //是否显示表底部
//view.OptionsView.AllowCellMerge = true;
//添加列标题
GridBand bandJbxx = view.Bands.AddBand("");
GridBand bandNO = bandJbxx.Children.AddBand("NO");
bandNO.MinWidth = 20;
GridBand bandTymc = bandJbxx.Children.AddBand("通用名称");
bandTymc.MinWidth = 60;
GridBand bandPfbz = bandJbxx.Children.AddBand("排放标准");
bandPfbz.MinWidth = 60;
GridBand bandClxh = bandJbxx.Children.AddBand("车辆型号");
bandClxh.MinWidth = 60;
GridBand bandPl = bandJbxx.Children.AddBand("排量");
bandPl.MinWidth = 60;
GridBand bandZczbzl = bandJbxx.Children.AddBand("整车整备质量");
bandZczbzl.MinWidth = 100;
GridBand bandScbl = bandJbxx.Children.AddBand("生产比例");
bandScbl.MinWidth = 60;
GridBand bandScl = bandJbxx.Children.AddBand("生产量");
bandScl.MinWidth = 60;
GridBand bandHj = bandJbxx.Children.AddBand("合计");
bandHj.MinWidth = 60;
GridBand bandDyk = bandJbxx.Children.AddBand("DYK油耗申报值(L/100km)");
bandDyk.MinWidth = 180;
GridBand bandSjdbzmbz = bandJbxx.Children.AddBand("4阶段标准目标值(L/100km)");
bandSjdbzmbz.MinWidth = 200;
GridBand bandDycxyhdcl = bandJbxx.Children.AddBand("单一车型油耗达成率");
bandDycxyhdcl.MinWidth = 150;
GridBand bandCAFC = view.Bands.AddBand("企业平均燃料消耗量(CAFC)(L/100km)");
bandCAFC.MinWidth = 220;
//bandCAFC.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandDykScl = bandCAFC.Children.AddBand("DYK申报值×生产量");
bandDykScl.MinWidth = 200;
GridBand bandDykValues = bandCAFC.Children.AddBand("6.3109");
bandDykValues.Caption = "";
GridBand bandTCafc = view.Bands.AddBand("企业平均燃料消耗量目标值(TCAFC)(L/100km)");
bandTCafc.MinWidth = 220;
//bandTCafc.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandTSum = bandTCafc.Children.AddBand("4阶段目标值×生产量");
bandTSum.MinWidth = 200;
GridBand bandTcafcValues = bandTCafc.Children.AddBand("4.9429");
bandTcafcValues.Caption = "";
GridBand bandZczbzlAvg = view.Bands.AddBand("企业平均整备质量(kg)");
bandZczbzlAvg.MinWidth = 180;
//bandZczbzlAvg.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Right;
GridBand bandDykSum = bandZczbzlAvg.Children.AddBand("DYK申报值×生产量");
bandDykSum.MinWidth = 160;
GridBand bandDykSumValue = bandZczbzlAvg.Children.AddBand("1284.714");
bandDykSumValue.Caption = "";
#region //列标题对齐方式
bandJbxx.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandNO.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTymc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandPfbz.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandClxh.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandPl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandZczbzl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandScbl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandScl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandHj.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDyk.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSjdbzmbz.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDycxyhdcl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandCAFC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykScl.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykValues.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTCafc.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTSum.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandTcafcValues.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandZczbzlAvg.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykSum.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDykSumValue.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//绑定数据源并显示
DataTable dt = QueryCafcData(this.dtStartTime.Text, this.dtEndTime.Text, cbRllx.Text);
gridControl2.DataSource = null;
gridControl2.DataSource = dt;
gridControl2.MainView.PopulateColumns();
#endregion
#region //将标题列和数据列对应
view.Columns["NO"].OwnerBand = bandNO;
view.Columns["TYMC"].OwnerBand = bandTymc;
view.Columns["PFBZ"].OwnerBand = bandPfbz;
view.Columns["CLXH"].OwnerBand = bandClxh;
view.Columns["PL"].OwnerBand = bandPl;
view.Columns["ZCZBZL"].OwnerBand = bandZczbzl;
view.Columns["SCBL"].OwnerBand = bandScbl;
view.Columns["SCL"].OwnerBand = bandScl;
view.Columns["HJ"].OwnerBand = bandHj;
//bandHj.View.CellMerge += new DevExpress.XtraGrid.Views.Grid.CellMergeEventHandler(View_CellMerge);
view.Columns["ACT_ZHGKRLXHL"].OwnerBand = bandDyk;
view.Columns["TGT_ZHGKRLXHL"].OwnerBand = bandSjdbzmbz;
view.Columns["DYCXYHDCL"].OwnerBand = bandDycxyhdcl;
view.Columns["SUM_AVGCAFC"].OwnerBand = bandDykScl;
view.Columns["SUM_AVGCAFC_VALUES"].OwnerBand = bandDykValues;
view.Columns["SUM_TGTCAFC"].OwnerBand = bandTSum;
view.Columns["SUM_TGTCAFC_VALUES"].OwnerBand = bandTcafcValues;
view.Columns["SUM_ZCZBZL"].OwnerBand = bandDykSum;
view.Columns["SUM_ZCZBZL_VALUES"].OwnerBand = bandDykSumValue;
//汇总信息
view.Columns["SCL"].SummaryItem.FieldName = "SCL";
view.Columns["SCL"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
view.Columns["HJ"].SummaryItem.FieldName = "HJ";
view.Columns["HJ"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
view.Columns["SUM_AVGCAFC"].SummaryItem.FieldName = "SUM_AVGCAFC";
view.Columns["SUM_AVGCAFC"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
view.Columns["SUM_TGTCAFC"].SummaryItem.FieldName = "SUM_TGTCAFC";
view.Columns["SUM_TGTCAFC"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
view.Columns["SUM_ZCZBZL"].SummaryItem.FieldName = "SUM_ZCZBZL";
view.Columns["SUM_ZCZBZL"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//view.Columns["A_ZCZBZL"].SummaryItem.DisplayFormat = "总数：{0}";
//view.BestFitColumns();
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
#endregion
}
private void SetGridDataProperties()
{
lst_datacolumnIdIndex = new List <int>();
advBandedGridView1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
advBandedGridView1.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
advBandedGridView1.OptionsBehavior.EditorShowMode = DevExpress.Utils.EditorShowMode.Click;
advBandedGridView1.OptionsBehavior.Editable = false;
advBandedGridView1.OptionsMenu.EnableColumnMenu = false;
advBandedGridView1.OptionsCustomization.AllowFilter = false;
advBandedGridView1.OptionsView.ShowColumnHeaders = false;
advBandedGridView1.OptionsView.ColumnAutoWidth = true;
advBandedGridView1.IndicatorWidth = 27;
advBandedGridView1.OptionsView.ShowFooter = true;
////表头及行内容居中显示
advBandedGridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
advBandedGridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
BandedGridView view = advBandedGridView1 as BandedGridView;
view.BeginUpdate();
view.BeginDataUpdate();
view.Bands.Clear();
BandedGridColumn columnId = new BandedGridColumn();
columnId.Caption = "ID";
columnId.Name = "gridColumn0";
columnId.OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
columnId.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
columnId.OptionsColumn.AllowMove = false;
columnId.OptionsEditForm.StartNewRow = true;
columnId.OptionsFilter.AllowAutoFilter = false;
columnId.OptionsFilter.AllowFilter = false;
columnId.Visible = true;
columnId.VisibleIndex = 0;
columnId.Width = 40;
columnId.FieldName = "TerminalID";
GridBand bandID = view.Bands.AddBand("ID");
bandID.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandID.Columns.Add(columnId);
List <UniversalWayTypeEntity> lst_TypeWay_Parent = typeBll.GetConfigPointID("", TerType.UniversalTer);
if (lst_TypeWay_Parent != null)
{
int index = 0;
foreach (UniversalWayTypeEntity ParentNode in lst_TypeWay_Parent)
{
GridBand bandParent = view.Bands.AddBand(ParentNode.Name);
bandParent.Tag = ParentNode;
bandParent.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (ParentNode.HaveChild) //have child
{
List <UniversalWayTypeEntity> lst_TypeWay_Child = typeBll.Select("WHERE ParentID='" + ParentNode.ID + "' AND TerminalType='" + ((int)TerType.UniversalTer).ToString() + "' ORDER BY Sequence");
if (lst_TypeWay_Child != null)
{
foreach (UniversalWayTypeEntity ChildNode in lst_TypeWay_Child)
{
index++;
GridBand bandChild = bandParent.Children.AddBand(ChildNode.Name);
bandChild.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
BandedGridColumn column_child = new BandedGridColumn();
column_child.Caption = ParentNode.Name;
column_child.Name = "gridColumn" + index;
column_child.OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
column_child.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
column_child.OptionsColumn.AllowMove = false;
column_child.OptionsEditForm.StartNewRow = true;
column_child.OptionsFilter.AllowAutoFilter = false;
column_child.OptionsFilter.AllowFilter = false;
column_child.Visible = true;
column_child.VisibleIndex = index - 1;
column_child.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column_child.FieldName = "column" + index;
column_child.Tag = ChildNode;
bandChild.Columns.Add(column_child);
GridBand bandUnit = bandChild.Children.AddBand(ChildNode.Unit);
bandUnit.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (!lst_datacolumnIdIndex.Contains(ChildNode.ID))
{
lst_datacolumnIdIndex.Add(ChildNode.ID);
}
}
}
}
else //alone
{
index++;
BandedGridColumn column_parent = new BandedGridColumn();
column_parent.Caption = ParentNode.Name;
column_parent.Name = "gridColumn" + index;
column_parent.OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
column_parent.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
column_parent.OptionsColumn.AllowMove = false;
column_parent.OptionsEditForm.StartNewRow = true;
column_parent.OptionsFilter.AllowAutoFilter = false;
column_parent.OptionsFilter.AllowFilter = false;
column_parent.Visible = true;
column_parent.VisibleIndex = index - 1;
column_parent.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
column_parent.FieldName = "column" + index;
column_parent.Tag = ParentNode;
bandParent.Columns.Add(column_parent);
GridBand bandUnit = bandParent.Children.AddBand(ParentNode.Unit);
bandUnit.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (!lst_datacolumnIdIndex.Contains(ParentNode.ID))
{
lst_datacolumnIdIndex.Add(ParentNode.ID);
}
}
}
}
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
}
private void InitGrid(DataTable dt)
{
BandedGridView view = advBandedGridView1 as BandedGridView;
//advBandedGridView1.BestFitColumns();
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
view.OptionsView.ColumnAutoWidth = true;
//view.BestFitColumns();
//修改附加选项
view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
view.OptionsCustomization.AllowColumnResizing = true; //是否允许调整列宽
view.OptionsCustomization.AllowGroup = false; //是否允许分组
view.OptionsCustomization.AllowFilter = true; //是否允许过滤
view.OptionsCustomization.AllowSort = true; //是否允许排序
view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
// view.OptionsBehavior.Editable = false; //是否允许用户编辑单元格
view.OptionsView.ColumnAutoWidth = false; //是否显示水平滚动条
view.OptionsView.ShowFooter = false; //是否显示表底部
view.OptionsView.AllowCellMerge = true;
GridBand bandCheck = view.Bands.AddBand("选择");
// bandCheck.MinWidth = 10;
bandCheck.Width = 30;
GridBand bandCLXH = view.Bands.AddBand("车辆型号");
bandCLXH.MinWidth = 50;
GridBand bandCSLY = view.Bands.AddBand("参数来源");
bandCSLY.MinWidth = 30;
//GridBand bandCPH = view.Bands.AddBand("配置号ID");
//bandCPH.MinWidth = 75;
GridBand bandGGPC = view.Bands.AddBand("公告批次");
bandGGPC.MinWidth = 100;
GridBand bandDCZ = view.Bands.AddBand("电池组（或超级电容）");
GridBand bandDCZDTXH = bandDCZ.Children.AddBand("单体型号");
bandDCZDTXH.MinWidth = 30;
GridBand bandDCZDTSCQY = bandDCZ.Children.AddBand("单体生产企业");
bandDCZDTSCQY.MinWidth = 120;
GridBand bandDCZCXXH = bandDCZ.Children.AddBand("成箱型号");
bandDCZCXXH.MinWidth = 30;
GridBand bandDCZZNL = bandDCZ.Children.AddBand("电池组总能量（kWh）");
bandDCZZNL.MinWidth = 150;
GridBand bandDCZSCQY = bandDCZ.Children.AddBand("电池组生产企业");
bandDCZSCQY.MinWidth = 120;
GridBand bandQDDJ = view.Bands.AddBand("驱动电机");
GridBand bandQDDJXH = bandQDDJ.Children.AddBand("型号");
bandQDDJXH.MinWidth = 30;
GridBand bandQDDJEDGL = bandQDDJ.Children.AddBand("额定功率(kW)");
bandQDDJEDGL.MinWidth = 100;
GridBand bandQDDJSCQY = bandQDDJ.Children.AddBand("生产企业");
bandQDDJSCQY.MinWidth = 30;
GridBand bandRLDC = view.Bands.AddBand("燃料电池");
GridBand bandRLDCXH = bandRLDC.Children.AddBand("型号");
bandRLDCXH.MinWidth = 30;
GridBand bandRLDCEDGL = bandRLDC.Children.AddBand("额定功率(kW)");
bandRLDCEDGL.MinWidth = 100;
GridBand bandRLDCSCQY = bandRLDC.Children.AddBand("生产企业");
bandRLDCSCQY.MinWidth = 30;
bandCheck.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandCLXH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandCSLY.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//bandCPH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandGGPC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZDTXH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZDTSCQY.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZCXXH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZZNL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandDCZSCQY.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandQDDJ.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandQDDJXH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandQDDJEDGL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandQDDJSCQY.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandRLDC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandRLDCXH.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandRLDCEDGL.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandRLDCSCQY.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dt.Columns.Add("check", System.Type.GetType("System.Boolean"));
dt.Columns["check"].ReadOnly = false;
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["check"] = false;
}
gridControl1.DataSource = null;
gridControl1.DataSource = dt;
gridControl1.MainView.PopulateColumns();
view.Columns["MODEL_VEHICLE"].OptionsColumn.ReadOnly = true;
view.Columns["DATASOURCE"].OptionsColumn.ReadOnly = true;
view.Columns["DATASOURCE"].OptionsColumn.AllowEdit = false;
//view.Columns["CONFIG_ID"].OptionsColumn.ReadOnly = true;
//view.Columns["CONFIG_ID"].Visible = false;
view.Columns["BATCH"].OptionsColumn.ReadOnly = true;
view.Columns["MODEL_SINGLE"].OptionsColumn.ReadOnly = true;
view.Columns["MFRS_SINGLE"].OptionsColumn.ReadOnly = true;
view.Columns["MODEL_WHOLE"].OptionsColumn.ReadOnly = true;
view.Columns["CAPACITY_BAT"].OptionsColumn.ReadOnly = true;
view.Columns["MFRS_BAT"].OptionsColumn.ReadOnly = true;
view.Columns["MODEL_DRIVE"].OptionsColumn.ReadOnly = true;
view.Columns["RATEPOW_DRIVE"].OptionsColumn.ReadOnly = true;
view.Columns["MFRS_DRIVE"].OptionsColumn.ReadOnly = true;
view.Columns["MDEL_FUEL"].OptionsColumn.ReadOnly = true;
view.Columns["RATEPOW_FUEL"].OptionsColumn.ReadOnly = true;
view.Columns["MFRS_FUEL"].OptionsColumn.ReadOnly = true;
view.Columns["check"].OwnerBand = bandCheck;
view.Columns["MODEL_VEHICLE"].OwnerBand = bandCLXH;
view.Columns["DATASOURCE"].OwnerBand = bandCSLY;
//view.Columns["CONFIG_ID"].OwnerBand = bandCPH;
//view.Columns["CONFIG_ID"].VisibleIndex = -1;
view.Columns["BATCH"].OwnerBand = bandGGPC;
view.Columns["MODEL_SINGLE"].OwnerBand = bandDCZDTXH;
view.Columns["MFRS_SINGLE"].OwnerBand = bandDCZDTSCQY;
view.Columns["MODEL_WHOLE"].OwnerBand = bandDCZCXXH;
view.Columns["CAPACITY_BAT"].OwnerBand = bandDCZZNL;
view.Columns["MFRS_BAT"].OwnerBand = bandDCZSCQY;
view.Columns["MODEL_DRIVE"].OwnerBand = bandQDDJXH;
view.Columns["RATEPOW_DRIVE"].OwnerBand = bandQDDJEDGL;
view.Columns["MFRS_DRIVE"].OwnerBand = bandQDDJSCQY;
view.Columns["MDEL_FUEL"].OwnerBand = bandRLDCXH;
view.Columns["RATEPOW_FUEL"].OwnerBand = bandRLDCEDGL;
view.Columns["MFRS_FUEL"].OwnerBand = bandRLDCSCQY;
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
/* int[] siz = new int[advBandedGridView1.Columns.Count];
* int z = 0*/
/* foreach (DevExpress.XtraGrid.Columns.GridColumn dc in advBandedGridView1.Columns)
* {
* dc.OptionsColumn.
* }*/
}
void initGantt(List <TaskTree> tasktree, DateTime[] projectDate)
{
BandedGridView view = advBandedGridView1 as BandedGridView;
view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
view.BeginDataUpdate(); //开始数据的编辑
view.Bands.Clear();
DateTime start = new DateTime(2013, 12, 10);
DateTime end = new DateTime(2014, 5, 2);
GridBand gridBand = view.Bands.AddBand(start.ToString("yy-MM-dd"));
gridBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
int days = (end - start).Days;
string Day = "日一二三四五六";
CustomAxisLabel[] customaxislabels = new CustomAxisLabel[days + 1];
customaxislabels[0] = new CustomAxisLabel(start.ToString("yy-MM-dd"), start);
for (int i = 0; i <= days + 1; i++)
{
try
{
CustomAxisLabel cal = new CustomAxisLabel();
cal.AxisValue = start;
cal.Name = start.ToString("yy-MM-dd");
customaxislabels[i + 1] = cal;
if (start.DayOfWeek == DayOfWeek.Monday)
{
gridBand = view.Bands.AddBand(start.ToString("yyyy-MM-dd"));
gridBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
GridBand childen = gridBand.Children.AddBand(Day[(int)start.DayOfWeek] + "");
childen.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
childen.Width = 24;
start = start.AddDays(1);
}
catch { }
}
gcGanttDate.Width = days * 24 + 2;
view.EndDataUpdate(); //结束数据的编辑
view.EndUpdate(); //结束视图的编辑
//设置甘特图属性
ccProjectGantt.Width = gcGanttDate.Width;
//chartControl1.Height = 4 * 24;
ganttDiagram1.AxisX.Visible = false;
ganttDiagram1.AxisY.CustomLabels.AddRange(customaxislabels);
ConstantLine progress = new ConstantLine("当前进度", DateTime.Now);
progress.Color = Color.Red;
ganttDiagram1.AxisY.ConstantLines.Add(progress);
ganttDiagram1.AxisY.Range.MinValueInternal = 0;
ganttDiagram1.AxisY.Range.MaxValueInternal = days * 24;
ganttDiagram1.AxisY.Visible = false;
series1.Points.Add(new SeriesPoint("项目进度", new DateTime[] { new DateTime(2013, 12, 12, 0, 0, 0), new DateTime(2014, 4, 30) }));
SeriesPoint sp = new SeriesPoint();
series2.Points.Add(new SeriesPoint("产品进度", new DateTime[] { new DateTime(2013, 12, 12), new DateTime(2014, 1, 12) }));
series2.Points.Add(new SeriesPoint("Task 2", new DateTime[] { new DateTime(2014, 1, 13), new DateTime(2014, 2, 28) }));
series2.Points.Add(new SeriesPoint("Task 3", new DateTime[] { new DateTime(2014, 3, 1), new DateTime(2014, 3, 30) }));
series2.Points.Add(new SeriesPoint("Task 4", new DateTime[] { new DateTime(2014, 4, 1), new DateTime(2014, 4, 30) }));
series2.Points[2].Relations.Add(series2.Points[1]);
series3.Points.Add(new SeriesPoint("产品进度", new DateTime[] { new DateTime(2013, 12, 12), new DateTime(2014, 1, 12) }));
series3.Points.Add(new SeriesPoint("Task 2", new DateTime[] { new DateTime(2014, 1, 13), new DateTime(2014, 2, 28) }));
series3.Points.Add(new SeriesPoint("Task 3", new DateTime[] { new DateTime(2014, 3, 1), new DateTime(2014, 3, 4) }));
series4.Points.Add(new SeriesPoint("Task 3", new DateTime[] { new DateTime(2014, 3, 4), DateTime.Now }));
}
