教程XAF使用视图Word文档格式.docx
- 文档编号:21214781
- 上传时间:2023-01-28
- 格式:DOCX
- 页数:10
- 大小:42.31KB
教程XAF使用视图Word文档格式.docx
《教程XAF使用视图Word文档格式.docx》由会员分享,可在线阅读,更多相关《教程XAF使用视图Word文档格式.docx(10页珍藏版)》请在冰豆网上搜索。
get{return_fLoan;
set{_fLoan=value;
计算起始日期"
publicDateTimeFDateBegin
get{return_fDateBegin;
set{_fDateBegin=value;
计算截止日期"
publicDateTimeFDateEnd
get{return_fDateEnd;
set{_fDateEnd=value;
备注"
),ModelDefault("
RowCount"
"
12"
publicstringFDescription
get{return_fDescription;
set{_fDescription=value;
审核状态"
AllowEdit"
false"
publicCheckStateFState
get{return_fState;
set{_fState=value;
[DevExpress.Xpo.Aggregated,Association("
TFee-TFeeEntrys"
[RuleRequiredField("
TFeeTFeeEntryRequried"
DefaultContexts.Save,"
结算项目必须输入!
"
publicXPCollection<
TFeeEntry>
TFeeEntry
get
returnGetCollection<
("
TFeeEntry"
);
publicoverridevoidAfterConstruction()
base.AfterConstruction();
FAccountingDate=System.DateTime.Today;
结算单分录"
publicclassTFeeEntry:
privatedecimal_fAmount;
privateTAuxiliaryInformation_fCategory;
publicTFeeEntry(Sessionsession)
[Association("
publicTFeeTFee{get;
set;
结算项目"
),DataSourceCriteria("
FType=1"
TFeeEntryFCategoryRequried"
publicTAuxiliaryInformationFCategory
get{return_fCategory;
set{_fCategory=value;
金额"
publicdecimalFAmount
get{return_fAmount;
set{_fAmount=value;
1.创建视图(SQL2008)
2./******Object:
View[dbo].[ViewFee]ScriptDate:
06/03/201317:
30:
40******/
3.SETANSI_NULLSON
4.GO
5.
6.SETQUOTED_IDENTIFIERON
7.GO
8.
9.CREATEVIEW[dbo].[ViewFee]
10.AS
11.SELECTdbo.TFee.FBillNo,dbo.TFee.FAccountingDate,dbo.TFee.FLoan,dbo.TFee.FDateBegin,dbo.TFee.FDateEnd,dbo.TFee.FDescription,dbo.TFee.FState,
12.dbo.TFeeEntry.FCategory,dbo.TFeeEntry.FAmount
13.FROMdbo.TFeeINNERJOIN
14.dbo.TFeeEntryONdbo.TFee.Oid=dbo.TFeeEntry.TFee
15.
16.GO
17.
18.EXECsys.sp_addextendedproperty@name=N'
MS_DiagramPane1'
@value=N'
[0E232FF0-B466-11cf-A24F-00AA00A3EFFF,1.00]
19.BeginDesignProperties=
20.BeginPaneConfigurations=
21.BeginPaneConfiguration=0
22.NumPanes=4
23.Configuration="
(H(1[41]4[20]2[10]3))"
24.End
25.BeginPaneConfiguration=1
26.NumPanes=3
27.Configuration="
(H(1[50]4[25]3))"
28.End
29.BeginPaneConfiguration=2
30.NumPanes=3
31.Configuration="
(H(1[50]2[25]3))"
32.End
33.BeginPaneConfiguration=3
34.NumPanes=3
35.Configuration="
(H(4[30]2[40]3))"
36.End
37.BeginPaneConfiguration=4
38.NumPanes=2
39.Configuration="
(H(1[56]3))"
40.End
41.BeginPaneConfiguration=5
42.NumPanes=2
43.Configuration="
(H(2[66]3))"
44.End
45.BeginPaneConfiguration=6
46.NumPanes=2
47.Configuration="
(H(4[50]3))"
48.End
49.BeginPaneConfiguration=7
50.NumPanes=1
51.Configuration="
(V(3))"
52.End
53.BeginPaneConfiguration=8
54.NumPanes=3
55.Configuration="
(H(1[56]4[18]2))"
56.End
57.BeginPaneConfiguration=9
58.NumPanes=2
59.Configuration="
(H(1[75]4))"
60.End
61.BeginPaneConfiguration=10
62.NumPanes=2
63.Configuration="
(H(1[66]2))"
64.End
65.BeginPaneConfiguration=11
66.NumPanes=2
67.Configuration="
(H(4[60]2))"
68.End
69.BeginPaneConfiguration=12
70.NumPanes=1
71.Configuration="
(H
(1))"
72.End
73.BeginPaneConfiguration=13
74.NumPanes=1
75.Configuration="
(V(4))"
76.End
77.BeginPaneConfiguration=14
78.NumPanes=1
79.Configuration="
(V
(2))"
80.End
81.ActivePaneConfig=0
82.End
83.BeginDiagramPane=
84.BeginOrigin=
85.Top=0
86.Left=0
87.End
88.BeginTables=
89.BeginTable="
TFee"
90.BeginExtent=
91.Top=6
92.Left=38
93.Bottom=125
94.Right=216
95.End
96.DisplayFlags=280
97.TopColumn=6
98.End
99.BeginTable="
100.BeginExtent=
101.Top=6
102.Left=254
103.Bottom=125
104.Right=432
105.End
106.DisplayFlags=280
107.TopColumn=0
108.End
109.End
110.End
111.BeginSQLPane=
112.End
113.BeginDataPane=
114.BeginParameterDefaults="
115.End
116.BeginColumnWidths=17
117.Width=284
118.Width=1500
119.Width=1500
120.Width=1500
121.Width=1500
122.Width=1500
123.Width=1500
124.Width=1500
125.Width=1500
126.Width=1500
127.Width=1500
128.Width=1500
129.Width=1500
130.Width=1500
131.Width=1500
132.Width=1500
133.Width=1500
134.End
135.End
136.BeginCriteriaPane=
137.BeginColumnWidths=11
138.Column=1440
139.Alias=900
140.Table=1170
141.Output=720
142.Append=1400
143.NewValue=1170
144.SortType=1350
145.SortOrder=1410
146.GroupBy=1350
147.Filter=1350
148.Or=1350
149.Or=1350
150.Or=1350
151.End
152.End
153.End
154.'
@level0type=N'
SCHEMA'
@level0name=N'
dbo'
@level1type=N'
VIEW'
@level1name=N'
ViewFee'
155.GO
156.EXECsys.sp_addextendedproperty@name=N'
MS_DiagramPaneCount'
@value=1,@level0type=N'
157.GO
158.
159.
3.使用结构
[Persistent("
ViewFee"
publicclassViewFee:
XPLiteObject
publicViewFee(Sessionsession)
[Key,Persistent,Browsable(false)]
publicCustomerReportsViewKeyKey;
publicdecimalFAmount{get{returnKey.FAmount;
}}
publicstringFBillNo{get{returnKey.FBillNo;
publicstructCustomerReportsViewKey
[Persistent("
FAmount"
),Browsable(false)]
publicdecimalFAmount;
FBillNo"
publicstringFBillNo;
}
4截图
未使用视图的明细情况:
使用视图结果如下:
(注:
可编辑下载,若有不当之处,请指正,谢谢!
)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 教程 XAF 使用 视图
![提示](https://static.bdocx.com/images/bang_tan.gif)