예제 #1
0
        /// <summary>
        /// 执行sql语句,获取DataTable
        /// </summary>
        private DataTable GetDataTableBySql()
        {
            //执行sql语句
            if (string.IsNullOrEmpty(this.sqlId.Trim()))
            {
                return(null);
            }
            if (this.dtpFromDate.Value > this.dtpEndDate.Value)
            {
                MessageBox.Show("开始时间不能大于截止时间,请重新输入");
                return(null);
            }
            Neusoft.HISFC.BizLogic.Manager.Report reportMgr = new Neusoft.HISFC.BizLogic.Manager.Report();

            string[] parm = null;
            if (this.isHaveDept)
            {
                parm = new string[] { this.dtpFromDate.Value.ToString("yyyy-MM-dd HH:mm:ss"), this.dtpEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss"), this.cmbDept.Tag.ToString() };
            }
            else
            {
                parm = new string[] { this.dtpFromDate.Value.ToString("yyyy-MM-dd HH:mm:ss"), this.dtpEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss") };
            }

            DataSet ds = new DataSet();

            if (reportMgr.ExecQuery(this.sqlId, ref ds, parm) < 0)
            {
                MessageBox.Show("查询数据出错:" + reportMgr.Err);
                return(null);
            }
            return(ds.Tables[0]);
        }
예제 #2
0
        public int Query()
        {
            DateTime myBeginDate = this.dtpBeginDate.Value; //取开始时间

            DateTime myEndDate = this.dtpEndDate.Value;     //取结束时间


            //判断时间的有效性

            if (myEndDate.CompareTo(myBeginDate) < 0)
            {
                MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("终止时间必须大于起始时间"));
                return(-1);
            }

            this.lblTop.Text = Neusoft.FrameWork.Management.Language.Msg("统计时间:") + myBeginDate.ToString() + " - " + myEndDate.ToString();

            Neusoft.HISFC.BizLogic.Manager.Report report = new Neusoft.HISFC.BizLogic.Manager.Report();

            Neusoft.HISFC.BizLogic.Manager.Person ps  = new Neusoft.HISFC.BizLogic.Manager.Person();
            Neusoft.HISFC.Models.Base.Employee    var = new Neusoft.HISFC.Models.Base.Employee();
            var            = ps.GetPersonByID(ps.Operator.ID);
            this.myDataSet = new DataSet();
            int parm = report.ExecQuery(reportParm, ref this.myDataSet, myBeginDate.ToString(), myEndDate.ToString(), var.Dept.ID);

            if (parm == -1)
            {
                MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg(report.Err));
                return(-1);
            }

            //对farpoint绑定数据源

            this.myDataView = new DataView(myDataSet.Tables[0]);
            this.neuSpread1_Sheet1.DataSource = this.myDataView;

            //格式化 该函数不在起作用
            this.SetFormat();

            if (this.iIndex != null)
            {
                this.SetSum(this.iTextIndex, this.iIndex);
            }
            return(1);
        }
예제 #3
0
        /// <summary>
        /// 获取已经月结的操作时间列
        /// </summary>
        /// <returns></returns>
        private ArrayList QueryDateList()
        {
            string strSql = string.Empty;

            strSql = string.Format("select distinct(to_char(t.oper_date,'yyyymmdd')) from pha_com_ms_drug t ");

            Neusoft.HISFC.BizLogic.Manager.Report reportManager = new Neusoft.HISFC.BizLogic.Manager.Report();
            if (reportManager.ExecQuery(strSql) == -1)
            {
                MessageBox.Show("没有找到索引!");

                return(null);
            }
            ArrayList arrdayList = new ArrayList();
            string    strday     = string.Empty;

            Neusoft.HISFC.Models.Base.Const constObj = new Neusoft.HISFC.Models.Base.Const();

            try
            {
                while (reportManager.Reader.Read())
                {
                    constObj      = new Neusoft.HISFC.Models.Base.Const();
                    constObj.ID   = reportManager.Reader[0].ToString();
                    constObj.Name = reportManager.Reader[0].ToString();

                    arrdayList.Add(constObj);
                }

                reportManager.Reader.Close();

                return(arrdayList);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);

                if (!reportManager.Reader.IsClosed)
                {
                    reportManager.Reader.Close();
                }

                return(null);
            }
        }
