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);