/// <summary>
/// 设置积分兑换订单状态，返回1成功，其它失败
/// </summary>
/// <param name="dingDanId">订单编号</param>
/// <param name="operatorId">操作员编号</param>
/// <param name="status">订单状态</param>
/// <returns></returns>
public int SheZhiJiFenDingDanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.JiFenDingDanStatus status)
{
DbCommand cmd = _db.GetStoredProcCommand("proc_YL_JiFenDingDan_SheZhiDingDanStatus");
_db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, dingDanId);
_db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, operatorId);
_db.AddInParameter(cmd, "@DingDanStatus", DbType.Byte, status);
_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>
/// <returns></returns>
public int SheZhiJiFenDingDanStatus(string dingDanId, string operatorId, EyouSoft.Model.EnumType.YlStructure.JiFenDingDanStatus status)
{
if (string.IsNullOrEmpty(dingDanId) ||
string.IsNullOrEmpty(operatorId))
{
return(0);
}
int dalRetCode = dal.SheZhiJiFenDingDanStatus(dingDanId, operatorId, status);
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", "兑换失败"));
}
}