/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_CheckParsRef DataRowToModel(DataRow row)
{
MesWeb.Model.T_CheckParsRef model = new MesWeb.Model.T_CheckParsRef();
if (row != null)
{
if (row["CheckParsRefID"] != null && row["CheckParsRefID"].ToString() != "")
{
model.CheckParsRefID = int.Parse(row["CheckParsRefID"].ToString());
}
if (row["CheckTypeID"] != null && row["CheckTypeID"].ToString() != "")
{
model.CheckTypeID = int.Parse(row["CheckTypeID"].ToString());
}
if (row["UpperValue"] != null && row["UpperValue"].ToString() != "")
{
model.UpperValue = decimal.Parse(row["UpperValue"].ToString());
}
if (row["Lower"] != null && row["Lower"].ToString() != "")
{
model.Lower = decimal.Parse(row["Lower"].ToString());
}
if (row["OtherStandard"] != null)
{
model.OtherStandard = row["OtherStandard"].ToString();
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public MesWeb.Model.T_CheckParsRef ReaderBind(IDataReader dataReader)
{
MesWeb.Model.T_CheckParsRef model = new MesWeb.Model.T_CheckParsRef();
object ojb;
ojb = dataReader["CheckParsRefID"];
if (ojb != null && ojb != DBNull.Value)
{
model.CheckParsRefID = (int)ojb;
}
ojb = dataReader["CheckTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.CheckTypeID = (int)ojb;
}
ojb = dataReader["UpperValue"];
if (ojb != null && ojb != DBNull.Value)
{
model.UpperValue = (decimal)ojb;
}
ojb = dataReader["Lower"];
if (ojb != null && ojb != DBNull.Value)
{
model.Lower = (decimal)ojb;
}
model.OtherStandard = dataReader["OtherStandard"].ToString();
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(MesWeb.Model.T_CheckParsRef model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("T_CheckParsRef_Update");
db.AddInParameter(dbCommand, "CheckParsRefID", DbType.Int32, model.CheckParsRefID);
db.AddInParameter(dbCommand, "CheckTypeID", DbType.Int32, model.CheckTypeID);
db.AddInParameter(dbCommand, "UpperValue", DbType.Double, model.UpperValue);
db.AddInParameter(dbCommand, "Lower", DbType.Double, model.Lower);
db.AddInParameter(dbCommand, "OtherStandard", DbType.String, model.OtherStandard);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_CheckParsRef GetModel(int CheckParsRefID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("T_CheckParsRef_GetModel");
db.AddInParameter(dbCommand, "CheckParsRefID", DbType.Int32, CheckParsRefID);
MesWeb.Model.T_CheckParsRef model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
