WPF技术与初识报表

2010-08-03   10:30:52

运行环境：win7系统   vs2010   Oracle10g   PL/SQL

              已连接到服务器，你可以随便写几个字段连接数据库练习

第一步：写存储过程如下：                                  /*------------------------------------------------------ -- 文件功能描述： 人事基本資料簡要表操作。 -- 創建日期：20100721 -- 創建人：LHH -- 修改描述： ------------------------------------------------------*/ PROCEDURE P_EMP_INFO(V_LAN_ID number, V_COMNO varchar2, V_FACTNO varchar2, V_DEPT_BEG varchar2, V_DEPT_END varchar2, V_EMPNO varchar2, V_EMPNAME varchar2, V_EASYCODE varchar2, V_EMPNO_BEG varchar2, V_EMPNO_END varchar2, V_TIME_BEG date, V_TIME_END date, V_CUR out mytype) as MAX_DEPT varchar2(8); MAX_EMP_NO varchar(6); MIN_DEPT VARCHAR2(8);BEGIN SELECT MIN(D.DEPT_NO) INTO MIN_DEPT FROM EMP_DEPT D; SELECT max(D.DEPT_NO) INTO MAX_DEPT FROM EMP_DEPT D; SELECT MAX(E.EMP_NO) INTO MAX_EMP_NO FROM EMP E; OPEN V_CUR FOR select P.DEPT_NO || '--' || DD.DEPT_NAME AS DEPT_NO, P.DEPT_NO, DD.DEPT_NAME, F_EMP_ID(E.EMP_NO) AS EMP_NO, D.EMP_NAME, E.SEX, ecd.card_no, O.POST_NO, OD.POST_NAME, HIRED_DATE, MD.POSSTATUS_METHOD_NAMEfrom (SELECT * FROM EMP WHERE EMP_NO BETWEEN NVL(V_EMPNO_BEG, '000001') AND NVL(V_EMPNO_END, MAX_EMP_NO) or EMP_NO LIKE V_EMPNO_BEG || '%' AND EMP_NO LIKE V_EMPNO AND EASY_CODE LIKE V_EASYCODE AND HIRED_DATE BETWEEN V_TIME_BEG AND V_TIME_END) E, (SELECT * FROM EMP_DETAIL WHERE LANGUAGE_ID = V_LAN_ID) D, (SELECT * FROM EMP_DEPT WHERE DEPT_PID IN (SELECT DEPT_ID FROM EMP_DEPT D WHERE D.DEPT_NO LIKE V_FACTNO) AND (DEPT_NO BETWEEN NVL(V_DEPT_BEG, '%') ANDNVL(V_DEPT_END, MAX_DEPT) OR DEPT_NO LIKE V_DEPT_BEG || '%')) P, (SELECT * FROM EMP_DEPT_DETAIL WHERE LANGUAGE_ID = V_LAN_ID) DD, EMP_POST_DEPT PD, EMP_POST O, (SELECT * FROM EMP_POST_DETAIL WHERE LANGUAGE_ID = V_LAN_ID) OD, EMP_POSSTATUS_METHOD M, (SELECT * FROM EMP_POSSTATUS_METHOD_DETAIL WHERE LANGUAGE_ID = V_LAN_ID) MD, (SELECT * FROM EMP_COMPANY WHERE COMPANY_NO LIKE NVL(V_COMNO, '%')) C, (SELECT * FROM EMP_COMPANY_DETAIL WHERE LANGUAGE_ID = V_LAN_ID) CD, EMP_CARD ecd, EMP_CARD_DETAIL ecdd where E.EMP_ID = D.EMP_ID(+) AND E.DEPT_ID = P.DEPT_ID AND E.DEPT_POST_ID = PD.POST_DEPT_ID AND E.POSSTATUS_ID = M.POSSTATUS_METHOD_ID AND P.DEPT_ID = DD.DEPT_ID(+) AND P.DEPT_ID = PD.DEPT_ID AND P.COMPANY_ID = C.COMPANY_ID AND PD.POST_ID = O.POST_ID AND E.EMP_ID = ECD.EMP_ID AND ECD.CARD_ID = ECDD.CARD_ID AND PD.FLAG = 1 AND O.POST_ID = OD.POST_ID AND M.POSSTATUS_METHOD_ID = MD.POSSTATUS_METHOD_ID(+) AND C.COMPANY_ID = CD.COMPANY_ID(+) AND EMP_NAME LIKE V_EMPNAME ORDER BY E.EMP_NO; END P_EMP_INFO;

 

 第二步：写一个实体类：info 用于获取和设置字段的值

using System.Runtime.Serialization;

