/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.DisaParameter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE DisaParameter SET ");
strSql.Append("A=@in_A,");
strSql.Append("B=@in_B,");
strSql.Append("C=@in_C,");
strSql.Append("D=@in_D ");
strSql.Append(" WHERE ID=@in_ID");
SqlParameter[] cmdParms = new SqlParameter[] {
new SqlParameter("@in_A", SqlDbType.Decimal),
new SqlParameter("@in_B", SqlDbType.Decimal),
new SqlParameter("@in_C", SqlDbType.Decimal),
new SqlParameter("@in_D", SqlDbType.Decimal),
new SqlParameter("@in_ID", SqlDbType.Int)
};
cmdParms[0].Value = model.A;
cmdParms[1].Value = model.B;
cmdParms[2].Value = model.C;
cmdParms[3].Value = model.D;
cmdParms[4].Value = model.ID;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.DisaParameter GetModel(DbDataReader dr)
{
Model.DisaParameter model = new Model.DisaParameter();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.A = DbHelperSQL.GetDouble(dr["A"]);
model.B = DbHelperSQL.GetDouble(dr["B"]);
model.C = DbHelperSQL.GetDouble(dr["C"]);
model.D = DbHelperSQL.GetDouble(dr["D"]);
model.isMajorAxis = DbHelperSQL.GetBool(dr["isMajorAxis"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DisaParameter GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM DisaParameter ");
strSql.Append(" WHERE ID=" + ID);
Model.DisaParameter model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
