/// <summary> /// 获得数据列表 /// </summary> public List <CashOrderModel> DataTableToOrderList(DataTable dt) { List <CashOrderModel> modelList = new List <CashOrderModel>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { CashOrderModel model; for (int n = 0; n < rowsCount; n++) { model = new CashOrderModel(); if (dt.Rows[n]["OrderID"] != null && dt.Rows[n]["OrderID"].ToString() != "") { model.OrderID = Convert.ToInt64(dt.Rows[n]["OrderID"]); } if (dt.Rows[n]["OrderCode"] != null && dt.Rows[n]["OrderCode"].ToString() != "") { model.OrderCode = dt.Rows[n]["OrderCode"].ToString(); } if (dt.Rows[n]["UserCode"] != null && dt.Rows[n]["UserCode"].ToString() != "") { model.UserCode = dt.Rows[n]["UserCode"].ToString(); } if (dt.Rows[n]["TradingNum"] != null && dt.Rows[n]["TradingNum"].ToString() != "") { model.Number = Convert.ToInt32(dt.Rows[n]["TradingNum"]); } if (dt.Rows[n]["Price"] != null && dt.Rows[n]["Price"].ToString() != "") { model.Price = Convert.ToDecimal(dt.Rows[n]["Price"]); } if (dt.Rows[n]["Amount"] != null && dt.Rows[n]["Amount"].ToString() != "") { model.Amount = Convert.ToDecimal(dt.Rows[n]["Amount"]); } if (dt.Rows[n]["TypeID"] != null && dt.Rows[n]["TypeID"].ToString() != "") { model.TypeID = Convert.ToInt32(dt.Rows[n]["TypeID"]); model.TypeIDName = GetOrderTypeName(model.TypeID); } if (dt.Rows[n]["OrderDate"] != null && dt.Rows[n]["OrderDate"].ToString() != "") { model.OrderDate = Convert.ToDateTime(dt.Rows[n]["OrderDate"]).ToString("yyyy-MM-dd HH:mm:ss"); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 获取数据对象 /// </summary> /// <param name="dt"></param> /// <returns></returns> public CashOrderModel OrderTableToModel(DataTable dt) { int n = 0; CashOrderModel model = new CashOrderModel(); if (dt.Rows.Count > 0) { if (dt.Rows[n]["OrderID"] != null && dt.Rows[n]["OrderID"].ToString() != "") { model.OrderID = Convert.ToInt64(dt.Rows[n]["OrderID"]); } if (dt.Rows[n]["OrderCode"] != null && dt.Rows[n]["OrderCode"].ToString() != "") { model.OrderCode = dt.Rows[n]["OrderCode"].ToString(); } if (dt.Rows[n]["UserCode"] != null && dt.Rows[n]["UserCode"].ToString() != "") { model.UserCode = dt.Rows[n]["UserCode"].ToString(); } if (dt.Rows[n]["Price"] != null && dt.Rows[n]["Price"].ToString() != "") { model.Price = Convert.ToDecimal(dt.Rows[n]["Price"]); } if (dt.Rows[n]["TradingNum"] != null && dt.Rows[n]["TradingNum"].ToString() != "") { model.Number = Convert.ToInt32(dt.Rows[n]["TradingNum"]); } if (dt.Rows[n]["Amount"] != null && dt.Rows[n]["Amount"].ToString() != "") { model.Amount = Convert.ToDecimal(dt.Rows[n]["Amount"]); } if (dt.Rows[n]["TypeID"] != null && dt.Rows[n]["TypeID"].ToString() != "") { model.TypeID = Convert.ToInt32(dt.Rows[n]["TypeID"]); model.TypeIDName = GetOrderTypeName(model.TypeID); } if (dt.Rows[n]["OrderDate"] != null && dt.Rows[n]["OrderDate"].ToString() != "") { model.OrderDate = Convert.ToDateTime(dt.Rows[n]["OrderDate"]).ToString("yyyy-MM-dd HH:mm:ss"); } } return(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <CashOrderModel> DataTableToOrderList(DataTable dt, decimal Price) { List <CashOrderModel> modelList = new List <CashOrderModel>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { CashOrderModel model; for (int n = 0; n < rowsCount; n++) { model = new CashOrderModel(); if (dt.Rows[n]["OrderID"] != null && dt.Rows[n]["OrderID"].ToString() != "") { model.TransOrderID = dt.Rows[n]["OrderID"].ToString(); } if (dt.Rows[n]["SellUserCode"] != null && dt.Rows[n]["SellUserCode"].ToString() != "") { model.SellUserCode = dt.Rows[n]["SellUserCode"].ToString(); } if (dt.Rows[n]["CashbuyID"] != null && dt.Rows[n]["CashbuyID"].ToString() != "") { model.BuyOrderID = dt.Rows[n]["CashbuyID"].ToString(); } if (dt.Rows[n]["OrderCode"] != null && dt.Rows[n]["OrderCode"].ToString() != "") { model.BuyOrderCode = dt.Rows[n]["OrderCode"].ToString(); } if (dt.Rows[n]["CashsellID"] != null && dt.Rows[n]["CashsellID"].ToString() != "") { model.SellOrderID = dt.Rows[n]["CashsellID"].ToString(); } if (dt.Rows[n]["SellOrderCode"] != null && dt.Rows[n]["SellOrderCode"].ToString() != "") { model.SellOrderCode = dt.Rows[n]["SellOrderCode"].ToString(); } if (dt.Rows[n]["BuyNum"] != null && dt.Rows[n]["BuyNum"].ToString() != "") { model.Number = dt.Rows[n]["BuyNum"].ToString(); } int iSStatus = int.Parse(dt.Rows[n]["SStatus"].ToString()); int iBStatus = int.Parse(dt.Rows[n]["BStatus"].ToString()); int iStatus = int.Parse(dt.Rows[n]["Status"].ToString()); int Status; model.StatusText = GetStatus(iSStatus, iBStatus, iStatus, out Status);//订单状态 model.Status = Status.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]["downtime"] != null && dt.Rows[n]["downtime"].ToString() != "") { model.ExpireDate = DateTime.Parse(dt.Rows[n]["downtime"].ToString()); } if (dt.Rows[n]["bankid"] != null && dt.Rows[n]["bankid"].ToString() != "") { model.BankID = long.Parse(dt.Rows[n]["bankid"].ToString()); } if (dt.Rows[n]["SellerPhone"] != null && dt.Rows[n]["SellerPhone"].ToString() != "") { model.SellerPhone = dt.Rows[n]["SellerPhone"].ToString(); } if (dt.Rows[n]["BuyUserCode"] != null && dt.Rows[n]["BuyUserCode"].ToString() != "") { model.BuyUserCode = dt.Rows[n]["BuyUserCode"].ToString(); } if (dt.Rows[n]["BuyerPhone"] != null && dt.Rows[n]["BuyerPhone"].ToString() != "") { model.BuyerPhone = dt.Rows[n]["BuyerPhone"].ToString(); } if (dt.Rows[n]["BuyNiceName"] != null && dt.Rows[n]["BuyNiceName"].ToString() != "") { model.BuyNiceName = dt.Rows[n]["BuyNiceName"].ToString(); } model.BuyerRemark = dt.Rows[n]["BRemark"] == null ? "" : dt.Rows[n]["BRemark"].ToString(); model.SellerRemark = dt.Rows[n]["SRemark"] == null ? "" : dt.Rows[n]["SRemark"].ToString(); model.Pic = dt.Rows[n]["Pic"] == null || dt.Rows[n]["Pic"].ToString() == "" ? "":WebHelper.HttpDomain + dt.Rows[n]["Pic"].ToString(); model.Price = Price.ToString("0.00");// dt.Rows[n]["Price"] == null ? "1" : dt.Rows[n]["Price"].ToString(); modelList.Add(model); } } return(modelList); }