public IList <PayNotifyInfo> Get(Func <PayNotifyInfo, bool> condition)
{
using (var db = new WXDBContext())
{
return(db.PayNotifyInfo.Where(condition).ToList());
}
}
/// <summary>
/// 根据条件获取结果
/// </summary>
/// <param name="condition">
/// The condition.
/// </param>
/// <returns>
/// The <see cref="IList"/>.
/// </returns>
public IList <RefundmentInfo> Get(Func <RefundmentInfo, bool> condition)
{
using (var db = new WXDBContext())
{
return(db.RefundmentInfo.Where(condition).ToList());
}
}
public static bool AddIdentifyingCode(IdentifyingCodeInfo code)
{
if (code != null)
{
var addResult = false;
code.IdentifyingCode = Utils.Number(12);
using (var context = new WXDBContext())
{
addResult = new IdentifyingCodeRepository(context).AddIdentifyingCode(code);
}
// 如果IdentifyingCode在数据库中存在，则递归执行此方法重新获取编号
if (!addResult)
{
AddIdentifyingCode(code);
}
else
{
return(true);
}
}
return(false);
}
public static bool ModifyIdentifyingCodeInfoStatus(string orderCode, int status)
{
if (string.IsNullOrEmpty(orderCode))
{
return(false);
}
using (var context = new WXDBContext())
{
var repository = new IdentifyingCodeRepository(context);
var identifyingCode = repository.Get(item => item.OrderCode.Equals(orderCode));
if (identifyingCode.Any())
{
foreach (var item in identifyingCode)
{
item.Status = status;
item.ModifyTime = DateTime.Now;
}
return(repository.Update(identifyingCode));
}
}
return(false);
}
public IList <IdentifyingCodeDetailSearchDTO> GetIdentifyingCodeDetailById(IdentifyingCodeInfo code)
{
var strSql = new StringBuilder();
if (code == null)
{
return(null);
}
if (code.ModuleName.Equals("restaurant"))
{
strSql.Append("select a.id AS ProductId,b.OrderId AS OrderId,a.cpName as ProductName,c.price as Price,b.status as Status FROM wx_diancai_caipin_manage a INNER join ");
strSql.Append("(select IdentifyingCodeId,CAST(ProductId AS INT) AS ProductId,CAST(OrderId AS INT) AS OrderId,");
strSql.Append("Status FROM [wx_Verification_IdentifyingCodeInfo] WHERE IdentifyingCodeId='" + code.IdentifyingCodeId + "') as b");
strSql.Append(" ON a.id=b.ProductId INNER JOIN (SELECT price,caiId,dingId FROM dbo.wx_diancai_dingdan_caiping)c");
strSql.Append(" ON b.ProductId= c.caiId AND c.dingId= b.OrderId");
}
else if (code.ModuleName.Equals("hotel"))
{
strSql.Append("select a.id AS OrderId,a.roomid AS ProductId,a.roomType as ProductName,a.price as Price,b.status as Status,a.orderNum AS Number,");
strSql.Append("CONVERT(varchar(10),a.arriveTime,120) as ArriveTime,CONVERT(varchar(10),a.leaveTime,120) as LeaveTime, CAST(DATEDIFF(DAY,a.arriveTime,a.leaveTime)*a.price*a.orderNum as FLOAT) as TotelPrice ");
strSql.Append("FROM dbo.wx_hotel_dingdan a INNER join (select IdentifyingCodeId,CAST(OrderId AS INT) AS OrderId,Status FROM [wx_Verification_IdentifyingCodeInfo] ");
strSql.Append("WHERE IdentifyingCodeId='" + code.IdentifyingCodeId + "') as b ON a.id=b.OrderId ");
}
using (var db = new WXDBContext())
{
return(db.Database.SqlQuery <IdentifyingCodeDetailSearchDTO>(strSql.ToString()).ToList());
}
}
public void Add()
{
using (var db = new WXDBContext())
{
db.PayNotifyInfo.Add(this);
db.SaveChanges();
}
}
public ShortMsgService()
{
var context = new WXDBContext();
_msgRepository = new ShortMsgRepository(context);
_userService = new UserManagerService();
CreateMapping();
}
public void Add()
{
using (var db = new WXDBContext())
{
db.RefundmentInfo.Add(this);
db.SaveChanges();
}
}
public void SearchIdentifyingCodeDetailForSearch_IdentifyingCode_ReturnDTO()
{
var db = new WXDBContext();
var obj = new IdentifyingCodeInfo()
{
ModuleName = "restaurant", IdentifyingCodeId = Guid.Parse("15EB49FB-B41D-4101-B882-29DDF746F0B0")
};
var result = new IdentifyingCodeRepository(db).GetIdentifyingCodeDetailById(obj);
}
public void Modify()
{
using (var db = new WXDBContext())
{
db.PayNotifyInfo.Attach(this);
db.Entry(this).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// 防止存在相同参数
/// </summary>
/// <param name="moudleName"></param>
/// <param name="out_trade_No"></param>
/// <returns></returns>
public bool ContainPayNotufy(string moudleName, string out_trade_No)
{
using (var db = new WXDBContext())
{
return
(db.PayNotifyInfo.Any(
item =>
string.Equals(item.ModuleName, moudleName) && string.Equals(out_trade_no, item.out_trade_no)));
}
}
public static IList <IdentifyingCodeInfo> GetIdentifyingCodeInfoByOrderId(int shopId, string moduleName, string orderId, int wid)
{
using (var db = new WXDBContext())
{
return(new IdentifyingCodeRepository(db).Get(
item =>
item.ModuleName.Equals(moduleName) &&
item.ShopId.Equals(shopId.ToString()) &&
item.OrderId.Equals(orderId) &&
item.Wid.Equals(wid)).ToList());
}
}
public static bool ModifyIdentifyingCodeInfo(IdentifyingCodeInfo code)
{
if (code == null)
{
return(false);
}
using (var context = new WXDBContext())
{
return(new IdentifyingCodeRepository(context).Update(code));
}
}
public static IdentifyingCodeInfo GetIdentifyingCodeInfoByIdentifyingCodeId(Guid identifyingCodeId, string moduleName, int wid)
{
if (identifyingCodeId == null || Guid.Empty.Equals(identifyingCodeId))
{
return(null);
}
using (var context = new WXDBContext())
{
return
(new IdentifyingCodeRepository(context).Get(
item => item.IdentifyingCodeId.Equals(identifyingCodeId) &&
item.ModuleName.Equals(moduleName) &&
item.Wid.Equals(wid)).FirstOrDefault());
}
}
public static IdentifyingCodeInfo GetConfirmIdentifyingCodeInfo(int shopId, string identifyingCode, string moduleName, int wid)
{
if (shopId == 0 || string.IsNullOrEmpty(identifyingCode) || string.IsNullOrEmpty(moduleName))
{
return(null);
}
using (var context = new WXDBContext())
{
return
(new IdentifyingCodeRepository(context).Get(
item =>
item.ShopId == shopId.ToString(CultureInfo.InvariantCulture) &&
item.IdentifyingCode.Equals(identifyingCode) &&
item.ModuleName.Equals(moduleName) &&
item.Wid.Equals(wid)).FirstOrDefault());
}
}
public ShortMsgRepository(WXDBContext context)
{
_context = context;
}
