/// <summary> /// 更新一条数据 /// </summary> public void Update(MesWeb.Model.T_ParametersRef model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("T_ParametersRef_Update"); db.AddInParameter(dbCommand, "ParametersRefID", DbType.Int32, model.ParametersRefID); db.AddInParameter(dbCommand, "SpecificationID", DbType.Int32, model.SpecificationID); db.AddInParameter(dbCommand, "MachineID", DbType.Int32, model.MachineID); db.AddInParameter(dbCommand, "CollectedParameterID", DbType.Int32, model.CollectedParameterID); db.AddInParameter(dbCommand, "SettingValue", DbType.Double, model.SettingValue); db.AddInParameter(dbCommand, "MaxiumValue", DbType.Double, model.MaxiumValue); db.AddInParameter(dbCommand, "MiniumValue", DbType.Double, model.MiniumValue); db.AddInParameter(dbCommand, "DateTime", DbType.DateTime, model.DateTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> public MesWeb.Model.T_ParametersRef ReaderBind(IDataReader dataReader) { MesWeb.Model.T_ParametersRef model = new MesWeb.Model.T_ParametersRef(); object ojb; ojb = dataReader["ParametersRefID"]; if (ojb != null && ojb != DBNull.Value) { model.ParametersRefID = (int)ojb; } ojb = dataReader["SpecificationID"]; if (ojb != null && ojb != DBNull.Value) { model.SpecificationID = (int)ojb; } ojb = dataReader["MachineID"]; if (ojb != null && ojb != DBNull.Value) { model.MachineID = (int)ojb; } ojb = dataReader["CollectedParameterID"]; if (ojb != null && ojb != DBNull.Value) { model.CollectedParameterID = (int)ojb; } ojb = dataReader["SettingValue"]; if (ojb != null && ojb != DBNull.Value) { model.SettingValue = (decimal)ojb; } ojb = dataReader["MaxiumValue"]; if (ojb != null && ojb != DBNull.Value) { model.MaxiumValue = (decimal)ojb; } ojb = dataReader["MiniumValue"]; if (ojb != null && ojb != DBNull.Value) { model.MiniumValue = (decimal)ojb; } ojb = dataReader["DateTime"]; if (ojb != null && ojb != DBNull.Value) { model.DateTime = (DateTime)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_ParametersRef GetModel(int ParametersRefID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("T_ParametersRef_GetModel"); db.AddInParameter(dbCommand, "ParametersRefID", DbType.Int32, ParametersRefID); MesWeb.Model.T_ParametersRef model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MesWeb.Model.T_ParametersRef DataRowToModel(DataRow row) { MesWeb.Model.T_ParametersRef model = new MesWeb.Model.T_ParametersRef(); if (row != null) { if (row["ParametersRefID"] != null && row["ParametersRefID"].ToString() != "") { model.ParametersRefID = int.Parse(row["ParametersRefID"].ToString()); } if (row["SpecificationID"] != null && row["SpecificationID"].ToString() != "") { model.SpecificationID = int.Parse(row["SpecificationID"].ToString()); } if (row["MachineID"] != null && row["MachineID"].ToString() != "") { model.MachineID = int.Parse(row["MachineID"].ToString()); } if (row["CollectedParameterID"] != null && row["CollectedParameterID"].ToString() != "") { model.CollectedParameterID = int.Parse(row["CollectedParameterID"].ToString()); } if (row["SettingValue"] != null && row["SettingValue"].ToString() != "") { model.SettingValue = decimal.Parse(row["SettingValue"].ToString()); } if (row["MaxiumValue"] != null && row["MaxiumValue"].ToString() != "") { model.MaxiumValue = decimal.Parse(row["MaxiumValue"].ToString()); } if (row["MiniumValue"] != null && row["MiniumValue"].ToString() != "") { model.MiniumValue = decimal.Parse(row["MiniumValue"].ToString()); } if (row["DateTime"] != null && row["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(row["DateTime"].ToString()); } } return(model); }