/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RecordsHealthConditionModel model, string outKey)
{
return(dal.Add(model, outKey));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(RecordsHealthConditionModel model, string outKey)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO ARCHIVE_HEALTH_CONDITION(");
strSql.Append("IDCardNo,FamilyHistory,FamilyHistoryOther,FoodAllergy,OtherAllergy,DrugAllergy,AllergyHistory,HealthStatus,SickStats,HypertensionOld,HypertensionAdvice,HypertensionInterrupt,HypertensionInterruptMonth,DiabetesOld,DiabetesAdvice,DiabetesInterrupt,DiabetesInterruptMonth,CerebralIschemia,CerebralIschemiaSum,CerebralIschemiaStartOld,CerebralIschemiaStartMonth,CerebralIschemiaEndOld,CerebralIschemiaEndMonth,CerebralHemorrhage,CerebralHemorrhageSum,CerebralHemorrhageStartOld,CerebralHemorrhageStartMonth,CerebralHemorrhageEndOld,CerebralHemorrhageEndMonth,CerebralTIA,CerebralTIASum,CerebralTIAStartOld,CerebralTIAStartMonth,CerebralTIAEndOld,CerebralTIAEndMonth,SubarachnoidHemorrhage,MiocardialInfarction,MiocardialInfarctionSum,MiocardialInfarctionStartOld,MiocardialInfarctionStartMonth,MiocardialInfarctionEndOld,MiocardialInfarctionEndMonth,HeartDisease,Kidney,BloodVessel,EyeDiseases,Other,OtherValue,OutKey)");
strSql.Append(" VALUES (");
strSql.Append("@IDCardNo,@FamilyHistory,@FamilyHistoryOther,@FoodAllergy,@OtherAllergy,@DrugAllergy,@AllergyHistory,@HealthStatus,@SickStats,@HypertensionOld,@HypertensionAdvice,@HypertensionInterrupt,@HypertensionInterruptMonth,@DiabetesOld,@DiabetesAdvice,@DiabetesInterrupt,@DiabetesInterruptMonth,@CerebralIschemia,@CerebralIschemiaSum,@CerebralIschemiaStartOld,@CerebralIschemiaStartMonth,@CerebralIschemiaEndOld,@CerebralIschemiaEndMonth,@CerebralHemorrhage,@CerebralHemorrhageSum,@CerebralHemorrhageStartOld,@CerebralHemorrhageStartMonth,@CerebralHemorrhageEndOld,@CerebralHemorrhageEndMonth,@CerebralTIA,@CerebralTIASum,@CerebralTIAStartOld,@CerebralTIAStartMonth,@CerebralTIAEndOld,@CerebralTIAEndMonth,@SubarachnoidHemorrhage,@MiocardialInfarction,@MiocardialInfarctionSum,@MiocardialInfarctionStartOld,@MiocardialInfarctionStartMonth,@MiocardialInfarctionEndOld,@MiocardialInfarctionEndMonth,@HeartDisease,@Kidney,@BloodVessel,@EyeDiseases,@Other,@OtherValue,@OutKey)");
MySqlParameter[] parameters =
{
new MySqlParameter("@OutKey", MySqlDbType.Int32, 11),
new MySqlParameter("@IDCardNo", MySqlDbType.VarChar, 21),
new MySqlParameter("@FamilyHistory", MySqlDbType.VarChar, 50),
new MySqlParameter("@FamilyHistoryOther", MySqlDbType.VarChar, 50),
new MySqlParameter("@FoodAllergy", MySqlDbType.VarChar, 255),
new MySqlParameter("@OtherAllergy", MySqlDbType.VarChar, 255),
new MySqlParameter("@DrugAllergy", MySqlDbType.VarChar, 255),
new MySqlParameter("@AllergyHistory", MySqlDbType.VarChar, 50),
new MySqlParameter("@HealthStatus", MySqlDbType.VarChar, 50),
new MySqlParameter("@SickStats", MySqlDbType.VarChar, 1),
new MySqlParameter("@HypertensionOld", MySqlDbType.VarChar, 50),
new MySqlParameter("@HypertensionAdvice", MySqlDbType.VarChar, 1),
new MySqlParameter("@HypertensionInterrupt", MySqlDbType.VarChar, 1),
new MySqlParameter("@HypertensionInterruptMonth", MySqlDbType.VarChar, 50),
new MySqlParameter("@DiabetesOld", MySqlDbType.VarChar, 50),
new MySqlParameter("@DiabetesAdvice", MySqlDbType.VarChar, 1),
new MySqlParameter("@DiabetesInterrupt", MySqlDbType.VarChar, 1),
new MySqlParameter("@DiabetesInterruptMonth", MySqlDbType.VarChar, 50),
new MySqlParameter("@CerebralIschemia", MySqlDbType.VarChar, 1),
new MySqlParameter("@CerebralIschemiaSum", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralIschemiaStartOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralIschemiaStartMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralIschemiaEndOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralIschemiaEndMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralHemorrhage", MySqlDbType.VarChar, 1),
new MySqlParameter("@CerebralHemorrhageSum", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralHemorrhageStartOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralHemorrhageStartMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralHemorrhageEndOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralHemorrhageEndMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralTIA", MySqlDbType.VarChar, 1),
new MySqlParameter("@CerebralTIASum", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralTIAStartOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralTIAStartMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralTIAEndOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@CerebralTIAEndMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@SubarachnoidHemorrhage", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarction", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarctionSum", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarctionStartOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarctionStartMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarctionEndOld", MySqlDbType.VarChar, 10),
new MySqlParameter("@MiocardialInfarctionEndMonth", MySqlDbType.VarChar, 10),
new MySqlParameter("@HeartDisease", MySqlDbType.VarChar, 10),
new MySqlParameter("@Kidney", MySqlDbType.VarChar, 50),
new MySqlParameter("@BloodVessel", MySqlDbType.VarChar, 50),
new MySqlParameter("@EyeDiseases", MySqlDbType.VarChar, 50),
new MySqlParameter("@Other", MySqlDbType.VarChar, 50),
new MySqlParameter("@OtherValue", MySqlDbType.VarChar, 50)
};
parameters[0].Value = outKey;
parameters[1].Value = model.IDCardNo;
parameters[2].Value = model.FamilyHistory;
parameters[3].Value = model.FamilyHistoryOther;
parameters[4].Value = model.FoodAllergy;
parameters[5].Value = model.OtherAllergy;
parameters[6].Value = model.DrugAllergy;
parameters[7].Value = model.AllergyHistory;
parameters[8].Value = model.HealthStatus;
parameters[9].Value = model.SickStats;
parameters[10].Value = model.HypertensionOld;
parameters[11].Value = model.HypertensionAdvice;
parameters[12].Value = model.HypertensionInterrupt;
parameters[13].Value = model.HypertensionInterruptMonth;
parameters[14].Value = model.DiabetesOld;
parameters[15].Value = model.DiabetesAdvice;
parameters[16].Value = model.DiabetesInterrupt;
parameters[17].Value = model.DiabetesInterruptMonth;
parameters[18].Value = model.CerebralIschemia;
parameters[19].Value = model.CerebralIschemiaSum;
parameters[20].Value = model.CerebralIschemiaStartOld;
parameters[21].Value = model.CerebralIschemiaStartMonth;
parameters[22].Value = model.CerebralIschemiaEndOld;
parameters[23].Value = model.CerebralIschemiaEndMonth;
parameters[24].Value = model.CerebralHemorrhage;
parameters[25].Value = model.CerebralHemorrhageSum;
parameters[26].Value = model.CerebralHemorrhageStartOld;
parameters[27].Value = model.CerebralHemorrhageStartMonth;
parameters[28].Value = model.CerebralHemorrhageEndOld;
parameters[29].Value = model.CerebralHemorrhageEndMonth;
parameters[30].Value = model.CerebralTIA;
parameters[31].Value = model.CerebralTIASum;
parameters[32].Value = model.CerebralTIAStartOld;
parameters[33].Value = model.CerebralTIAStartMonth;
parameters[34].Value = model.CerebralTIAEndOld;
parameters[35].Value = model.CerebralTIAEndMonth;
parameters[36].Value = model.SubarachnoidHemorrhage;
parameters[37].Value = model.MiocardialInfarction;
parameters[38].Value = model.MiocardialInfarctionSum;
parameters[39].Value = model.MiocardialInfarctionStartOld;
parameters[40].Value = model.MiocardialInfarctionStartMonth;
parameters[41].Value = model.MiocardialInfarctionEndOld;
parameters[42].Value = model.MiocardialInfarctionEndMonth;
parameters[43].Value = model.HeartDisease;
parameters[44].Value = model.Kidney;
parameters[45].Value = model.BloodVessel;
parameters[46].Value = model.EyeDiseases;
parameters[47].Value = model.Other;
parameters[48].Value = model.OtherValue;
int rows = MySQLHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateByMiniPad(RecordsHealthConditionModel model, string OutKey)
{
return(this.dal.UpdateByMiniPad(model, OutKey));
}
public bool UpdateByMiniPad(RecordsHealthConditionModel model, string OutKey)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE ARCHIVE_HEALTH_CONDITION SET ");
strSql.Append("FamilyHistory=@FamilyHistory,");
strSql.Append("FamilyHistoryOther=@FamilyHistoryOther,");
strSql.Append("FoodAllergy=@FoodAllergy,");
strSql.Append("OtherAllergy=@OtherAllergy,");
strSql.Append("DrugAllergy=@DrugAllergy,");
strSql.Append("AllergyHistory=@AllergyHistory,");
strSql.Append("HealthStatus=@HealthStatus,");
strSql.Append("SickStats=@SickStats,");
strSql.Append("HypertensionOld=@HypertensionOld,");
strSql.Append("HypertensionAdvice=@HypertensionAdvice,");
strSql.Append("HypertensionInterrupt=@HypertensionInterrupt,");
strSql.Append("HypertensionInterruptMonth=@HypertensionInterruptMonth,");
strSql.Append("DiabetesOld=@DiabetesOld,");
strSql.Append("DiabetesAdvice=@DiabetesAdvice,");
strSql.Append("DiabetesInterrupt=@DiabetesInterrupt,");
strSql.Append("DiabetesInterruptMonth=@DiabetesInterruptMonth,");
strSql.Append("CerebralIschemia=@CerebralIschemia,");
strSql.Append("CerebralIschemiaSum=@CerebralIschemiaSum,");
strSql.Append("CerebralIschemiaStartOld=@CerebralIschemiaStartOld,");
strSql.Append("CerebralIschemiaStartMonth=@CerebralIschemiaStartMonth,");
strSql.Append("CerebralIschemiaEndOld=@CerebralIschemiaEndOld,");
strSql.Append("CerebralIschemiaEndMonth=@CerebralIschemiaEndMonth,");
strSql.Append("CerebralHemorrhage=@CerebralHemorrhage,");
strSql.Append("CerebralHemorrhageSum=@CerebralHemorrhageSum,");
strSql.Append("CerebralHemorrhageStartOld=@CerebralHemorrhageStartOld,");
strSql.Append("CerebralHemorrhageStartMonth=@CerebralHemorrhageStartMonth,");
strSql.Append("CerebralHemorrhageEndOld=@CerebralHemorrhageEndOld,");
strSql.Append("CerebralHemorrhageEndMonth=@CerebralHemorrhageEndMonth,");
strSql.Append("CerebralTIA=@CerebralTIA,");
strSql.Append("CerebralTIASum=@CerebralTIASum,");
strSql.Append("CerebralTIAStartOld=@CerebralTIAStartOld,");
strSql.Append("CerebralTIAStartMonth=@CerebralTIAStartMonth,");
strSql.Append("CerebralTIAEndOld=@CerebralTIAEndOld,");
strSql.Append("CerebralTIAEndMonth=@CerebralTIAEndMonth,");
strSql.Append("SubarachnoidHemorrhage=@SubarachnoidHemorrhage,");
strSql.Append("MiocardialInfarction=@MiocardialInfarction,");
strSql.Append("MiocardialInfarctionSum=@MiocardialInfarctionSum,");
strSql.Append("MiocardialInfarctionStartOld=@MiocardialInfarctionStartOld,");
strSql.Append("MiocardialInfarctionStartMonth=@MiocardialInfarctionStartMonth,");
strSql.Append("MiocardialInfarctionEndOld=@MiocardialInfarctionEndOld,");
strSql.Append("MiocardialInfarctionEndMonth=@MiocardialInfarctionEndMonth,");
strSql.Append("HeartDisease=@HeartDisease,");
strSql.Append("Kidney=@Kidney,");
strSql.Append("BloodVessel=@BloodVessel,");
strSql.Append("EyeDiseases=@EyeDiseases,");
strSql.Append("Other=@Other,");
strSql.Append("OtherValue=@OtherValue");
strSql.Append(@" WHERE OutKey=@OutKey AND IDCardNo=@IDCardNo;");
MySqlParameter[] parameters =
{
new MySqlParameter("@FamilyHistory", model.FamilyHistory),
new MySqlParameter("@FamilyHistoryOther", model.FamilyHistoryOther),
new MySqlParameter("@FoodAllergy", model.FoodAllergy),
new MySqlParameter("@OtherAllergy", model.OtherAllergy),
new MySqlParameter("@DrugAllergy", model.DrugAllergy),
new MySqlParameter("@AllergyHistory", model.AllergyHistory),
new MySqlParameter("@HealthStatus", model.HealthStatus),
new MySqlParameter("@SickStats", model.SickStats),
new MySqlParameter("@HypertensionOld", model.HypertensionOld),
new MySqlParameter("@HypertensionAdvice", model.HypertensionAdvice),
new MySqlParameter("@HypertensionInterrupt", model.HypertensionInterrupt),
new MySqlParameter("@HypertensionInterruptMonth", model.HypertensionInterruptMonth),
new MySqlParameter("@DiabetesOld", model.DiabetesOld),
new MySqlParameter("@DiabetesAdvice", model.DiabetesAdvice),
new MySqlParameter("@DiabetesInterrupt", model.DiabetesInterrupt),
new MySqlParameter("@DiabetesInterruptMonth", model.DiabetesInterruptMonth),
new MySqlParameter("@CerebralIschemia", model.CerebralIschemia),
new MySqlParameter("@CerebralIschemiaSum", model.CerebralIschemiaSum),
new MySqlParameter("@CerebralIschemiaStartOld", model.CerebralIschemiaStartOld),
new MySqlParameter("@CerebralIschemiaStartMonth", model.CerebralIschemiaStartMonth),
new MySqlParameter("@CerebralIschemiaEndOld", model.CerebralIschemiaEndOld),
new MySqlParameter("@CerebralIschemiaEndMonth", model.CerebralIschemiaEndMonth),
new MySqlParameter("@CerebralHemorrhage", model.CerebralHemorrhage),
new MySqlParameter("@CerebralHemorrhageSum", model.CerebralHemorrhageSum),
new MySqlParameter("@CerebralHemorrhageStartOld", model.CerebralHemorrhageStartOld),
new MySqlParameter("@CerebralHemorrhageStartMonth", model.CerebralHemorrhageStartMonth),
new MySqlParameter("@CerebralHemorrhageEndOld", model.CerebralHemorrhageEndOld),
new MySqlParameter("@CerebralHemorrhageEndMonth", model.CerebralHemorrhageEndMonth),
new MySqlParameter("@CerebralTIA", model.CerebralTIA),
new MySqlParameter("@CerebralTIASum", model.CerebralTIASum),
new MySqlParameter("@CerebralTIAStartOld", model.CerebralTIAStartOld),
new MySqlParameter("@CerebralTIAStartMonth", model.CerebralTIAStartMonth),
new MySqlParameter("@CerebralTIAEndOld", model.CerebralTIAEndOld),
new MySqlParameter("@CerebralTIAEndMonth", model.CerebralTIAEndMonth),
new MySqlParameter("@SubarachnoidHemorrhage", model.SubarachnoidHemorrhage),
new MySqlParameter("@MiocardialInfarction", model.MiocardialInfarction),
new MySqlParameter("@MiocardialInfarctionSum", model.MiocardialInfarctionSum),
new MySqlParameter("@MiocardialInfarctionStartOld", model.MiocardialInfarctionStartOld),
new MySqlParameter("@MiocardialInfarctionStartMonth", model.MiocardialInfarctionStartMonth),
new MySqlParameter("@MiocardialInfarctionEndOld", model.MiocardialInfarctionEndOld),
new MySqlParameter("@MiocardialInfarctionEndMonth", model.MiocardialInfarctionEndMonth),
new MySqlParameter("@HeartDisease", model.HeartDisease),
new MySqlParameter("@Kidney", model.Kidney),
new MySqlParameter("@BloodVessel", model.BloodVessel),
new MySqlParameter("@EyeDiseases", model.EyeDiseases),
new MySqlParameter("@Other", model.Other),
new MySqlParameter("@OtherValue", model.OtherValue),
new MySqlParameter("@OutKey", OutKey),
new MySqlParameter("@IDCardNo", model.IDCardNo)
};
return(MySQLHelper.ExecuteSql(strSql.ToString(), parameters) > 0);
}