/// <summary>
/// 转换Reader为对象
/// </summary>
/// <param name="relation">体检科室与体检项目的关系类</param>
private void ReaderToObject(ref Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation relation)
{
relation.Business.ID = this.Reader[0].ToString();
relation.Business.Name = this.Reader[1].ToString();
relation.ID = this.Reader[2].ToString();
relation.Name = this.Reader[3].ToString();
relation.Item.ID = this.Reader[4].ToString();
relation.Item.Name = this.Reader[5].ToString();
relation.Memo = this.Reader[6].ToString();
relation.CreateEnvironment.ID = this.Reader[7].ToString();
relation.CreateEnvironment.Name = this.Reader[8].ToString();
relation.CreateEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[9].ToString());
relation.InvalidEnvironment.ID = this.Reader[10].ToString();
relation.InvalidEnvironment.Name = this.Reader[11].ToString();
relation.InvalidEnvironment.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[11].ToString());
if (this.Reader[12].ToString().Equals("1"))
{
relation.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid;
}
else
{
relation.Validity = Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Invalid;
}
relation.User01 = this.Reader[13].ToString();
relation.User02 = this.Reader[14].ToString();
relation.User03 = this.Reader[15].ToString();
relation.SpellCode = this.Reader[16].ToString();
relation.WBCode = this.Reader[17].ToString();
relation.UserCode = this.Reader[18].ToString();
}
/// <summary>
/// 形成体检科室与项目的关系类数组
/// </summary>
/// <param name="recordList">体检科室与项目的关系类数组</param>
public void ReturnArray(ref ArrayList recordList)
{
// 体检科室与项目的关系类
Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation relation;
// 循环添加数组
while (this.Reader.Read())
{
relation = new Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation();
// 转换Reader为类对象
this.ReaderToObject(ref relation);
recordList.Add(relation);
}
}
/// <summary>
/// 插入表
/// </summary>
/// <param name="record">体检科室与项目的关系类</param>
/// <returns>1－成功、－1－失败</returns>
public int Insert(NeuObject record)
{
// 转换成体检科室与项目的关系类
Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation relation = (Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation)record;
this.SQL = "";
// 转换成字段数组
this.FillFields(relation);
// 获取SQL语句
if (this.Sql.GetSql("", 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.Management.Relation.DeptItemRelation relation = (Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation)record;
// 清空字段数组
this.ClearFields();
// 填充字段数组
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Business] = relation.Business.ID;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Department] = relation.ID;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Item] = relation.Item.ID;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Memo] = relation.Memo;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.CreateOper] = relation.CreateEnvironment.ID;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.CreateTime] = relation.CreateEnvironment.OperTime.ToString();
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.InvalidOper] = relation.InvalidEnvironment.ID;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.InvalidTime] = relation.InvalidEnvironment.OperTime.ToString();
if (relation.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid))
{
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.IsValid] = "1";
}
else
{
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.IsValid] = "0";
}
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend1] = relation.User01;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend2] = relation.User02;
this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend3] = relation.User03;
}