public List <Order> GetOrderToCharge(Func <Order, bool> seleWhere)
{
try
{
List <Order> order = new List <Order>();
using (DCLEntities dcl = new DCLEntities())
{
foreach (Order item in dcl.Order.Where(seleWhere).ToList())
{
item.RechargeStatus = (int)OrderRechargeStatus.processing;
dcl.Entry(item).State = System.Data.Entity.EntityState.Modified;
if (dcl.SaveChanges() > 0)
{
order.Add(item);
}
}
}
return(order);
}
catch (Exception ex)
{
WriteLog.Write("异常场信息[GetOrderToCharge]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="CardNo">卡号</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="isUse">是否查询使用时间</param>
/// <param name="type">卡类型</param>
/// <param name="Status">充值状态</param>
/// <returns></returns>
public static List <Cards> GetCards(string CardNo, DateTime startTime, DateTime endTime, bool isUse = false, int type = -1, int Status = -1)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
var result = dcl.Cards.Where(p => p.CardNumber.Contains(CardNo));
if (isUse)
{
result = result.Where(p => p.UseTime >= startTime && p.UseTime <= endTime);
}
else
{
result = result.Where(p => p.CreatTime >= startTime && p.CreatTime <= endTime);
}
if (type != -1)
{
result = result.Where(p => p.ChargeAccountTypeID == type);
}
if (Status != -1)
{
result = result.Where(p => (p.ReChargeStatus != null && p.ReChargeStatus == Status));
}
return(result.ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static List <ChargeAccountType> GetChargeAccountType(Func <ChargeAccountType, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
return(dcl.ChargeAccountType.Where(seleWhere).ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static List <ProductInfo> GetProductInfos(Func <ProductInfo, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
return(dcl.ProductInfo.Where(seleWhere).ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static List <OrderChargeAccount> GetOrderChargeAccount(Func <OrderChargeAccount, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
return(dcl.OrderChargeAccount.Where(seleWhere).ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static List <Cards> GetCards(Func <Cards, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
return(dcl.Cards.Where(seleWhere).ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static List <ClientConfig> GetClientConfig(Func <ClientConfig, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
return(dcl.ClientConfig.Where(seleWhere).ToList());
}
}
catch (Exception)
{
return(null);
}
}
public static bool AddListCards(List <Cards> cardsSet)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.Cards.AddRange(cardsSet);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddOrderChargeAccount(OrderChargeAccount orderChargeAccount)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
orderChargeAccount = dcl.OrderChargeAccount.Add(orderChargeAccount);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool UpdateOrderChargeAccount(OrderChargeAccount orderChargeAccount)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.Entry(orderChargeAccount).State = System.Data.Entity.EntityState.Modified;
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddCards(Cards cards)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
cards = dcl.Cards.Add(cards);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddClientConfig(ClientConfig clientConfig)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
clientConfig = dcl.ClientConfig.Add(clientConfig);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddChargeAccountType(ChargeAccountType chargeAccountType)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
chargeAccountType = dcl.ChargeAccountType.Add(chargeAccountType);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool UpdateCards(Cards cards)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.Entry(cards).State = System.Data.Entity.EntityState.Modified;
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddOrder(Order order)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
order = dcl.Order.Add(order);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception ex)
{
WriteLog.Write("系统订单号:" + order.OrderInsideID + ",商户订单号：" + order.OrderExternalID + ",异常场信息[AddOrder]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(false);
}
}
public static bool DeleteClientConfig(ClientConfig clientConfig)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.ClientConfig.Attach(clientConfig);
dcl.ClientConfig.Remove(clientConfig);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool DeleteOrderChargeAccount(OrderChargeAccount orderChargeAccount)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.OrderChargeAccount.Attach(orderChargeAccount);
dcl.OrderChargeAccount.Remove(orderChargeAccount);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool DeleteCards(Cards cards)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.Cards.Attach(cards);
dcl.Cards.Remove(cards);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool DeleteChargeAccountType(ChargeAccountType chargeAccountType)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.ChargeAccountType.Attach(chargeAccountType);
dcl.ChargeAccountType.Remove(chargeAccountType);
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public List <Order> GetOrder(Func <Order, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
List <Order> order = dcl.Order.Where(seleWhere).ToList();
return(order);
}
}
catch (Exception ex)
{
WriteLog.Write("异常场信息[GetOrder]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(null);
}
}
public bool IsOrders(Func <Order, bool> seleWhere)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
int count = dcl.Order.AsNoTracking().Where(seleWhere).Count();
return(count > 0 ? true : false);
}
}
catch (Exception ex)
{
WriteLog.Write("异常场信息[IsOrders]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(true);
}
}
public bool UpdateOrder(Order order)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
dcl.Entry(order).State = System.Data.Entity.EntityState.Modified;
return(dcl.SaveChanges() > 0);
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
WriteLog.Write("系统订单号:" + order.OrderInsideID + ",商户订单号：" + order.OrderExternalID + ",异常场信息[UpdateOrder]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(false);
}
}
public static bool UpdateCards(Cards cards, int cardStatus, string msg)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
cards.ReChargeStatus = cardStatus;
cards.UseTime = DateTime.Now;
cards.ReChargeMsg = msg;
dcl.Entry(cards).State = System.Data.Entity.EntityState.Modified;
return(dcl.SaveChanges() > 0);
}
}
catch (Exception)
{
return(false);
}
}
public static bool AddOrder(List <Order> orderList)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
foreach (var item in orderList)
{
dcl.Order.Add(item);
}
return(dcl.SaveChanges() > 0);
}
}
catch (Exception ex)
{
WriteLog.Write("批量插入订单,异常场信息[AddOrder]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(false);
}
}
public List <Order> GetOrder_top1000()
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
List <Order> orderExternalIDlist = dcl.Order.AsNoTracking().OrderByDescending(p => p.OrderID)
.Select(p => new { p.OrderExternalID }).Take(1000).ToList().Select(a => new Order {
OrderExternalID = a.OrderExternalID
}).ToList();
return(orderExternalIDlist);
}
}
catch (Exception ex)
{
WriteLog.Write("异常场信息[GetOrder_top1000]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(null);
}
}
public static List <Order> GetOrder(string orderInsideID, string orderExternalID, string productID, string productName, string targetAccount, string reChargeAccount, DateTime startTime, DateTime endTime, int Status = -1)
{
try
{
using (DCLEntities dcl = new DCLEntities())
{
var result = dcl.Order.Where(p => p.OrderInsideID.Contains(orderInsideID) && p.OrderExternalID.Contains(orderExternalID) &&
p.ProductID.Contains(productID) && p.ProductName.Contains(productName) && p.TargetAccount.Contains(targetAccount) &&
p.ChargeAccountInfo.Contains(reChargeAccount) && p.StartDatetime > startTime && p.StartDatetime < endTime);
if (Status != -1)
{
result = result.Where(p => (p.RechargeStatus != null && p.RechargeStatus == Status));
}
return(result.ToList());
}
}
catch (Exception ex)
{
WriteLog.Write("系统订单号:" + orderInsideID + ",商户订单号：" + orderExternalID + ",异常场信息[GetOrder]：" + ex.Message + ex.Source, LogPathFile.Exception);
return(null);
}
}
