Example #1
0
        /// <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);
        }
Example #2
0
        /// <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);
        }
Example #3
0
        /// <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);
        }