/// <summary> /// 转换Reader为对象 /// </summary> /// <param name="business">健康档案类</param> private void ReaderToObject(ref Neusoft.HISFC.Models.PhysicalExamination.Management.Business business) { business.Hospital.ID = this.Reader[0].ToString(); business.ID = this.Reader [1].ToString(); business.Name = this.Reader[2].ToString(); // 判断体检类型:个人体检还是集体体检 if (this.Reader [3].ToString().Equals("1")) { business.PEType = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumPEType.Collective; } else { business.PEType = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumPEType.Personal; } business.Memo = this.Reader[4].ToString(); business.CreateEnvironment.ID = this.Reader[5].ToString(); business.CreateEnvironment.Name = this.Reader[6].ToString(); business.CreateEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[7].ToString()); business.InvalidEnvironment.ID = this.Reader[8].ToString(); business.InvalidEnvironment.Name = this.Reader[9].ToString(); business.InvalidEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[10].ToString()); business.User01 = this.Reader[11].ToString(); business.User02 = this.Reader[12].ToString(); business.User03 = this.Reader[13].ToString(); // 判断有效性:有效还是无效 if (this.Reader[14].ToString().Equals("1")) { business.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid; } else { business.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Invalid; } }
/// <summary> /// 更新表 /// <param name="record">体检业务类</param> /// <returns>1-成功、-1-失败</returns> /// </summary> public int Update(NeuObject record) { // 转换成健康档案类 Neusoft.HISFC.Models.PhysicalExamination.Management.Business business = (Neusoft.HISFC.Models.PhysicalExamination.Management.Business)record; this.SQL = ""; // 转换成字段数组 this.FillFields(business); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Business.Update", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 形成体检业务类数组 /// </summary> /// <param name="recordList">体检业务类数组</param> public void ReturnArray(ref ArrayList recordList) { // 健康档案类 Neusoft.HISFC.Models.PhysicalExamination.Management.Business business; // 循环添加数组 while (this.Reader.Read()) { business = new Neusoft.HISFC.Models.PhysicalExamination.Management.Business(); // 转换Reader为类对象 this.ReaderToObject(ref business); recordList.Add(business); } }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">体检业务类</param> public void FillFields(NeuObject record) { // 体检业务类 Neusoft.HISFC.Models.PhysicalExamination.Management.Business business = (Neusoft.HISFC.Models.PhysicalExamination.Management.Business)record; // 清空数组 this.ClearFields(); // 填充数组 this.fields[(int)Table.Enum.EnumBusiness.BusinessID] = business.ID; this.fields[(int)Table.Enum.EnumBusiness.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); this.fields[(int)Table.Enum.EnumBusiness.BusinessName] = business.Name; if (business.PEType.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumPEType.Personal)) { this.fields [(int)Table.Enum.EnumBusiness.PEType] = "0"; } else { this.fields [(int)Table.Enum.EnumBusiness.PEType] = "1"; } this.fields[(int)Table.Enum.EnumBusiness.Memo] = business.Memo; this.fields[(int)Table.Enum.EnumBusiness.CreateOper] = business.CreateEnvironment.ID; this.fields[(int)Table.Enum.EnumBusiness.CreateTime] = business.CreateEnvironment.OperTime.ToString(); this.fields[(int)Table.Enum.EnumBusiness.InvalidOper] = business.InvalidEnvironment.ID; this.fields[(int)Table.Enum.EnumBusiness.InvalidTime] = business.InvalidEnvironment.OperTime.ToString(); if (business.Validity == Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid) { this.fields[(int)Table.Enum.EnumBusiness.IsValid] = "1"; } else { this.fields[(int)Table.Enum.EnumBusiness.IsValid] = "0"; } this.fields[(int)Table.Enum.EnumBusiness.Extend1] = business.User01; this.fields[(int)Table.Enum.EnumBusiness.Extend2] = business.User02; this.fields[(int)Table.Enum.EnumBusiness.Extend3] = business.User03; }
/// <summary> /// 插入表 /// </summary> /// <param name="record">体检业务类</param> /// <returns>1-成功、-1-失败</returns> public int Insert(NeuObject record) { // 转换成健康档案类 Neusoft.HISFC.Models.PhysicalExamination.Management.Business business = (Neusoft.HISFC.Models.PhysicalExamination.Management.Business)record; this.SQL = ""; // 转换成字段数组 this.FillFields(business); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Business.Insert", ref this.SQL) == -1) { return(-1); } // 匹配参数 try { this.SQL = string.Format(this.SQL, this.fields); } catch (Exception e) { this.Err += e.Message; return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL) == -1) { return(-1); } // 成功返回 return(1); }