/// <summary>
/// 插入科室出诊表记录
/// </summary>
/// <param name="schema"></param>
/// <returns></returns>
public int Insert(Neusoft.HISFC.Models.Registration.DeptSchema schema)
{
string sql = "";
if (this.Sql.GetSql("Registration.DeptSchema.Insert", ref sql) == -1)
{
return(-1);
}
try
{
sql = string.Format(sql, schema.ID, schema.SeeDate.ToString(), schema.Week, schema.NoonID,
schema.Dept.ID, schema.Dept.Name, schema.RegLevel, schema.RegLimit,
schema.PreRegLimit, Neusoft.FrameWork.Function.NConvert.ToInt32(schema.IsValid), schema.StopReason.ID, schema.StopReason.Name,
schema.StopID, schema.StopDate.ToString(), schema.Memo, schema.OperID);
return(this.ExecNoQuery(sql));
}
catch (Exception e)
{
this.Err = "插入专科出诊信息表出错!" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
}
/// <summary>
/// 按sql查询排班信息
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
private ArrayList QuerySchema(string sql)
{
al = new ArrayList();
try
{
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
schema = new Neusoft.HISFC.Models.Registration.DeptSchema();
schema.ID = this.Reader[2].ToString();
schema.SeeDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[3].ToString()); //看诊日期
schema.NoonID = this.Reader[5].ToString(); //午别
schema.Dept.ID = this.Reader[6].ToString(); //科室代码
schema.Dept.Name = this.Reader[7].ToString(); //科室名称
schema.RegLevel = this.Reader[8].ToString(); //挂号级别
if (this.Reader.IsDBNull(9) == false)
{
schema.RegLimit = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[9].ToString()); //挂号限额
}
if (this.Reader.IsDBNull(10) == false)
{
schema.PreRegLimit = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString()); //预约挂号限额
}
schema.HasReg = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[12].ToString()); //已挂
schema.HasPreReg = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[13].ToString()); //预约已挂
schema.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[16].ToString());
schema.StopReason.ID = this.Reader[17].ToString();
schema.StopReason.Name = this.Reader[18].ToString(); //停诊原因
schema.StopID = this.Reader[19].ToString(); //停止人
if (this.Reader.IsDBNull(20) == false)
{
schema.StopDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[20].ToString());
}
schema.Memo = this.Reader[21].ToString(); //备注
schema.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[22].ToString());
schema.OperID = this.Reader[23].ToString(); //操作人
al.Add(schema);
}
this.Reader.Close();
}
catch (Exception e)
{
this.Err = "获取科室出诊排班信息出错![" + sql + "]" + e.Message;
this.ErrCode = e.Message;
return(null);
}
return(al);
}
/// <summary>
/// 删除排班记录
/// </summary>
/// <param name="schema"></param>
/// <returns></returns>
public int Delete(Neusoft.HISFC.Models.Registration.DeptSchema schema)
{
string sql = "";
if (this.Sql.GetSql("Registration.DeptSchema.Delete.1", ref sql) == -1)
{
return(-1);
}
try
{
sql = string.Format(sql, schema.ID);
return(this.ExecNoQuery(sql));
}
catch (Exception e)
{
this.Err = "删除科室出诊排班信息时出错!" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
}
/// <summary>
/// 更新排班记录
/// </summary>
/// <param name="schema"></param>
/// <returns></returns>
public int Update(Neusoft.HISFC.Models.Registration.DeptSchema schema)
{
string sql = "";
if (this.Sql.GetSql("Registration.DeptSchema.Update.1", ref sql) == -1)
{
return(-1);
}
try
{
sql = string.Format(sql, schema.ID, schema.RegLimit, schema.PreRegLimit, Neusoft.FrameWork.Function.NConvert.ToInt32(schema.IsValid),
schema.StopReason.ID, schema.StopReason.Name, schema.StopID, schema.StopDate.ToString());
return(this.ExecNoQuery(sql));
}
catch (Exception e)
{
this.Err = "更新科室出诊排班信息时出错!" + e.Message;
this.ErrCode = e.Message;
return(-1);
}
}