/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.GeneralInfo DataRowToModel(DataRow row)
{
Maticsoft.Model.GeneralInfo model = new Maticsoft.Model.GeneralInfo();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["PID"] != null && row["PID"].ToString() != "")
{
model.PID = int.Parse(row["PID"].ToString());
}
if (row["Height"] != null && row["Height"].ToString() != "")
{
model.Height = decimal.Parse(row["Height"].ToString());
}
if (row["Weight"] != null && row["Weight"].ToString() != "")
{
model.Weight = decimal.Parse(row["Weight"].ToString());
}
if (row["Waist"] != null && row["Waist"].ToString() != "")
{
model.Waist = decimal.Parse(row["Waist"].ToString());
}
if (row["BMI"] != null && row["BMI"].ToString() != "")
{
model.BMI = decimal.Parse(row["BMI"].ToString());
}
if (row["SmokeYear"] != null && row["SmokeYear"].ToString() != "")
{
model.SmokeYear = decimal.Parse(row["SmokeYear"].ToString());
}
if (row["SmokePerDay"] != null && row["SmokePerDay"].ToString() != "")
{
model.SmokePerDay = decimal.Parse(row["SmokePerDay"].ToString());
}
if (row["SmokeIndex"] != null && row["SmokeIndex"].ToString() != "")
{
model.SmokeIndex = decimal.Parse(row["SmokeIndex"].ToString());
}
if (row["QuitSmoke"] != null && row["QuitSmoke"].ToString() != "")
{
if ((row["QuitSmoke"].ToString() == "1") || (row["QuitSmoke"].ToString().ToLower() == "true"))
{
model.QuitSmoke = true;
}
else
{
model.QuitSmoke = false;
}
}
if (row["QuitYear"] != null)
{
model.QuitYear = row["QuitYear"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.GeneralInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GeneralInfo set ");
strSql.Append("PID=@PID,");
strSql.Append("Height=@Height,");
strSql.Append("Weight=@Weight,");
strSql.Append("Waist=@Waist,");
strSql.Append("BMI=@BMI,");
strSql.Append("SmokeYear=@SmokeYear,");
strSql.Append("SmokePerDay=@SmokePerDay,");
strSql.Append("SmokeIndex=@SmokeIndex,");
strSql.Append("QuitSmoke=@QuitSmoke,");
strSql.Append("QuitYear=@QuitYear");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Height", OleDbType.Decimal),
new OleDbParameter("@Weight", OleDbType.Decimal),
new OleDbParameter("@Waist", OleDbType.Decimal),
new OleDbParameter("@BMI", OleDbType.Decimal),
new OleDbParameter("@SmokeYear", OleDbType.Decimal),
new OleDbParameter("@SmokePerDay", OleDbType.Decimal),
new OleDbParameter("@SmokeIndex", OleDbType.Decimal),
new OleDbParameter("@QuitSmoke", OleDbType.Boolean, 1),
new OleDbParameter("@QuitYear", OleDbType.VarChar, 50),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Height;
parameters[2].Value = model.Weight;
parameters[3].Value = model.Waist;
parameters[4].Value = model.BMI;
parameters[5].Value = model.SmokeYear;
parameters[6].Value = model.SmokePerDay;
parameters[7].Value = model.SmokeIndex;
parameters[8].Value = model.QuitSmoke;
parameters[9].Value = model.QuitYear;
parameters[10].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.GeneralInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GeneralInfo(");
strSql.Append("PID,Height,Weight,Waist,BMI,SmokeYear,SmokePerDay,SmokeIndex,QuitSmoke,QuitYear)");
strSql.Append(" values (");
strSql.Append("@PID,@Height,@Weight,@Waist,@BMI,@SmokeYear,@SmokePerDay,@SmokeIndex,@QuitSmoke,@QuitYear)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Height", OleDbType.Decimal),
new OleDbParameter("@Weight", OleDbType.Decimal),
new OleDbParameter("@Waist", OleDbType.Decimal),
new OleDbParameter("@BMI", OleDbType.Decimal),
new OleDbParameter("@SmokeYear", OleDbType.Decimal),
new OleDbParameter("@SmokePerDay", OleDbType.Decimal),
new OleDbParameter("@SmokeIndex", OleDbType.Decimal),
new OleDbParameter("@QuitSmoke", OleDbType.Boolean, 1),
new OleDbParameter("@QuitYear", OleDbType.VarChar, 50)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Height;
parameters[2].Value = model.Weight;
parameters[3].Value = model.Waist;
parameters[4].Value = model.BMI;
parameters[5].Value = model.SmokeYear;
parameters[6].Value = model.SmokePerDay;
parameters[7].Value = model.SmokeIndex;
parameters[8].Value = model.QuitSmoke;
parameters[9].Value = model.QuitYear;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.GeneralInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PID,Height,Weight,Waist,BMI,SmokeYear,SmokePerDay,SmokeIndex,QuitSmoke,QuitYear from GeneralInfo ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.GeneralInfo model = new Maticsoft.Model.GeneralInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