[DataContract]
    public class Info
    {
        #region   人事基础资料简报表 ：用于綁定字段,返回數據
        [DataMember]
        public System.String DEPT_NO//返回數據
        {
            get;
            set;
        }

        ........根据字段来写

第三步：界面代码

<UserControl xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:wf="clr-namespace:Microsoft.Reporting.WinForms;assembly=Microsoft.ReportViewer.WinForms" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" x:Class="HrSystem.STAFFING.Report.LHH.R_EMP_INFO" mc:Ignorable="d" d:DesignHeight="800" d:DesignWidth="900" xmlns:my="clr-namespace:HrSystem.STAFFING.Basic_Service"> <Grid> <Grid VerticalAlignment="Top" > <my:Basic_Condition_Control Height="125" Margin="5,0,0,0" x:Name="ctrl" VerticalAlignment="Top" /> </Grid> <WindowsFormsHost xmlns:my="clr-namespace:System.Windows.Forms.Integration;assembly=WindowsFormsIntegration" x:Name="windowsFormsHost1" VerticalAlignment="Stretch" HorizontalAlignment="Stretch" Margin="5,121,1,5" OverridesDefaultStyle="False" Grid.ColumnSpan="2"> <wf:ReportViewer Name="rp"/> </WindowsFormsHost> </Grid></UserControl>  

界面引用插件如下图功能：

第四步：报表服务

  1. 对应接口 和服务

                                                          自定义实体类方法                   插件实体类 、也可放多个实体类

 A.接口：   List<HrSystem.Entity.STAFFING.Info> GetV_EMP_INFO(ControlEntity rm)；

 

 B.服务： //人事基本资料简要报表
        public List<HrSystem.Entity.STAFFING.Info> GetV_EMP_INFO(ControlEntity rm)
        {
            string procname = "PKG_HR_LHH.P_EMP_INFO";
            OracleParameter[] ps = new OracleParameter[]
            {

                 new OracleParameter("V_LAN_ID",OracleType.Number){Value=rm.LANGUAGE_ID},
                 new OracleParameter("V_COMNO",OracleType.VarChar){Value=rm.COMPANY_NO_NAME},
                 new OracleParameter("V_FACTNO",OracleType.VarChar){Value=rm.FACT_NO_NAME},
                 new OracleParameter("V_DEPT_BEG",OracleType.VarChar){Value=rm.DEPT_NO_NAME_BEG},
                 new OracleParameter("V_DEPT_END",OracleType.VarChar){Value=rm.DEPT_NO_NAME_END},
                
                 new OracleParameter("V_EMPNO",OracleType.VarChar){Value=rm.EMP_NO},
                 new OracleParameter("V_EMPNAME",OracleType.VarChar){Value=rm.EMP_NAME},
                 new OracleParameter("V_EASYCODE",OracleType.VarChar){Value=rm.EASY_CODE},

                 new OracleParameter("V_EMPNO_BEG",OracleType.VarChar){Value=rm.EMP_NO_BEG},
                 new OracleParameter("V_EMPNO_END",OracleType.VarChar){Value=rm.EMP_NO_END},
                 new OracleParameter("V_TIME_BEG",OracleType.DateTime){Value=rm.TIME_BEG},
                 new OracleParameter("V_TIME_END",OracleType.DateTime){Value=rm.TIME_END},
                 new OracleParameter("V_CUR",OracleType.Cursor){Direction=System.Data.ParameterDirection.Output}
            };
            return DbAccess.SelectedToIList<Info>(procname, ps);
        }

第五步：人事基礎資料簡要表

 

 

 

第六步：具体的代码实现

public partial class R_EMP_INFO : UserControl { //decimal lanid = Hr_Login.LANGUAGE_ID; public R_EMP_INFO() { InitializeComponent(); ctrl.Handle = bt_sear_Click; } private void bt_sear_Click(ControlEntity CE) { try { Microsoft.Reporting.WinForms.ReportViewer rep = windowsFormsHost1.Child as Microsoft.Reporting.WinForms.ReportViewer; rep.LocalReport.ReportEmbeddedResource = "HrSystem.STAFFING.Report.LHH.RPT_EMP_INFO.rdlc"; rep.LocalReport.DataSources.Clear(); var handle = new STAFFINGService.STAFFINGServiceClient(); var result = handle.GetV_EMP_INFO(CE); rep.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", result)); handle.Close(); ReportParameter rpname = new ReportParameter("username", Hr_Login.user.LOGIN_NO == "" ? " " : Hr_Login.user.LOGIN_NO); ReportParameter rpcase = new ReportParameter("usercase", CE.REPORT_HEADER); rep.LocalReport.SetParameters(new ReportParameter[] { rpname }); rep.LocalReport.SetParameters(new ReportParameter[] { rpcase }); rep.RefreshReport(); } catch { MessageBox.Show("報表載入失敗"); } }