Ejemplo n.º 1
0
        /// <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);
            }
        }
Ejemplo n.º 2
0
        /// <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);
        }
Ejemplo n.º 3
0
        /// <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);
            }
        }
Ejemplo n.º 4
0
        /// <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);
            }
        }