/// <summary>
/// 根据现存健康问题表（MajorProblems）的主键“体检编号（CheckId）”从数据库中获取现存健康问题表（MajorProblems）的实例。
/// 成功从数据库中取得记录返回新现存健康问题表（MajorProblems）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="checkId">现存健康问题表（MajorProblems）的主键“体检编号（CheckId）”</param>
public override MajorProblems GetDataByCheckId(int checkId)
{
MajorProblems majorProblems = null;
string sqlText = "SELECT [CheckId],[CerebrovascularDiseaseId],[KidneyDiseaseId],[HeartDiseaseId],[VascularDiseaseId],[EyeDiseaseId],"
+ "[DiseasesOfTheNervousSystem],[OtherSystemDiseases],[HospitalizationIs],[MainMedications],[IPVHistory],[HealthAssessment],[Guidance],[RiskControlSuggestions] "
+ "FROM [MajorProblems] "
+ "WHERE [CheckId]=@CheckId";
SqlParameter[] parameters =
{
new SqlParameter("@CheckId", SqlDbType.Int, 4)
{
Value = checkId
}
};
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, parameters);
if (sqlDataReader.Read())
{
majorProblems = new MajorProblems();
ReadMajorProblemsAllData(sqlDataReader, majorProblems);
}
sqlDataReader.Close();
return(majorProblems);
}
/// <summary>
/// 根据现存健康问题表（MajorProblems）的主键“体检编号（CheckId）”从数据库中获取现存健康问题表（MajorProblems）的实例。
/// 成功从数据库中取得记录返回新现存健康问题表（MajorProblems）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="checkId">现存健康问题表（MajorProblems）的主键“体检编号（CheckId）”</param>
public override MajorProblems GetDataByCheckId(int checkId)
{
MajorProblems majorProblems = null;
string sqlText = "SELECT \"CheckId\",\"CerebrovascularDiseaseId\",\"KidneyDiseaseId\",\"HeartDiseaseId\",\"VascularDiseaseId\",\"EyeDiseaseId\","
+ "\"DiseasesOfTheNervousSystem\",\"OtherSystemDiseases\",\"HospitalizationIs\",\"MainMedications\",\"IPVHistory\",\"HealthAssessment\",\"Guidance\",\"RiskControlSuggestions\" "
+ "FROM \"MajorProblems\" "
+ "WHERE \"CheckId\"=:CheckId";
OracleParameter[] parameters =
{
new OracleParameter(":CheckId", OracleType.Int32, 4)
{
Value = checkId
}
};
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, parameters);
if (oracleDataReader.Read())
{
majorProblems = new MajorProblems();
ReadMajorProblemsAllData(oracleDataReader, majorProblems);
}
oracleDataReader.Close();
return(majorProblems);
}
/// <summary>
/// 对现存健康问题表（MajorProblems）实例对象，进行数据有效性检查。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public static void CheckValid(MajorProblems majorProblems)
{
#region 检查各属性是否符合空值约束
if (DataValid.IsNull(majorProblems.CheckId))
{
throw new CustomException("“体检编号”不能为空，请您确认输入是否正确。");
}
#endregion
#region 检查字符串是否超出规定长度
if (DataValid.IsOutLength(majorProblems.DiseasesOfTheNervousSystem, 50))
{
throw new CustomException("“神经系统疾病”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.OtherSystemDiseases, 50))
{
throw new CustomException("“其他系统疾病”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.HospitalizationIs, 50))
{
throw new CustomException("“住院治疗情况”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.MainMedications, 50))
{
throw new CustomException("“主要用药情况”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.IPVHistory, 50))
{
throw new CustomException("“非免疫规划预防接种史”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.HealthAssessment, 50))
{
throw new CustomException("“健康评价”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.Guidance, 50))
{
throw new CustomException("“健康指导”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(majorProblems.RiskControlSuggestions, 50))
{
throw new CustomException("“危险因素控制建议”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
#endregion
}
/// <summary>
/// 从数据库中读取并返回所有现存健康问题表（MajorProblems）List列表。
/// </summary>
public override List <MajorProblems> GetAllList()
{
string sqlText = "SELECT [CheckId],[CerebrovascularDiseaseId],[KidneyDiseaseId],[HeartDiseaseId],[VascularDiseaseId],[EyeDiseaseId],"
+ "[DiseasesOfTheNervousSystem],[OtherSystemDiseases],[HospitalizationIs],[MainMedications],[IPVHistory],[HealthAssessment],[Guidance],[RiskControlSuggestions] "
+ "FROM [MajorProblems]";
List <MajorProblems> list = new List <MajorProblems>();
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, null);
while (sqlDataReader.Read())
{
MajorProblems majorProblems = new MajorProblems();
ReadMajorProblemsAllData(sqlDataReader, majorProblems);
list.Add(majorProblems);
}
sqlDataReader.Close();
return(list);
}
/// <summary>
/// 从数据库中读取并返回所有现存健康问题表（MajorProblems）List列表。
/// </summary>
public override List <MajorProblems> GetAllList()
{
string sqlText = "SELECT \"CheckId\",\"CerebrovascularDiseaseId\",\"KidneyDiseaseId\",\"HeartDiseaseId\",\"VascularDiseaseId\",\"EyeDiseaseId\","
+ "\"DiseasesOfTheNervousSystem\",\"OtherSystemDiseases\",\"HospitalizationIs\",\"MainMedications\",\"IPVHistory\",\"HealthAssessment\",\"Guidance\",\"RiskControlSuggestions\" "
+ "FROM \"MajorProblems\"";
List <MajorProblems> list = new List <MajorProblems>();
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, null);
while (oracleDataReader.Read())
{
MajorProblems majorProblems = new MajorProblems();
ReadMajorProblemsAllData(oracleDataReader, majorProblems);
list.Add(majorProblems);
}
oracleDataReader.Close();
return(list);
}
/// <summary>
/// 从DataReader中读取数据，并为MajorProblems对象需要进行显示的属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
protected void ReadMajorProblemsPageData(IDataReader dataReader, MajorProblems majorProblems)
{
// 体检编号
if (dataReader["CheckId"] != DBNull.Value)
{
majorProblems.CheckId = Convert.ToInt32(dataReader["CheckId"]);
}
// 健康评价
if (dataReader["HealthAssessment"] != DBNull.Value)
{
majorProblems.HealthAssessment = Convert.ToString(dataReader["HealthAssessment"]);
}
// 危险因素控制建议
if (dataReader["RiskControlSuggestions"] != DBNull.Value)
{
majorProblems.RiskControlSuggestions = Convert.ToString(dataReader["RiskControlSuggestions"]);
}
}
/// <summary>
/// 根据每页记录数及所要获取的页数，从数据库中读取并返回经过分页后的现存健康问题表（MajorProblems）的列表及分页信息。
/// 该方法所获取的现存健康问题表（MajorProblems）列表仅用于在数据控件中显示，该方法只为对象中需要显示的属性进行赋值。
/// </summary>
public override PageData GetPageList(int pageSize, int curPage)
{
string sqlText = "SELECT [CheckId],[HealthAssessment],[RiskControlSuggestions] "
+ "FROM [MajorProblems]";
List <MajorProblems> list = new List <MajorProblems>();
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)
{
MajorProblems majorProblems = new MajorProblems();
ReadMajorProblemsPageData(sqlDataReader, majorProblems);
list.Add(majorProblems);
}
}
sqlDataReader.Close();
if (pageData.RecordCount > 0)
{
pageData.PageCount = Convert.ToInt32(Math.Ceiling((double)pageData.RecordCount / (double)pageSize));
}
pageData.PageList = list;
return(pageData);
}
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，根据主键“体检编号（CheckId）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public static int Update(MajorProblems majorProblems)
{
CheckValid(majorProblems);
return(DataAccess.Update(majorProblems));
}
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public static int Insert(MajorProblems majorProblems)
{
CheckValid(majorProblems);
return(DataAccess.Insert(majorProblems));
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public override int Insert(MajorProblems majorProblems)
{
string sqlText = "INSERT INTO [MajorProblems]"
+ "([CheckId],[CerebrovascularDiseaseId],[KidneyDiseaseId],[HeartDiseaseId],[VascularDiseaseId],[EyeDiseaseId],"
+ "[DiseasesOfTheNervousSystem],[OtherSystemDiseases],[HospitalizationIs],[MainMedications],[IPVHistory],[HealthAssessment],[Guidance],[RiskControlSuggestions])"
+ "VALUES"
+ "(@CheckId,@CerebrovascularDiseaseId,@KidneyDiseaseId,@HeartDiseaseId,@VascularDiseaseId,@EyeDiseaseId,"
+ "@DiseasesOfTheNervousSystem,@OtherSystemDiseases,@HospitalizationIs,@MainMedications,@IPVHistory,@HealthAssessment,@Guidance,@RiskControlSuggestions)";
SqlParameter[] parameters =
{
new SqlParameter("@CheckId", SqlDbType.Int, 4)
{
Value = majorProblems.CheckId
},
new SqlParameter("@CerebrovascularDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.CerebrovascularDisease.Id
},
new SqlParameter("@KidneyDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.KidneyDisease.Id
},
new SqlParameter("@HeartDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.HeartDisease.Id
},
new SqlParameter("@VascularDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.VascularDisease.Id
},
new SqlParameter("@EyeDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.EyeDisease.Id
},
new SqlParameter("@DiseasesOfTheNervousSystem", SqlDbType.NVarChar, 50)
{
Value = majorProblems.DiseasesOfTheNervousSystem
},
new SqlParameter("@OtherSystemDiseases", SqlDbType.NVarChar, 50)
{
Value = majorProblems.OtherSystemDiseases
},
new SqlParameter("@HospitalizationIs", SqlDbType.NVarChar, 50)
{
Value = majorProblems.HospitalizationIs
},
new SqlParameter("@MainMedications", SqlDbType.NVarChar, 50)
{
Value = majorProblems.MainMedications
},
new SqlParameter("@IPVHistory", SqlDbType.NVarChar, 50)
{
Value = majorProblems.IPVHistory
},
new SqlParameter("@HealthAssessment", SqlDbType.NVarChar, 50)
{
Value = majorProblems.HealthAssessment
},
new SqlParameter("@Guidance", SqlDbType.NVarChar, 50)
{
Value = majorProblems.Guidance
},
new SqlParameter("@RiskControlSuggestions", SqlDbType.NVarChar, 50)
{
Value = majorProblems.RiskControlSuggestions
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，根据主键“体检编号（CheckId）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public override int Update(MajorProblems majorProblems)
{
string sqlText = "UPDATE [MajorProblems] SET "
+ "[CerebrovascularDiseaseId]=@CerebrovascularDiseaseId,[KidneyDiseaseId]=@KidneyDiseaseId,[HeartDiseaseId]=@HeartDiseaseId,"
+ "[VascularDiseaseId]=@VascularDiseaseId,[EyeDiseaseId]=@EyeDiseaseId,[DiseasesOfTheNervousSystem]=@DiseasesOfTheNervousSystem,"
+ "[OtherSystemDiseases]=@OtherSystemDiseases,[HospitalizationIs]=@HospitalizationIs,[MainMedications]=@MainMedications,[IPVHistory]=@IPVHistory,"
+ "[HealthAssessment]=@HealthAssessment,[Guidance]=@Guidance,[RiskControlSuggestions]=@RiskControlSuggestions "
+ "WHERE [CheckId]=@CheckId";
SqlParameter[] parameters =
{
new SqlParameter("@CerebrovascularDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.CerebrovascularDisease.Id
},
new SqlParameter("@KidneyDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.KidneyDisease.Id
},
new SqlParameter("@HeartDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.HeartDisease.Id
},
new SqlParameter("@VascularDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.VascularDisease.Id
},
new SqlParameter("@EyeDiseaseId", SqlDbType.Int, 4)
{
Value = majorProblems.EyeDisease.Id
},
new SqlParameter("@DiseasesOfTheNervousSystem", SqlDbType.NVarChar, 50)
{
Value = majorProblems.DiseasesOfTheNervousSystem
},
new SqlParameter("@OtherSystemDiseases", SqlDbType.NVarChar, 50)
{
Value = majorProblems.OtherSystemDiseases
},
new SqlParameter("@HospitalizationIs", SqlDbType.NVarChar, 50)
{
Value = majorProblems.HospitalizationIs
},
new SqlParameter("@MainMedications", SqlDbType.NVarChar, 50)
{
Value = majorProblems.MainMedications
},
new SqlParameter("@IPVHistory", SqlDbType.NVarChar, 50)
{
Value = majorProblems.IPVHistory
},
new SqlParameter("@HealthAssessment", SqlDbType.NVarChar, 50)
{
Value = majorProblems.HealthAssessment
},
new SqlParameter("@Guidance", SqlDbType.NVarChar, 50)
{
Value = majorProblems.Guidance
},
new SqlParameter("@RiskControlSuggestions", SqlDbType.NVarChar, 50)
{
Value = majorProblems.RiskControlSuggestions
},
new SqlParameter("@CheckId", SqlDbType.Int, 4)
{
Value = majorProblems.CheckId
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 从DataReader中读取数据，并为MajorProblems对象的所有属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
protected void ReadMajorProblemsAllData(IDataReader dataReader, MajorProblems majorProblems)
{
// 体检编号
if (dataReader["CheckId"] != DBNull.Value)
{
majorProblems.CheckId = Convert.ToInt32(dataReader["CheckId"]);
}
// 脑血管疾病
if (dataReader["CerebrovascularDiseaseId"] != DBNull.Value)
{
//参照完整性捆绑子对象
majorProblems.CerebrovascularDisease = T_CerebrovascularDisease.GetDataById(Convert.ToInt32(dataReader["CerebrovascularDiseaseId"])) ?? T_CerebrovascularDisease.Empty;
}
// 肾脏疾病
if (dataReader["KidneyDiseaseId"] != DBNull.Value)
{
//参照完整性捆绑子对象
majorProblems.KidneyDisease = T_KidneyDisease.GetDataById(Convert.ToInt32(dataReader["KidneyDiseaseId"])) ?? T_KidneyDisease.Empty;
}
// 心脏疾病
if (dataReader["HeartDiseaseId"] != DBNull.Value)
{
//参照完整性捆绑子对象
majorProblems.HeartDisease = T_HeartDisease.GetDataById(Convert.ToInt32(dataReader["HeartDiseaseId"])) ?? T_HeartDisease.Empty;
}
// 血管疾病
if (dataReader["VascularDiseaseId"] != DBNull.Value)
{
//参照完整性捆绑子对象
majorProblems.VascularDisease = T_VascularDisease.GetDataById(Convert.ToInt32(dataReader["VascularDiseaseId"])) ?? T_VascularDisease.Empty;
}
// 眼部疾病
if (dataReader["EyeDiseaseId"] != DBNull.Value)
{
//参照完整性捆绑子对象
majorProblems.EyeDisease = T_EyeDisease.GetDataById(Convert.ToInt32(dataReader["EyeDiseaseId"])) ?? T_EyeDisease.Empty;
}
// 神经系统疾病
if (dataReader["DiseasesOfTheNervousSystem"] != DBNull.Value)
{
majorProblems.DiseasesOfTheNervousSystem = Convert.ToString(dataReader["DiseasesOfTheNervousSystem"]);
}
// 其他系统疾病
if (dataReader["OtherSystemDiseases"] != DBNull.Value)
{
majorProblems.OtherSystemDiseases = Convert.ToString(dataReader["OtherSystemDiseases"]);
}
// 住院治疗情况
if (dataReader["HospitalizationIs"] != DBNull.Value)
{
majorProblems.HospitalizationIs = Convert.ToString(dataReader["HospitalizationIs"]);
}
// 主要用药情况
if (dataReader["MainMedications"] != DBNull.Value)
{
majorProblems.MainMedications = Convert.ToString(dataReader["MainMedications"]);
}
// 非免疫规划预防接种史
if (dataReader["IPVHistory"] != DBNull.Value)
{
majorProblems.IPVHistory = Convert.ToString(dataReader["IPVHistory"]);
}
// 健康评价
if (dataReader["HealthAssessment"] != DBNull.Value)
{
majorProblems.HealthAssessment = Convert.ToString(dataReader["HealthAssessment"]);
}
// 健康指导
if (dataReader["Guidance"] != DBNull.Value)
{
majorProblems.Guidance = Convert.ToString(dataReader["Guidance"]);
}
// 危险因素控制建议
if (dataReader["RiskControlSuggestions"] != DBNull.Value)
{
majorProblems.RiskControlSuggestions = Convert.ToString(dataReader["RiskControlSuggestions"]);
}
}
/// <summary> /// 将现存健康问题表（MajorProblems）数据，根据主键“体检编号（CheckId）”采用UPDATE操作更新到数据库中，并返回受影响的行数。 /// </summary> /// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param> public abstract int Update(MajorProblems majorProblems);
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 公共数据访问类抽象方法定义，在SqlServer/Oracle/OleDb子类中实现具体方法。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public abstract int Insert(MajorProblems majorProblems);
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public override int Insert(MajorProblems majorProblems)
{
string sqlText = "INSERT INTO \"MajorProblems\""
+ "(\"CheckId\",\"CerebrovascularDiseaseId\",\"KidneyDiseaseId\",\"HeartDiseaseId\",\"VascularDiseaseId\",\"EyeDiseaseId\","
+ "\"DiseasesOfTheNervousSystem\",\"OtherSystemDiseases\",\"HospitalizationIs\",\"MainMedications\",\"IPVHistory\",\"HealthAssessment\",\"Guidance\",\"RiskControlSuggestions\")"
+ "VALUES"
+ "(:CheckId,:CerebrovascularDiseaseId,:KidneyDiseaseId,:HeartDiseaseId,:VascularDiseaseId,:EyeDiseaseId,"
+ ":DiseasesOfTheNervousSystem,:OtherSystemDiseases,:HospitalizationIs,:MainMedications,:IPVHistory,:HealthAssessment,:Guidance,:RiskControlSuggestions)";
OracleParameter[] parameters =
{
new OracleParameter(":CheckId", OracleType.Int32, 4)
{
Value = majorProblems.CheckId
},
new OracleParameter(":CerebrovascularDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.CerebrovascularDisease
},
new OracleParameter(":KidneyDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.KidneyDisease
},
new OracleParameter(":HeartDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.HeartDisease
},
new OracleParameter(":VascularDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.VascularDisease
},
new OracleParameter(":EyeDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.EyeDisease
},
new OracleParameter(":DiseasesOfTheNervousSystem", OracleType.NVarChar, 50)
{
Value = majorProblems.DiseasesOfTheNervousSystem
},
new OracleParameter(":OtherSystemDiseases", OracleType.NVarChar, 50)
{
Value = majorProblems.OtherSystemDiseases
},
new OracleParameter(":HospitalizationIs", OracleType.NVarChar, 50)
{
Value = majorProblems.HospitalizationIs
},
new OracleParameter(":MainMedications", OracleType.NVarChar, 50)
{
Value = majorProblems.MainMedications
},
new OracleParameter(":IPVHistory", OracleType.NVarChar, 50)
{
Value = majorProblems.IPVHistory
},
new OracleParameter(":HealthAssessment", OracleType.NVarChar, 50)
{
Value = majorProblems.HealthAssessment
},
new OracleParameter(":Guidance", OracleType.NVarChar, 50)
{
Value = majorProblems.Guidance
},
new OracleParameter(":RiskControlSuggestions", OracleType.NVarChar, 50)
{
Value = majorProblems.RiskControlSuggestions
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 将现存健康问题表（MajorProblems）数据，根据主键“体检编号（CheckId）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="majorProblems">现存健康问题表（MajorProblems）实例对象</param>
public override int Update(MajorProblems majorProblems)
{
string sqlText = "UPDATE \"MajorProblems\" SET "
+ "\"CheckId\"=:CheckId,\"CerebrovascularDiseaseId\"=:CerebrovascularDiseaseId,\"KidneyDiseaseId\"=:KidneyDiseaseId,"
+ "\"HeartDiseaseId\"=:HeartDiseaseId,\"VascularDiseaseId\"=:VascularDiseaseId,\"EyeDiseaseId\"=:EyeDiseaseId,\"DiseasesOfTheNervousSystem\"=:DiseasesOfTheNervousSystem,"
+ "\"OtherSystemDiseases\"=:OtherSystemDiseases,\"HospitalizationIs\"=:HospitalizationIs,\"MainMedications\"=:MainMedications,\"IPVHistory\"=:IPVHistory,"
+ "\"HealthAssessment\"=:HealthAssessment,\"Guidance\"=:Guidance,\"RiskControlSuggestions\"=:RiskControlSuggestions "
+ "WHERE \"CheckId\"=:CheckId";
OracleParameter[] parameters =
{
new OracleParameter(":CheckId", OracleType.Int32, 4)
{
Value = majorProblems.CheckId
},
new OracleParameter(":CerebrovascularDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.CerebrovascularDisease
},
new OracleParameter(":KidneyDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.KidneyDisease
},
new OracleParameter(":HeartDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.HeartDisease
},
new OracleParameter(":VascularDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.VascularDisease
},
new OracleParameter(":EyeDiseaseId", OracleType.Int32, 4)
{
Value = majorProblems.EyeDisease
},
new OracleParameter(":DiseasesOfTheNervousSystem", OracleType.NVarChar, 50)
{
Value = majorProblems.DiseasesOfTheNervousSystem
},
new OracleParameter(":OtherSystemDiseases", OracleType.NVarChar, 50)
{
Value = majorProblems.OtherSystemDiseases
},
new OracleParameter(":HospitalizationIs", OracleType.NVarChar, 50)
{
Value = majorProblems.HospitalizationIs
},
new OracleParameter(":MainMedications", OracleType.NVarChar, 50)
{
Value = majorProblems.MainMedications
},
new OracleParameter(":IPVHistory", OracleType.NVarChar, 50)
{
Value = majorProblems.IPVHistory
},
new OracleParameter(":HealthAssessment", OracleType.NVarChar, 50)
{
Value = majorProblems.HealthAssessment
},
new OracleParameter(":Guidance", OracleType.NVarChar, 50)
{
Value = majorProblems.Guidance
},
new OracleParameter(":RiskControlSuggestions", OracleType.NVarChar, 50)
{
Value = majorProblems.RiskControlSuggestions
},
new OracleParameter(":CheckId", OracleType.Int32, 4)
{
Value = majorProblems.CheckId
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
