/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Tao.OrderHistory GetModel(int OrderID, int BuyerID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,OrderDate,BuyerID,UserName,Email,Remark,Amount,Status,SellerID,PaymentTypeId,GatewayOrderId,PaymentType,CurrencyCode,CurrencyName from Tao_OrderHistory ");
strSql.Append(" where OrderID=@OrderID and BuyerID=@BuyerID ");
SqlParameter[] parameters = {
new SqlParameter("@OrderID", SqlDbType.Int,4),
new SqlParameter("@BuyerID", SqlDbType.Int,4)};
parameters[0].Value = OrderID;
parameters[1].Value = BuyerID;
Maticsoft.Model.Tao.OrderHistory model = new Maticsoft.Model.Tao.OrderHistory();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["OrderID"] != null && ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderDate"] != null && ds.Tables[0].Rows[0]["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(ds.Tables[0].Rows[0]["OrderDate"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyerID"] != null && ds.Tables[0].Rows[0]["BuyerID"].ToString() != "")
{
model.BuyerID = int.Parse(ds.Tables[0].Rows[0]["BuyerID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["Amount"] != null && ds.Tables[0].Rows[0]["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(ds.Tables[0].Rows[0]["Amount"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["SellerID"] != null && ds.Tables[0].Rows[0]["SellerID"].ToString() != "")
{
model.SellerID = int.Parse(ds.Tables[0].Rows[0]["SellerID"].ToString());
}
if (ds.Tables[0].Rows[0]["PaymentTypeId"] != null && ds.Tables[0].Rows[0]["PaymentTypeId"].ToString() != "")
{
model.PaymentTypeId = int.Parse(ds.Tables[0].Rows[0]["PaymentTypeId"].ToString());
}
if (ds.Tables[0].Rows[0]["GatewayOrderId"] != null && ds.Tables[0].Rows[0]["GatewayOrderId"].ToString() != "")
{
model.GatewayOrderId = ds.Tables[0].Rows[0]["GatewayOrderId"].ToString();
}
if (ds.Tables[0].Rows[0]["PaymentType"] != null && ds.Tables[0].Rows[0]["PaymentType"].ToString() != "")
{
model.PaymentType = ds.Tables[0].Rows[0]["PaymentType"].ToString();
}
if (ds.Tables[0].Rows[0]["CurrencyCode"] != null && ds.Tables[0].Rows[0]["CurrencyCode"].ToString() != "")
{
model.CurrencyCode = ds.Tables[0].Rows[0]["CurrencyCode"].ToString();
}
if (ds.Tables[0].Rows[0]["CurrencyName"] != null && ds.Tables[0].Rows[0]["CurrencyName"].ToString() != "")
{
model.CurrencyName = ds.Tables[0].Rows[0]["CurrencyName"].ToString();
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Maticsoft.Model.Tao.OrderHistory> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.Tao.OrderHistory> modelList = new List<Maticsoft.Model.Tao.OrderHistory>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Maticsoft.Model.Tao.OrderHistory model;
for (int n = 0; n < rowsCount; n++)
{
model = new Maticsoft.Model.Tao.OrderHistory();
if (dt.Rows[n]["OrderID"] != null && dt.Rows[n]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(dt.Rows[n]["OrderID"].ToString());
}
if (dt.Rows[n]["OrderDate"] != null && dt.Rows[n]["OrderDate"].ToString() != "")
{
model.OrderDate = DateTime.Parse(dt.Rows[n]["OrderDate"].ToString());
}
if (dt.Rows[n]["BuyerID"] != null && dt.Rows[n]["BuyerID"].ToString() != "")
{
model.BuyerID = int.Parse(dt.Rows[n]["BuyerID"].ToString());
}
if (dt.Rows[n]["UserName"] != null && dt.Rows[n]["UserName"].ToString() != "")
{
model.UserName = dt.Rows[n]["UserName"].ToString();
}
if (dt.Rows[n]["Email"] != null && dt.Rows[n]["Email"].ToString() != "")
{
model.Email = dt.Rows[n]["Email"].ToString();
}
if (dt.Rows[n]["Remark"] != null && dt.Rows[n]["Remark"].ToString() != "")
{
model.Remark = dt.Rows[n]["Remark"].ToString();
}
if (dt.Rows[n]["Amount"] != null && dt.Rows[n]["Amount"].ToString() != "")
{
model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString());
}
if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "")
{
model.Status = int.Parse(dt.Rows[n]["Status"].ToString());
}
if (dt.Rows[n]["SellerID"] != null && dt.Rows[n]["SellerID"].ToString() != "")
{
model.SellerID = int.Parse(dt.Rows[n]["SellerID"].ToString());
}
if (dt.Rows[n]["PaymentTypeId"] != null && dt.Rows[n]["PaymentTypeId"].ToString() != "")
{
model.PaymentTypeId = int.Parse(dt.Rows[n]["PaymentTypeId"].ToString());
}
if (dt.Rows[n]["GatewayOrderId"] != null && dt.Rows[n]["GatewayOrderId"].ToString() != "")
{
model.GatewayOrderId = dt.Rows[n]["GatewayOrderId"].ToString();
}
if (dt.Rows[n]["PaymentType"] != null && dt.Rows[n]["PaymentType"].ToString() != "")
{
model.PaymentType = dt.Rows[n]["PaymentType"].ToString();
}
if (dt.Rows[n]["CurrencyCode"] != null && dt.Rows[n]["CurrencyCode"].ToString() != "")
{
model.CurrencyCode = dt.Rows[n]["CurrencyCode"].ToString();
}
if (dt.Rows[n]["CurrencyName"] != null && dt.Rows[n]["CurrencyName"].ToString() != "")
{
model.CurrencyName = dt.Rows[n]["CurrencyName"].ToString();
}
modelList.Add(model);
}
}
return modelList;
}
