/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Prize DataRowToModel(DataRow row) { SmartLaw.Model.Prize model = new SmartLaw.Model.Prize(); if (row != null) { if (row["AutoID"] != null) { model.AutoID = long.Parse(row["AutoID"].ToString()); } if (row["PrizeName"] != null && row["PrizeName"].ToString() != "") { model.PrizeName = row["PrizeName"].ToString(); } if (row["PrizeUnit"] != null && row["PrizeUnit"].ToString() != "") { model.PrizeUnit = row["PrizeUnit"].ToString(); } if (row["Points"] != null) { model.Points =int.Parse( row["Points"].ToString()); } if (row["Registrant"] != null && row["Registrant"].ToString() != "") { model.Registrant = row["Registrant"].ToString(); } if (row["Stock"] != null) { model.Stock = long.Parse( row["Stock"].ToString()); } if (row["Remarks"] != null && row["Remarks"].ToString() != "") { model.Remarks = row["Remarks"].ToString(); } if (row["RegTime"] != null && row["RegTime"].ToString() != "") { model.RegTime = DateTime.Parse(row["RegTime"].ToString()); } if (row["Picture"] != null && row["Picture"].ToString() != "") { model.Picture = row["Picture"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Prize GetModel(long AutoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AutoID,PrizeName,PrizeUnit,Points,Registrant,Stock,Remarks,RegTime,Picture from Prize"); strSql.Append(" where AutoID=@AutoID limit 1"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64) }; parameters[0].Value = AutoID; SmartLaw.Model.Prize model = new SmartLaw.Model.Prize(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }