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); }
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); }