public ActionResult Add(Coupon model)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
//先校验优惠码是否重复
var isExist = db.Coupon.Any(p => p.Code == model.Code.Trim());
if (isExist)
{
msg.Status = false;
msg.Result = "900";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
model.IsUsed = false;
msg.Status = true;
var entity = db.Coupon.Add(model);
db.SaveChanges();
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Cancel(int id)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
var entity = db.Order.FirstOrDefault(p => p.ID == id);
if (DateTime.Parse(entity.ServiceTime).AddHours(-2) <= DateTime.Now)
{
msg.Status = false;
msg.Result = "504";
msg.Msg = "定单离服务时间小于2小时,不能取消订单！";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
db.Database.ExecuteSqlCommand("update [Order] set PayState=-1 where id= " + id);
msg.Status = true;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
// GET: CarPriceSetting
public ActionResult Index()
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
msg.Status = true;
msg.Data = db.CarPriceSetting.ToList();
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetModelByCarCode(string carCode)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
msg.Status = true;
var model = db.CarPriceSetting.FirstOrDefault(p => p.CarCode == carCode);
msg.Data = model;
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
// GET: Comment
public ActionResult Index()
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
var dt = DateTime.Now.AddMonths(-1).ToString(FormatDateTime.LongDateTimeStr);
ResponseMessage msg = new ResponseMessage();
msg.Status = true;
var list = db.Comment.Where(p => string.Compare(p.CreateTime, dt) >= 0)
.OrderByDescending(p => p.CreateTime).ToList();
msg.Data = list;
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
// GET: Order
public ActionResult Index(string openID, string startTime, string endTime)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
msg.Status = true;
var list = db.Order.Where(p => p.OpenID == openID &&
string.Compare(p.CreateTime, startTime, StringComparison.Ordinal) >= 0 &&
string.Compare(p.CreateTime, endTime, StringComparison.Ordinal) <= 0).OrderByDescending(x => x.ServiceTime).ToList();
msg.Data = list;
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 回调函数
/// </summary>
public void PayNotifyUrl()
{
PayLogHelper.Debug("进入微信支付回调HttpPost WeChatPay PayNotifyUrl");
WxPayData notifyData = GetNotifyData();
string out_trade_no = notifyData.GetValue("out_trade_no").ToString();
string transaction_id = notifyData.GetValue("transaction_id").ToString();
string totalFee = notifyData.GetValue("total_fee").ToString();
if (notifyData.GetValue("return_code").ToString() == "SUCCESS" && notifyData.GetValue("result_code").ToString() == "SUCCESS")
{
PayLogHelper.Debug("WX:获取到notifyData值");
PayLogHelper.Debug("WXout_trade_no:" + out_trade_no);
Response.Write("成功");
//支付成功，以下执行业务处理
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
msg.Status = true;
var entity = db.Order.FirstOrDefault(p => p.OrderNo == out_trade_no && p.PayState != "2");
if (entity != null)
{
entity.PayTime = DateTime.Now.ToString(FormatDateTime.LongDateTimeStr);
entity.PayState = "1";
entity.PayType = "WX";
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//注释下处代码，允许微信回调，重复通知申请支付的网站，让客户端做重复处理
WxPayData res = new WxPayData();
res.SetValue("return_code", "SUCCESS");
res.SetValue("return_msg", "OK");
PayLogHelper.Debug("WX:order query success : " + res.ToXml());
System.Web.HttpContext.Current.Response.Write(res.ToXml());
System.Web.HttpContext.Current.Response.End();
}
}
else
{
PayLogHelper.Debug("WX支付失败");
Response.Write("失败");
//失败
//msg.Result = AESEncryption.AESEncrypt("false");
}
}
public ActionResult Delete(int id)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
db.Database.ExecuteSqlCommand("delete Coupon where id= " + id);
msg.Status = true;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Add(Order model)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
//先校验优惠码
if (!string.IsNullOrWhiteSpace(model.CouponCode))
{
var couponModel = db.Coupon.FirstOrDefault(p => p.IsUsed == false && p.Code == model.CouponCode.Trim());
if (couponModel == null)
{
msg.Status = false;
msg.Result = "900";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
model.CouponID = couponModel.ID;
//优惠金额
model.SalePrice = couponModel.Amount;
//支付金额
model.PayPrice = model.OrgPrice - couponModel.Amount;
//db.Children.Attach(model);
couponModel.IsUsed = true;
db.Entry(couponModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
model.PayState = "0";
model.OrderNo = DateTime.Now.ToString(FormatDateTime.DateTimeFormatNoStr);
model.CreateTime = DateTime.Now.ToString(FormatDateTime.LongDateTimeStr);
var entity = db.Order.Add(model);
db.SaveChanges();
msg.Status = true;
msg.Data = model;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(CarPriceSetting model)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
db.CarPriceSetting.Attach(model);
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
msg.Status = true;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Add(Comment model)
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
ResponseMessage msg = new ResponseMessage();
try
{
model.CreateTime = DateTime.Now.ToString(FormatDateTime.LongDateTimeStr);
var entity = db.Comment.Add(model);
db.SaveChanges();
msg.Status = true;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 微信退款
/// </summary>
/// <param name="origTransactionNo">支付时，微信流水号</param>
/// <param name="origOutTradeNo">支付时，商户订单号</param>
/// <param name="refundFee">退款金额 单位：分</param>
/// <param name="totalFee">订单总金额 单位：分</param>
public ActionResult WeChatRefund(string origTransactionNo, string origOutTradeNo, string refundFee, string totalFee)
{
//origOutTradeNo = "20181102225722191";
//refundFee = "1";
//totalFee = "1";
ResponseMessage msg = new ResponseMessage();
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
msg.Status = true;
var entity = db.Order.FirstOrDefault(p => p.OrderNo == origOutTradeNo);
if (DateTime.Parse(entity.ServiceTime).AddHours(-2) <= DateTime.Now)
{
msg.Status = false;
msg.Result = "504";
msg.Msg = "定单离服务时间小于2小时,不能取消订单！";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
//若 出错 看http://www.cnblogs.com/ithome8/p/5189926.html
WxPayData data = Refund.Run2(origTransactionNo, origOutTradeNo, refundFee, totalFee);
try
{
if (data.GetValue("return_code").ToString() == "SUCCESS" && data.GetValue("result_code").ToString() == "SUCCESS")
{
using (HouseMovingDBEntities db = new HouseMovingDBEntities())
{
try
{
db.Database.ExecuteSqlCommand("update [Order] set PayState=2 where OrderNo= '" + origOutTradeNo + "'");
msg.Status = true;
}
catch (Exception e)
{
msg.Status = false;
msg.Result = "500";
msg.Msg = "退款数据更新失败";
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
PayLogHelper.Debug("WX退款成功" + origTransactionNo);
msg.Status = true;
}
else
{
PayLogHelper.Debug("WX退款失败" + origTransactionNo);
msg.Status = false;
msg.Result = "501";
//msg.Msg = data.GetValue("err_code_des").ToString();
}
}
catch (WxPayException ex)
{
msg.Status = false;
msg.Result = "502";
msg.Msg = "退款出错";
//若签名错误，则立即返回结果给微信支付后台
WxPayData res = new WxPayData();
res.SetValue("return_code", "FAIL");
res.SetValue("return_msg", ex.Message);
PayLogHelper.Debug("WX:若签名错误" + "Sign check error : " + res.ToXml());
}
return(Json(msg, JsonRequestBehavior.AllowGet));
}
