/// <summary> /// 得到一条数据 /// </summary> public Model.UserPrize GetModel(long AutoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AutoID,SimCardNO,PrizeID,Amount,IsTaken,TakenTime,Remarks"); strSql.Append(" FROM UserPrize "); strSql.Append(" where AutoID=@AutoID"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64) }; parameters[0].Value = AutoID; Model.UserPrize model = new Model.UserPrize(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.UserPrize DataRowToModel(DataRow row) { Model.UserPrize model = new Model.UserPrize(); if (row != null) { if (row["AutoID"] != null && row["AutoID"].ToString() != "") { model.AutoID = long.Parse(row["AutoID"].ToString()); } if (row["SimCardNO"] != null && row["SimCardNO"].ToString() != "") { model.SimCardNO = row["SimCardNO"].ToString(); } if (row["PrizeID"] != null && row["PrizeID"].ToString() != "") { model.PrizeID= long.Parse(row["PrizeID"].ToString()); } if (row["Amount"] != null) { model.Amount=int.Parse( row["Amount"].ToString()); } if (row["IsTaken"] != null && row["IsTaken"].ToString() != "") { if ((row["IsTaken"].ToString() == "1") || (row["IsTaken"].ToString().ToLower() == "true")) { model.IsTaken = true; } else { model.IsTaken = false; } } if (row["TakenTime"] != null) { model.TakenTime = DateTime.Parse( row["TakenTime"].ToString()); } if (row["Remarks"] != null) { model.Remarks = row["Remarks"].ToString(); } } return model; }