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