/// <summary> /// 查询某日的门诊日报 /// </summary> /// <param name="statTime"></param> /// <returns></returns> public ArrayList QueryByStatTime(DateTime statTime) { ArrayList list = null; string strSql = ""; if (this.Sql.GetSql("Case.OpbDayReport.SelectOpbDayReport", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, statTime.ToString()); try { //查询 this.ExecQuery(strSql); Neusoft.HISFC.Models.HealthRecord.DayReportRegister regDayReport = null; list = new ArrayList(); while (this.Reader.Read()) { regDayReport = new Neusoft.HISFC.Models.HealthRecord.DayReportRegister(); regDayReport.DateStat = statTime; regDayReport.Dept.ID = this.Reader[0].ToString(); //科室编码 regDayReport.Dept.Name = this.Reader[1].ToString(); //科室名称 regDayReport.ClinicNum = FrameWork.Function.NConvert.ToInt32(this.Reader[2]); //门诊人数 regDayReport.EmcNum = FrameWork.Function.NConvert.ToInt32(this.Reader[3]); //急诊人数 regDayReport.EmcDeadNum = FrameWork.Function.NConvert.ToInt32(this.Reader[4]); //急诊死亡人数 regDayReport.ObserveNum = FrameWork.Function.NConvert.ToInt32(this.Reader[5]); //观察人数 regDayReport.ObserveDeadNum = FrameWork.Function.NConvert.ToInt32(this.Reader[6]); //观察死亡人数 regDayReport.ReDiagnoseNum = FrameWork.Function.NConvert.ToInt32(this.Reader[7]); //复诊人数 regDayReport.ClcDiagnoseNum = FrameWork.Function.NConvert.ToInt32(this.Reader[8]); //会诊人数 regDayReport.SpecialNum = FrameWork.Function.NConvert.ToInt32(this.Reader[9]); //专家门诊人数 regDayReport.HosInsuranceNum = FrameWork.Function.NConvert.ToInt32(this.Reader[10]); //医保患者人数 regDayReport.BdCheckNum = FrameWork.Function.NConvert.ToInt32(this.Reader[11]); //体检/健康检查人数 regDayReport.Oper.ID = this.Reader[12].ToString(); //操作员编码 regDayReport.Oper.Name = this.Reader[13].ToString(); //操作员姓名 regDayReport.OperDate = FrameWork.Function.NConvert.ToDateTime(this.Reader[14]); //操作时间 list.Add(regDayReport); } return(list); } catch (Exception ex) { this.Err = ex.Message; return(null); } }
/// <summary> /// 得到数据表中的对象 /// </summary> /// <param name="dataTable"></param> /// <returns>对象集</returns> private ArrayList GetList(DataTable dataTable) { ArrayList arrayList = new ArrayList(); try { foreach (DataRow dtRow in dataTable.Rows) { Neusoft.HISFC.Models.HealthRecord.DayReportRegister regReport = new Neusoft.HISFC.Models.HealthRecord.DayReportRegister(); regReport.DateStat = DateTime.Parse(dtRow["DateStat"].ToString()); regReport.Dept.ID = dtRow["DeptCode"].ToString(); regReport.Dept.Name = dtRow["DeptName"].ToString(); regReport.ClinicNum = int.Parse(dtRow["ClinicNum"].ToString()); regReport.EmcNum = int.Parse(dtRow["EmcNum"].ToString()); regReport.EmcDeadNum = int.Parse(dtRow["EmcDeadNum"].ToString()); regReport.ObserveNum = int.Parse(dtRow["ObserveNum"].ToString()); regReport.ObserveDeadNum = int.Parse(dtRow["ObserveDeadNum"].ToString()); regReport.ReDiagnoseNum = int.Parse(dtRow["ReDiagnoseNum"].ToString()); regReport.ClcDiagnoseNum = int.Parse(dtRow["ClcDiagnoseNum"].ToString()); regReport.SpecialNum = int.Parse(dtRow["SpecialNum"].ToString()); regReport.HosInsuranceNum = int.Parse(dtRow["HosInsuranceNum"].ToString()); regReport.BdCheckNum = int.Parse(dtRow["BdCheckNum"].ToString()); regReport.Oper.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID; arrayList.Add(regReport); } } catch (Exception e) { MessageBox.Show("生成实体集合出错!" + e.Message, "提示"); return(null); } return(arrayList); }
/// <summary> /// 初始化表格 /// </summary> private void InitFrp(DateTime dateTime) { Neusoft.HISFC.BizLogic.HealthRecord.DayReportRegister dayReport = new Neusoft.HISFC.BizLogic.HealthRecord.DayReportRegister(); ArrayList al = new ArrayList(); Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("正在初始化表格,请稍候..."); Application.DoEvents(); al = dayReport.QueryByStatTime(dateTime); this.hasRecord = true; /*本段内容为默认初始化farpoint * if (al.Count == 0) * { * this.hasRecord = false; * al = dayReport.QueryAllDept(dateTime); * } * else * { * this.hasRecord = true; * } */ Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); //清空原有数据 this.dtDayReport.Rows.Clear(); Neusoft.HISFC.Models.HealthRecord.DayReportRegister regReport = new Neusoft.HISFC.Models.HealthRecord.DayReportRegister(); foreach (object obj in al) { regReport = obj as Neusoft.HISFC.Models.HealthRecord.DayReportRegister; this.dtDayReport.Rows.Add(new object[] { regReport.DateStat, regReport.Dept.ID, regReport.Dept.Name, regReport.ClinicNum, regReport.EmcNum, regReport.EmcDeadNum, regReport.ObserveNum, regReport.ObserveDeadNum, regReport.ReDiagnoseNum, regReport.ClcDiagnoseNum, regReport.SpecialNum, regReport.HosInsuranceNum, regReport.BdCheckNum }); } this.dtDayReport.AcceptChanges(); this.dvDayReport = this.dtDayReport.DefaultView; this.dvDayReport.AllowDelete = true; this.dvDayReport.AllowEdit = true; this.dvDayReport.AllowNew = true; this.neuSpread1_Sheet1.DataSource = this.dvDayReport; this.neuSpread1_Sheet1.DataMember = "DayReportRegister"; this.SetFpFormat(); }