/// <summary>
/// 智力评估的新增
/// </summary>
/// <param name="model"></param>
/// <param name="OutKey"></param>
/// <returns></returns>
public int Add(OldIntelligenceModel model, string OutKey)
{
return(this.dal.Add(model, OutKey));
}
/// <summary>
/// 智力评估的新增
/// </summary>
/// <param name="model"></param>
/// <param name="OutKey"></param>
/// <returns></returns>
public int Add(OldIntelligenceModel model, string OutKey)
{
StringBuilder builder = new StringBuilder();
builder.Append(@"INSERT INTO tbl_OldIntelligence
(
IDCardNo
,DirectionalOne
,DirectionalTwo
,Memory
,Attention
,RecallAbility
,NamingAbility
,RetellAbility
,Comprehension
,ReadAbility
,WriteAbility
,StructureAbility
,TotalScore
,VisitDate
,VisitDoctor
,NextVisitDate
,CreatedBy
,CreatedDate
,LastUpDateBy
,LastUpDateDate
,OutKey
)
VALUES
(
@IDCardNo
,@DirectionalOne
,@DirectionalTwo
,@Memory
,@Attention
,@RecallAbility
,@NamingAbility
,@RetellAbility
,@Comprehension
,@ReadAbility
,@WriteAbility
,@StructureAbility
,@TotalScore
,@VisitDate
,@VisitDoctor
,@NextVisitDate
,@CreatedBy
,@CreatedDate
,@LastUpDateBy
,@LastUpDateDate
,@OutKey
) ");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@IDCardNo", MySqlDbType.String, 18),
new MySqlParameter("@DirectionalOne", MySqlDbType.Int32),
new MySqlParameter("@DirectionalTwo", MySqlDbType.Int32),
new MySqlParameter("@Memory", MySqlDbType.Int32),
new MySqlParameter("@Attention", MySqlDbType.Int32),
new MySqlParameter("@RecallAbility", MySqlDbType.Int32),
new MySqlParameter("@NamingAbility", MySqlDbType.Int32),
new MySqlParameter("@RetellAbility", MySqlDbType.Int32),
new MySqlParameter("@Comprehension", MySqlDbType.Int32),
new MySqlParameter("@ReadAbility", MySqlDbType.Int32),
new MySqlParameter("@WriteAbility", MySqlDbType.Int32),
new MySqlParameter("@StructureAbility", MySqlDbType.Int32),
new MySqlParameter("@TotalScore", MySqlDbType.Int32),
new MySqlParameter("@VisitDate", MySqlDbType.Date),
new MySqlParameter("@VisitDoctor", MySqlDbType.String, 50),
new MySqlParameter("@NextVisitDate", MySqlDbType.Date),
new MySqlParameter("@CreatedBy", MySqlDbType.String, 100),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpDateBy", MySqlDbType.String, 100),
new MySqlParameter("@LastUpDateDate", MySqlDbType.Date),
new MySqlParameter("@OutKey", MySqlDbType.Int32)
};
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.DirectionalOne == "" ? null : model.DirectionalOne;
cmdParms[2].Value = model.DirectionalTwo == "" ? null : model.DirectionalTwo;
cmdParms[3].Value = model.Memory == "" ? null : model.Memory;
cmdParms[4].Value = model.Attention == "" ? null : model.Attention;
cmdParms[5].Value = model.RecallAbility == "" ? null : model.RecallAbility;
cmdParms[6].Value = model.NamingAbility == "" ? null : model.NamingAbility;
cmdParms[7].Value = model.RetellAbility == "" ? null : model.RetellAbility;
cmdParms[8].Value = model.Comprehension == "" ? null : model.Comprehension;
cmdParms[9].Value = model.ReadAbility == "" ? null : model.ReadAbility;
cmdParms[10].Value = model.WriteAbility == "" ? null : model.WriteAbility;
cmdParms[11].Value = model.StructureAbility == "" ? null : model.StructureAbility;
cmdParms[12].Value = model.TotalScore == "" ? null : model.TotalScore;
cmdParms[13].Value = model.VisitDate;
cmdParms[14].Value = model.VisitDoctor;
cmdParms[15].Value = model.NextVisitDate;
cmdParms[16].Value = model.CreatedBy;
cmdParms[17].Value = model.CreatedDate;
cmdParms[18].Value = model.LastUpDateBy;
cmdParms[19].Value = model.LastUpDateDate;
cmdParms[20].Value = OutKey;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
