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