/// <summary> /// 修改航期订单信息,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int DingDan_M(EyouSoft.Model.YlStructure.MHangQiDingDanInfo info) { DbCommand cmd = _db.GetStoredProcCommand("proc_YL_HangQiDingDan_M"); _db.AddInParameter(cmd, "@HangQiId", DbType.AnsiStringFixedLength, info.HangQiId); _db.AddInParameter(cmd, "@RiQiId", DbType.AnsiStringFixedLength, info.RiQiId); _db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, info.CompanyId); _db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, info.DingDanId); _db.AddInParameter(cmd, "@JiaoYiHao", DbType.String, info.JiaoYiHao); _db.AddInParameter(cmd, "@RenShu", DbType.Int32, info.RenShu); _db.AddInParameter(cmd, "@JinE", DbType.Decimal, info.JinE); _db.AddInParameter(cmd, "@DingDanStatus", DbType.Byte, info.DingDanStatus); _db.AddInParameter(cmd, "@FuKuanStatus", DbType.Byte, info.FuKuanStatus); //_db.AddInParameter(cmd, "@LiuWeiDaoQiShiJian", DbType.DateTime, info.LiuWeiDaoQiShiJian); _db.AddInParameter(cmd, "@XiaDanBeiZhu", DbType.String, info.XiaDanBeiZhu); _db.AddInParameter(cmd, "@YuDingRenName", DbType.String, info.YuDingRenName); _db.AddInParameter(cmd, "@YuDingRenDianHua", DbType.String, info.YuDingRenDianHua); _db.AddInParameter(cmd, "@YuDingRenShouJi", DbType.String, info.YuDingRenShouJi); _db.AddInParameter(cmd, "@YuDingRenYouXiang", DbType.String, info.YuDingRenYouXiang); _db.AddInParameter(cmd, "@IsXuYaoFaPiao", DbType.AnsiStringFixedLength, info.IsXuYaoFaPiao ? "1" : "0"); _db.AddInParameter(cmd, "@FaPiaoTaiTou", DbType.String, info.FaPiaoTaiTou); _db.AddInParameter(cmd, "@FaPiaoLeiXing", DbType.String, info.FaPiaoLeiXing); _db.AddInParameter(cmd, "@FaPiaoMingXi", DbType.String, info.FaPiaoMingXi); _db.AddInParameter(cmd, "@FaPiaoPeiSongFangShi", DbType.Byte, info.FaPiaoPeiSongFangShi); _db.AddInParameter(cmd, "@FaPiaoDiZhiId", DbType.AnsiStringFixedLength, info.FaPiaoDiZhiId); _db.AddInParameter(cmd, "@FaPiaoKuaiDiJinE", DbType.Decimal, info.FaPiaoKuaiDiJinE); _db.AddInParameter(cmd, "@XiaDanRenId", DbType.AnsiStringFixedLength, info.XiaDanRenId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@IsTuanGou", DbType.AnsiStringFixedLength, info.IsTuanGou ? "1" : "0"); _db.AddInParameter(cmd, "@TuanGouId", DbType.AnsiStringFixedLength, info.TuanGouId); _db.AddInParameter(cmd, "@FuJiaChanPinXml", DbType.String, CreateFuJiaChanPinXml(info.FuJiaChanPins)); _db.AddInParameter(cmd, "@YouKeXml", DbType.String, CreateYouKeXml(info.YouKes)); _db.AddInParameter(cmd, "@JiaGeXml", DbType.String, CreateJiaGeXml(info.JiaGes)); _db.AddInParameter(cmd, "@YouHuiXml", DbType.String, CreateYouHuiXml(info.YouHuis)); _db.AddInParameter(cmd, "@DiKouXml", DbType.String, CreateDiKouXml(info.DiKouInfo)); _db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(cmd, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(sqlExceptionCode); } else { return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode"))); } }
/// <summary> /// 修改航期订单信息,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns>-100:失败 -94:该订单已付款 1:成功</returns> public int UpdateDingDan(EyouSoft.Model.YlStructure.MHangQiDingDanInfo info) { if (info == null || string.IsNullOrEmpty(info.DingDanId)) { return(0); } info.IssueTime = DateTime.Now; return(dal.DingDan_M(info)); }
/// <summary> /// 写入航期订单信息,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int InsertDingDan(EyouSoft.Model.YlStructure.MHangQiDingDanInfo info) { if (info == null || string.IsNullOrEmpty(info.CompanyId) || string.IsNullOrEmpty(info.HangQiId) || string.IsNullOrEmpty(info.RiQiId) || string.IsNullOrEmpty(info.XiaDanRenId)) { return(0); } info.DingDanId = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; if (info.LiuWeiDaoQiShiJian == DateTime.MinValue) { info.LiuWeiDaoQiShiJian = DateTime.Now; } if (info.YouKes != null && info.YouKes.Count > 0) { foreach (var item in info.YouKes) { item.YouKeId = Guid.NewGuid().ToString(); } } info.DingDanStatus = EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus.成交; int dalRetCode = dal.DingDan_C(info); if (dalRetCode == 1) { info = dal.GetDingDanInfo(info.DingDanId); var m = new BLL.YlStructure.BHuiYuan().GetHuiYuanInfo(info.XiaDanRenId); if (!string.IsNullOrEmpty(m.ShouJi)) { var r = new BLL.YlStructure.BHangQi().GetRiQiInfo(info.RiQiId); var content = "尊敬的会员" + m.XingMing + ":您预订的" + info.MingCheng + "产品 出发日期:" + (r != null ? r.RiQi.ToShortDateString() : string.Empty) + ",预订人数:" + info.RenShu + ",总价格:" + info.JinE.ToString("F2"); switch (info.DingDanStatus) { case EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus.未处理: //订单提交成功短信提醒预订人 EyouSoft.Toolkit.Utils.ProxySMS(m.ShouJi, content + "已经提交成功,请您耐心等待审核!我们工作人员会随后联系您,服务热线:400-665-9099【维诗达游轮网】"); break; case EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus.成交: EyouSoft.Toolkit.Utils.ProxySMS(m.ShouJi, content + "已经审核成功,请您进入订单中心进行支付!服务热线:400-665-9099【维诗达游轮网】"); break; } } } return(dalRetCode); }
/// <summary> /// 获取订单信息集合 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.YlStructure.MHangQiDingDanInfo> GetDingDans(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MHangQiDingDanChaXunInfo chaXun) { IList <EyouSoft.Model.YlStructure.MHangQiDingDanInfo> items = new List <EyouSoft.Model.YlStructure.MHangQiDingDanInfo>(); string tableName = "view_YL_HangQiDingDan"; string fields = "*"; string orderByString = "IssueTime DESC"; string sumString = string.Empty; StringBuilder sql = new StringBuilder(); sql.AppendFormat(" CompanyId='{0}' AND IsDelete='0' ", companyId); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.HuiYuanId)) { sql.AppendFormat(" AND XiaDanRenId='{0}' ", chaXun.HuiYuanId); } if (!string.IsNullOrEmpty(chaXun.DingDanHao)) { sql.AppendFormat(" AND JiaoYiHao LIKE '%{0}%' ", chaXun.DingDanHao); } if (chaXun.DingDanStatus.HasValue) { sql.AppendFormat(" AND DingDanStatus={0} ", (int)chaXun.DingDanStatus.Value); } if (chaXun.FuKuanStatus.HasValue) { sql.AppendFormat(" AND FuKuanStatus={0} ", (int)chaXun.FuKuanStatus.Value); } if (chaXun.XiaDanShiJian1.HasValue) { sql.AppendFormat(" AND IssueTime>='{0}' ", chaXun.XiaDanShiJian1.Value); } if (chaXun.XiaDanShiJian2.HasValue) { sql.AppendFormat(" AND IssueTime<='{0}' ", chaXun.XiaDanShiJian2.Value.AddDays(1).AddMinutes(-1)); } if (chaXun.DingDanLeiXing.HasValue) { switch (chaXun.DingDanLeiXing) { case 0: sql.AppendFormat(" AND LeiXing=0 AND IsTuanGou='0' "); break; case 1: sql.AppendFormat(" AND LeiXing=1 AND IsTuanGou='0' "); break; case 2: sql.AppendFormat(" AND IsTuanGou='1' "); break; } } } using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString)) { while (rdr.Read()) { var info = new EyouSoft.Model.YlStructure.MHangQiDingDanInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.DiKouInfo = null; info.DingDanId = rdr["DingDanId"].ToString(); info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus)rdr.GetByte(rdr.GetOrdinal("DingDanStatus")); info.FaPiaoDiZhiId = rdr["FaPiaoDiZhiId"].ToString(); info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE")); info.FaPiaoLeiXing = rdr["FaPiaoLeiXing"].ToString(); info.FaPiaoMingXi = rdr["FaPiaoMingXi"].ToString(); info.FaPiaoPeiSongFangShi = (EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi)rdr.GetByte(rdr.GetOrdinal("FaPiaoPeiSongFangShi")); info.FaPiaoTaiTou = rdr["FaPiaoTaiTou"].ToString(); info.FuJiaChanPins = null; info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus)rdr.GetByte(rdr.GetOrdinal("FuKuanStatus")); info.HangQiId = rdr["HangQiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.IsTuanGou = rdr["IsTuanGou"].ToString() == "1"; info.IsXuYaoFaPiao = rdr["IsXuYaoFaPiao"].ToString() == "1"; info.JiaGes = null; info.JiaoYiHao = rdr["JiaoYiHao"].ToString(); info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); info.LiuWeiDaoQiShiJian = rdr.GetDateTime(rdr.GetOrdinal("LiuWeiDaoQiShiJian")); info.RenShu = rdr.GetInt32(rdr.GetOrdinal("RenShu")); info.RiQiId = rdr["RiQiId"].ToString(); info.TuanGouId = rdr["TuanGouId"].ToString(); info.XiaDanBeiZhu = rdr["XiaDanBeiZhu"].ToString(); info.XiaDanRenId = rdr["XiaDanRenId"].ToString(); info.YouHuis = null; info.YouKes = null; info.YuDingRenDianHua = rdr["YuDingRenDianHua"].ToString(); info.YuDingRenName = rdr["YuDingRenName"].ToString(); info.YuDingRenShouJi = rdr["YuDingRenShouJi"].ToString(); info.YuDingRenYouXiang = rdr["YuDingRenYouXiang"].ToString(); info.JiFenLeiJiBiLi = rdr.GetDecimal(rdr.GetOrdinal("JiFenLeiJiBiLi")); info.MingCheng = rdr["MingCheng"].ToString(); info.GysName = rdr["GysName"].ToString(); info.GongSiName = rdr["GongSiName"].ToString(); info.XiLieName = rdr["XiLieName"].ToString(); info.ChuanZhiName = rdr["ChuanZhiName"].ToString(); items.Add(info); } } return(items); }
/// <summary> /// 获取订单信息 /// </summary> /// <param name="dingDanId">订单编号</param> /// <returns></returns> public EyouSoft.Model.YlStructure.MHangQiDingDanInfo GetDingDanInfo(string dingDanId) { EyouSoft.Model.YlStructure.MHangQiDingDanInfo info = null; DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetDingDanInfo); _db.AddInParameter(cmd, "DingDanId", DbType.AnsiStringFixedLength, dingDanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.YlStructure.MHangQiDingDanInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.DiKouInfo = null; info.DingDanId = rdr["DingDanId"].ToString(); info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.HangQiDingDanStatus)rdr.GetByte(rdr.GetOrdinal("DingDanStatus")); info.FaPiaoDiZhiId = rdr["FaPiaoDiZhiId"].ToString(); info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE")); info.FaPiaoLeiXing = rdr["FaPiaoLeiXing"].ToString(); info.FaPiaoMingXi = rdr["FaPiaoMingXi"].ToString(); info.FaPiaoPeiSongFangShi = (EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi)rdr.GetByte(rdr.GetOrdinal("FaPiaoPeiSongFangShi")); info.FaPiaoTaiTou = rdr["FaPiaoTaiTou"].ToString(); info.FuJiaChanPins = null; info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus)rdr.GetByte(rdr.GetOrdinal("FuKuanStatus")); info.HangQiId = rdr["HangQiId"].ToString(); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.IsTuanGou = rdr["IsTuanGou"].ToString() == "1"; info.IsXuYaoFaPiao = rdr["IsXuYaoFaPiao"].ToString() == "1"; info.JiaGes = null; info.JiaoYiHao = rdr["JiaoYiHao"].ToString(); info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); info.LiuWeiDaoQiShiJian = rdr.GetDateTime(rdr.GetOrdinal("LiuWeiDaoQiShiJian")); info.RenShu = rdr.GetInt32(rdr.GetOrdinal("RenShu")); info.RiQiId = rdr["RiQiId"].ToString(); info.TuanGouId = rdr["TuanGouId"].ToString(); info.XiaDanBeiZhu = rdr["XiaDanBeiZhu"].ToString(); info.XiaDanRenId = rdr["XiaDanRenId"].ToString(); info.YouHuis = null; info.YouKes = null; info.YuDingRenDianHua = rdr["YuDingRenDianHua"].ToString(); info.YuDingRenName = rdr["YuDingRenName"].ToString(); info.YuDingRenShouJi = rdr["YuDingRenShouJi"].ToString(); info.YuDingRenYouXiang = rdr["YuDingRenYouXiang"].ToString(); info.MingCheng = rdr["MingCheng"].ToString(); info.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId")); info.YouLunLeiXing = (EyouSoft.Model.EnumType.YlStructure.YouLunLeiXing)rdr.GetByte(rdr.GetOrdinal("LeiXing")); info.GysName = rdr["GysName"].ToString(); info.GongSiName = rdr["GongSiName"].ToString(); info.XiLieName = rdr["XiLieName"].ToString(); info.ChuanZhiName = rdr["ChuanZhiName"].ToString(); info.HangXian = rdr["HangXian"].ToString(); info.BianHao = rdr["BianHao"].ToString(); info.TianShu1 = rdr.GetInt32(rdr.GetOrdinal("TianShu1")); info.TianShu2 = rdr.GetInt32(rdr.GetOrdinal("TianShu2")); info.RiQi = rdr.GetDateTime(rdr.GetOrdinal("RiQi")); info.DingDanJiFen = rdr.GetDecimal(rdr.GetOrdinal("DingDanJiFen")); info.CaoZuoBeiZhu = rdr["CaoZuoBeiZhu"].ToString(); } } if (info != null) { info.DiKouInfo = GetDiKouInfo(info.DingDanId); info.FuJiaChanPins = GetFuJiaChanPins(info.DingDanId); info.JiaGes = GetJiaGes(info.DingDanId); info.YouHuis = GetYouHuis(info.DingDanId); info.YouKes = GetYouKes(info.DingDanId); } return(info); }