📄 - developer express xtragrid使用技巧 - 腾讯博客 - qzone.htm
字号:
//sda1.Fill(this.northwindDataSet.Orders);<BR>
SqlDataAdapter sda2 = new SqlDataAdapter("select * from [Order
Details]",con);<BR>
sda2.Fill(this.northwindDataSet.Order_Details);<BR>
}<BR><B><WBR>1.8
summary的用法</B><WBR><BR>
//If the GridOptionsView.ShowFooter option is set,
<BR>
//the summary(of course some else can ) can be displayed within the footer
cell.<BR>
gridView1.OptionsView.ShowFooter =
true;<BR>
//初始化,也可以不用指定<BR>
colOrderID.SummaryItem.FieldName =
"OrderID";<BR>
colOrderID.SummaryItem.SummaryType =
DevExpress.Data.SummaryItemType.Count;<BR><B><WBR>2.XtraGrid的打印</B><WBR><BR>借用别人写的一个类<BR>class
DevPrint<BR>
{<BR>
//*********************字段*********************<BR>
private string
pageHeaderName="";<BR>
private string
pageFooterName="";<BR>
private bool
isPrintPage=true;<BR>
private bool
isPrintDate=true;<BR>
private int
headerLocation=1;<BR>
private int
footerLocation=1;<BR>
private int
pageLocation=3;<BR>
private int
dateLocation=5;<BR>
private bool enableEditPage =
true;<BR> private
System.Drawing.Font pageHeaderFont =
null;<BR> private
System.Drawing.Font pageFooterFont =
null;<BR> private
System.Drawing.Printing.Margins devMargins =
null;<BR> private
System.Drawing.Printing.PaperKind devPaperKind =
System.Drawing.Printing.PaperKind.A4;//可以自定义修改纸张<BR>
private DevExpress.XtraPrinting.PageHeaderArea PHA = new
DevExpress.XtraPrinting.PageHeaderArea();<BR>
private DevExpress.XtraPrinting.PageFooterArea PFA = new
DevExpress.XtraPrinting.PageFooterArea();<BR>
//*********************字段*********************<BR><BR>
//*********************属性*********************<BR>
//标题<BR> public string
PageHeaderName<BR>
{<BR> get<BR> {<BR> return
pageHeaderName;<BR> }<BR> set
<BR> {<BR> pageHeaderName=value;<BR> }<BR>
}<BR> <BR>
//页脚<BR> public string
PageFooterName<BR>
{<BR> get<BR> {<BR> return
pageFooterName;<BR> }<BR> set<BR> {<BR> pageFooterName
=
value;<BR> }<BR>
}<BR>
//是否打印页数<BR> public bool
IsPrintPage<BR>
{<BR> get
<BR> {<BR> return
isPrintPage;<BR> }<BR> set<BR> {<BR> isPrintPage
=
value;<BR> }<BR>
}<BR><BR>
//是否打印时间<BR> public bool
IsPrintDate<BR>
{<BR> get<BR> {<BR> return
isPrintDate;<BR> }<BR> set<BR> {<BR> isPrintDate
=
value;<BR> }<BR>
}<BR>
//header的位置(左,中,右)<BR>
public int
HeaderLocation<BR>
{<BR> get<BR> {<BR> return
headerLocation;<BR> }<BR> set<BR> {<BR> headerLocation=value;<BR> }<BR>
}<BR>
//footer的位置(左,中,右)<BR>
public int
FooterLocation<BR>
{<BR> get<BR> {<BR> return
footerLocation;<BR> }<BR> set<BR> {<BR> footerLocation=value;<BR> }<BR>
}<BR><BR>
//页数的位置<BR> public int
PageLocation<BR>
{<BR> get<BR> {<BR> return
pageLocation;<BR> }<BR> set<BR> {<BR> pageLocation=value;<BR> }<BR>
}<BR><BR>
//时间的位置<BR> public int
DateLocation<BR>
{<BR> get<BR> {<BR> return
dateLocation;<BR> }<BR> set<BR> {<BR> dateLocation=value;<BR> }<BR>
}<BR>
<BR>
//是否允许编辑页面<BR> public bool
EnableEditPage<BR> {
<BR> get<BR> {<BR> return
enableEditPage;<BR> }<BR> set<BR> {<BR> enableEditPage
=
value;<BR> }<BR>
}<BR>
//标题字体<BR> public
System.Drawing.Font
PageHeaderFont<BR>
{<BR> get<BR> {<BR> return
pageHeaderFont;<BR> }<BR> set<BR> {<BR> pageHeaderFont
=
value;<BR> }<BR>
}<BR><BR>
//页脚字体<BR> public
System.Drawing.Font
PageFooterFont<BR>
{<BR> get<BR> {<BR> return
pageFooterFont;<BR> }<BR> set<BR> {<BR> pageFooterFont
=
value;<BR> }<BR>
}<BR><BR>
//页边距<BR> public
System.Drawing.Printing.Margins
DevMargins<BR>
{<BR> get<BR> {<BR> return
devMargins;<BR> }<BR> set<BR> {<BR> devMargins
=
value;<BR> }<BR>
}<BR><BR>
//纸张类型<BR> public
System.Drawing.Printing.PaperKind
DevPaperKind<BR>
{<BR> get<BR> {<BR> return
devPaperKind;<BR> }<BR> set<BR> {<BR> devPaperKind
=
value;<BR> }<BR>
}<BR>
//*********************字段*********************<BR><BR>
private void
PageHeaderFooterSettings()<BR>
{<BR>
PHA.Content.Clear();<BR>
PFA.Content.Clear();<BR>
string[] stringsPHA = new string[]
{"","",""};<BR>
string[] stringsPFA = new string[]
{"","",""};<BR>
switch(headerLocation)<BR>
{
<BR>
case
0:stringsPHA[0]=pageHeaderName;<BR> break;<BR>
case
1:stringsPHA[1]=pageHeaderName;<BR> break;<BR>
case
2:stringsPHA[2]=pageHeaderName;<BR> break;<BR>
default:stringsPHA[1]=pageHeaderName;<BR> break;<BR>
};<BR>
switch(footerLocation)<BR>
{<BR>
case
0:stringsPFA[0]=pageFooterName;<BR> break;<BR>
case
1:stringsPFA[1]=pageFooterName;<BR> break;<BR>
case
2:stringsPFA[2]=pageFooterName;<BR> break;<BR>
default:stringsPFA[1]=pageFooterName;<BR> break;<BR>
};<BR>
if
(isPrintPage)<BR>
{<BR>
switch(pageLocation)<BR>
{<BR> case
0:stringsPHA[0]=stringsPHA[0]+"[Page # of Pages
#]";<BR>
break;<BR> case
1:stringsPHA[1]=stringsPHA[1]+"[Page # of Pages
#]";<BR>
break;<BR> case
2:stringsPHA[2]=stringsPHA[2]+"[Page # of Pages
#]";<BR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -