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