public PutUpOrderRecord QueryUpOrderByID(string orderID)
{
PutUpOrderRecord data = null;
if (string.IsNullOrEmpty(orderID))
{
return(data);
}
DataTable dt = ExecuteDataTable(@"select * from put_up_order where id=@orderID and state='0'", new MySqlParameter("@orderID", orderID));
if (dt.Rows.Count > 0)
{
data = BuildData(dt.Rows[0]);
}
return(data);
}
private PutUpOrderRecord BuildData(DataRow dr)
{
PutUpOrderRecord data = new PutUpOrderRecord();
if (!string.IsNullOrEmpty(dr["member_id"].ToString()))
{
data.MemberID = (string)dr["member_id"];
}
if (!string.IsNullOrEmpty(dr["state"].ToString()))
{
data.Status = (int)dr["state"];
}
if (!string.IsNullOrEmpty(dr["dt"].ToString()))
{
data.PutUpDate = (DateTime)dr["dt"];
}
if (!string.IsNullOrEmpty(dr["cost_value"].ToString()))
{
data.ConsumeMoney = (decimal)dr["cost_value"];
}
if (!string.IsNullOrEmpty(dr["pledge_value"].ToString()))
{
data.Deposit = (decimal)dr["pledge_value"];
}
if (!string.IsNullOrEmpty(dr["total_value"].ToString()))
{
data.TotalMoney = (decimal)dr["total_value"];
}
if (!string.IsNullOrEmpty(dr["score"].ToString()))
{
data.Integral = (int)dr["score"];
}
if (!string.IsNullOrEmpty(dr["operator_id"].ToString()))
{
data.OperatorID = (int)dr["operator_id"];
}
if (!string.IsNullOrEmpty(dr["comment"].ToString()))
{
data.Remark = (string)dr["comment"];
}
return(data);
}
