/// <summary>
/// 修改建议指导
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(HealthGuidanceModel model)
{
string sql = @"UPDATE tbl_HealthGuidance
SET
GreaterThanRecom = @GreaterThanRecom
,LessThanRecom = @LessThanRecom
,MiddleThanRecom = @MiddleThanRecom
,Title = @Title
,Code=@Code
,Sex=@Sex
,Type=@Type
WHERE ID = @ID";
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@ID", MySqlDbType.Int32),
new MySqlParameter("@GreaterThanRecom", MySqlDbType.Text),
new MySqlParameter("@LessThanRecom", MySqlDbType.Text),
new MySqlParameter("@MiddleThanRecom", MySqlDbType.Text),
new MySqlParameter("@Title", MySqlDbType.String, 50),
new MySqlParameter("@Code", MySqlDbType.String, 50),
new MySqlParameter("@Sex", MySqlDbType.String, 1),
new MySqlParameter("@Type", MySqlDbType.Int32)
};
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.GreaterThanRecom;
cmdParms[2].Value = model.LessThanRecom;
cmdParms[3].Value = model.MiddleThanRecom;
cmdParms[4].Value = model.Title;
cmdParms[5].Value = model.Code;
cmdParms[5].Value = model.Sex;
cmdParms[6].Value = model.Type;
return(MySQLHelper.ExecuteSql(sql, cmdParms));
}
/// <summary>
/// 添加建议指导
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(HealthGuidanceModel model)
{
string sql = @"INSERT INTO tbl_HealthGuidance
(
GreaterThanRecom
,LessThanRecom
,MiddleThanRecom
,Title
,Code
,Sex
,Type
)
VALUES
(
@GreaterThanRecom
,@LessThanRecom
,@MiddleThanRecom
,@Title
,@Code
,@Sex
,@Type
)";
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@GreaterThanRecom", MySqlDbType.Text),
new MySqlParameter("@LessThanRecom", MySqlDbType.Text),
new MySqlParameter("@MiddleThanRecom", MySqlDbType.Text),
new MySqlParameter("@Title", MySqlDbType.String, 50),
new MySqlParameter("@Code", MySqlDbType.String, 50),
new MySqlParameter("@Sex", MySqlDbType.String, 1),
new MySqlParameter("@Type", MySqlDbType.Int32)
};
cmdParms[0].Value = model.GreaterThanRecom;
cmdParms[1].Value = model.LessThanRecom;
cmdParms[2].Value = model.MiddleThanRecom;
cmdParms[3].Value = model.Title;
cmdParms[4].Value = model.Code;
cmdParms[5].Value = model.Sex;
cmdParms[6].Value = model.Type;
return(MySQLHelper.ExecuteSql(sql, cmdParms));
}
/// <summary>
/// 修改建议指导
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(HealthGuidanceModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加建议指导
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(HealthGuidanceModel model)
{
return(dal.Insert(model));
}
