WPF技术与初识报表

最新推荐文章于 2021-06-26 19:23:54 发布

liuhehui721

最新推荐文章于 2021-06-26 19:23:54 发布

阅读量949

点赞数

分类专栏： C#和 asp.net之路文章标签：报表 wpf oracle10g date dataset class

本文链接：https://blog.csdn.net/liuhehui721/article/details/5784629

版权

C#和 asp.net之路专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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_NAME from (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, '%') AND NVL(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;
        }

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

第三步：界面代码

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

第四步：报表服务

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("報表載入失敗"); } }