/// <summary>
/// 登记一条预约挂号信息
/// </summary>
/// <param name="booking"></param>
/// <returns></returns>
public int Insert(Neusoft.HISFC.Models.Registration.Booking booking)
{
string sql = "";
if (this.Sql.GetSql("Registration.Booking.Insert", ref sql) == -1)
{
return(-1);
}
try
{
sql = string.Format(sql, booking.ID, booking.PID.CardNO, booking.DoctorInfo.SeeDate.ToString(), booking.DoctorInfo.Templet.Noon.ID,
booking.Name, booking.IDCard, booking.Sex.ID.ToString(), booking.Birthday.ToString(), booking.PhoneHome,
booking.AddressHome, booking.DoctorInfo.Templet.Dept.ID, booking.DoctorInfo.Templet.Dept.Name,
booking.DoctorInfo.Templet.Begin.ToString(), booking.DoctorInfo.Templet.End.ToString(),
booking.DoctorInfo.Templet.Doct.ID, booking.DoctorInfo.Templet.Doct.Name,
Neusoft.FrameWork.Function.NConvert.ToInt32(booking.IsSee),
booking.Oper.ID, booking.Oper.OperTime.ToString(), Neusoft.FrameWork.Function.NConvert.ToInt32(booking.DoctorInfo.Templet.IsAppend),
booking.DoctorInfo.Templet.ID, booking.DoctorInfo.Templet.RegLevel.ID, booking.DoctorInfo.Templet.RegLevel.Name);
}
catch (Exception e)
{
this.Err = "[Registration.Booking.Insert]格式不匹配!" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
return(this.ExecNoQuery(sql));
}
/// <summary>
/// 按sql查询
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public ArrayList QueryBase(string sql)
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
this.al = new ArrayList();
try
{
while (this.Reader.Read())
{
this.objBooking = new Neusoft.HISFC.Models.Registration.Booking();
this.objBooking.ID = this.Reader[0].ToString();
this.objBooking.PID.CardNO = this.Reader[1].ToString();
this.objBooking.DoctorInfo.SeeDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[2].ToString());
this.objBooking.DoctorInfo.Templet.Noon.ID = this.Reader[3].ToString();
this.objBooking.Name = this.Reader[4].ToString();
this.objBooking.IDCard = this.Reader[5].ToString();
this.objBooking.Sex.ID = this.Reader[6].ToString();
this.objBooking.Birthday = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[7].ToString());
this.objBooking.PhoneHome = this.Reader[8].ToString();
this.objBooking.AddressHome = this.Reader[9].ToString();
this.objBooking.DoctorInfo.Templet.Dept.ID = this.Reader[10].ToString();
this.objBooking.DoctorInfo.Templet.Dept.Name = this.Reader[11].ToString();
this.objBooking.DoctorInfo.Templet.Begin = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[12].ToString());
this.objBooking.DoctorInfo.Templet.End = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[13].ToString());
this.objBooking.DoctorInfo.Templet.Doct.ID = this.Reader[14].ToString();
this.objBooking.DoctorInfo.Templet.Doct.Name = this.Reader[15].ToString();
this.objBooking.IsSee = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[16].ToString());
this.objBooking.Oper.ID = this.Reader[17].ToString();
this.objBooking.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[18].ToString());
this.objBooking.DoctorInfo.Templet.IsAppend = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[19].ToString());
this.objBooking.DoctorInfo.Templet.ID = this.Reader[20].ToString();
this.objBooking.ConfirmOper.ID = this.Reader[21].ToString(); //确认人
if (!this.Reader.IsDBNull(22)) //确认时间
{
this.objBooking.ConfirmOper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[22].ToString());
}
if (!this.Reader.IsDBNull(23))//确认时间
{
this.objBooking.DoctorInfo.Templet.RegLevel.ID = this.Reader[23].ToString();
}
if (!this.Reader.IsDBNull(24))//确认时间
{
this.objBooking.DoctorInfo.Templet.RegLevel.Name = this.Reader[24].ToString();
}
this.al.Add(this.objBooking);
}
this.Reader.Close();
}
catch (Exception e)
{
this.Err = "查询患者预约挂号信息出错!" + e.Message;
this.ErrCode = e.Message;
return(null);
}
return(al);
}