/// <summary>
/// 得到一条数据
/// </summary>
public SmartLaw.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;
SmartLaw.Model.UserPrize model = new SmartLaw.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 SmartLaw.Model.UserPrize DataRowToModel(DataRow row)
{
SmartLaw.Model.UserPrize model = new SmartLaw.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;
}
