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