/// <summary> /// 添加套餐购买记录 /// </summary> /// <param name="model">套餐购买记录实体</param> /// <returns>true:成功 false:失败</returns> public virtual bool Add(EyouSoft.Model.TicketStructure.TicketFreightBuyLog model) { DbCommand dc = this._database.GetSqlStringCommand(Sql_TicketFreightBuyLog_INSERT); model.Id = Guid.NewGuid().ToString(); this._database.AddInParameter(dc, "Id", DbType.String, model.Id); //this._database.AddInParameter(dc, "OrderNo", DbType.String, model.OrderNo); this._database.AddInParameter(dc, "CompanyId", DbType.String, model.CompanyId); this._database.AddInParameter(dc, "OperatorId", DbType.String, model.OperatorId); this._database.AddInParameter(dc, "PackageId", DbType.Int32, model.PackageId); this._database.AddInParameter(dc, "PackageName", DbType.String, model.PackageName); this._database.AddInParameter(dc, "PackageType", DbType.Int32, (int)model.PackageType); this._database.AddInParameter(dc, "RateType", DbType.Int32, (int)model.RateType); this._database.AddInParameter(dc, "FlightId", DbType.Int32, model.FlightId); this._database.AddInParameter(dc, "FlightName", DbType.String, model.FlightName); this._database.AddInParameter(dc, "HomeCityId", DbType.Int32, model.HomeCityId); this._database.AddInParameter(dc, "HomeCityName", DbType.String, model.HomeCityName); this._database.AddInParameter(dc, "DestCityIds", DbType.String, model.DestCityIds); this._database.AddInParameter(dc, "DestCityNames", DbType.String, model.DestCityNames); this._database.AddInParameter(dc, "BuyCount", DbType.Int32, model.PackageType == EyouSoft.Model.TicketStructure.PackageTypes.常规 ? model.BuyCount : (model.DestCityIds.TrimEnd(',').Contains(",") ? model.DestCityIds.TrimEnd(',').Split(',').Length : 0)); this._database.AddInParameter(dc, "StartMonth", DbType.DateTime, model.StartMonth); this._database.AddInParameter(dc, "EndMonth", DbType.DateTime, model.EndMonth); this._database.AddInParameter(dc, "BuyTime", DbType.DateTime, DateTime.Now); this._database.AddInParameter(dc, "SumPrice", DbType.Decimal, model.SumPrice); this._database.AddInParameter(dc, "PayState", DbType.String, model.PayState?"1":"0"); return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false); }
/// <summary> /// 页面数据初始化 /// </summary> /// <param name="logId"></param> protected void DataInit(string logId) { EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().GetModel(logId); if (model != null) { this.msg_hide_logId.Value = logId; EyouSoft.Model.TicketStructure.TicketFreightPackageInfo packageModel = EyouSoft.BLL.TicketStructure.FreightPackageInfo.CreateInstance().GetModel(model.PackageId); if (packageModel != null) { this.lbl_msg_name.Text = packageModel.PackageName; this.lbl_msg_air.Text = packageModel.FlightName; this.lbl_msg_count.Text = model.BuyCount.ToString(); this.lbl_msg_begin.Text = model.StartMonth.ToString("yyyy-MM-dd"); this.lbl_msg_end.Text = model.EndMonth.ToString("yyyy-MM-dd"); this.lbl_msg_price.Text = model.SumPrice.ToString("0.00"); switch (model.PackageType) { case EyouSoft.Model.TicketStructure.PackageTypes.常规: this.lbl_msg_type.Text = "常规购买"; break; case EyouSoft.Model.TicketStructure.PackageTypes.套餐: this.lbl_msg_type.Text = "套餐购买"; break; default: this.lbl_msg_type.Text = "促销购买"; break; } if (model.PackageType == EyouSoft.Model.TicketStructure.PackageTypes.常规) { panelHangKong.Visible = false; } } this.lclMsg.Text = "购买运价航线成功,<a href='" + Domain.UserBackCenter + "/ticketscenter/freightmanage/freightadd.aspx" + "' >点此返回机票供应商后台</a>!"; } }
/// <summary> /// 页面数据初始化 /// </summary> /// <param name="logId"></param> protected void DataInit(string logId) { EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().GetModel(logId); if (model != null) { this.msg_hide_logId.Value = logId; EyouSoft.Model.TicketStructure.TicketFreightPackageInfo packageModel = EyouSoft.BLL.TicketStructure.FreightPackageInfo.CreateInstance().GetModel(model.PackageId); if (packageModel != null) { this.lbl_msg_name.Text = packageModel.PackageName; this.lbl_msg_air.Text = packageModel.FlightName; this.lbl_msg_count.Text = model.BuyCount.ToString(); this.lbl_msg_begin.Text = model.StartMonth.ToString("yyyy-MM-dd"); this.lbl_msg_end.Text = model.EndMonth.ToString("yyyy-MM-dd"); this.lbl_msg_price.Text = model.SumPrice.ToString("0.00"); switch (model.PackageType) { case EyouSoft.Model.TicketStructure.PackageTypes.常规: this.lbl_msg_type.Text = "常规购买"; break; case EyouSoft.Model.TicketStructure.PackageTypes.套餐: this.lbl_msg_type.Text = "套餐购买"; break; default: this.lbl_msg_type.Text = "促销购买"; break; } if (model.PackageType == EyouSoft.Model.TicketStructure.PackageTypes.常规) { panelHangKong.Visible = false; } } } }
/// <summary> /// 获取套餐购买记录实体 /// </summary> /// <param name="Id">订单编号</param> /// <returns>套餐购买记录实体</returns> public virtual EyouSoft.Model.TicketStructure.TicketFreightBuyLog GetModelByOrderNo(string OrderNo) { EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = null; DbCommand dc = this._database.GetSqlStringCommand(Sql_TicketFreightBuyLog_GETMODELBYORDERNO); this._database.AddInParameter(dc, "OrderNo", DbType.String, OrderNo); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { if (dr.Read()) { model = new EyouSoft.Model.TicketStructure.TicketFreightBuyLog(); model.Id = dr.IsDBNull(0) ? string.Empty : dr[0].ToString(); model.OrderNo = dr.IsDBNull(1) ? string.Empty : dr[1].ToString(); model.CompanyId = dr[2].ToString(); model.OperatorId = dr.IsDBNull(3) ? string.Empty : dr[3].ToString(); model.PackageId = dr.IsDBNull(4) ? 0 : dr.GetInt32(4); model.PackageName = dr[5].ToString(); if (!dr.IsDBNull(6)) { model.PackageType = (EyouSoft.Model.TicketStructure.PackageTypes) int.Parse(dr.GetByte(6).ToString()); } if (!dr.IsDBNull(7)) { model.RateType = (EyouSoft.Model.TicketStructure.RateType) int.Parse(dr.GetByte(7).ToString()); } model.FlightId = dr.GetInt32(8); model.FlightName = dr.IsDBNull(9) ? string.Empty : dr[9].ToString(); model.HomeCityId = dr.GetInt32(10); model.HomeCityName = dr[11].ToString(); model.DestCityIds = dr[12].ToString(); model.DestCityNames = dr[13].ToString(); model.BuyCount = dr.GetInt32(14); model.AvailableCount = dr.GetInt32(15); model.StartMonth = dr.IsDBNull(16) ? DateTime.MinValue : dr.GetDateTime(16); model.EndMonth = dr.IsDBNull(17) ? DateTime.MinValue : dr.GetDateTime(17); model.BuyTime = dr.IsDBNull(18) ? DateTime.MinValue : dr.GetDateTime(18); model.SumPrice = dr.IsDBNull(19) ? 0 : dr.GetDecimal(19); model.PayState = dr[20].ToString() == "1" ? true : false; model.PayTime = dr.IsDBNull(21) ? DateTime.MinValue : dr.GetDateTime(21); } } return(model); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string logId = context.Request.QueryString["logId"]; if (!String.IsNullOrEmpty(logId)) { EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().GetModel(logId); string url = ""; /* * 常规购买:套餐项目-常规 类型-团队 运价数-19 开始10.1-10.3 * 套餐购买:套餐项目-华东区 类型-团队 航空公司-CA 始发地-上海 目的地-所有 开始10.1-10.3 * 促销购买:套餐项目-华东区 类型-团队 航空公司-CA 始发地-上海 目的地-北京 开始10.1-10.3 */ string batch_no = ""; companyModel = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(model.CompanyId); string bankType = context.Request.QueryString["bankType"]; if (companyModel == null || String.IsNullOrEmpty(context.Request.QueryString["uid"]) || String.IsNullOrEmpty(bankType)) { context.Response.Write("error"); return; } switch (bankType) { case "ZFB": switch (model.PackageType) { case EyouSoft.Model.TicketStructure.PackageTypes.常规: url = this.GetPayUrlByZFB(model.OrderNo, string.Format("常规购买:套餐项目-{0}、类型-团队、运价数-{1}、开始{2}-{3}", model.PackageName, model.BuyCount.ToString(), model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), "暂无", Utils.GetDecimal((model.SumPrice * 100).ToString("0")) / 100); break; case EyouSoft.Model.TicketStructure.PackageTypes.套餐: url = this.GetPayUrlByZFB(model.OrderNo, string.Format("套餐购买:套餐项目-{0}、类型-团队、航空公司-{1}、始发地-{2}、目的地-{3}、开始{4}-{5}", model.PackageName, model.FlightName, model.HomeCityName, model.DestCityNames, model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), "暂无", Utils.GetDecimal((model.SumPrice * 100).ToString("0")) / 100); break; default: url = this.GetPayUrlByZFB(model.OrderNo, string.Format("促销购买:套餐项目-{0}、类型-团队 航空公司-{1}、始发地-{2}、目的地-{3}、开始{4}-{5}", model.PackageName, model.FlightName, model.HomeCityName, model.DestCityNames, model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), "暂无", Utils.GetDecimal((model.SumPrice * 100).ToString("0")) / 100); break; } EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().AddTicketPay(model.Id, model.OrderNo, context.Request.QueryString["uid"], companyModel.ID, Utils.GetDecimal((model.SumPrice * 100).ToString("0")) / 100, EyouSoft.Model.TicketStructure.TicketAccountType.支付宝, out batch_no); break; case "CFT": switch (model.PackageType) { case EyouSoft.Model.TicketStructure.PackageTypes.常规: url = this.GetPayUrlByCFT(model.OrderNo, string.Format("常规购买:套餐项目-{0}、类型-团队、运价数-{1}、开始{2}-{3}", model.PackageName, model.BuyCount.ToString(), model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), Utils.GetDecimal((model.SumPrice * 100).ToString("0")), context); break; case EyouSoft.Model.TicketStructure.PackageTypes.套餐: url = this.GetPayUrlByCFT(model.OrderNo, string.Format("套餐购买:套餐项目-{0}、类型-团队、航空公司-{1}、始发地-{2}、目的地-{3}、开始{4}-{5}", model.PackageName, model.FlightName, model.HomeCityName, model.DestCityNames, model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), Utils.GetDecimal((model.SumPrice * 100).ToString("0")), context); break; default: url = this.GetPayUrlByCFT(model.OrderNo, string.Format("促销购买:套餐项目-{0}、类型-团队、航空公司-{1}、始发地-{2}、目的地-{3}、开始{4}-{5}", model.PackageName, model.FlightName, model.HomeCityName, model.DestCityNames, model.StartMonth.ToString("yyyy.MM"), model.EndMonth.ToString("yyyy.MM")), Utils.GetDecimal((model.SumPrice * 100).ToString("0")), context); break; } EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().AddTicketPay(model.Id, model.OrderNo, context.Request.QueryString["uid"], companyModel.ID, Utils.GetDecimal((model.SumPrice * 100).ToString("0")) / 100, EyouSoft.Model.TicketStructure.TicketAccountType.财付通, out batch_no); break; default: context.Response.Write("error"); return; } if (url != "") { context.Response.Write(url); } else { context.Response.Write("error"); } return; } //购买数 int buyCount = Utils.GetInt(context.Request.QueryString["buyCount"]); //公司ID string companyId = context.Request.QueryString["companyId"]; //开始时间 DateTime?startMonth = Utils.GetDateTimeNullable(context.Request.QueryString["SartDateTime"]); //套餐编号 int packageId = Utils.GetInt(context.Request.QueryString["packageId"]); //购买时间类型 string type = Utils.GetQueryStringValue("type"); //购买类型: cg = 常规 cs = 套餐 + 促销 string p = context.Request.QueryString["p"]; //购买运价类型 2 = 套餐 3 = 促销 string packageType = context.Request.QueryString["packageType"]; if (startMonth == null) { context.Response.Write("error"); return; } if (p != null) { //获得公司信息 companyModel = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(companyId); if (companyModel == null) { context.Response.Write("error"); return; } //获取购买运价信息 packageModel = EyouSoft.BLL.TicketStructure.FreightPackageInfo.CreateInstance().GetModel(packageId); if (packageModel == null) { context.Response.Write("error"); return; } decimal onePrice = 0.00M; //结束时间计算 DateTime endTime = DateTime.Now; DateTime startDate = Convert.ToDateTime(startMonth); //如果开始日期是本月 if (Convert.ToDateTime(startMonth).Month == DateTime.Now.Month) { //计算当月的剩余天数的比例 int today = Convert.ToDateTime(startMonth).Day; decimal ratio = Decimal.Parse((DateTime.DaysInMonth(startDate.Year, startDate.Month) - today + 1).ToString("0.00")) / Decimal.Parse(Convert.ToDecimal(DateTime.DaysInMonth(startDate.Year, startDate.Month)).ToString("0.00")); switch (type) { case "1": //单价 = 当月剩余天数比率 * 每月价格 onePrice = packageModel.MonthPrice * ratio; endTime = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-" + DateTime.DaysInMonth(startDate.Year, startDate.Month)); break; case "2": //单价 = 当月剩余天数比率 * 每月价格 + 其它两月的价格 onePrice = ratio * packageModel.QuarterPrice / 3 + packageModel.QuarterPrice / 3 * 2; endTime = Convert.ToDateTime(startDate.AddMonths(2).Year + "-" + startDate.AddMonths(2).Month + "-" + DateTime.DaysInMonth(startDate.AddMonths(2).Year, startDate.AddMonths(2).Month)); break; default: //单价 = 当月剩余天数比率 * 每月价格 + 其它五月的价格 onePrice = ratio * packageModel.HalfYearPrice / 6 + packageModel.HalfYearPrice / 6 * 5; endTime = Convert.ToDateTime(startDate.AddMonths(5).Year + "-" + startDate.AddMonths(5).Month + "-" + DateTime.DaysInMonth(startDate.AddMonths(5).Year, startDate.AddMonths(5).Month)); break; } } //如果开始日期是大于本月 else { //设置开始日期为每月 1 号 startDate = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-01"); switch (type) { case "1": //单价 = 当月剩余天数比率 * 每月价格 onePrice = packageModel.MonthPrice; endTime = Convert.ToDateTime(startDate.Year + "-" + startDate.Month + "-" + DateTime.DaysInMonth(startDate.Year, startDate.Month)); break; case "2": //单价 = 当月剩余天数比率 * 每月价格 + 其它两月的价格 onePrice = packageModel.QuarterPrice; endTime = Convert.ToDateTime(startDate.AddMonths(2).Year + "-" + startDate.AddMonths(2).Month + "-" + DateTime.DaysInMonth(startDate.AddMonths(2).Year, startDate.AddMonths(2).Month)); break; default: //单价 = 当月剩余天数比率 * 每月价格 + 其它五月的价格 onePrice = packageModel.HalfYearPrice; endTime = Convert.ToDateTime(startDate.AddMonths(5).Year + "-" + startDate.AddMonths(5).Month + "-" + DateTime.DaysInMonth(startDate.AddMonths(5).Year, startDate.AddMonths(5).Month)); break; } } if (p == "cg") { if (buyCount == 0 || string.IsNullOrEmpty(companyId) || packageId == 0 || type == "" || string.IsNullOrEmpty(p)) { context.Response.Write("error"); return; } //获得支付总金额 decimal sumPrice = onePrice * buyCount; EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = new EyouSoft.Model.TicketStructure.TicketFreightBuyLog(); model.BuyCount = buyCount; model.BuyTime = DateTime.Now; model.CompanyId = companyId; model.EndMonth = endTime; model.FlightId = packageModel.FlightId; EyouSoft.Model.TicketStructure.TicketFlightCompany flightCompanyModel = EyouSoft.BLL.TicketStructure.TicketFlightCompany.CreateInstance().GetTicketFlightCompany(packageModel.FlightId); if (flightCompanyModel != null) { model.FlightName = flightCompanyModel.AirportName; } if (string.IsNullOrEmpty(model.FlightName)) { model.FlightName = string.Empty; } model.OperatorId = companyModel.ID; model.PackageId = packageId; EyouSoft.Model.TicketStructure.TicketFreightPackageInfo ticketFreightModel = EyouSoft.BLL.TicketStructure.FreightPackageInfo.CreateInstance().GetModel(packageId); if (ticketFreightModel != null) { model.PackageName = ticketFreightModel.PackageName; } model.PackageType = EyouSoft.Model.TicketStructure.PackageTypes.常规; model.PayState = false; model.RateType = EyouSoft.Model.TicketStructure.RateType.团队散拼; model.StartMonth = Convert.ToDateTime(startMonth); model.SumPrice = Utils.GetDecimal((sumPrice * 100).ToString("0")) / 100; bool result = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().Add(model); if (result) { context.Response.Write(model.Id); } else { context.Response.Write("error"); } } if (p == "cs") { if (string.IsNullOrEmpty(companyId) || startMonth == null || packageId == 0 || type == "" || string.IsNullOrEmpty(p)) { context.Response.Write("error"); return; } //获得支付总金额 decimal sumPrice = onePrice; EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = new EyouSoft.Model.TicketStructure.TicketFreightBuyLog(); model.BuyCount = buyCount; model.BuyTime = DateTime.Now; model.CompanyId = companyId; model.EndMonth = endTime; model.FlightId = packageModel.FlightId; if (EyouSoft.BLL.TicketStructure.TicketFlightCompany.CreateInstance().GetTicketFlightCompany(packageModel.FlightId) != null) { model.FlightName = EyouSoft.BLL.TicketStructure.TicketFlightCompany.CreateInstance().GetTicketFlightCompany(packageModel.FlightId).AirportName; } model.OperatorId = companyModel.ID; model.PackageId = packageId; model.PackageName = EyouSoft.BLL.TicketStructure.FreightPackageInfo.CreateInstance().GetModel(packageId).PackageName; if (packageType == "2") { model.PackageType = EyouSoft.Model.TicketStructure.PackageTypes.套餐; } else { model.PackageType = EyouSoft.Model.TicketStructure.PackageTypes.促销; } model.PayState = false; model.RateType = EyouSoft.Model.TicketStructure.RateType.团队散拼; model.StartMonth = Convert.ToDateTime(startMonth); model.SumPrice = Utils.GetDecimal((sumPrice * 100).ToString("0")) / 100; model.HomeCityId = packageModel.HomeCityId; model.HomeCityName = GetCityNameById(packageModel.HomeCityId.ToString()); model.DestCityIds = packageModel.DestCityIds; model.DestCityNames = GetCityNameById(packageModel.DestCityIds).Replace('、', ','); bool result = EyouSoft.BLL.TicketStructure.FreightBuyLog.CreateInstance().Add(model); if (result) { context.Response.Write(model.Id); } else { context.Response.Write("error"); } } } }
/// <summary> /// 购买运价航线记录 /// </summary> /// <param name="model">运价套餐购买记录实体</param> /// <returns>true:成功 false:失败</returns> public bool Add(EyouSoft.Model.TicketStructure.TicketFreightBuyLog model) { return(idal.Add(model)); }
/// <summary> /// 支付回调 /// </summary> /// <param name="payNumber">支付接口返回的交易流水号</param> /// <param name="payprice">支付金额</param> /// <param name="paystate">支付状态</param> /// <param name="paytype">支付接口类型</param> /// <param name="payaccount">支付账号</param> /// <param name="paytradeno">提交到支付接口的交易号</param> /// <param name="paytime">支付时间</param> /// <param name="batchno">批次号</param> /// <returns></returns> public bool PayAfter(string payNumber, decimal?payprice, EyouSoft.Model.TicketStructure.PayState paystate, EyouSoft.Model.TicketStructure.TicketAccountType paytype, string payaccount, string paytradeno, DateTime?paytime, string batchno) { bool result = false; string itemId = string.Empty; //项目编号 string currCompanyId = string.Empty; //当前公司ID string currUserId = string.Empty; //当前用户ID EyouSoft.Model.TicketStructure.ItemType?itemType = null; //流水明细记录项类型 //回调后修改支付明细 idalTicketPayList.PayCallback(payNumber, paystate, string.Empty, paytradeno, batchno, paytype, out itemId, out itemType, out currCompanyId, out currUserId); if (paystate == EyouSoft.Model.TicketStructure.PayState.交易完成 && itemType.Value == EyouSoft.Model.TicketStructure.ItemType.供应商付款到平台_购买运价) { result = idal.SetPayInfo(itemId, true, DateTime.Now); } #region 回写运价信息 EyouSoft.Model.TicketStructure.TicketFreightBuyLog LogModel = idal.GetModelByOrderNo(paytradeno); if (LogModel != null) { if (LogModel.PackageType != EyouSoft.Model.TicketStructure.PackageTypes.常规 && !String.IsNullOrEmpty(LogModel.DestCityIds.Trim())) { string[] tmpDestCityIdList = LogModel.DestCityIds.Split(','); string[] tmpDestCityNameList = LogModel.DestCityNames.Split(','); IList <EyouSoft.Model.TicketStructure.TicketFreightInfo> FList = new List <EyouSoft.Model.TicketStructure.TicketFreightInfo>(); if (tmpDestCityIdList.Length > 0) { for (int i = 0; i < tmpDestCityIdList.Length; i++) { EyouSoft.Model.TicketStructure.TicketSeattle seattlemodel = EyouSoft.BLL.TicketStructure.TicketSeattle.CreateInstance().GetTicketSeattleById(Convert.ToInt32(tmpDestCityIdList[i])); if (seattlemodel != null) { EyouSoft.Model.TicketStructure.TicketFreightInfo FModel = new EyouSoft.Model.TicketStructure.TicketFreightInfo(); FModel.Id = Guid.NewGuid().ToString(); EyouSoft.Model.CompanyStructure.Company CompanyModel = new EyouSoft.Model.CompanyStructure.Company(); CompanyModel.ID = LogModel.CompanyId; FModel.Company = CompanyModel; CompanyModel = null; FModel.FlightId = LogModel.FlightId; FModel.FlightName = LogModel.FlightName; FModel.RateType = LogModel.RateType; FModel.NoGadHomeCityId = LogModel.HomeCityId; FModel.NoGadHomeCityIdName = LogModel.HomeCityName; FModel.NoGadDestCityId = int.Parse(tmpDestCityIdList[i]); FModel.NoGadDestCityName = seattlemodel.Seattle; FModel.BuyType = LogModel.PackageType; FModel.LastUpdateDate = DateTime.Now; FModel.IsEnabled = false; FModel.FreightBuyId = LogModel.Id; //FModel.FreightStartDate = LogModel.StartMonth; //FModel.FreightEndDate = LogModel.EndMonth; FList.Add(FModel); FModel = null; } } result = ifdal.AddFreightInfo(FList) > 0 ? true : false; FList = null; } } LogModel = null; } #endregion return(result); }
/// <summary> /// 分页获取套餐购买记录 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="recordCount">总记录数</param> /// <param name="CompanyId">供应商编号 =""返回全部</param> /// <param name="PackageType">套餐类型 =null返回全部</param> /// <param name="RateType">业务类型 =null返回全部</param> /// <param name="FlightId">航空公司编号 =0返回全部</param> /// <param name="HomeCityId">起始地编号 =0返回全部</param> /// <param name="DestCityId">目的地编号 =0返回全部</param> /// <param name="StartMonth">开始时间 =null返回全部</param> /// <param name="EndMonth">结束时间 =null返回全部</param> /// <param name="PayState">支付状态 =null返回全部</param> /// <returns>套餐购买记录列表</returns> public virtual IList <EyouSoft.Model.TicketStructure.TicketFreightBuyLog> GetList(int pageSize, int pageIndex, ref int recordCount, string CompanyId, EyouSoft.Model.TicketStructure.PackageTypes?PackageType, EyouSoft.Model.TicketStructure.RateType?RateType, int FlightId, int HomeCityId, int DestCityId, DateTime?StartMonth, DateTime?EndMonth, bool?PayState) { IList <EyouSoft.Model.TicketStructure.TicketFreightBuyLog> list = new List <EyouSoft.Model.TicketStructure.TicketFreightBuyLog>(); #region 查询参数变量 StringBuilder strWhere = new StringBuilder(" 1=1 "); string tableName = "tbl_TicketFreightBuyLog"; string fields = "[Id],[OrderNo],[CompanyId],[OperatorId],[PackageId],[PackageName],[PackageType],[RateType],[FlightId],[FlightName],[HomeCityId],[HomeCityName],[DestCityIds],[DestCityNames],[BuyCount],[AvailableCount],[StartMonth],[EndMonth],[BuyTime],[SumPrice],[PayState],[PayTime]"; string primaryKey = "Id"; string orderByString = " BuyTime Desc "; if (!string.IsNullOrEmpty(CompanyId)) { strWhere.AppendFormat(" and CompanyId='{0}' ", CompanyId); } //套餐类型 if (PackageType.HasValue) { strWhere.AppendFormat(" and PackageType={0} ", (int)PackageType.Value); } //业务类型 if (RateType.HasValue) { strWhere.AppendFormat(" and RateType={0} ", (int)RateType.Value); } //航空公司编号 if (FlightId > 0) { strWhere.AppendFormat(" and FlightId={0} ", FlightId); } //起始地编号 if (HomeCityId > 0) { strWhere.AppendFormat(" and charindex('{0}',HomeCityId)>0 ", HomeCityId); } //开始时间 if (StartMonth.HasValue) { strWhere.AppendFormat(" and datediff(dd,'{0}',StartMonth)>-1 ", StartMonth.Value.ToString()); } //结束时间 if (EndMonth.HasValue) { strWhere.AppendFormat(" and datediff(dd,EndMonth,'{0}')>-1 ", EndMonth.Value.ToString()); } //支付状态 if (PayState.HasValue) { strWhere.AppendFormat(" and PayState='{0}' ", PayState.Value ? "1" : "0"); } #endregion #region 列表赋值 using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString)) { while (dr.Read()) { EyouSoft.Model.TicketStructure.TicketFreightBuyLog model = new EyouSoft.Model.TicketStructure.TicketFreightBuyLog(); model.Id = dr.IsDBNull(0) ? string.Empty : dr[0].ToString(); model.OrderNo = dr.IsDBNull(1) ? string.Empty : dr[1].ToString(); model.OperatorId = dr.IsDBNull(2) ? string.Empty : dr[2].ToString(); model.PackageId = dr.IsDBNull(3) ? 0 : int.Parse(dr.GetByte(3).ToString()); model.PackageName = dr[4].ToString(); if (!dr.IsDBNull(5)) { model.PackageType = (EyouSoft.Model.TicketStructure.PackageTypes) int.Parse(dr.GetByte(5).ToString()); } if (!dr.IsDBNull(6)) { model.RateType = (EyouSoft.Model.TicketStructure.RateType) int.Parse(dr.GetByte(6).ToString()); } model.FlightId = dr.GetInt32(7); model.FlightName = dr.IsDBNull(8) ? string.Empty : dr[8].ToString(); model.HomeCityId = dr.GetInt32(9); model.HomeCityName = dr[10].ToString(); model.DestCityIds = dr[11].ToString(); model.DestCityNames = dr[12].ToString(); model.BuyCount = dr.GetInt32(13); model.AvailableCount = dr.GetInt32(14); model.StartMonth = dr.IsDBNull(15) ? DateTime.MinValue : dr.GetDateTime(15); model.EndMonth = dr.IsDBNull(16) ? DateTime.MinValue : dr.GetDateTime(16); model.BuyTime = dr.IsDBNull(17) ? DateTime.MinValue : dr.GetDateTime(17); model.SumPrice = dr.IsDBNull(18) ? 0 : dr.GetDecimal(18); model.PayState = dr[19].ToString() == "1" ? true : false; model.PayTime = dr.IsDBNull(20) ? DateTime.MinValue : dr.GetDateTime(20); list.Add(model); model = null; } } #endregion return(list); }