public static void Insert(Restaurant restaurant) { OperationsLogs.WriteLogsDebug("VentaBrl", "Insertar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), "Empezando a ejecutar el método lógica de negocio para crear un Venta")); try { RestaurantDal.Insert(restaurant); } catch (SqlException ex) { OperationsLogs.WriteLogsRelease("VentaBrl", "Insertar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message)); throw ex; } catch (Exception ex) { OperationsLogs.WriteLogsRelease("VentaBrl", "Insertar", string.Format("{0} Error: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message)); throw ex; } OperationsLogs.WriteLogsDebug("VentaBrl", "Insertar", string.Format("{0} Info: {1}", DateTime.Now.ToString(), DateTime.Now.ToString(), "Termino de ejecutar el método lógica de negocio para insertar Venta")); }
public List<OrderSummary> GetUserOrders(string memberCardNo) { List<OrderSummary> list = new List<OrderSummary>(); using (var SqlConn = ConnectionProvider.GetConnection()) { var SqlCmd = new SqlCommand(); SqlCmd.Connection = SqlConn; SqlCmd.CommandText = @" select o.Id AS OrderId,o.ContactName,o.ContactPhone,o.DiningDate,o.DiningDate,o.CreateDate, o.Status,o.RstId AS RestaurantId,o.PersonCount, os.OrderStatus, os.LastUpdateTime, -- Caculates order total price case when pr.PrepayMoney is NULL then (select SUM(od.ProductCount * od.UnitPrice) from OrderDetails od where od.OrderId=o.Id) else pr.PrepayMoney end as TotalMoney from orders o left join OrderStatus os on os.OrderId = o.Id left join PrepayRecord pr on pr.SId = convert(nvarchar(50), o.Id) where ((pr.AddMoney = pr.PrepayMoney and pr.AddMoney <= 0) or (pr.AddMoney is null and pr.PrepayMoney is null)) and o.MemberCardNo=@MemberCardNo order by o.CreateDate desc; "; SqlCmd.Parameters.AddWithValue(@"MemberCardNo", memberCardNo); var reader = SqlCmd.ExecuteReader(); while (reader.Read()) { if (reader["TotalMoney"] == DBNull.Value) { continue; } var summary = new OrderSummary(); summary.OrderId = Guid.Parse(reader["OrderId"].ToString()); summary.ContactName = reader["ContactName"].ToString(); if (reader["ContactPhone"] != DBNull.Value) { summary.ContactPhone = reader["ContactPhone"].ToString(); } if (reader["PersonCount"] != DBNull.Value) { summary.PersonCount = Convert.ToInt32(reader["PersonCount"]); } if (reader["OrderStatus"] != DBNull.Value) { summary.Status = Convert.ToString(reader["OrderStatus"]); } if (reader["DiningDate"] != DBNull.Value) { summary.DiningDate = Convert.ToDateTime(reader["DiningDate"]); } if (reader["TotalMoney"] != DBNull.Value) { summary.TotalMoney = Math.Abs(Convert.ToDecimal(reader["TotalMoney"])); } summary.RestaurantId = Guid.Parse(reader["RestaurantId"].ToString()); summary.CreateTime = Convert.ToDateTime(reader["CreateDate"]); summary.Backlog = "无"; list.Add(summary); } } if (list != null && list.Count > 0) { RestaurantDal restaurantDal = new RestaurantDal(); foreach (var item in list) { item.RestaurantName = restaurantDal.GetRestaurantName(item.RestaurantId); } } return list; }