使用DX写系统的随手笔记（三）

下载 (14.74 KB)

2012-2-19 21:47

2. using System;
3. using System.Collections.Generic;
4. using System.ComponentModel;
5. using System.Windows.Forms;
6. using DevExpress.XtraGrid.Columns;
7. using DevExpress.XtraGrid.Views.Base;
8. using DevExpress.XtraGrid.Views.BandedGrid;
9. using DevExpress.XtraEditors.Repository;
11. namespace XtraGridDemo1
12. {
13. public partial class Form1 : DevExpress.XtraEditors.XtraForm
14. {
15. public Form1()
16. {
17. InitializeComponent();
19. //首先拖到窗体上一个GridControl，在表格上点击“Click here to change view”链接，在弹出菜单中选择“convert to”-->“AdvBandedGridView”。
21. InitGrid();
22. }
24. ///初始化表格
25. private void InitGrid()
26. {
28. // advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
29. BandedGridView view = advBandedGridView1 as BandedGridView;
31. view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
32. view.BeginDataUpdate(); //开始数据的编辑
34. view.Bands.Clear();
36. //修改附加选项
37. view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
38. view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
39. view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
40. view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
41. view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
42. view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
43. view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
44. view.OptionsCustomization.AllowGroup = false; //是否允许分组
45. view.OptionsCustomization.AllowFilter = false; //是否允许过滤
46. view.OptionsCustomization.AllowSort = true; //是否允许排序
47. view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
48. view.OptionsBehavior.Editable = true; //是否允许用户编辑单元格
50. //添加列标题
51. GridBand bandID = view.Bands.AddBand("ID");
52. bandID.Visible = false; //隐藏ID列
53. GridBand bandName = view.Bands.AddBand("姓名");
54. GridBand bandSex = view.Bands.AddBand("性别");
55. GridBand bandBirth = view.Bands.AddBand("出生日期");
56. GridBand bandScore = view.Bands.AddBand("分数");
57. GridBand bandMath = bandScore.Children.AddBand("数学");
58. GridBand bandChinese = bandScore.Children.AddBand("语文");
59. GridBand bandEnglish = bandScore.Children.AddBand("英语");
60. GridBand bandSubTotal = bandScore.Children.AddBand("小计");
61. GridBand bandRemark = view.Bands.AddBand("备注");
63. //列标题对齐方式
64. bandName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
65. bandSex.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
66. bandBirth.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
67. bandScore.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
68. bandMath.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
69. bandChinese.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
70. bandEnglish.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
71. bandSubTotal.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
72. bandRemark.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
74. //模拟几个数据
75. List<Record> listDataSource = new List<Record>();
76. listDataSource.Add(new Record(1, "张三","男",Convert.ToDateTime("1989-5-6") ,115.5f,101,96,""));
77. listDataSource.Add(new Record(2, "李四", "女", Convert.ToDateTime("1987-12-23"), 92, 85, 87, ""));
78. listDataSource.Add(new Record(3, "王五", "女", Convert.ToDateTime("1990-2-11"), 88, 69, 41.5f, ""));
79. listDataSource.Add(new Record(4, "赵六", "男", Convert.ToDateTime("1988-9-1"), 119, 108, 110, "备注行"));
80. //绑定数据源并显示
81. gridControl1.DataSource = listDataSource;
82. gridControl1.MainView.PopulateColumns();
84. //[小计]这一列因为没绑定数据源，所以需要手动添加
85. //(有点复杂，慢慢看吧)
86. string[] fieldNames = new string[] { "SubTotal" };
87. GridColumn column; //声明单列
88. column = view.Columns.AddField(fieldNames[0]); //添加一个数据字段
89. column.VisibleIndex = view.Columns.Count -1; //设置该列在编辑视图时的显示位置(倒数第二列)
90. column.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
91. column.OptionsColumn.AllowEdit = false; //此列不可编辑
92. column.Visible = true;
93. view.Columns.Add(column); //视图中添加一列
95. //绑定事件，当[分数]改变时[小计]也跟着变
96. //(好像只有在绑定事件里才能改变该单元格数值，直接修改无效)
97. view.CustomUnboundColumnData += new
98. DevExpress.XtraGrid.Views.Base.CustomColumnDataEventHandler(advBandedGridView1_CustomUnboundColumnData);
100. //[性别]列绑定ComboBox
101. RepositoryItemComboBox riCombo = new RepositoryItemComboBox();
102. riCombo.Items.AddRange(new string[] {"男", "女"});
103. gridControl1.RepositoryItems.Add(riCombo);
104. view.Columns["Sex"].ColumnEdit = riCombo;
106. //[出生年月]列绑定Date
107. RepositoryItemDateEdit riDate = new RepositoryItemDateEdit();
108. gridControl1.RepositoryItems.Add(riDate);
109. view.Columns["Birth"].ColumnEdit = riDate;
111. //[分数]列绑定SpinEdit
112. RepositoryItemSpinEdit riSpin = new RepositoryItemSpinEdit();
113. gridControl1.RepositoryItems.Add(riSpin);
114. view.Columns["Math"].ColumnEdit = riSpin;
115. view.Columns["Chinese"].ColumnEdit = riSpin;
116. view.Columns["English"].ColumnEdit = riSpin;
118. //[备注]列绑定MemoExEdit
119. RepositoryItemMemoExEdit riMemoEx = new RepositoryItemMemoExEdit();
120. gridControl1.RepositoryItems.Add(riMemoEx);
121. view.Columns["Remark"].ColumnEdit = riMemoEx;
123. //小计列添加汇总
124. view.OptionsView.ShowFooter = true; //显示表格页脚
125. view.Columns["SubTotal"].SummaryItem.FieldName = "SubTotal";
126. view.Columns["SubTotal"].SummaryItem.DisplayFormat = "{0:f2}";
127. view.Columns["SubTotal"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
129. //将标题列和数据列对应
130. view.Columns["ID"].OwnerBand = bandID;
131. view.Columns["Name"].OwnerBand = bandName;
132. view.Columns["Sex"].OwnerBand = bandSex;
133. view.Columns["Birth"].OwnerBand = bandBirth;
134. view.Columns["Math"].OwnerBand = bandMath;
135. view.Columns["Chinese"].OwnerBand = bandChinese;
136. view.Columns["English"].OwnerBand = bandEnglish;
137. view.Columns["SubTotal"].OwnerBand = bandSubTotal;
138. view.Columns["Remark"].OwnerBand = bandRemark;
140. view.EndDataUpdate();//结束数据的编辑
141. view.EndUpdate(); //结束视图的编辑
144. }
147. // 计算小计
148. private float calcSubTotal(float math, float chinese, float english)
149. {
150. return math + chinese + english;
151. }
153. private void advBandedGridView1_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)
154. {
155. ColumnView colView = sender as ColumnView;
156. if (e.Column.FieldName == "SubTotal" && e.IsGetData) e.Value = calcSubTotal(
157. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Math"])),
158. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Chinese"])),
159. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["English"])));
160. }
163. #region 运行时绑定到实现Ilist接口的数据源
165. public class Record
166. {
167. int id;
168. DateTime birth;
169. string name, sex, remark;
170. float math, chinese, english;
171. public Record(int id, string name, string sex, DateTime birth, float math, float chinese, float english, string remark)
172. {
173. this.id = id;
174. this.name = name;
175. this.sex = sex;
176. this.birth = birth;
177. this.math = math;
178. this.chinese = chinese;
179. this.english = english;
180. this.remark = remark;
181. }
182. public int ID { get { return id; } }
183. public string Name
184. {
185. get { return name; }
186. set { name = value; }
187. }
188. public string Sex
189. {
190. get { return sex; }
191. set { sex = value; }
192. }
193. public DateTime Birth
194. {
195. get { return birth; }
196. set { birth = value; }
197. }
198. public float Math
199. {
200. get { return math; }
201. set { math = value; }
202. }
203. public float Chinese
204. {
205. get { return chinese; }
206. set { chinese = value; }
207. }
208. public float English
209. {
210. get { return english; }
211. set { english = value; }
212. }
213. public string Remark
214. {
215. get { return remark; }
216. set { remark = value; }
217. }
219. }
221. #endregion
223. }
224. }

转载于:https://www.cnblogs.com/jlfood/archive/2012/02/29/2373239.html