/// <summary>
/// 更新表
/// </summary>
/// <param name="record">健康档案类</param>
/// <returns>1－成功、0－失败</returns>
public int Update(NeuObject record)
{
// 转换成健康档案类
Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve = (Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve)record;
this.SQL = "";
// 转换成字段数组
this.FillFields(archieve);
// 获取SQL语句
if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Archieve.Update", ref this.SQL) == -1)
{
return(-1);
}
// 执行SQL语句
if (this.ExecNoQuery(this.SQL, this.fields) == -1)
{
return(-1);
}
// 成功返回
return(1);
}
/// <summary>
/// 填充字段数组
/// </summary>
/// <param name="record">健康档案类</param>
public void FillFields(NeuObject record)
{
// 健康档案类
Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve = (Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve)record;
// 清空字段数组
this.ClearFields();
// 向字段数组赋值
this.fields[(int)EnumArchieve.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital");
this.fields [(int)EnumArchieve.ArchieveID] = archieve.ID;
this.fields[(int)EnumArchieve.ArchieveCode] = archieve.Code;
this.fields [(int)EnumArchieve.ArchieveType] = archieve.ArchieveType.ID;
this.fields[(int)EnumArchieve.CardNO] = archieve.Guest.PID.CardNO;
this.fields[(int)EnumArchieve.Collective] = archieve.Collective.ID;
this.fields[(int)EnumArchieve.Name] = archieve.Name;
this.fields[(int)EnumArchieve.Sex] = archieve.Sex.ToString();
this.fields[(int)EnumArchieve.Birthday] = archieve.Guest.Birthday.ToString();
this.fields[(int)EnumArchieve.IDCard] = archieve.Guest.IDCard;
this.fields[(int)EnumArchieve.Height] = archieve.Guest.Height;
this.fields[(int)EnumArchieve.Weight] = archieve.Guest.Weight;
this.fields[(int)EnumArchieve.BloodType] = archieve.Guest.BloodType.ID.ToString();
this.fields[(int)EnumArchieve.TotalCost] = archieve.TotalCost.ToString();
this.fields[(int)EnumArchieve.TotalCount] = archieve.TotalCount.ToString();
this.fields[(int)EnumArchieve.CRMType] = archieve.CRMType.ID;
this.fields[(int)EnumArchieve.Memo] = archieve.Memo;
this.fields [(int)EnumArchieve.CreateOper] = archieve.CreateEnvironment.ID;
this.fields [(int)EnumArchieve.CreateTime] = archieve.CreateEnvironment.OperTime.ToString();
this.fields[(int)EnumArchieve.InvalidOper] = archieve.InvalidEnvironment.ID;
this.fields[(int)EnumArchieve.InvalidTime] = archieve.InvalidEnvironment.OperTime.ToString();
this.fields[(int)EnumArchieve.IsValid] = ((int)archieve.Validity).ToString();
this.fields [(int)EnumArchieve.Extend1] = archieve.User01;
this.fields [(int)EnumArchieve.Extend2] = archieve.User02;
this.fields [(int)EnumArchieve.Extend3] = archieve.User03;
}
/// <summary>
/// 转换Reader为对象
/// </summary>
/// <param name="archieve">健康档案类</param>
private void ReaderToObject(ref Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve)
{
archieve.Hospital.ID = this.Reader[0].ToString();
archieve.ID = this.Reader[1].ToString();
archieve.Code = this.Reader[2].ToString();
archieve.ArchieveType.ID = this.Reader[3].ToString();
archieve.ArchieveType.Name = this.Reader[4].ToString();
archieve.Guest.PID.CardNO = this.Reader[5].ToString();
archieve.Collective.ID = this.Reader[6].ToString();
archieve.Collective.Name = this.Reader[7].ToString();
archieve.Guest.Name = this.Reader[8].ToString();
if (this.Reader[9].ToString() == "F")
{
archieve.Sex = EnumSex.F;
}
else if (this.Reader[9].ToString() == "M")
{
archieve.Sex = EnumSex.M;
}
//{5983BA8C-05F9-459b-B47D-3ACAFC3594BB} wbo 20100918
//else if (this.Reader[9].ToString() == "O")
//{
// archieve.Sex = EnumSex.O;
//}
else
{
archieve.Sex = EnumSex.U;
}
archieve.Guest.Birthday = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[10].ToString());
archieve.Guest.IDCard = this.Reader[11].ToString();
archieve.Guest.Height = this.Reader[12].ToString();
archieve.Guest.Weight = this.Reader[13].ToString();
archieve.Guest.BloodType.Name = this.Reader[14].ToString();
archieve.TotalCost = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[15].ToString());
archieve.TotalCount = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[16].ToString());
archieve.CRMType.ID = this.Reader[17].ToString();
archieve.CRMType.Name = this.Reader[18].ToString();
archieve.Memo = this.Reader[19].ToString();
archieve.CreateEnvironment.ID = this.Reader[20].ToString();
archieve.CreateEnvironment.Name = this.Reader[21].ToString();
archieve.CreateEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[22].ToString());
archieve.InvalidEnvironment.ID = this.Reader[23].ToString();
archieve.InvalidEnvironment.Name = this.Reader[24].ToString();
archieve.InvalidEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[25].ToString());
if (this.Reader[26].ToString().Equals("1"))
{
archieve.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid;
}
else
{
archieve.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Invalid;
}
archieve.User01 = this.Reader[27].ToString();
archieve.User02 = this.Reader[28].ToString();
archieve.User03 = this.Reader[29].ToString();
archieve.Guest.SpellCode = this.Reader[30].ToString();
archieve.Guest.WBCode = this.Reader[31].ToString();
archieve.Guest.UserCode = this.Reader[32].ToString();
}
/// <summary>
/// 形成返回的健康档案类数组
/// </summary>
/// <param name="recordList">健康档案类数组</param>
public void ReturnArray(ref ArrayList recordList)
{
// 健康档案类
Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve;
// 循环添加数组
while (this.Reader.Read())
{
archieve = new Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve();
// 转换Reader为类对象
this.ReaderToObject(ref archieve);
recordList.Add(archieve);
}
}
/// <summary>
/// 转换Reader为对象
/// </summary>
/// <param name="archieve">体检科室与人员类</param>
private void ReaderToObject(ref Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve)
{
}