예제 #4
0
        /// <summary>
        /// 执行sql语句,获取DataTable
        /// </summary>
        private DataTable GetDataTableBySql(string sql)
        {
            //执行sql语句
            if (string.IsNullOrEmpty(sql.Trim()))
            {
                return(null);
            }
            if (this.dtpFromDate.Value > this.dtpEndDate.Value)
            {
                MessageBox.Show("开始时间不能大于截止时间,请重新输入");
                return(null);
            }
            Neusoft.HISFC.BizLogic.Manager.Report reportMgr = new Neusoft.HISFC.BizLogic.Manager.Report();

            DataSet ds = new DataSet();

            if (reportMgr.ExecQuery(sql, ref ds, detailParm) < 0)
            {
                MessageBox.Show("查询数据出错:" + reportMgr.Err);
                return(null);
            }
            return(ds.Tables[0]);
        }
예제 #5
0
        /// <summary>
        /// 检索查询结果
        /// </summary>
        public virtual void Query()
        {
            // TODO:  添加 ucReportBase.Query 实现

            this.myBeginDate = this.dtpBeginDate.Value; //取开始时间
            this.myEndDate   = this.dtpEndDate.Value;   //取结束时间

            //判断时间的有效性
            if (this.myEndDate.CompareTo(this.myBeginDate) < 0)
            {
                MessageBox.Show("终止时间必须大于起始时间!", "提示");
                return;
            }

            this.lblTop.Text = "统计时间:" + this.myBeginDate.ToString() + " - " + this.myEndDate.ToString();
            this.lblTop.Text = "统计科室:" + this.cmbDept.Text + "               统计日期:"
                               //+ this.myBeginDate.ToString() + " - " + this.myEndDate.ToString();
                               + System.DateTime.Now.ToString("yyyy-MM-dd");

            Neusoft.HISFC.BizLogic.Manager.Report report = new Neusoft.HISFC.BizLogic.Manager.Report();
            //检索数据,返回dataset
            //this.myDataSet = report.Query(reportParm, this.myBeginDate, this.myEndDate);
            Neusoft.HISFC.BizLogic.Manager.Person ps  = new Neusoft.HISFC.BizLogic.Manager.Person();
            Neusoft.HISFC.Models.Base.Employee    var = new Neusoft.HISFC.Models.Base.Employee();// Neusoft.FrameWork.WinForms.BaseVar();
            var            = ps.GetPersonByID(ps.Operator.ID);
            this.myDataSet = new DataSet();

            try
            {
                if (this.cmbItem.Tag == null || this.cmbItem.Tag.ToString() == "" || this.cmbItem.SelectedIndex < 0)
                {
                    this.cmbItem.Tag = "ALL";
                }

                if (this.cmbDept.Tag == null || this.cmbItem.Tag == null)
                {
                    MessageBox.Show("请先选择好申请科室!");
                    return;
                }

                int parm = report.ExecQuery("Material.Report.GetApplyInfoHistory", ref this.myDataSet,
                                            this.cmbDept.Tag.ToString(), this.cmbItem.Tag.ToString(),
                                            this.dtpBeginDate.Value.ToString("yyyy-MM-dd HH:mm:ss"),
                                            this.dtpEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss"));
                if (parm == -1)
                {
                    MessageBox.Show(report.Err);
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //格式配置文件地址

            //对farpoint绑定数据源
            this.myDataView = new DataView(myDataSet.Tables[0]);
            this.neuSpread1_Sheet1.DataSource = this.myDataView;
            this.neuSpread1_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
            this.neuSpread1_Sheet1.RowHeader.DefaultStyle.BackColor    = System.Drawing.Color.White;
            this.neuSpread1_Sheet1.SheetCornerStyle.BackColor          = System.Drawing.Color.White;
            this.neuSpread1_Sheet1.GrayAreaBackColor = System.Drawing.Color.White;
            this.SetFormat();

            if (this.iIndex != null)
            {
                this.SetSum(this.iTextIndex, this.iIndex);
            }
        }