Beispiel #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        private static Order DataRowToModel(SQLiteDataReader row)
        {
            Order model = new Order();

            if (row != null)
            {
                if (row["id"] != null && row["id"].ToString() != "")
                {
                    model.Id = int.Parse(row["id"].ToString());
                }
                if (row["order_no"] != null)
                {
                    model.No = row["order_no"].ToString();
                }
                if (row["order_name"] != null)
                {
                    model.Name = row["order_name"].ToString();
                }
                if (row["order_body"] != null)
                {
                    model.Body = row["order_body"].ToString();
                }
                if (row["order_url"] != null)
                {
                    model.Url = row["order_url"].ToString();
                }
                if (row["payment_type"] != null)
                {
                    model.Payment = (PaymentType)Enum.Parse(typeof(PaymentType), row["payment_type"].ToString());
                }
                if (row["original_money"] != null && row["original_money"].ToString() != "")
                {
                    model.OriginalMoney = decimal.Parse(row["original_money"].ToString());
                }
                if (row["money"] != null && row["money"].ToString() != "")
                {
                    model.Money = decimal.Parse(row["money"].ToString());
                }
                if (row["invoice_title"] != null)
                {
                    model.InvoiceTitle = row["invoice_title"].ToString();
                }
                if (row["user_id"] != null && row["user_id"].ToString() != "")
                {
                    model.UserId = int.Parse(row["user_id"].ToString());
                }
                if (row["from_id"] != null && row["from_id"].ToString() != "")
                {
                    model.FromId = int.Parse(row["from_id"].ToString());
                }
                if (row["emp_id"] != null && row["emp_id"].ToString() != "")
                {
                    model.EmpId = int.Parse(row["emp_id"].ToString());
                }
                if (row["buyer_id"] != null && row["buyer_id"].ToString() != "")
                {
                    model.BuyerId = int.Parse(row["buyer_id"].ToString());
                }
                if (row["order_type"] != null)
                {
                    model.OrderType = (OrderType)Enum.Parse(typeof(OrderType), row["order_type"].ToString());
                }
                if (row["order_status"] != null)
                {
                    model.Status = (OrderStatus)Enum.Parse(typeof(OrderStatus), row["order_status"].ToString());
                }
                if (row["feedback_status"] != null)
                {
                    model.FeedbackStatus = (FeedbackStatus)Enum.Parse(typeof(FeedbackStatus), row["feedback_status"].ToString());
                }
                if (row["transport_fee"] != null && row["transport_fee"].ToString() != "")
                {
                    model.TransportFee = decimal.Parse(row["transport_fee"].ToString());
                }
                if (row["remark"] != null)
                {
                    model.Remark = row["remark"].ToString();
                }
                if (row["arrived_at"] != null && row["arrived_at"].ToString() != "")
                {
                    model.ArrivedAt = model.ConvertIntDateTime(Convert.ToInt32(row["arrived_at"].ToString()));
                }
                if (row["express_at"] != null && row["express_at"].ToString() != "")
                {
                    model.ExpressAt = model.ConvertIntDateTime(Convert.ToInt32(row["express_at"].ToString()));
                }
                if (row["sign_at"] != null && row["sign_at"].ToString() != "")
                {
                    model.SignAt = model.ConvertIntDateTime(Convert.ToInt32(row["sign_at"].ToString()));
                }
                if (row["close_at"] != null && row["close_at"].ToString() != "")
                {
                    model.CloseAt = model.ConvertIntDateTime(Convert.ToInt32(row["close_at"].ToString()));
                }
                if (row["refund_at"] != null && row["refund_at"].ToString() != "")
                {
                    model.RefundAt = model.ConvertIntDateTime(Convert.ToInt32(row["refund_at"].ToString()));
                }
                if (row["is_delete"] != null && row["is_delete"].ToString() != "")
                {
                    model.IsDelete = int.Parse(row["is_delete"].ToString()) == 1;
                }
                if (row["created_at"] != null && row["created_at"].ToString() != "")
                {
                    model.CreatedAt = model.ConvertIntDateTime(Convert.ToInt32(row["created_at"].ToString()));
                }
                if (row["updated_at"] != null && row["updated_at"].ToString() != "")
                {
                    model.UpdatedAt = model.ConvertIntDateTime(Convert.ToInt32(row["updated_at"].ToString()));
                }
                if (row["pay_at"] != null && row["pay_at"].ToString() != "")
                {
                    model.PayAt = model.ConvertIntDateTime(Convert.ToInt32(row["pay_at"].ToString()));
                }
                if (row["feedback_at"] != null && row["feedback_at"].ToString() != "")
                {
                    model.FeedbackAt = model.ConvertIntDateTime(Convert.ToInt32(row["feedback_at"].ToString()));
                }
            }
            return(model);
        }