public override List <BloodOxygen> GetDatasByName(string name)
{
string sqlText = "SELECT \"Id\",\"Checkdate\",\"ExamNo\",\"CheckID\",\"Name\",\"SexId\",\"Age\",\"Doctor\",\"DeviceID\",\"Version\",\"Reserve\",\"Check_flagId\",\"Hosname\",\"Auditdoctor\",\"Auditdate\","
+ "\"StatusId\",\"Str1\",\"Str2\",\"Str3\",\"Str4\",\"Str5\",\"Str6\",\"Str7\",\"Str8\",\"Str9\",\"Str10\",\"T3001005_ename\",\"T3001005_cname\",\"T3001005_unit\",\"T3001005_srange\","
+ "\"T3001005_lrange\",\"T3001005_value\",\"T3001009_ename\",\"T3001009_cname\",\"T3001009_unit\",\"T3001009_srange\",\"T3001009_lrange\",\"T3001009_value\" "
+ "FROM \"BloodOxygen\""
+ "WHERE \"Name\"=:Name";
List <BloodOxygen> list = new List <BloodOxygen>();
OracleParameter[] parameters =
{
new OracleParameter(":Name", OracleType.NVarChar, 50)
{
Value = name
}
};
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, parameters);
while (oracleDataReader.Read())
{
BloodOxygen bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(oracleDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
oracleDataReader.Close();
return(list);
}
/// <summary>
/// 根据血氧检测类（BloodOxygen）的主键“编号（Id）”从数据库中获取血氧检测类（BloodOxygen）的实例。
/// 成功从数据库中取得记录返回新血氧检测类（BloodOxygen）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="id">血氧检测类（BloodOxygen）的主键“编号（Id）”</param>
public override BloodOxygen GetDataById(int id)
{
BloodOxygen bloodOxygen = null;
string sqlText = "SELECT \"Id\",\"Checkdate\",\"ExamNo\",\"CheckID\",\"Name\",\"SexId\",\"Age\",\"Doctor\",\"DeviceID\",\"Version\",\"Reserve\",\"Check_flagId\",\"Hosname\",\"Auditdoctor\",\"Auditdate\","
+ "\"StatusId\",\"Str1\",\"Str2\",\"Str3\",\"Str4\",\"Str5\",\"Str6\",\"Str7\",\"Str8\",\"Str9\",\"Str10\",\"T3001005_ename\",\"T3001005_cname\",\"T3001005_unit\",\"T3001005_srange\","
+ "\"T3001005_lrange\",\"T3001005_value\",\"T3001009_ename\",\"T3001009_cname\",\"T3001009_unit\",\"T3001009_srange\",\"T3001009_lrange\",\"T3001009_value\" "
+ "FROM \"BloodOxygen\" "
+ "WHERE \"Id\"=:Id";
OracleParameter[] parameters =
{
new OracleParameter(":Id", OracleType.Int32, 4)
{
Value = id
}
};
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, parameters);
if (oracleDataReader.Read())
{
bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(oracleDataReader, bloodOxygen);
}
oracleDataReader.Close();
return(bloodOxygen);
}
/// <summary>
/// 根据血氧检测类（BloodOxygen）的主键“编号（Id）”从数据库中获取血氧检测类（BloodOxygen）的实例。
/// 成功从数据库中取得记录返回新血氧检测类（BloodOxygen）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="id">血氧检测类（BloodOxygen）的主键“编号（Id）”</param>
public override BloodOxygen GetDataById(int id)
{
BloodOxygen bloodOxygen = null;
string sqlText = "SELECT [Id],[Checkdate],[ExamNo],[CheckID],[Name],[SexId],[Age],[Doctor],[DeviceID],[Version],[Reserve],[Check_flagId],[Hosname],[Auditdoctor],[Auditdate],"
+ "[StatusId],[Str1],[Str2],[Str3],[Str4],[Str5],[Str6],[Str7],[Str8],[Str9],[Str10],[T3001005_ename],[T3001005_cname],[T3001005_unit],[T3001005_srange],"
+ "[T3001005_lrange],[T3001005_value],[T3001009_ename],[T3001009_cname],[T3001009_unit],[T3001009_srange],[T3001009_lrange],[T3001009_value] "
+ "FROM [BloodOxygen] "
+ "WHERE [Id]=@Id";
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
{
Value = id
}
};
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, parameters);
if (sqlDataReader.Read())
{
bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(sqlDataReader, bloodOxygen);
}
sqlDataReader.Close();
return(bloodOxygen);
}
public override List <BloodOxygen> GetDatasByName(string name)
{
BloodOxygen bloodOxygen = null;
string sqlText = "SELECT [Id],[Checkdate],[ExamNo],[CheckID],[Name],[SexId],[Age],[Doctor],[DeviceID],[Version],[Reserve],[Check_flagId],[Hosname],[Auditdoctor],[Auditdate],"
+ "[StatusId],[Str1],[Str2],[Str3],[Str4],[Str5],[Str6],[Str7],[Str8],[Str9],[Str10],[T3001005_ename],[T3001005_cname],[T3001005_unit],[T3001005_srange],"
+ "[T3001005_lrange],[T3001005_value],[T3001009_ename],[T3001009_cname],[T3001009_unit],[T3001009_srange],[T3001009_lrange],[T3001009_value] "
+ "FROM [BloodOxygen] "
+ "WHERE [Name]=@Name";
List <BloodOxygen> list = new List <BloodOxygen>();
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
{
Value = name
}
};
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, parameters);
if (sqlDataReader.Read())
{
bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(sqlDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
sqlDataReader.Close();
return(list);
}
/// <summary>
/// 从数据库中读取并返回所有血氧检测类（BloodOxygen）List列表。
/// </summary>
public override List <BloodOxygen> GetAllList()
{
string sqlText = "SELECT \"Id\",\"Checkdate\",\"ExamNo\",\"CheckID\",\"Name\",\"SexId\",\"Age\",\"Doctor\",\"DeviceID\",\"Version\",\"Reserve\",\"Check_flagId\",\"Hosname\",\"Auditdoctor\",\"Auditdate\","
+ "\"StatusId\",\"Str1\",\"Str2\",\"Str3\",\"Str4\",\"Str5\",\"Str6\",\"Str7\",\"Str8\",\"Str9\",\"Str10\",\"T3001005_ename\",\"T3001005_cname\",\"T3001005_unit\",\"T3001005_srange\","
+ "\"T3001005_lrange\",\"T3001005_value\",\"T3001009_ename\",\"T3001009_cname\",\"T3001009_unit\",\"T3001009_srange\",\"T3001009_lrange\",\"T3001009_value\" "
+ "FROM \"BloodOxygen\"";
List <BloodOxygen> list = new List <BloodOxygen>();
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, null);
while (oracleDataReader.Read())
{
BloodOxygen bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(oracleDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
oracleDataReader.Close();
return(list);
}
/// <summary>
/// 从数据库中读取并返回所有血氧检测类（BloodOxygen）List列表。
/// </summary>
public override List <BloodOxygen> GetAllList()
{
string sqlText = "SELECT [Id],[Checkdate],[ExamNo],[CheckID],[Name],[SexId],[Age],[Doctor],[DeviceID],[Version],[Reserve],[Check_flagId],[Hosname],[Auditdoctor],[Auditdate],"
+ "[StatusId],[Str1],[Str2],[Str3],[Str4],[Str5],[Str6],[Str7],[Str8],[Str9],[Str10],[T3001005_ename],[T3001005_cname],[T3001005_unit],[T3001005_srange],"
+ "[T3001005_lrange],[T3001005_value],[T3001009_ename],[T3001009_cname],[T3001009_unit],[T3001009_srange],[T3001009_lrange],[T3001009_value] "
+ "FROM [BloodOxygen]";
List <BloodOxygen> list = new List <BloodOxygen>();
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, null);
while (sqlDataReader.Read())
{
BloodOxygen bloodOxygen = new BloodOxygen();
ReadBloodOxygenAllData(sqlDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
sqlDataReader.Close();
return(list);
}
/// <summary>
/// 根据每页记录数及所要获取的页数，从数据库中读取并返回经过分页后的血氧检测类（BloodOxygen）的列表及分页信息。
/// 该方法所获取的血氧检测类（BloodOxygen）列表仅用于在数据控件中显示，该方法只为对象中需要显示的属性进行赋值。
/// </summary>
public override PageData GetPageList(int pageSize, int curPage)
{
string sqlText = "SELECT [Id],[Checkdate],[ExamNo],[CheckID],[Name],[SexId],[Doctor],[DeviceID],[Check_flagId],[Hosname],[StatusId] "
+ "FROM [BloodOxygen]";
List <BloodOxygen> list = new List <BloodOxygen>();
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, null);
PageData pageData = new PageData();
pageData.PageSize = pageSize;
pageData.CurPage = curPage;
pageData.RecordCount = 0;
pageData.PageCount = 1;
int first = (curPage - 1) * pageSize + 1;
int last = curPage * pageSize;
while (sqlDataReader.Read())
{
pageData.RecordCount++;
if (pageData.RecordCount >= first && last >= pageData.RecordCount)
{
BloodOxygen bloodOxygen = new BloodOxygen();
ReadBloodOxygenPageData(sqlDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
}
sqlDataReader.Close();
if (pageData.RecordCount > 0)
{
pageData.PageCount = Convert.ToInt32(Math.Ceiling((double)pageData.RecordCount / (double)pageSize));
}
pageData.PageList = list;
return(pageData);
}
/// <summary>
/// 根据每页记录数及所要获取的页数，从数据库中读取并返回经过分页后的血氧检测类（BloodOxygen）的列表及分页信息。
/// 该方法所获取的血氧检测类（BloodOxygen）列表仅用于在数据控件中显示，该方法只为对象中需要显示的属性进行赋值。
/// </summary>
public override PageData GetPageList(int pageSize, int curPage)
{
string sqlText = "SELECT \"Id\",\"Checkdate\",\"ExamNo\",\"CheckID\",\"Name\",\"SexId\",\"Doctor\",\"DeviceID\",\"Check_flagId\",\"Hosname\",\"StatusId\" "
+ "FROM \"BloodOxygen\"";
List <BloodOxygen> list = new List <BloodOxygen>();
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, null);
PageData pageData = new PageData();
pageData.PageSize = pageSize;
pageData.CurPage = curPage;
pageData.RecordCount = 0;
pageData.PageCount = 1;
int first = (curPage - 1) * pageSize + 1;
int last = curPage * pageSize;
while (oracleDataReader.Read())
{
pageData.RecordCount++;
if (pageData.RecordCount >= first && last >= pageData.RecordCount)
{
BloodOxygen bloodOxygen = new BloodOxygen();
ReadBloodOxygenPageData(oracleDataReader, bloodOxygen);
list.Add(bloodOxygen);
}
}
oracleDataReader.Close();
if (pageData.RecordCount > 0)
{
pageData.PageCount = Convert.ToInt32(Math.Ceiling((double)pageData.RecordCount / (double)pageSize));
}
pageData.PageList = list;
return(pageData);
}
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public static int Insert(BloodOxygen bloodOxygen)
{
CheckValid(bloodOxygen);
return(DataAccess.Insert(bloodOxygen));
}
/// <summary>
/// 对血氧检测类（BloodOxygen）实例对象，进行数据有效性检查。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public static void CheckValid(BloodOxygen bloodOxygen)
{
#region 检查各属性是否符合空值约束
if (DataValid.IsNull(bloodOxygen.Checkdate))
{
throw new CustomException("“检查日期”不能为空，请您确认输入是否正确。");
}
if (DataValid.IsNull(bloodOxygen.ExamNo))
{
throw new CustomException("“门诊号”不能为空，请您确认输入是否正确。");
}
if (DataValid.IsNull(bloodOxygen.CheckID))
{
throw new CustomException("“检查号”不能为空，请您确认输入是否正确。");
}
if (DataValid.IsNull(bloodOxygen.Name))
{
throw new CustomException("“姓名”不能为空，请您确认输入是否正确。");
}
if (DataValid.IsNull(bloodOxygen.Check_flag))
{
throw new CustomException("“检查标记”不能为空，请您确认输入是否正确。");
}
if (DataValid.IsNull(bloodOxygen.Status))
{
throw new CustomException("“状态”不能为空，请您确认输入是否正确。");
}
#endregion
#region 检查字符串是否超出规定长度
if (DataValid.IsOutLength(bloodOxygen.ExamNo, 50))
{
throw new CustomException("“门诊号”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.CheckID, 50))
{
throw new CustomException("“检查号”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Name, 50))
{
throw new CustomException("“姓名”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Sex.ToString(), 50))
{
throw new CustomException("“性别”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Doctor, 50))
{
throw new CustomException("“开单医生”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.DeviceID, 50))
{
throw new CustomException("“设备号”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Version, 50))
{
throw new CustomException("“版本号”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Reserve, 50))
{
throw new CustomException("“保留字段”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Hosname, 50))
{
throw new CustomException("“医院”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Auditdoctor, 50))
{
throw new CustomException("“审核医生”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str1, 50))
{
throw new CustomException("“心电诊断”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str2, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str3, 50))
{
throw new CustomException("“身份证号”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str4, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str5, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str6, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str7, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str8, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str9, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.Str10, 50))
{
throw new CustomException("“冗余”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001005_ename, 50))
{
throw new CustomException("“血氧简称”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001005_cname, 50))
{
throw new CustomException("“血氧全称”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001005_unit, 50))
{
throw new CustomException("“血氧UNIT”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001009_ename, 50))
{
throw new CustomException("“脉率简称”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001009_cname, 50))
{
throw new CustomException("“脉率全称”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(bloodOxygen.T3001009_unit, 50))
{
throw new CustomException("“UNIT(BPM)”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
#endregion
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public override int Insert(BloodOxygen bloodOxygen)
{
string sqlText = "INSERT INTO [BloodOxygen]"
+ "([Checkdate],[ExamNo],[CheckID],[Name],[SexId],[Age],[Doctor],[DeviceID],[Version],[Reserve],[Check_flagId],[Hosname],[Auditdoctor],[Auditdate],"
+ "[StatusId],[Str1],[Str2],[Str3],[Str4],[Str5],[Str6],[Str7],[Str8],[Str9],[Str10],[T3001005_ename],[T3001005_cname],[T3001005_unit],[T3001005_srange],"
+ "[T3001005_lrange],[T3001005_value],[T3001009_ename],[T3001009_cname],[T3001009_unit],[T3001009_srange],[T3001009_lrange],[T3001009_value])"
+ "VALUES"
+ "(@Checkdate,@ExamNo,@CheckID,@Name,@SexId,@Age,@Doctor,@DeviceID,@Version,@Reserve,@Check_flagId,@Hosname,@Auditdoctor,@Auditdate,"
+ "@StatusId,@Str1,@Str2,@Str3,@Str4,@Str5,@Str6,@Str7,@Str8,@Str9,@Str10,@T3001005_ename,@T3001005_cname,@T3001005_unit,@T3001005_srange,"
+ "@T3001005_lrange,@T3001005_value,@T3001009_ename,@T3001009_cname,@T3001009_unit,@T3001009_srange,@T3001009_lrange,@T3001009_value)";
SqlParameter[] parameters =
{
new SqlParameter("@Checkdate", SqlDbType.DateTime, 8)
{
Value = bloodOxygen.Checkdate
},
new SqlParameter("@ExamNo", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.ExamNo
},
new SqlParameter("@CheckID", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.CheckID
},
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Name
},
new SqlParameter("@SexId", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Sex
},
new SqlParameter("@Age", SqlDbType.Int, 4)
{
Value = bloodOxygen.Age
},
new SqlParameter("@Doctor", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Doctor
},
new SqlParameter("@DeviceID", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.DeviceID
},
new SqlParameter("@Version", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Version
},
new SqlParameter("@Reserve", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Reserve
},
new SqlParameter("@Check_flagId", SqlDbType.Int, 4)
{
Value = bloodOxygen.Check_flag
},
new SqlParameter("@Hosname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Hosname
},
new SqlParameter("@Auditdoctor", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Auditdoctor
},
new SqlParameter("@Auditdate", SqlDbType.DateTime, 8)
{
Value = bloodOxygen.Auditdate
},
new SqlParameter("@StatusId", SqlDbType.Int, 4)
{
Value = bloodOxygen.Status
},
new SqlParameter("@Str1", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str1
},
new SqlParameter("@Str2", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str2
},
new SqlParameter("@Str3", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str3
},
new SqlParameter("@Str4", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str4
},
new SqlParameter("@Str5", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str5
},
new SqlParameter("@Str6", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str6
},
new SqlParameter("@Str7", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str7
},
new SqlParameter("@Str8", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str8
},
new SqlParameter("@Str9", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str9
},
new SqlParameter("@Str10", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str10
},
new SqlParameter("@T3001005_ename", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_ename
},
new SqlParameter("@T3001005_cname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_cname
},
new SqlParameter("@T3001005_unit", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_unit
},
new SqlParameter("@T3001005_srange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_srange
},
new SqlParameter("@T3001005_lrange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_lrange
},
new SqlParameter("@T3001005_value", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_value
},
new SqlParameter("@T3001009_ename", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_ename
},
new SqlParameter("@T3001009_cname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_cname
},
new SqlParameter("@T3001009_unit", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_unit
},
new SqlParameter("@T3001009_srange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_srange
},
new SqlParameter("@T3001009_lrange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_lrange
},
new SqlParameter("@T3001009_value", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_value
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，根据主键“编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public override int Update(BloodOxygen bloodOxygen)
{
string sqlText = "UPDATE [BloodOxygen] SET "
+ "[Checkdate]=@Checkdate,[ExamNo]=@ExamNo,[CheckID]=@CheckID,[Name]=@Name,[SexId]=@SexId,[Age]=@Age,[Doctor]=@Doctor,"
+ "[DeviceID]=@DeviceID,[Version]=@Version,[Reserve]=@Reserve,[Check_flagId]=@Check_flagId,[Hosname]=@Hosname,[Auditdoctor]=@Auditdoctor,"
+ "[Auditdate]=@Auditdate,[StatusId]=@StatusId,[Str1]=@Str1,[Str2]=@Str2,[Str3]=@Str3,[Str4]=@Str4,[Str5]=@Str5,[Str6]=@Str6,[Str7]=@Str7,[Str8]=@Str8,[Str9]=@Str9,"
+ "[Str10]=@Str10,[T3001005_ename]=@T3001005_ename,[T3001005_cname]=@T3001005_cname,[T3001005_unit]=@T3001005_unit,"
+ "[T3001005_srange]=@T3001005_srange,[T3001005_lrange]=@T3001005_lrange,[T3001005_value]=@T3001005_value,[T3001009_ename]=@T3001009_ename,"
+ "[T3001009_cname]=@T3001009_cname,[T3001009_unit]=@T3001009_unit,[T3001009_srange]=@T3001009_srange,[T3001009_lrange]=@T3001009_lrange,"
+ "[T3001009_value]=@T3001009_value "
+ "WHERE [Id]=@Id";
SqlParameter[] parameters =
{
new SqlParameter("@Checkdate", SqlDbType.DateTime, 8)
{
Value = bloodOxygen.Checkdate
},
new SqlParameter("@ExamNo", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.ExamNo
},
new SqlParameter("@CheckID", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.CheckID
},
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Name
},
new SqlParameter("@SexId", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Sex
},
new SqlParameter("@Age", SqlDbType.Int, 4)
{
Value = bloodOxygen.Age
},
new SqlParameter("@Doctor", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Doctor
},
new SqlParameter("@DeviceID", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.DeviceID
},
new SqlParameter("@Version", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Version
},
new SqlParameter("@Reserve", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Reserve
},
new SqlParameter("@Check_flagId", SqlDbType.Int, 4)
{
Value = bloodOxygen.Check_flag
},
new SqlParameter("@Hosname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Hosname
},
new SqlParameter("@Auditdoctor", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Auditdoctor
},
new SqlParameter("@Auditdate", SqlDbType.DateTime, 8)
{
Value = bloodOxygen.Auditdate
},
new SqlParameter("@StatusId", SqlDbType.Int, 4)
{
Value = bloodOxygen.Status
},
new SqlParameter("@Str1", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str1
},
new SqlParameter("@Str2", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str2
},
new SqlParameter("@Str3", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str3
},
new SqlParameter("@Str4", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str4
},
new SqlParameter("@Str5", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str5
},
new SqlParameter("@Str6", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str6
},
new SqlParameter("@Str7", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str7
},
new SqlParameter("@Str8", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str8
},
new SqlParameter("@Str9", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str9
},
new SqlParameter("@Str10", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.Str10
},
new SqlParameter("@T3001005_ename", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_ename
},
new SqlParameter("@T3001005_cname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_cname
},
new SqlParameter("@T3001005_unit", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_unit
},
new SqlParameter("@T3001005_srange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_srange
},
new SqlParameter("@T3001005_lrange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_lrange
},
new SqlParameter("@T3001005_value", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001005_value
},
new SqlParameter("@T3001009_ename", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_ename
},
new SqlParameter("@T3001009_cname", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_cname
},
new SqlParameter("@T3001009_unit", SqlDbType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_unit
},
new SqlParameter("@T3001009_srange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_srange
},
new SqlParameter("@T3001009_lrange", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_lrange
},
new SqlParameter("@T3001009_value", SqlDbType.Int, 4)
{
Value = bloodOxygen.T3001009_value
},
new SqlParameter("@Id", SqlDbType.Int, 4)
{
Value = bloodOxygen.Id
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
public IHttpActionResult Post(BloodOxygen value)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (value.source == null || value.humanId == null)
{
return(BadRequest());
}
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
tSourceService sourceServiceObj = db.tSourceServices
.SingleOrDefault(x => x.ServiceName == value.source && x.SourceID == 5);
if (sourceServiceObj == null)
{
sourceServiceObj = new tSourceService();
sourceServiceObj.ServiceName = value.source;
sourceServiceObj.TypeID = 2; //Wellness
sourceServiceObj.SourceID = 5; //HumanAPI
db.tSourceServices.Add(sourceServiceObj);
}
tUserSourceService userSourceServiceObj = null;
//Get credentials
tCredential credentialObj =
db.tCredentials.SingleOrDefault(x => x.SourceID == 5 && x.SourceUserID == value.humanId &&
x.SystemStatusID == 1);
if (credentialObj == null)
{
throw new NoUserCredentialsException("Unable to find any matching HAPI user credentials");
}
else
{
userSourceServiceObj = db.tUserSourceServices.SingleOrDefault(
x => x.SourceServiceID == sourceServiceObj.ID &&
x.CredentialID == credentialObj.ID &&
x.SystemStatusID == 1);
if (userSourceServiceObj == null)
{
userSourceServiceObj = new tUserSourceService();
userSourceServiceObj.SourceServiceID = sourceServiceObj.ID;
userSourceServiceObj.UserID = credentialObj.UserID;
userSourceServiceObj.CredentialID = credentialObj.ID;
userSourceServiceObj.ConnectedOnDateTime = DateTime.Now;
userSourceServiceObj.LastSyncDateTime = DateTime.Now;
userSourceServiceObj.LatestDateTime = value.updatedAt;
userSourceServiceObj.StatusID = 3; //connected
userSourceServiceObj.SystemStatusID = 1; //valid
userSourceServiceObj.tCredential = credentialObj;
db.tUserSourceServices.Add(userSourceServiceObj);
}
else
{
//update LatestDateTime to the most recent datetime
if (userSourceServiceObj.LatestDateTime == null ||
userSourceServiceObj.LatestDateTime < value.updatedAt)
{
userSourceServiceObj.LatestDateTime = value.updatedAt;
}
}
}
tUserTestResult userTestResult = null;
userTestResult = db.tUserTestResults
.SingleOrDefault(x => x.SourceObjectID == value.id);
if (userTestResult == null)
{
//insert
userTestResult = new tUserTestResult();
userTestResult.SourceObjectID = value.id;
userTestResult.UserID = credentialObj.UserID;
userTestResult.tUserSourceService = userSourceServiceObj;
userTestResult.UserSourceServiceID = userSourceServiceObj.ID;
userTestResult.Name = "Blood Oxygen";
userTestResult.StatusID = 3; //captured
userTestResult.SystemStatusID = 1;
//Dates
DateTimeOffset dtoStart;
if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.timestamp,
value.tzOffset,
out dtoStart))
{
userTestResult.ResultDateTime = dtoStart;
}
else
{
userTestResult.ResultDateTime = value.timestamp;
}
tUserTestResultComponent userTestResultComponent = new tUserTestResultComponent();
userTestResultComponent.SystemStatusID = 1;
userTestResultComponent.Name = "Blood Oxygen";
userTestResultComponent.Value = value.value.ToString();
//UOM
if (value.unit != null)
{
tUnitsOfMeasure uom = null;
uom = db.tUnitsOfMeasures.SingleOrDefault(x => x.UnitOfMeasure == value.unit);
if (uom == null)
{
uom = new tUnitsOfMeasure();
uom.UnitOfMeasure = value.unit;
db.tUnitsOfMeasures.Add(uom);
}
userTestResultComponent.tUnitsOfMeasure = uom;
userTestResultComponent.UOMID = uom.ID;
}
userTestResult.tUserTestResultComponents.Add(userTestResultComponent);
tXrefUserTestResultComponentsCode xRefComponentCode = new tXrefUserTestResultComponentsCode();
xRefComponentCode.UserTestResultComponentID = userTestResultComponent.ID;
xRefComponentCode.CodeID = 6720;
userTestResultComponent.tXrefUserTestResultComponentsCodes.Add(xRefComponentCode);
userTestResult.tUserSourceService = userSourceServiceObj;
db.tUserTestResults.Add(userTestResult);
}
else
{
//update
//Dates
DateTimeOffset dtoStart;
if (RESTfulBAL.Models.DynamoDB.Utilities.ConvertToDateTimeOffset(value.timestamp,
value.tzOffset,
out dtoStart))
{
userTestResult.ResultDateTime = dtoStart;
}
else
{
userTestResult.ResultDateTime = value.timestamp;
}
tUserTestResultComponent userTestResultComponent = db.tUserTestResultComponents
.SingleOrDefault(x => x.TestResultID == userTestResult.ID);
if (userTestResultComponent != null)
{
userTestResultComponent.Value = value.value.ToString();
//UOM
if (value.unit != null)
{
tUnitsOfMeasure uom = null;
uom = db.tUnitsOfMeasures.SingleOrDefault(x => x.UnitOfMeasure == value.unit);
if (uom == null)
{
uom = new tUnitsOfMeasure();
uom.UnitOfMeasure = value.unit;
db.tUnitsOfMeasures.Add(uom);
}
if (!uom.UnitOfMeasure.Equals(value.unit))
{
userTestResultComponent.tUnitsOfMeasure = uom;
userTestResultComponent.UOMID = uom.ID;
}
}
userTestResult.tUserTestResultComponents.Add(userTestResultComponent);
}
userTestResult.LastUpdatedDateTime = DateTime.Now;
userTestResult.tUserSourceService = userSourceServiceObj;
}
db.SaveChanges();
dbContextTransaction.Commit();
return(Ok(userTestResult));
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
//Insert Error Log
tUserDataErrLog userErrorLog = new tUserDataErrLog();
userErrorLog.ErrTypeID = (int)ErrorLogging.enumErrorType.Application;
userErrorLog.ErrSourceID = (int)AuditLogging.enumApplication.SFCBAL;
userErrorLog.Code = ex.HResult.ToString();
userErrorLog.Description = ex.Message;
userErrorLog.Trace = ex.StackTrace;
dbErr.tUserDataErrLogs.Add(userErrorLog);
dbErr.SaveChanges();
string ErrMsg = "An error occured and we have logged the error. Please try again later.";
Exception Err = new Exception(ErrMsg, ex);
return(InternalServerError(Err));
}
}
}
/// <summary>
/// 从DataReader中读取数据，并为BloodOxygen对象需要进行显示的属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
protected void ReadBloodOxygenPageData(IDataReader dataReader, BloodOxygen bloodOxygen)
{
// 编号
if (dataReader["Id"] != DBNull.Value)
{
bloodOxygen.Id = Convert.ToInt32(dataReader["Id"]);
}
// 检查日期
if (dataReader["Checkdate"] != DBNull.Value)
{
bloodOxygen.Checkdate = Convert.ToDateTime(dataReader["Checkdate"]);
}
// 门诊号
if (dataReader["ExamNo"] != DBNull.Value)
{
bloodOxygen.ExamNo = Convert.ToString(dataReader["ExamNo"]);
}
// 检查号
if (dataReader["CheckID"] != DBNull.Value)
{
bloodOxygen.CheckID = Convert.ToString(dataReader["CheckID"]);
}
// 姓名
if (dataReader["Name"] != DBNull.Value)
{
bloodOxygen.Name = Convert.ToString(dataReader["Name"]);
}
// 性别
if (dataReader["SexId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Sex = T_Sex.GetDataById(Convert.ToString(dataReader["SexId"])) ?? T_Sex.Empty;
}
// 开单医生
if (dataReader["Doctor"] != DBNull.Value)
{
bloodOxygen.Doctor = Convert.ToString(dataReader["Doctor"]);
}
// 设备号
if (dataReader["DeviceID"] != DBNull.Value)
{
bloodOxygen.DeviceID = Convert.ToString(dataReader["DeviceID"]);
}
// 检查标记
if (dataReader["Check_flagId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Check_flag = T_Check_Flag.GetDataById(Convert.ToInt32(dataReader["Check_flagId"])) ?? T_Check_Flag.Empty;
}
// 医院
if (dataReader["Hosname"] != DBNull.Value)
{
bloodOxygen.Hosname = Convert.ToString(dataReader["Hosname"]);
}
// 状态
if (dataReader["StatusId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Status = T_Status.GetDataById(Convert.ToInt32(dataReader["StatusId"])) ?? T_Status.Empty;
}
}
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，根据主键“编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public static int Update(BloodOxygen bloodOxygen)
{
CheckValid(bloodOxygen);
return(DataAccess.Update(bloodOxygen));
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 公共数据访问类抽象方法定义，在SqlServer/Oracle/OleDb子类中实现具体方法。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public abstract int Insert(BloodOxygen bloodOxygen);
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public override int Insert(BloodOxygen bloodOxygen)
{
string sqlText = "INSERT INTO \"BloodOxygen\""
+ "(\"Checkdate\",\"ExamNo\",\"CheckID\",\"Name\",\"SexId\",\"Age\",\"Doctor\",\"DeviceID\",\"Version\",\"Reserve\",\"Check_flagId\",\"Hosname\",\"Auditdoctor\",\"Auditdate\","
+ "\"StatusId\",\"Str1\",\"Str2\",\"Str3\",\"Str4\",\"Str5\",\"Str6\",\"Str7\",\"Str8\",\"Str9\",\"Str10\",\"T3001005_ename\",\"T3001005_cname\",\"T3001005_unit\",\"T3001005_srange\","
+ "\"T3001005_lrange\",\"T3001005_value\",\"T3001009_ename\",\"T3001009_cname\",\"T3001009_unit\",\"T3001009_srange\",\"T3001009_lrange\",\"T3001009_value\")"
+ "VALUES"
+ "(:Checkdate,:ExamNo,:CheckID,:Name,:SexId,:Age,:Doctor,:DeviceID,:Version,:Reserve,:Check_flagId,:Hosname,:Auditdoctor,:Auditdate,"
+ ":StatusId,:Str1,:Str2,:Str3,:Str4,:Str5,:Str6,:Str7,:Str8,:Str9,:Str10,:T3001005_ename,:T3001005_cname,:T3001005_unit,:T3001005_srange,"
+ ":T3001005_lrange,:T3001005_value,:T3001009_ename,:T3001009_cname,:T3001009_unit,:T3001009_srange,:T3001009_lrange,:T3001009_value)";
OracleParameter[] parameters =
{
new OracleParameter(":Checkdate", OracleType.DateTime, 8)
{
Value = bloodOxygen.Checkdate
},
new OracleParameter(":ExamNo", OracleType.NVarChar, 50)
{
Value = bloodOxygen.ExamNo
},
new OracleParameter(":CheckID", OracleType.NVarChar, 50)
{
Value = bloodOxygen.CheckID
},
new OracleParameter(":Name", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Name
},
new OracleParameter(":SexId", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Sex
},
new OracleParameter(":Age", OracleType.Int32, 4)
{
Value = bloodOxygen.Age
},
new OracleParameter(":Doctor", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Doctor
},
new OracleParameter(":DeviceID", OracleType.NVarChar, 50)
{
Value = bloodOxygen.DeviceID
},
new OracleParameter(":Version", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Version
},
new OracleParameter(":Reserve", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Reserve
},
new OracleParameter(":Check_flagId", OracleType.Int32, 4)
{
Value = bloodOxygen.Check_flag
},
new OracleParameter(":Hosname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Hosname
},
new OracleParameter(":Auditdoctor", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Auditdoctor
},
new OracleParameter(":Auditdate", OracleType.DateTime, 8)
{
Value = bloodOxygen.Auditdate
},
new OracleParameter(":StatusId", OracleType.Int32, 4)
{
Value = bloodOxygen.Status
},
new OracleParameter(":Str1", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str1
},
new OracleParameter(":Str2", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str2
},
new OracleParameter(":Str3", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str3
},
new OracleParameter(":Str4", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str4
},
new OracleParameter(":Str5", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str5
},
new OracleParameter(":Str6", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str6
},
new OracleParameter(":Str7", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str7
},
new OracleParameter(":Str8", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str8
},
new OracleParameter(":Str9", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str9
},
new OracleParameter(":Str10", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str10
},
new OracleParameter(":T3001005_ename", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_ename
},
new OracleParameter(":T3001005_cname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_cname
},
new OracleParameter(":T3001005_unit", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_unit
},
new OracleParameter(":T3001005_srange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_srange
},
new OracleParameter(":T3001005_lrange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_lrange
},
new OracleParameter(":T3001005_value", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_value
},
new OracleParameter(":T3001009_ename", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_ename
},
new OracleParameter(":T3001009_cname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_cname
},
new OracleParameter(":T3001009_unit", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_unit
},
new OracleParameter(":T3001009_srange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_srange
},
new OracleParameter(":T3001009_lrange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_lrange
},
new OracleParameter(":T3001009_value", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_value
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 将血氧检测类（BloodOxygen）数据，根据主键“编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
public override int Update(BloodOxygen bloodOxygen)
{
string sqlText = "UPDATE \"BloodOxygen\" SET "
+ "\"Checkdate\"=:Checkdate,\"ExamNo\"=:ExamNo,\"CheckID\"=:CheckID,\"Name\"=:Name,\"SexId\"=:SexId,\"Age\"=:Age,\"Doctor\"=:Doctor,"
+ "\"DeviceID\"=:DeviceID,\"Version\"=:Version,\"Reserve\"=:Reserve,\"Check_flagId\"=:Check_flagId,\"Hosname\"=:Hosname,\"Auditdoctor\"=:Auditdoctor,"
+ "\"Auditdate\"=:Auditdate,\"StatusId\"=:StatusId,\"Str1\"=:Str1,\"Str2\"=:Str2,\"Str3\"=:Str3,\"Str4\"=:Str4,\"Str5\"=:Str5,\"Str6\"=:Str6,\"Str7\"=:Str7,\"Str8\"=:Str8,\"Str9\"=:Str9,"
+ "\"Str10\"=:Str10,\"T3001005_ename\"=:T3001005_ename,\"T3001005_cname\"=:T3001005_cname,\"T3001005_unit\"=:T3001005_unit,"
+ "\"T3001005_srange\"=:T3001005_srange,\"T3001005_lrange\"=:T3001005_lrange,\"T3001005_value\"=:T3001005_value,\"T3001009_ename\"=:T3001009_ename,"
+ "\"T3001009_cname\"=:T3001009_cname,\"T3001009_unit\"=:T3001009_unit,\"T3001009_srange\"=:T3001009_srange,\"T3001009_lrange\"=:T3001009_lrange,"
+ "\"T3001009_value\"=:T3001009_value "
+ "WHERE \"Id\"=:Id";
OracleParameter[] parameters =
{
new OracleParameter(":Checkdate", OracleType.DateTime, 8)
{
Value = bloodOxygen.Checkdate
},
new OracleParameter(":ExamNo", OracleType.NVarChar, 50)
{
Value = bloodOxygen.ExamNo
},
new OracleParameter(":CheckID", OracleType.NVarChar, 50)
{
Value = bloodOxygen.CheckID
},
new OracleParameter(":Name", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Name
},
new OracleParameter(":SexId", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Sex
},
new OracleParameter(":Age", OracleType.Int32, 4)
{
Value = bloodOxygen.Age
},
new OracleParameter(":Doctor", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Doctor
},
new OracleParameter(":DeviceID", OracleType.NVarChar, 50)
{
Value = bloodOxygen.DeviceID
},
new OracleParameter(":Version", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Version
},
new OracleParameter(":Reserve", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Reserve
},
new OracleParameter(":Check_flagId", OracleType.Int32, 4)
{
Value = bloodOxygen.Check_flag
},
new OracleParameter(":Hosname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Hosname
},
new OracleParameter(":Auditdoctor", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Auditdoctor
},
new OracleParameter(":Auditdate", OracleType.DateTime, 8)
{
Value = bloodOxygen.Auditdate
},
new OracleParameter(":StatusId", OracleType.Int32, 4)
{
Value = bloodOxygen.Status
},
new OracleParameter(":Str1", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str1
},
new OracleParameter(":Str2", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str2
},
new OracleParameter(":Str3", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str3
},
new OracleParameter(":Str4", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str4
},
new OracleParameter(":Str5", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str5
},
new OracleParameter(":Str6", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str6
},
new OracleParameter(":Str7", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str7
},
new OracleParameter(":Str8", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str8
},
new OracleParameter(":Str9", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str9
},
new OracleParameter(":Str10", OracleType.NVarChar, 50)
{
Value = bloodOxygen.Str10
},
new OracleParameter(":T3001005_ename", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_ename
},
new OracleParameter(":T3001005_cname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_cname
},
new OracleParameter(":T3001005_unit", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001005_unit
},
new OracleParameter(":T3001005_srange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_srange
},
new OracleParameter(":T3001005_lrange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_lrange
},
new OracleParameter(":T3001005_value", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001005_value
},
new OracleParameter(":T3001009_ename", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_ename
},
new OracleParameter(":T3001009_cname", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_cname
},
new OracleParameter(":T3001009_unit", OracleType.NVarChar, 50)
{
Value = bloodOxygen.T3001009_unit
},
new OracleParameter(":T3001009_srange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_srange
},
new OracleParameter(":T3001009_lrange", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_lrange
},
new OracleParameter(":T3001009_value", OracleType.Int32, 4)
{
Value = bloodOxygen.T3001009_value
},
new OracleParameter(":Id", OracleType.Int32, 4)
{
Value = bloodOxygen.Id
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 从DataReader中读取数据，并为BloodOxygen对象的所有属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param>
protected void ReadBloodOxygenAllData(IDataReader dataReader, BloodOxygen bloodOxygen)
{
// 编号
if (dataReader["Id"] != DBNull.Value)
{
bloodOxygen.Id = Convert.ToInt32(dataReader["Id"]);
}
// 检查日期
if (dataReader["Checkdate"] != DBNull.Value)
{
bloodOxygen.Checkdate = Convert.ToDateTime(dataReader["Checkdate"]);
}
// 门诊号
if (dataReader["ExamNo"] != DBNull.Value)
{
bloodOxygen.ExamNo = Convert.ToString(dataReader["ExamNo"]);
}
// 检查号
if (dataReader["CheckID"] != DBNull.Value)
{
bloodOxygen.CheckID = Convert.ToString(dataReader["CheckID"]);
}
// 姓名
if (dataReader["Name"] != DBNull.Value)
{
bloodOxygen.Name = Convert.ToString(dataReader["Name"]);
}
// 性别
if (dataReader["SexId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Sex = T_Sex.GetDataById(Convert.ToString(dataReader["SexId"])) ?? T_Sex.Empty;
}
// 年龄
if (dataReader["Age"] != DBNull.Value)
{
bloodOxygen.Age = Convert.ToInt32(dataReader["Age"]);
}
// 开单医生
if (dataReader["Doctor"] != DBNull.Value)
{
bloodOxygen.Doctor = Convert.ToString(dataReader["Doctor"]);
}
// 设备号
if (dataReader["DeviceID"] != DBNull.Value)
{
bloodOxygen.DeviceID = Convert.ToString(dataReader["DeviceID"]);
}
// 版本号
if (dataReader["Version"] != DBNull.Value)
{
bloodOxygen.Version = Convert.ToString(dataReader["Version"]);
}
// 保留字段
if (dataReader["Reserve"] != DBNull.Value)
{
bloodOxygen.Reserve = Convert.ToString(dataReader["Reserve"]);
}
// 检查标记
if (dataReader["Check_flagId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Check_flag = T_Check_Flag.GetDataById(Convert.ToInt32(dataReader["Check_flagId"])) ?? T_Check_Flag.Empty;
}
// 医院
if (dataReader["Hosname"] != DBNull.Value)
{
bloodOxygen.Hosname = Convert.ToString(dataReader["Hosname"]);
}
// 审核医生
if (dataReader["Auditdoctor"] != DBNull.Value)
{
bloodOxygen.Auditdoctor = Convert.ToString(dataReader["Auditdoctor"]);
}
// 审核日期
if (dataReader["Auditdate"] != DBNull.Value)
{
bloodOxygen.Auditdate = Convert.ToDateTime(dataReader["Auditdate"]);
}
// 状态
if (dataReader["StatusId"] != DBNull.Value)
{
//参照完整性捆绑对象
bloodOxygen.Status = T_Status.GetDataById(Convert.ToInt32(dataReader["StatusId"])) ?? T_Status.Empty;
}
// 心电诊断
if (dataReader["Str1"] != DBNull.Value)
{
bloodOxygen.Str1 = Convert.ToString(dataReader["Str1"]);
}
// 冗余
if (dataReader["Str2"] != DBNull.Value)
{
bloodOxygen.Str2 = Convert.ToString(dataReader["Str2"]);
}
// 身份证号
if (dataReader["Str3"] != DBNull.Value)
{
bloodOxygen.Str3 = Convert.ToString(dataReader["Str3"]);
}
// 冗余
if (dataReader["Str4"] != DBNull.Value)
{
bloodOxygen.Str4 = Convert.ToString(dataReader["Str4"]);
}
// 冗余
if (dataReader["Str5"] != DBNull.Value)
{
bloodOxygen.Str5 = Convert.ToString(dataReader["Str5"]);
}
// 冗余
if (dataReader["Str6"] != DBNull.Value)
{
bloodOxygen.Str6 = Convert.ToString(dataReader["Str6"]);
}
// 冗余
if (dataReader["Str7"] != DBNull.Value)
{
bloodOxygen.Str7 = Convert.ToString(dataReader["Str7"]);
}
// 冗余
if (dataReader["Str8"] != DBNull.Value)
{
bloodOxygen.Str8 = Convert.ToString(dataReader["Str8"]);
}
// 冗余
if (dataReader["Str9"] != DBNull.Value)
{
bloodOxygen.Str9 = Convert.ToString(dataReader["Str9"]);
}
// 冗余
if (dataReader["Str10"] != DBNull.Value)
{
bloodOxygen.Str10 = Convert.ToString(dataReader["Str10"]);
}
// 血氧简称
if (dataReader["T3001005_ename"] != DBNull.Value)
{
bloodOxygen.T3001005_ename = Convert.ToString(dataReader["T3001005_ename"]);
}
// 血氧全称
if (dataReader["T3001005_cname"] != DBNull.Value)
{
bloodOxygen.T3001005_cname = Convert.ToString(dataReader["T3001005_cname"]);
}
// 血氧UNIT
if (dataReader["T3001005_unit"] != DBNull.Value)
{
bloodOxygen.T3001005_unit = Convert.ToString(dataReader["T3001005_unit"]);
}
// 血氧上限
if (dataReader["T3001005_srange"] != DBNull.Value)
{
bloodOxygen.T3001005_srange = Convert.ToInt32(dataReader["T3001005_srange"]);
}
// 血氧下限
if (dataReader["T3001005_lrange"] != DBNull.Value)
{
bloodOxygen.T3001005_lrange = Convert.ToInt32(dataReader["T3001005_lrange"]);
}
// 血氧值
if (dataReader["T3001005_value"] != DBNull.Value)
{
bloodOxygen.T3001005_value = Convert.ToInt32(dataReader["T3001005_value"]);
}
// 脉率简称
if (dataReader["T3001009_ename"] != DBNull.Value)
{
bloodOxygen.T3001009_ename = Convert.ToString(dataReader["T3001009_ename"]);
}
// 脉率全称
if (dataReader["T3001009_cname"] != DBNull.Value)
{
bloodOxygen.T3001009_cname = Convert.ToString(dataReader["T3001009_cname"]);
}
// UNIT(BPM)
if (dataReader["T3001009_unit"] != DBNull.Value)
{
bloodOxygen.T3001009_unit = Convert.ToString(dataReader["T3001009_unit"]);
}
// 脉率上限
if (dataReader["T3001009_srange"] != DBNull.Value)
{
bloodOxygen.T3001009_srange = Convert.ToInt32(dataReader["T3001009_srange"]);
}
// 脉率下限
if (dataReader["T3001009_lrange"] != DBNull.Value)
{
bloodOxygen.T3001009_lrange = Convert.ToInt32(dataReader["T3001009_lrange"]);
}
// 脉率值
if (dataReader["T3001009_value"] != DBNull.Value)
{
bloodOxygen.T3001009_value = Convert.ToInt32(dataReader["T3001009_value"]);
}
}
/// <summary> /// 将血氧检测类（BloodOxygen）数据，根据主键“编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。 /// </summary> /// <param name="bloodOxygen">血氧检测类（BloodOxygen）实例对象</param> public abstract int Update(BloodOxygen bloodOxygen);
