/// <summary> /// 获取全部区域列表数据 /// </summary> /// <returns></returns> public static MResult <List <ItemRegion>[]> GetAllRegionList() { var result = new MResult <List <ItemRegion>[]>(); try { var provinceList = new List <ItemRegion>(); var cityList = new List <ItemRegion>(); var countyList = new List <ItemRegion>(); var basedata = DALFactory.BaseData(); var list = basedata.GetAllRegionList(0); #region 处理地区数据 转换 list.ForEach(item => { try { var regionType = string.Empty; switch (item.intRegionType) { case 1: regionType = "国家"; break; case 2: regionType = "省/直辖市"; provinceList.Add(new ItemRegion() { id = item.intRegionID, name = item.vchRegionName, zip = item.vchPostCode, code = item.vchShortSpell, pid = item.intFRegionID, type = regionType }); break; case 3: regionType = "地区"; cityList.Add(new ItemRegion() { id = item.intRegionID, name = item.vchRegionName, zip = item.vchPostCode, code = item.vchShortSpell, pid = item.intFRegionID, type = regionType }); break; case 4: regionType = "区县"; countyList.Add(new ItemRegion() { id = item.intRegionID, name = item.vchRegionName, zip = item.vchPostCode, code = item.vchShortSpell, pid = item.intFRegionID, type = regionType }); break; default: regionType = item.intRegionType + ""; break; } } catch { } }); #endregion result.info = new[] { provinceList, cityList, countyList }; result.status = MResultStatus.Success; return(result); } catch (Exception) { result.status = MResultStatus.ExceptionError; result.msg = "获取区域列表数据异常"; } return(result); }
/// <summary> /// 获取订单信息 /// </summary> /// <param name="sid"></param> /// <param name="uid"></param> /// <param name="userId"></param> /// <param name="orderCode"></param> /// <returns></returns> public static MResult <ItemOrderDetails> GetOrderinfo(int sid, string uid, int userId, string orderCode) { var result = new MResult <ItemOrderDetails>(); try { #region 参数判断 if (userId <= 0) { result.status = MResultStatus.ParamsError; result.msg = "用户标识错误!"; } if (string.IsNullOrEmpty(orderCode)) { result.status = MResultStatus.ParamsError; result.msg = "订单标识错误!"; } #endregion var orderDal = DALFactory.Order(); var baseDataDal = DALFactory.BaseData(); var orderInfo = orderDal.GetOrderInfo(userId, orderCode); if (orderInfo != null && orderInfo.OrderNo > 0) { orderInfo.PayType = orderInfo.PayId == 0 ? "货到付款" : "在线支付"; orderInfo.InvoiceType = (int)(string.IsNullOrEmpty(orderInfo.InvoiceTitle) ? Invoice.TitleType.NoNeed : orderInfo.InvoiceTitle.StartsWith("个人") ? Invoice.TitleType.Personal : Invoice.TitleType.Company); orderInfo.PayStatus = orderInfo.PayStatusId == 2 ? "已付款" : "未付款"; #region 订单状态 string orderStatus; switch (orderInfo.OrderStatusId) { case 0: orderStatus = "付款未审核"; break; case 1: orderStatus = "未确定"; break; case 4: orderStatus = "客户已确认"; break; case 5: orderStatus = "生成配货单"; break; case 7: orderStatus = "已出库"; break; case 20: orderStatus = "完成"; break; default: orderStatus = "未知"; break; } #endregion orderInfo.OrderStatus = orderStatus; var invoiceCategory = MCvHelper.To <int>(orderInfo.InvoiceCategory, 0); result.info = new ItemOrderDetails { oid = orderInfo.OrderNo, ocode = orderInfo.OrderCode, status = orderInfo.OrderStatus, addr = orderInfo.AddressInfo, province = orderInfo.Provinces, city = orderInfo.City, county = orderInfo.County, contact_name = orderInfo.Consignee, invoicecategory = invoiceCategory, invoicetitle = orderInfo.InvoiceTitle, phone = orderInfo.Phone, titletype = orderInfo.InvoiceType, mobile = orderInfo.Mobile, paytype = orderInfo.PayType, paytypeid = orderInfo.PayId, statusid = orderInfo.OrderStatusId, zip = orderInfo.Zip, paystatus = orderInfo.PayStatus, paystatusid = orderInfo.PayStatusId, deliverytype = orderInfo.DeliveryType }; result.status = MResultStatus.Success; } else { result.status = MResultStatus.Undefined; result.msg = "没有数据!"; } } catch (Exception ex) { result.status = MResultStatus.ExecutionError; MLogManager.Error(MLogGroup.Order.获取订单信息, null, "获取订单信息", ex); } return(result); }
/// <summary> /// 获取订单列表 /// </summary> /// <param name="sid"></param> /// <param name="uid"></param> /// <param name="userId"></param> /// <param name="begimTime"></param> /// <param name="endTime"></param> /// <returns></returns> public static MResultList <ItemOrder> GetOrdersList(int sid, string uid, int userId, DateTime begimTime, DateTime endTime) { var result = new MResultList <ItemOrder>(true); #region 参数验证 if (userId <= 0) { result.status = MResultStatus.ParamsError; result.msg = "用户标识错误!"; } #endregion try { var orderDal = DALFactory.Order(); var orderList = orderDal.GetOrdersList(userId, begimTime, endTime); if (orderList.Any()) { orderList.ForEach(item => { var payType = item.payMethod == 0 ? "货到付款" : "在线支付"; var payStatus = item.payStatus == 2 ? "已付款" : "未付款"; #region 订单状态 string orderStatus; switch (item.flowStatus) { case 0: orderStatus = "付款未审核"; break; case 1: orderStatus = "未确定"; break; case 4: orderStatus = "客户已确认"; break; case 5: orderStatus = "生成配货单"; break; case 7: orderStatus = "已出库"; break; case 20: orderStatus = "完成"; break; default: orderStatus = "未知"; break; } #endregion var orderInfo = new ItemOrder { oid = item.orderNo, ocode = item.orderCode, created = item.createDate, statusid = item.flowStatus, paytype = payType, status = orderStatus, total_fee = item.actuallyPay, total_freight = item.carriage, total_order = item.shouldPay }; result.list.Add(orderInfo); }); result.status = MResultStatus.Success; } } catch (Exception ex) { result.status = MResultStatus.ExecutionError; MLogManager.Error(MLogGroup.Order.获取订单列表, null, "获取订单列表", ex); } return(result); }
public CourseTableBLL() { dal = DALFactory.createCourseTableDAL(); }
/// <summary> /// 获取临时订单信息 /// </summary> /// <param name="guid"></param> /// <param name="channelId"> </param> /// <param name="uid"></param> /// <param name="userId"></param> /// <param name="order"></param> /// <returns></returns> public static MResult <OrderResult> GetTempOrderInfo(string guid, int channelId, string uid, int userId, OrderEntity order) { var result = new MResult <OrderResult>(true); try { if (order.addressid > 0) { var memberDal = DALFactory.Member(); var shoppingCartDal = DALFactory.ShoppingCartDal(); //获取用户选择的收货地址 var addressInfo = memberDal.GetMemberAddressInfo(order.addressid); //判断地址是否存在,并且判断 支付方式和配送方式是否已选择 if (addressInfo != null && addressInfo.intCityID > 0 && order.payid != null && order.logisticsid > 0) { //查询该用户购物车所有商品 var shoppingCartList = shoppingCartDal.GetShoppingCartProductInfosByUserIDGuidChannelID(userId, guid, channelId); if (shoppingCartList.Any()) { //排除 已删除的商品 var notDelShoppingCart = (from a in shoppingCartList where a.intIsDelete == 0 select a).ToList(); if (notDelShoppingCart.Any()) { var summaryOrderInfo = SummaryOrderInfo(notDelShoppingCart, channelId, userId, MCvHelper.To <int>(order.payid, -1), order.logisticsid, MCvHelper.To <int>(addressInfo.intCityID)); if (summaryOrderInfo != null) { result.info.total_discount_fee = summaryOrderInfo.TotalDiscountFee; result.info.total_freight = summaryOrderInfo.TotalFreight; result.info.total_goods_fee = summaryOrderInfo.TotalGoodsFee; result.info.total_order_fee = summaryOrderInfo.TotalOrderFee; result.info.total_original = summaryOrderInfo.TotalOriginal; result.info.total_score = summaryOrderInfo.TotalScore; result.info.total_weight = summaryOrderInfo.TotalWeight; } } else { result.status = Core.Enums.MResultStatus.LogicError; result.msg = "购物车没有商品!"; } } else { result.status = Core.Enums.MResultStatus.LogicError; result.msg = "购物车没有商品!"; } } else { result.status = Core.Enums.MResultStatus.LogicError; result.msg = "请选择支付方式和配送方式!"; } } else { result.status = Core.Enums.MResultStatus.LogicError; result.msg = "请选择收货地址!"; } } catch (Exception ex) { result.status = MResultStatus.ExecutionError; MLogManager.Error(MLogGroup.Order.获取临时订单信息, null, "", ex); } return(result); }
public IEnumerable <Tour> GetItems() { ITourDAO tourDao = DALFactory.CreateTourDAO(); return(tourDao.GetTours()); }
public void DeleteTour(Tour tour, string imagePath) { ITourDAO tourDao = DALFactory.CreateTourDAO(); tourDao.DeleteTour(tour); }
public int InsertNewSign(string[] parameters) { ISign sign = DALFactory.CreateSign(); return(sign.Insert((object[])parameters)); }
public SegmentMappingRepository(string dbProvider, string strConn) { this._dbType = (DatabaseProvider_Type)Enum.Parse(typeof(DatabaseProvider_Type), dbProvider); _dbProvider = DALFactory.CreateSqlProvider(_dbType, strConn); }
/// <summary> /// 根据ID获取学生对象 /// </summary> /// <param name="id">学生ID</param> /// <returns>学生对象</returns> public Student GetStudentById(int id) { return(DALFactory.CreateStudentDAL().GetStudentById(id)); }
/// <summary> /// 删除学生信息 /// </summary> /// <param name="Id">学生ID</param> /// <returns>是否成功 true成功 false 失败</returns> public bool DeleteStudent(int Id) { return(DALFactory.CreateStudentDAL().DeleteStudent(Id)); }
/// <summary> /// 返回所有学生 /// </summary> /// <returns></returns> public IEnumerable <Student> GetAll() { return(DALFactory.CreateStudentDAL().GetAll()); }
public Agency_Sync(string group_record) { _stageProvider = DALFactory.CreateSqlProvider(DatabaseProvider_Type.MSSQLProvider, AppConfiguration.PNCStaging_Connection); _group_record = group_record; }
/// <summary> /// 获取运费总额 /// </summary> /// <param name="channelId"></param> /// <param name="userId"> </param> /// <param name="cityId"></param> /// <param name="payId"></param> /// <param name="deliverId"> </param> /// <param name="totalWeight"></param> /// <param name="orderTotal"> </param> /// <returns></returns> public static MResult <decimal> GetLogisticsInfo(int channelId, int userId, int cityId, int payId, int deliverId, long totalWeight, decimal orderTotal) { var result = new MResult <decimal>(true); try { var baseDataDal = DALFactory.BaseData(); var deliveryInfo = baseDataDal.GetDeliverInfo(deliverId); if (MCvHelper.To <byte>(deliveryInfo.intIsCarriage, 0) == 1) { //上门自提,先不收运费 if (deliverId == 8) { result.info = 0; } else { //否则根据城市id 计算运费 result.info = baseDataDal.GetCarriage(totalWeight, deliverId, cityId); #region 中通满100元江浙免运费 /* * if (orderTotal >= 100 && deliverId == 3) * { * List<City> clist = CityArea.GetCities(10); * clist.AddRange(CityArea.GetCities(11)); * * if (clist.Any(c => c.RegionId == cityId)) * { * result.info = 0; * } * } */ #endregion } } else { var memberDal = DALFactory.Member(); var memberInfo = memberDal.GetMemberInfo(userId.ToString()); //选择不需要运费的送货方式则50元起送,不足50元则加5元运费 if (deliverId == 8) { result.info = 0; } if (orderTotal < 50 && deliverId == 1) { result.info = 5; } if (orderTotal < 100 && deliverId == 6) { result.info = 5; } //月亮太阳会员不收运费 if (memberInfo != null && (memberInfo.clusterId == 3 || memberInfo.clusterId == 4 || memberInfo.clusterId == 17 || memberInfo.clusterId == 18)) { result.info = 0; } } } catch (Exception ex) { result.status = MResultStatus.ExceptionError; result.msg = "获取运费总额 错误!"; } return(result); }
public IList <Performance> QueryPerformances() { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.findAll()); }
public QueryService() { database = DALFactory.CreateDatabase(); }
public Bl_imp() { dal = DALFactory.GetIdal(); DS.DataSource.initializeList(); }
public IList <Performance> QueryPerformancesByVenueAndDay(Venue venue, DateTime day) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.FindPerformanceForVenueByDay(venue, day)); }
public IEnumerable <TourLog> GetTourLogs(Tour tour) { ITourLogDAO tourLogDao = DALFactory.CreateTourLogDAO(); return(tourLogDao.GetTourLogs(tour)); }
public IList <Artist> QueryArtists() { IArtistDao dao = DALFactory.CreateArtistDao(database); return(dao.findAllWithoutDeleted()); }
public void DeleteTourLog(TourLog tourLog) { ITourLogDAO tourLogDao = DALFactory.CreateTourLogDAO(); tourLogDao.DeleteTourLog(tourLog); }
public Artist QueryArtistById(string id) { IArtistDao dao = DALFactory.CreateArtistDao(database); return(dao.findByUniqueProperty(typeof(Artist).GetProperty("Email"), id)); }
public BL_imp() { MyDAL = DALFactory.getDAL(); }
public IList <Performance> QueryPerfomancesByDay(DateTime day) { IPerformanceDao dao = DALFactory.CreatePerformanceDao(database); return(dao.FindPerormanceByDay(day)); }
/// <summary> /// 创建订单 /// </summary> /// <param name="guid"></param> /// <param name="channelId"></param> /// <param name="uid"></param> /// <param name="userId"></param> /// <param name="orderEntity"></param> /// <returns></returns> public static MResult <ItemOrder> CreateOrder(string guid, int channelId, string uid, int userId, OrderEntity orderEntity) { var result = new MResult <ItemOrder>(true); try { var memberDal = DALFactory.Member(); var baseDataDal = DALFactory.BaseData(); var shoppingCartDal = DALFactory.ShoppingCartDal(); var orderDal = DALFactory.Order(); var payId = MCvHelper.To <int>(orderEntity.payid, -1); #region 验证数据 #region 用户是否登录 if (userId <= 0) { result.msg = "请登录后再操作!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #region 收货地址 if (orderEntity.addressid <= 0) { result.msg = "请选择收货地址!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #region 支付方式 if (payId < 0) { result.msg = "请选择支付方式!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #region 配送方式 if (orderEntity.logisticsid <= 0) { result.msg = "请选择配送方式!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #region 发票信息是否完整 if (orderEntity.titletype == null) { result.msg = "请选择发票类型!"; result.status = MResultStatus.ParamsError; return(result); } if (orderEntity.titletype != Entity.Enum.Invoice.TitleType.NoNeed) { if (orderEntity.invoicecategory == null) { result.msg = "请选择发票分类!"; result.status = MResultStatus.ParamsError; return(result); } if (orderEntity.titletype == Entity.Enum.Invoice.TitleType.Company && string.IsNullOrEmpty(orderEntity.invoicetitle)) { result.msg = "请填写发票抬头!"; result.status = MResultStatus.ParamsError; return(result); } } #endregion #endregion var memberInfo = memberDal.GetMemberInfo(uid); #region 验证用户是否存在 if (memberInfo == null || memberInfo.membNo <= 0) { result.msg = "该用户不存在!"; result.status = MResultStatus.ParamsError; return(result); } #endregion //购物车商品数据 List <ShoppingCartEntity> norMalShoppingCartList = null; #region 判断购物车是否有商品 var shoppingCartList = shoppingCartDal.GetShoppingCartProductInfosByUserIDGuidChannelID(userId, guid, channelId); if (shoppingCartList == null || !shoppingCartList.Any()) { result.msg = "购物车没有商品!"; result.status = MResultStatus.LogicError; return(result); } norMalShoppingCartList = (from a in shoppingCartList where a.intIsDelete == 0 select a).ToList(); if (!norMalShoppingCartList.Any()) { result.msg = "购物车没有商品!"; result.status = MResultStatus.LogicError; return(result); } #endregion #region 该用户是否是黑名单 var isExistBacklist = memberDal.CheckUserIdInBackList(userId); if (isExistBacklist) { result.msg = "您的用户出现异常,请联系我们的客服人员进行解决!"; result.status = MResultStatus.LogicError; return(result); } #endregion //收货地址信息 var addressInfo = memberDal.GetMemberAddressInfo(orderEntity.addressid); #region 验证收货地址 #region 是否存在 if (addressInfo == null || addressInfo.intAddressID <= 0 || addressInfo.intCityID <= 0 && payId <= 0 && orderEntity.logisticsid <= 0) { result.msg = "收货地址信息不正确!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #endregion //配送方式 var deliverInfo = baseDataDal.GetDeliverInfo(orderEntity.logisticsid); #region 验证配送方式 if (deliverInfo == null || deliverInfo.intDeliverID == 0) { result.msg = "验证配送方式信息不正确!"; result.status = MResultStatus.ParamsError; return(result); } #endregion #region 检查商品销售区域 var checkGoodsSaleAreaState = CheckGoodsSaleArea(norMalShoppingCartList, userId, MCvHelper.To <int>(addressInfo.intCityID), channelId); if (checkGoodsSaleAreaState.Any()) { result.msg = "有部分商品不在您选择的区域内销售!"; result.status = MResultStatus.LogicError; result.data = String.Join(",", checkGoodsSaleAreaState.ToArray()); return(result); } #endregion var summaryOrderInfo = SummaryOrderInfo(norMalShoppingCartList, channelId, userId, payId, orderEntity.logisticsid, MCvHelper.To <int>(addressInfo.intCityID)); #region 开始创建订单 if (summaryOrderInfo != null && summaryOrderInfo.TotalGoodsFee > 0) { var order = new Sale_Order(); #region 订单主表信息 order.dtCreateDate = DateTime.Now; order.dtSendDate = CheckDateTime(orderEntity.posttimetype, orderEntity.logisticsid); //处理送货日期 order.intChannel = channelId; order.intCreaterID = 555; order.intDeliverID = orderEntity.logisticsid; order.intLogisticsID = 21; order.intOrderState = 1; order.intOrderType = 1; order.intPayID = payId; order.intPayState = 0; order.intStockID = 100; order.intTotalStars = summaryOrderInfo.TotalScore; order.intUserID = userId; order.numAddAmount = 0; order.numCarriage = summaryOrderInfo.TotalFreight; order.numChange = 0; order.numGoodsAmount = summaryOrderInfo.TotalGoodsFee; order.numCouponAmount = summaryOrderInfo.TotalDiscountFee; order.numReceAmount = summaryOrderInfo.TotalOrderFee; order.numWeight = summaryOrderInfo.TotalWeight; order.vchSendTime = order.dtSendDate.ToShortTimeString(); order.vchUserCode = memberInfo.userCode; order.vchOrderCode = GetOrderCode(); #endregion #region 配送信息 var deliver = new Sale_Order_Deliver(); deliver.intAddressID = addressInfo.intAddressID; deliver.intCityID = MCvHelper.To <int>(addressInfo.intCityID, 0); deliver.vchCityName = addressInfo.vchCityName; deliver.vchConsignee = addressInfo.vchConsignee; deliver.intCountyID = MCvHelper.To <int>(addressInfo.intCountyID, 0); deliver.vchCountyName = addressInfo.vchCountyName; deliver.vchDetailAddr = addressInfo.vchStateName + "," + addressInfo.vchCityName + "," + addressInfo.vchCountyName + "," + addressInfo.vchDetailAddr; deliver.vchHausnummer = addressInfo.vchHausnummer; deliver.vchMobile = addressInfo.vchMobile; deliver.vchPhone = addressInfo.vchPhone; deliver.vchPostCode = addressInfo.vchPostCode; deliver.vchRoadName = addressInfo.vchRoadName; deliver.intStateID = MCvHelper.To <int>(addressInfo.intStateID, 0); deliver.vchStateName = addressInfo.vchStateName; deliver.vchUserMemo = orderEntity.remark; deliver.vchOrderCode = order.vchOrderCode; #endregion #region 发票信息 var invoice = new Sale_Order_Invoice(); if (orderEntity.titletype != null && orderEntity.titletype != Invoice.TitleType.NoNeed) { if (orderEntity.titletype == Invoice.TitleType.Personal) { invoice.vchInvoicTitile = "个人"; } else if (orderEntity.titletype == Invoice.TitleType.Company) { invoice.vchInvoicTitile = orderEntity.invoicetitle; } invoice.intInvoiceType = (int)orderEntity.invoicecategory; invoice.intInvoiceKind = 1; invoice.numAmount = order.numReceAmount; invoice.dtBillingTime = DateTime.Now; invoice.dtCreateDate = DateTime.Now; invoice.intIsBilling = 1; invoice.intIsDetail = 0; invoice.vchOrderCode = order.vchOrderCode; invoice.vchPhone = addressInfo.vchPhone; invoice.intUserID = userId; } #endregion #region 保存订单 string message; result.info.oid = orderDal.SaveWebOrder(order, invoice, deliver, null, userId, guid, channelId, MCvHelper.To <int>(memberInfo.clusterId, 0), -1, out message); if (result.info.oid > 0) { #region 清空购物车 shoppingCartDal.ClearShoppingCart(userId); #endregion #region 步订单信息到 BBHome orderDal.SyncOrderInfoToBBHome(order.vchOrderCode); #endregion result.status = MResultStatus.Success; var payType = string.Empty; if (payId == 0) { payType = "货到付款"; } else if (payId == 1) { payType = "在线支付"; } var postTimetype = string.Empty; switch (orderEntity.posttimetype) { case 1: postTimetype = "工作日送货"; break; case 2: postTimetype = "工作日、双休日均可送货"; break; case 3: postTimetype = "只双休日送货"; break; } result.info.ocode = order.vchOrderCode; result.info.paytype = payType; result.info.logisticstype = deliverInfo.vchDeliverName; result.info.total_fee = order.numGoodsAmount; result.info.total_freight = order.numCarriage; result.info.total_order = order.numReceAmount; result.info.posttimetype = postTimetype; } #endregion } #endregion } catch (Exception ex) { result.status = MResultStatus.ExecutionError; MLogManager.Error(MLogGroup.Order.创建订单, null, "", ex); } return(result); }
public IList <Catagory> QueryCatagories() { ICatagoryDao dao = DALFactory.CreateCatagoryDao(database); return(dao.findAll()); }
/// <summary> /// 获取订单商品列表 /// </summary> /// <param name="sid"></param> /// <param name="uid"></param> /// <param name="userId"></param> /// <param name="orderCode"></param> /// <returns></returns> public static MResultList <ItemOrderGoods> GetOrderGoodsList(int sid, string uid, int userId, string orderCode) { var result = new MResultList <ItemOrderGoods>(true); try { #region 参数判断 if (userId <= 0) { result.status = MResultStatus.ParamsError; result.msg = "用户标识错误!"; } if (string.IsNullOrEmpty(orderCode)) { result.status = MResultStatus.ParamsError; result.msg = "订单标识错误!"; } #endregion var orderDal = DALFactory.Order(); var memberDal = DALFactory.Member(); var memberInfo = memberDal.GetMemberInfo(userId); if (memberInfo == null || memberInfo.membNo <= 0) { result.status = MResultStatus.Undefined; result.msg = "用户不存在!"; } var clusterId = MCvHelper.To(memberInfo.clusterId, 1); var orderGoodsList = orderDal.GetOrderGoodsList(userId, orderCode, clusterId); if (orderGoodsList.Any()) { orderGoodsList.ForEach(item => { var goodsItem = new ItemOrderGoods() { gid = item.intProductID, title = item.vchProductName, price = item.numSalePrice, num = item.intQty, total = item.numTotalAmount, pic_url = GoodsBLL.FormatProductPicUrl(item.PicUrl), score = item.intScores, marketprice = MCvHelper.To <decimal>(item.numStandarPrice, item.numSalePrice), productcode = item.vchProductPrinted }; result.list.Add(goodsItem); }); result.status = MResultStatus.Success; } else { result.status = MResultStatus.Undefined; result.msg = "没有数据!"; } } catch (Exception ex) { result.status = MResultStatus.ExecutionError; MLogManager.Error(MLogGroup.Order.获取订单信息, null, "获取订单信息", ex); } return(result); }
public IList <Venue> QueryVenues() { IVenueDao dao = DALFactory.CreateVenueDao(database); return(dao.findAll()); }
/// <summary> /// 订单支付成功 /// </summary> /// <param name="sType"></param> /// <param name="userId"></param> /// <param name="uid"></param> /// <param name="getData"></param> /// <param name="postData"></param> /// <returns></returns> public static MResult <string> OrderPaymentSuccess(SystemType sType, int userId, string uid, string getData, string postData) { var result = new MResult <string>(); try { if (!string.IsNullOrWhiteSpace(getData)) { var getDataForNameValue = HttpUtility.ParseQueryString(getData); #region 解析 query 参数集合 组成 SortedDictionary var sortDict = new SortedDictionary <string, string>(); foreach (string name in getDataForNameValue) { sortDict.Add(name, getDataForNameValue.Get(name)); } #endregion #region 解析参数 var outTradeNo = getDataForNameValue.Get("out_trade_no"); var requestToken = getDataForNameValue.Get("request_token"); var resultStatus = getDataForNameValue.Get("result"); var tradeNo = getDataForNameValue.Get("trade_no"); #endregion #region 验证 签名是否合法 var alipayPayment = new AlipayWapPayment(); var validationPass = alipayPayment.ValidationSign(sortDict); #endregion #region 解析订单编号和用户编号 var orderCode = string.Empty; var userCode = string.Empty; var tradeNosplit = (outTradeNo ?? "").Split('-'); if (tradeNosplit.Length == 2) { orderCode = tradeNosplit[0]; userCode = tradeNosplit[1]; } #endregion if (!string.IsNullOrEmpty(orderCode) && !string.IsNullOrEmpty(userCode) && resultStatus.Equals("success", StringComparison.InvariantCultureIgnoreCase) && validationPass) { #region 更新订单状态 var orderDal = DALFactory.Order(); var orderInfo = orderDal.GetOrderInfo(orderCode); if (orderInfo != null && orderInfo.orderNo > 0) { if (orderInfo.payStatus == 2 || orderInfo.payStatus == 1) { result.status = MResultStatus.LogicError; result.msg = "该订单已经支付 或正在支付中!"; } else { result.info = orderCode; orderDal.UpdateOrderPayStatusSuccess(orderCode, userCode); result.status = MResultStatus.Success; } } #endregion } else { result.status = MResultStatus.LogicError; result.msg = "支付失败!"; } } } catch (Exception) { result.status = MResultStatus.ExceptionError; result.msg = "处理订单支付成功 出现异常!"; } return(result); }
public TourEntryPostgresDAO() { this.database = DALFactory.GetDatabase(); }