/// <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 SheZhiFuKuanStatus(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_HangQiDingDan_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")));
}
}
/// <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>
/// 积分兑换
/// </summary>
/// <returns></returns>
protected string DingDanSava()
{
string id = Utils.GetQueryStringValue("jfid");
int Sum = Utils.GetInt(Utils.GetQueryStringValue("jfsum"));
int fangshiId = Utils.GetInt(Utils.GetQueryStringValue("fsid"));
string dizhi = Utils.GetFormValue(hidAddressId.UniqueID);
string str = "";
EyouSoft.BLL.YlStructure.BDuiHuan bll = new EyouSoft.BLL.YlStructure.BDuiHuan();
var DuiHuan = bll.GetJiFenShangPinInfo(id);
if (DuiHuan == null)
{
return(UtilsCommons.AjaxReturnJson("0", "兑换的积分商品不存在"));
}
if (DuiHuan.Status == EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus.架)
{
return(UtilsCommons.AjaxReturnJson("0", "商品已下架，不能兑换"));
}
if (!isLogin)
{
return(UtilsCommons.AjaxReturnJson("0", "请登录后再兑换"));
}
var JfFangShi = DuiHuan.FangShis.Where(n => (int)n.FangShi == fangshiId).ToList();
#region 赋值
/// <summary>
/// 商品编号
/// </summary>
string ShangPinId = id;
/// <summary>
/// 公司编号
/// </summary>
string CompanyId = YuMingInfo.CompanyId;
/// <summary>
/// 数量
/// </summary>
int ShuLiang = Sum;
/// <summary>
/// 兑换方式
/// </summary>
EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi FangShi = JfFangShi[0].FangShi;
/// <summary>
/// 积分
/// </summary>
decimal JiFen = JfFangShi[0].JiFen * Sum;
/// <summary>
/// 订单状态
/// </summary>
EyouSoft.Model.EnumType.YlStructure.JiFenDingDanStatus DingDanStatus = EyouSoft.Model.EnumType.YlStructure.JiFenDingDanStatus.未处理;
/// <summary>
/// 付款状态
/// </summary>
EyouSoft.Model.EnumType.YlStructure.FuKuanStatus FuKuanStatus = EyouSoft.Model.EnumType.YlStructure.FuKuanStatus.未付款;
/// <summary>
/// 下单备注
/// </summary>
string XiaDanBeiZhu = "";
/// <summary>
/// 预订人姓名
/// </summary>
string YuDingRenName = "";
/// <summary>
/// 预订人电话
/// </summary>
string YuDingRenDianHua = "";
/// <summary>
/// 预订人手机
/// </summary>
string YuDingRenShouJi = "";
/// <summary>
/// 预订人邮箱
/// </summary>
string YuDingRenYouXiang = "";
/// <summary>
/// 是否需要发票
/// </summary>
bool IsXuYaoFaPiao = Utils.GetInt(Utils.GetFormValue(hidIsFapiao.UniqueID)) == 1 ? true : false;
/// <summary>
/// 发票抬头
/// </summary>
string FaPiaoTaiTou = Utils.GetFormValue("txtFapTitle");
/// <summary>
/// 发票明细类型
/// </summary>
string FaPiaoLeiXing = "";
/// <summary>
/// 发票明细
/// </summary>
string FaPiaoMingXi = Utils.GetFormValue("txtFapMingx");
/// <summary>
/// 发票配送方式
/// </summary>
EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi FaPiaoPeiSongFangShi = EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi.快递;
/// <summary>
/// 发票配送地址
/// </summary>
string FaPiaoDiZhiId = dizhi;
/// <summary>
/// 发票快递费用
/// </summary>
decimal FaPiaoKuaiDiJinE = 0;
if (IsXuYaoFaPiao)
{
FaPiaoKuaiDiJinE = DuiHuan.FaPiaoKuaiDiJinE;
}
/// <summary>
/// 下单人编号
/// </summary>
string XiaDanRenId = m.HuiYuanId;
/*******************金额计算***********************************************************/
/// <summary>
/// 金额
/// </summary>
decimal JinE = JfFangShi[0].JinE * Sum;
if (IsXuYaoFaPiao)
{
JinE = JinE + FaPiaoKuaiDiJinE;
}
/******************************************************************************/
#endregion
EyouSoft.Model.YlStructure.MWzJiFenDingDanInfo info = new MWzJiFenDingDanInfo()
{
ShangPinId = ShangPinId,
CompanyId = CompanyId,
ShuLiang = ShuLiang,
FangShi = FangShi,
JinE = JinE,
JiFen = JiFen,
DingDanStatus = DingDanStatus,
FuKuanStatus = FuKuanStatus,
XiaDanBeiZhu = XiaDanBeiZhu,
YuDingRenName = YuDingRenName,
YuDingRenDianHua = YuDingRenDianHua,
YuDingRenShouJi = YuDingRenShouJi,
YuDingRenYouXiang = YuDingRenYouXiang,
IsXuYaoFaPiao = IsXuYaoFaPiao,
FaPiaoTaiTou = FaPiaoTaiTou,
FaPiaoLeiXing = FaPiaoLeiXing,
FaPiaoMingXi = FaPiaoMingXi,
FaPiaoPeiSongFangShi = FaPiaoPeiSongFangShi,
FaPiaoDiZhiId = FaPiaoDiZhiId,
FaPiaoKuaiDiJinE = FaPiaoKuaiDiJinE,
XiaDanRenId = XiaDanRenId
};
if (info.JinE <= 0 && info.JiFen <= 0)
{
str += "兑换积分产品数量小于1!</br>";
}
if (Sum < 1)
{
str += "兑换积分产品数量小于1！</br>";
}
if (info.IsXuYaoFaPiao && string.IsNullOrEmpty(info.FaPiaoDiZhiId))
{
str += "请选择配送地址！</br>";
}
if (!string.IsNullOrEmpty(str))
{
return(UtilsCommons.AjaxReturnJson("0", str));
}
decimal keYongJiFen = 0;
var huiYuanInfo = new EyouSoft.BLL.YlStructure.BHuiYuan().GetHuiYuanInfo(m.HuiYuanId);
if (huiYuanInfo != null)
{
keYongJiFen = huiYuanInfo.KeYongJiFen;
}
if (keYongJiFen < info.JiFen)
{
return(UtilsCommons.AjaxReturnJson("0", "你的可用积分不足！"));
}
int bllRetCode = bll.InsertJiFenDingDan(info);
if (bllRetCode == 1)
{
var tj = bll.GetJiFenDingDanInfo(info.DingDanId);
return(UtilsCommons.AjaxReturnJson("1", "兑换成功", new { DingDanId = info.DingDanId, FangShi = (int)info.FangShi, JinE = info.JinE, FuKuanState = (int)tj.FuKuanStatus }));
}
else
{
return(UtilsCommons.AjaxReturnJson("0", "兑换失败"));
}
}
