/// <summary> /// 查询午别 /// </summary> /// <returns></returns> public ArrayList Query() { string sql = ""; if (this.Sql.GetSql("Registration.DoctSchema.Query.1", ref sql) == -1) { return(null); } if (this.ExecQuery(sql) == -1) { return(null); } al = new ArrayList(); try { while (this.Reader.Read()) { noon = new Neusoft.HISFC.Models.Base.Noon(); noon.ID = this.Reader[2].ToString(); //id noon.Name = this.Reader[3].ToString(); //name if (Reader.IsDBNull(4) == false) { noon.StartTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[4].ToString());//开始时间 } if (Reader.IsDBNull(5) == false) { noon.EndTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[5].ToString());//结束时间 } if (Reader.IsDBNull(6) == false) { noon.IsAutoEmergency = Neusoft.FrameWork.Function.NConvert.ToBoolean(Reader[6].ToString());//是否急诊 } //noon.OperID = this.Reader[7].ToString();//操作员 //noon.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[8].ToString()); al.Add(noon); } this.Reader.Close(); } catch (Exception e) { this.Err = "获取午别出错" + e.Message; this.ErrCode = e.Message; return(null); } return(al); }
/// <summary> /// 删除一条午别记录 /// </summary> /// <param name="noon"></param> /// <returns></returns> public int Delete(Neusoft.HISFC.Models.Base.Noon noon) { string sql = ""; if (this.Sql.GetSql("Registration.DoctSchema.Delete.2", ref sql) == -1) { return(-1); } try { sql = string.Format(sql, noon.ID); return(this.ExecNoQuery(sql)); } catch (Exception e) { this.Err = "删除午别信息时出错!" + e.Message; this.ErrCode = e.Message; return(-1); } }
/// <summary> /// 插入午别表 /// </summary> /// <param name="noon"></param> /// <returns></returns> public int Insert(Neusoft.HISFC.Models.Base.Noon noon) { string sql = ""; if (this.Sql.GetSql("Registration.DoctSchema.Insert.2", ref sql) == -1) { return(-1); } try { sql = string.Format(sql, noon.ID, noon.Name, noon.StartTime.ToString(), noon.EndTime.ToString(), "", DateTime.MinValue.ToString()); return(this.ExecNoQuery(sql)); } catch (Exception e) { this.Err = "插入午别信息表出错!" + e.Message; this.ErrCode = e.Message; return(-1); } }
/// <summary> /// 获取挂号信息 /// </summary> /// <returns></returns> private Neusoft.HISFC.Models.Registration.Register GetRegisterInfo() { Neusoft.HISFC.Models.Registration.Register register = null; if (this.patientInfo != null && !string.IsNullOrEmpty(this.patientInfo.PID.CardNO)) { register = new Neusoft.HISFC.Models.Registration.Register(); register.PID.CardNO = this.patientInfo.PID.CardNO; register.Name = this.patientInfo.Name; register.Sex.ID = this.patientInfo.Sex.ID; register.Birthday = this.patientInfo.Birthday; register.Pact.ID = this.patientInfo.Pact.ID; register.Pact.PayKind.ID = this.patientInfo.Pact.PayKind.ID; register.SSN = this.patientInfo.SSN; register.PhoneHome = this.patientInfo.PhoneHome; register.AddressHome = this.patientInfo.AddressHome; register.IDCard = this.patientInfo.IDCard; register.NormalName = this.patientInfo.NormalName; register.IsEncrypt = this.patientInfo.IsEncrypt; register.IDCard = this.patientInfo.IDCard; if (this.patientInfo.IsEncrypt == true) { register.Name = Neusoft.FrameWork.WinForms.Classes.Function.Decrypt3DES(this.patientInfo.NormalName); } register.CardType.ID = this.patientInfo.Memo; //挂号流水号 register.ID = this.regMgr.GetSequence("Registration.Register.ClinicID"); register.TranType = Neusoft.HISFC.Models.Base.TransTypes.Positive;//正交易 //this.regObj.DoctorInfo.Templet.RegLevel.ID = this.cmbRegLevel.Tag.ToString(); //this.regObj.DoctorInfo.Templet.RegLevel.Name = this.cmbRegLevel.Text; register.DoctorInfo.Templet.Dept.ID = (this.txtDept.Tag as Neusoft.FrameWork.Models.NeuObject).ID; register.DoctorInfo.Templet.Dept.Name = (this.txtDept.Tag as Neusoft.FrameWork.Models.NeuObject).Name; register.DoctorInfo.Templet.Doct.ID = string.Empty; register.DoctorInfo.Templet.Doct.Name = string.Empty; register.RegType = Neusoft.HISFC.Models.Base.EnumRegType.Reg; register.Pact = this.patientInfo.Pact; register.DoctorInfo.SeeDate = this.regMgr.GetDateTimeFromSysDateTime(); register.DoctorInfo.Templet.RegLevel.ID = "1"; register.DoctorInfo.Templet.RegLevel.Name = "普通号"; Neusoft.HISFC.Models.Base.Noon noon = this.getNoon(register.DoctorInfo.SeeDate); register.DoctorInfo.Templet.Noon = noon; register.DoctorInfo.Templet.Begin = register.DoctorInfo.SeeDate.Date; register.DoctorInfo.Templet.End = register.DoctorInfo.SeeDate.Date; int returnValue = this.GetRegFee(register); if (returnValue < 0) { MessageBox.Show("获得挂号费失败"); return(null); } //处方号 // this.regObj.InvoiceNO = this.txtRecipeNo.Text.Trim(); register.RecipeNO = "1"; register.IsFee = false; register.Status = Neusoft.HISFC.Models.Base.EnumRegisterStatus.Valid; register.IsSee = false; register.InputOper.ID = this.regMgr.Operator.ID; register.InputOper.OperTime = this.regMgr.GetDateTimeFromSysDateTime(); //add by niuxinyuan register.DoctorInfo.SeeDate = register.InputOper.OperTime; register.CancelOper.ID = ""; register.CancelOper.OperTime = DateTime.MinValue; string invoice = this.feeIntegrate.GetNewInvoiceNO("C"); if (invoice == null) { MessageBox.Show(this.feeIntegrate.Err); return(null); } register.InvoiceNO = invoice; //查询患者就诊记录出错 int regCount = this.regMgr.QueryRegiterByCardNO(register.PID.CardNO); if (regCount == 1) { register.IsFirst = false; } else { if (regCount == 0) { register.IsFirst = true; } else { MessageBox.Show("查询患者就诊记录出错"); return(null); } } if (register.DoctorInfo.Templet.Noon.ID == "") { MessageBox.Show("未维护午别信息,请先维护!", "提示"); return(null); } register.DoctorInfo.Templet.ID = ""; } return(register); }