Exemple #1
0
        public OrderExtEntity Populate_OrdersExtEntity_FromDr(DataRow dr)
        {
            OrderExtEntity Obj = new OrderExtEntity();

            Obj.OrderId     = ((dr["OrderId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["OrderId"]);
            Obj.OrderCode   = dr["OrderCode"].ToString();
            Obj.UserId      = ((dr["UserId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["UserId"]);
            Obj.PaymentId   = ((dr["PaymentId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["PaymentId"]);
            Obj.TotalPrice  = ((dr["TotalPrice"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["TotalPrice"]);
            Obj.Postage     = ((dr["Postage"]) == DBNull.Value) ? 0 : Convert.ToDecimal(dr["Postage"]);
            Obj.Status      = ((dr["Status"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["Status"]);
            Obj.Consignee   = dr["Consignee"].ToString();
            Obj.LocationId  = ((dr["LocationId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["LocationId"]);
            Obj.Address     = dr["Address"].ToString();
            Obj.Phone       = dr["Phone"].ToString();
            Obj.Buyer       = dr["Buyer"].ToString();
            Obj.Description = dr["Description"].ToString();
            Obj.AddTime     = ((dr["AddTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["AddTime"]);
            Obj.UpdateTime  = ((dr["UpdateTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["UpdateTime"]);
            Obj.ConfirmTime = ((dr["ConfirmTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["ConfirmTime"]);
            Obj.SendTime    = ((dr["SendTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["SendTime"]);
            Obj.expresstype = ((dr["expresstype"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["expresstype"]);
            Obj.expresscode = dr["expresscode"].ToString();
            Obj.RefundTime  = ((dr["RefundTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["RefundTime"]);
            Obj.ReturnTime  = ((dr["ReturnTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["ReturnTime"]);
            return(Obj);
        }
Exemple #2
0
        public IList <OrderExtEntity> DataSet2List(DataSet ds)
        {
            IList <OrderExtEntity> Obj = new List <OrderExtEntity>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                OrderExtEntity model = new OrderExtEntity();
                model = Populate_OrdersExtEntity_FromDr(dr);
                OrderExtEntity temp = Obj.FirstOrDefault(c => c.OrderCode == model.OrderCode);
                if (temp != null)
                {
                    temp.List.Add(Populate_OrdersItemEntity_FromDr(dr));
                }
                else
                {
                    model.List.Add(Populate_OrdersItemEntity_FromDr(dr));
                    Obj.Add(model);
                }
            }

            return(Obj);
        }