/// <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();
}
