001.
1
using
System;
002.
2
using
System.Data;
003.
3
using
System.Data.SqlClient;
004.
4
using
System.Web.Configuration;
005.
5
using
System.Configuration;
006.
6
using
System.Web;
007.
7
using
System.Web.Security;
008.
8
using
System.Web.UI;
009.
9
using
System.Web.UI.WebControls;
010.
10
using
System.Web.UI.WebControls.WebParts;
011.
11
using
System.Web.UI.HtmlControls;
012.
12
using
CrystalDecisions.CrystalReports.Engine;
013.
13
using
CrystalDecisions.Shared;
014.
14
using
dsShippingSummByProductTableAdapters;
015.
15
016.
16
public
partial
class
Admin_AdminCrShippingSummByProduct : System.Web.UI.Page
017.
17 {
018.
18
string
fDate;
019.
19
string
tDate;
020.
20
string
viewBy;
021.
21
string
fullName;
022.
22 ReportDocument report =
new
ReportDocument();
023.
23 ParameterFields pfields =
new
ParameterFields();
024.
24
025.
25
protected
void
Page_Load(
object
sender, EventArgs e)
026.
26 {
027.
27 fDate = Session[
"FDATE"
].ToString();
028.
28 tDate = Session[
"TDATE"
].ToString();
029.
29 viewBy = Session[
"VIEWBY"
].ToString();
030.
30
031.
31
string
staffID =
"0000000001"
;
032.
32 Session[
"staffID"
] = staffID;
033.
33 Session[
"StaffID"
] = Session[
"staffID"
];
034.
34
035.
35
string
strConn =
"Data Source=MIXAR-PC;Initial Catalog=StockProductInfo;Integrated Security=True"
;
036.
36
037.
37 SqlConnection Conn =
new
SqlConnection(strConn);
038.
38
if
(Conn.State == ConnectionState.Open)
039.
39 {
040.
40 Conn.Close();
041.
41 }
042.
42 Conn.ConnectionString = strConn;
043.
43 Conn.Open();
044.
44
045.
45
string
sqlStaffName =
"select Staff_FName, Staff_LName "
;
046.
46 sqlStaffName +=
"from masStaff "
;
047.
47 sqlStaffName +=
"where Staff_ID = "
+ Session[
"StaffID"
].ToString();
048.
48
049.
49 SqlDataAdapter daStaff =
new
SqlDataAdapter(sqlStaffName, Conn);
050.
50 DataSet dsStaff =
new
DataSet();
051.
51 daStaff.Fill(dsStaff,
"Staff"
);
052.
52
053.
53
string
fName = dsStaff.Tables[
"Staff"
].Rows[0][
"Staff_FName"
].ToString();
054.
54
string
lName = dsStaff.Tables[
"Staff"
].Rows[0][
"Staff_LName"
].ToString();
055.
55 fullName = fName +
" "
+ lName;
056.
56
057.
57 ParameterField pfieldFDATE =
new
ParameterField();
058.
58 ParameterDiscreteValue disValFDATE =
new
ParameterDiscreteValue();
059.
59 disValFDATE.Value = DateTime.Parse(fDate);
060.
60 pfieldFDATE.Name =
"FDate"
;
061.
61 pfieldFDATE.CurrentValues.Add(disValFDATE);
062.
62
063.
63 ParameterField pfieldTDATE =
new
ParameterField();
064.
64 ParameterDiscreteValue disValTDATE =
new
ParameterDiscreteValue();
065.
65 disValTDATE.Value = DateTime.Parse(tDate);
066.
66 pfieldTDATE.Name =
"TDate"
;
067.
67 pfieldTDATE.CurrentValues.Add(disValTDATE);
068.
68
069.
69 ParameterField pfieldVIEWBY =
new
ParameterField();
070.
70 ParameterDiscreteValue disValVIEWBY =
new
ParameterDiscreteValue();
071.
71 disValVIEWBY.Value = viewBy;
072.
72 pfieldVIEWBY.Name =
"ViewBy"
;
073.
73 pfieldVIEWBY.CurrentValues.Add(disValVIEWBY);
074.
74
075.
75 ParameterField pfieldSTAFF =
new
ParameterField();
076.
76 ParameterDiscreteValue disValSTAFF =
new
ParameterDiscreteValue();
077.
77 disValSTAFF.Value = fullName;
078.
78 pfieldSTAFF.Name =
"StaffName"
;
079.
79 pfieldSTAFF.CurrentValues.Add(disValSTAFF);
080.
80
081.
81 pfields.Add(pfieldFDATE);
082.
82 pfields.Add(pfieldTDATE);
083.
83 pfields.Add(pfieldVIEWBY);
084.
84 pfields.Add(pfieldSTAFF);
085.
85
086.
86 CrystalReportViewer1.ParameterFieldInfo = pfields;
087.
87
088.
88 crvBinding();
089.
89 }
090.
90
private
void
crvBinding()
091.
91 {
092.
92 report.Load(Server.MapPath(
"../SalesReport/ShippingSummByProductReport.rpt"
));
093.
93
094.
94 SPShipSummByProductTableAdapter adapter =
new
SPShipSummByProductTableAdapter();
095.
95 CrystalReportManager crManager =
new
CrystalReportManager(report, adapter.GetData(fDate,tDate));
096.
96
097.
97 CrystalReportViewer1.ReportSource = crManager.Report;
098.
98 CrystalReportViewer1.Visible =
true
;
099.
99 }
100.
100
protected
void
CrystalReportViewer1_ViewZoom(
object
source, CrystalDecisions.Web.ZoomEventArgs e)
101.
101 {
102.
102 crvBinding();
103.
103 }
104.
104
protected
void
CrystalReportViewer1_Search(
object
source, CrystalDecisions.Web.SearchEventArgs e)
105.
105 {
106.
106 crvBinding();
107.
107 }
108.
108
protected
void
CrystalReportViewer1_Navigate(
object
source, CrystalDecisions.Web.NavigateEventArgs e)
109.
109 {
110.
110 crvBinding();
111.
111 }
112.
112 }
113.
113