/// <summary>
/// 得到一个对象实体
/// </summary>
public MyBookShop.Model.Orders DataRowToModel(DataRow row)
{
MyBookShop.Model.Orders model=new MyBookShop.Model.Orders();
if (row != null)
{
if(row["OrderId"]!=null)
{
model.OrderId=row["OrderId"].ToString();
}
if(row["OrderDate"]!=null && row["OrderDate"].ToString()!="")
{
model.OrderDate=DateTime.Parse(row["OrderDate"].ToString());
}
if(row["UserId"]!=null && row["UserId"].ToString()!="")
{
model.UserId=int.Parse(row["UserId"].ToString());
}
if(row["TotalPrice"]!=null && row["TotalPrice"].ToString()!="")
{
model.TotalPrice=decimal.Parse(row["TotalPrice"].ToString());
}
if(row["PostAddress"]!=null)
{
model.PostAddress=row["PostAddress"].ToString();
}
if(row["state"]!=null && row["state"].ToString()!="")
{
model.state=int.Parse(row["state"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyBookShop.Model.Orders GetModel(string OrderId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 OrderId,OrderDate,UserId,TotalPrice,PostAddress,state from Orders ");
strSql.Append(" where OrderId=@OrderId ");
SqlParameter[] parameters = {
new SqlParameter("@OrderId", SqlDbType.NVarChar,50) };
parameters[0].Value = OrderId;
MyBookShop.Model.Orders model=new MyBookShop.Model.Orders();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
