/// <summary>
/// 处理积分订单信息
/// </summary>
/// <param name="orderId"></param>
private void HandlerJiFenDingDan(string orderId)
{
if (string.IsNullOrEmpty(orderId))
{
return;
}
var info = new EyouSoft.BLL.YlStructure.BDuiHuan().GetJiFenDingDanInfo(orderId);
if (info == null)
{
return;
}
var kuanInfo = new EyouSoft.Model.YlStructure.MHangQiDingDanKuanInfo();
kuanInfo.BeiZhu = string.Empty;
kuanInfo.DingDanId = info.DingDanId;
kuanInfo.FangShi = EyouSoft.Model.EnumType.YlStructure.ZaiXianZhiFuFangShi.Alipay;
kuanInfo.FuKuanId = string.Empty;
kuanInfo.IssueTime = DateTime.Now;
kuanInfo.JinE = info.JinE;
kuanInfo.OperatorId = info.XiaDanRenId;
kuanInfo.ShiJian = DateTime.Now;
kuanInfo.Status = EyouSoft.Model.EnumType.YlStructure.FuKuanStatus.已付款;
new EyouSoft.BLL.YlStructure.BDuiHuan().SheZhiJiFenDingDanFuKuanStatus(info.DingDanId, info.XiaDanRenId, EyouSoft.Model.EnumType.YlStructure.FuKuanStatus.已付款, DateTime.Now, kuanInfo);
}
/// <summary>
/// 设置礼品卡订单付款状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="operatorId">操作员编号</param>
/// <param name="status">付款状态</param>
/// <param name="fuKuanShiJian">付款时间</param>
/// <param name="info">款项实体</param>
/// <returns></returns>
public int SheZhiLiPinKaDingDanFuKuanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.FuKuanStatus status, DateTime?fuKuanShiJian, EyouSoft.Model.YlStructure.MHangQiDingDanKuanInfo info)
{
if (string.IsNullOrEmpty(dingDanId) || string.IsNullOrEmpty(operatorId))
{
return(0);
}
if (info == null)
{
return(0);
}
if (!fuKuanShiJian.HasValue)
{
fuKuanShiJian = DateTime.Now;
}
int dalRetCode = dal.SheZhiLiPinKaDingDanFuKuanStatus(dingDanId, operatorId, status, fuKuanShiJian, info);
return(dalRetCode);
}
/// <summary>
/// 设置积分兑换订单付款状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="operatorId">操作员编号</param>
/// <param name="status">付款状态</param>
/// <param name="fuKuanShiJian">付款时间</param>
/// <param name="info">款项实体</param>
/// <returns></returns>
public int SheZhiJiFenDingDanFuKuanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.FuKuanStatus status, DateTime?fuKuanShiJian, EyouSoft.Model.YlStructure.MHangQiDingDanKuanInfo info)
{
if (string.IsNullOrEmpty(dingDanId) || string.IsNullOrEmpty(operatorId))
{
return(0);
}
if (info == null)
{
return(0);
}
if (!fuKuanShiJian.HasValue)
{
fuKuanShiJian = DateTime.Now;
}
int dalRetCode = dal.SheZhiJiFenDingDanFuKuanStatus(dingDanId, operatorId, status, fuKuanShiJian, info);
if (status == Model.EnumType.YlStructure.FuKuanStatus.已付款 && dalRetCode == 1)
{
var dingdan = dal.GetJiFenDingDanInfo(dingDanId);
if (dingdan != null)
{
var m = new BLL.YlStructure.BHuiYuan().GetHuiYuanInfo(dingdan.XiaDanRenId);
if (m != null && !string.IsNullOrEmpty(m.ShouJi))
{
var content = "尊敬的会员" + m.XingMing + "：您在积分商城成功兑换" + dingdan.ShangPinMingCheng + "，该商品将在5个工作日内为您寄出，请保持手机畅通！服务热线：400-665-9099【维诗达游轮网】";
EyouSoft.Toolkit.Utils.ProxySMS(m.ShouJi, content);
}
}
}
return(dalRetCode);
}
/// <summary>
/// 设置付款状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="operatorId">操作员编号</param>
/// <param name="status">付款状态</param>
/// <param name="fuKuanShiJian">付款时间</param>
/// <param name="info">款项实体</param>
/// <returns></returns>
public int SheZhiFuKuanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.FuKuanStatus status, DateTime?fuKuanShiJian, EyouSoft.Model.YlStructure.MHangQiDingDanKuanInfo info)
{
if (string.IsNullOrEmpty(dingDanId) || string.IsNullOrEmpty(operatorId))
{
return(0);
}
if (info == null)
{
return(0);
}
if (!fuKuanShiJian.HasValue)
{
fuKuanShiJian = DateTime.Now;
}
info.FuKuanId = Guid.NewGuid().ToString();
int dalRetCode = dal.SheZhiFuKuanStatus(dingDanId, operatorId, status, fuKuanShiJian, info);
if (status == Model.EnumType.YlStructure.FuKuanStatus.已付款 && dalRetCode == 1)
{
var dingdan = dal.GetDingDanInfo(dingDanId);
if (dingdan != null)
{
var m = new BLL.YlStructure.BHuiYuan().GetHuiYuanInfo(dingdan.XiaDanRenId);
if (m != null && !string.IsNullOrEmpty(m.ShouJi))
{
var content = "尊敬的会员" + m.XingMing + "：您预订的" + dingdan.MingCheng + "产品 出发日期：" + dingdan.RiQi.ToShortDateString() + "，预订人数：" + dingdan.RenShu + "，总价格：" + dingdan.JinE.ToString("F2") + "已经支付成功。请在" + dingdan.RiQi.ToShortDateString() + "当天登船出游，祝您旅途愉快！服务热线：400-665-9099【维诗达游轮网】";
EyouSoft.Toolkit.Utils.ProxySMS(m.ShouJi, content);
}
}
}
return(dalRetCode);
}
/// <summary>
/// 设置积分兑换订单付款状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="operatorId">操作员编号</param>
/// <param name="status">付款状态</param>
/// <param name="fuKuanShiJian">付款时间</param>
/// <param name="info">款项实体</param>
/// <returns></returns>
public int SheZhiJiFenDingDanFuKuanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.FuKuanStatus status, DateTime?fuKuanShiJian, EyouSoft.Model.YlStructure.MHangQiDingDanKuanInfo info)
{
if (!fuKuanShiJian.HasValue)
{
fuKuanShiJian = DateTime.Now;
}
DbCommand cmd = _db.GetStoredProcCommand("proc_YL_JiFenDingDan_SheZhiFuKuanStatus");
_db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, dingDanId);
_db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, operatorId);
_db.AddInParameter(cmd, "@FuKuanStatus", DbType.Byte, status);
_db.AddInParameter(cmd, "@FuKuanShiJian", DbType.DateTime, fuKuanShiJian.Value);
_db.AddInParameter(cmd, "@JinE", DbType.Decimal, info.JinE);
_db.AddInParameter(cmd, "@FangShi", DbType.Byte, info.FangShi);
_db.AddInParameter(cmd, "@BeiZhu", DbType.String, info.BeiZhu);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, DateTime.Now);
_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")));
}
}