public Neusoft.HISFC.Models.Base.Bed GetBedGradeByBedNo(string BedNo)
{
Neusoft.HISFC.Models.Base.Bed BedInfo = null;
string strSql = "";
if (this.Sql.GetSql("Fee.BedFeeItem.GetBedGradeByBedNo", ref strSql) == -1)
{
this.Err = this.Sql.Err;
return(null);
}
try
{
strSql = string.Format(strSql, BedNo);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(null);
}
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
BedInfo = new Neusoft.HISFC.Models.Base.Bed();
BedInfo.ID = Reader[0].ToString();
BedInfo.BedGrade.ID = Reader[1].ToString();
BedInfo.InpatientNO = Reader[2].ToString();
}
this.Reader.Close();
return(BedInfo);
}
/// <summary>
/// 显示床位列表
/// </summary>
public void ShowBedList()
{
this.lblShow.Text = "";
//取床位信息
#region {8ADDE7FC-0CF5-4e86-9B0A-41DFD058A400}
ArrayList al = new ArrayList();
if (this.bedtype.ToString() == "Wap" || this.bedtype.ToString() == "Unlock")
{
al = this.manager.QueryUnoccupiedBed(this.nurseCell.ID);
}
else if (this.bedtype.ToString() == "Hang" || this.bedtype.ToString() == "Change")
{
al = this.manager.QueryBedList(this.nurseCell.ID);
}
#endregion
if (al == null)
{
MessageBox.Show(this.manager.Err, "提示");
return;
}
//显示数据总行数
this.fpSpread1_Sheet1.Rows.Count = 0;
this.fpSpread1_Sheet1.Rows.Count = al.Count;
//逐行显示数据
Neusoft.HISFC.Models.Base.Bed bed = null;
for (int i = 0; i < al.Count; i++)
{
bed = al[i] as Neusoft.HISFC.Models.Base.Bed;
if (bed == null)
{
return;
}
//赋值
this.fpSpread1_Sheet1.Cells[i, 0].Value = bed.ID.Substring(4); //床号
this.fpSpread1_Sheet1.Cells[i, 1].Value = bed.SickRoom; //房间号
this.fpSpread1_Sheet1.Cells[i, 2].Value = bed.BedGrade.Name; //床位等级
this.fpSpread1_Sheet1.Cells[i, 3].Value = bed.BedRankEnumService.Name; //床位编制
this.fpSpread1_Sheet1.Cells[i, 4].Value = bed.Status.Name; //床位状态
this.fpSpread1_Sheet1.Cells[i, 5].Value = bed.InpatientNO == "N" ? "" : bed.InpatientNO.Substring(4); //住院号
this.fpSpread1_Sheet1.Cells[i, 6].Value = bed.Phone; //床位电话
this.fpSpread1_Sheet1.Cells[i, 7].Value = bed.OwnerPc; //归属
this.fpSpread1_Sheet1.Cells[i, 8].Value = bed.IsValid; //是否有效
this.fpSpread1_Sheet1.Cells[i, 9].Value = bed.IsPrepay; //是否预约
this.fpSpread1_Sheet1.Rows[i].Tag = bed;
}
//选中第一行
if (this.fpSpread1_Sheet1.RowCount > 0)
{
this.fpSpread1_Sheet1.ActiveRowIndex = 0;
}
this.fpSpread1.Focus();
}
/// <summary>
/// 克隆函数
/// </summary>
/// <returns></returns>
public new Bed Clone()
{
Bed bed = base.Clone() as Bed;
bed.Dept = this.Dept.Clone();
bed.NurseStation = this.NurseStation.Clone();
bed.BedGrade = this.BedGrade.Clone();
bed.AdmittingDoctor = this.AdmittingDoctor.Clone();
bed.AdmittingNurse = this.AdmittingNurse.Clone();
bed.Doctor = this.Doctor.Clone();
bed.AttendingDoctor = this.AttendingDoctor.Clone();
bed.ConsultingDoctor = this.ConsultingDoctor.Clone();
bed.Status = this.Status.Clone() as BedStatusEnumService;
return(bed);
}