/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public bool UpdateModel(M_LuckDrawRecord record)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"UPDATE [dbo].[LuckDrawRecord]
SET [Ldre_UserID] = @Ldre_UserID
,[Ldre_AwardID] = @Ldre_AwardID
,[Ldre_AwardName] = @Ldre_AwardName
,[Ldre_CreatTime] = @Ldre_CreatTime
,[Ldre_AwardType] = @Ldre_AwardType
,[Ldre_OrderID] = @Ldre_OrderID
WHERE [Ldre_ID] = @Ldre_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Ldre_UserID", SqlDbType.Int),
new SqlParameter("@Ldre_AwardID", SqlDbType.Int),
new SqlParameter("@Ldre_AwardName", SqlDbType.NVarChar, 50),
new SqlParameter("@Ldre_CreatTime", SqlDbType.DateTime),
new SqlParameter("@Ldre_AwardType", SqlDbType.Int),
new SqlParameter("@Ldre_ID", SqlDbType.Int),
new SqlParameter("@Ldre_OrderID", SqlDbType.NVarChar, 500)
};
parameters[0].Value = record.Ldre_UserID;
parameters[1].Value = record.Ldre_AwardID;
parameters[2].Value = record.Ldre_AwardName;
parameters[3].Value = record.Ldre_CreatTime;
parameters[4].Value = record.Ldre_AwardType;
parameters[5].Value = record.Ldre_ID;
int res = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(res > 0);
}
/// <summary>
/// 发放现金奖励
/// </summary>
/// <param name="luckDrawID"></param>
/// <returns></returns>
public ActionResult CheckCashAward(string luckDrawID)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
int online_adminuserid = 0;
M_login M_uid = (M_login)DataCache.GetCache(CacheRemove._loginCachePrefix + Utils.GetUserIDCookieslocahost().ToString());
if (M_uid == null)
{
return(Content(jss.Serialize(new { code = -1, data = "请登录后在进行该操作！" })));
}
B_LuckDraw bllLuckDraw = new B_LuckDraw();
M_LuckDrawRecord record = bllLuckDraw.GetModel(luckDrawID);
if (record.Ldre_AwardType != (int)EnumHelp.LuckDrawEnum.E_AwardType.type0)
{
return(Content(jss.Serialize(new { code = -1, data = "只有未发放的现金奖励才能进行该操作！" })));
}
B_member_table bllUser = new B_member_table();
M_member_table user = bllUser.GetModel(record.Ldre_UserID);
decimal orderID = decimal.Parse(Utils.Createcode());
string errMsg = "";
if (string.IsNullOrWhiteSpace(user.UsrCustId))
{
return(Content(jss.Serialize(new { code = -1, data = "会员未开通汇付账号，无法完成转账操作" })));
}
record.Ldre_AwardType = (int)EnumHelp.LuckDrawEnum.E_AwardType.type4;
record.Ldre_OrderID = orderID.ToString();
if (!bllLuckDraw.UpdateModel(record))
{
LogInfo.WriteLog("九月抽奖活动，后台列表审核，更新抽奖记录状态失败：" + string.Format(" operater:{0};operateTime:{1};", online_adminuserid, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
return(Content(jss.Serialize(new { code = -1, data = "更新抽奖记录失败" })));
}
//hx_Activity_schedule 活动表中 50元红包的ID 为 53，对应于LuckDrawRecord中的awardID 为 -2 的数据均替换为 53
//if (!LuckDrawSendCash(orderID, 50, user.UsrCustId, 53, user.registerid, record.Ldre_AwardName, ref errMsg))
if (SendCash(record.Ldre_AwardID, user.registerid))
{
LogInfo.WriteLog("九月抽奖活动，后台列表审核，现金奖励发放失败：" + string.Format(" operater:{0};operateTime:{1};errMsg:{2}", online_adminuserid, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), errMsg));
return(Content(jss.Serialize(new { code = -1, data = errMsg })));
}
LogInfo.WriteLog("九月抽奖活动，后台列表审核，现金发放成功：" + string.Format(" operater:{0};operateTime:{1};", online_adminuserid, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
return(Content(jss.Serialize(new { code = 0, data = "现金发放成功" })));
}
/// <summary>
/// 添加新数据
/// </summary>
/// <param name="record">新数据</param>
/// <returns></returns>
public bool AddNewRecord(M_LuckDrawRecord record)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"INSERT INTO [dbo].[LuckDrawRecord]
([Ldre_UserID]
,[Ldre_AwardID]
,[Ldre_AwardName]
,[Ldre_CreatTime]
,[Ldre_AwardType]
,[Ldre_OrderID]
,[Ldre_ActivityName])
VALUES
(@Ldre_UserID
,@Ldre_AwardID
,@Ldre_AwardName
,@Ldre_CreatTime
,@Ldre_AwardType
,@Ldre_OrderID
,@Ldre_ActivityName)");
SqlParameter[] parameters =
{
new SqlParameter("@Ldre_UserID", SqlDbType.Int),
new SqlParameter("@Ldre_AwardID", SqlDbType.Int),
new SqlParameter("@Ldre_AwardName", SqlDbType.NVarChar, 50),
new SqlParameter("@Ldre_CreatTime", SqlDbType.DateTime),
new SqlParameter("@Ldre_AwardType", SqlDbType.Int),
new SqlParameter("@Ldre_OrderID", SqlDbType.NVarChar, 500),
new SqlParameter("@Ldre_ActivityName", SqlDbType.NVarChar, 200)
};
parameters[0].Value = record.Ldre_UserID;
parameters[1].Value = record.Ldre_AwardID;
parameters[2].Value = record.Ldre_AwardName;
parameters[3].Value = record.Ldre_CreatTime;
parameters[4].Value = record.Ldre_AwardType;
parameters[5].Value = record.Ldre_OrderID;
parameters[6].Value = record.Ldre_ActivityName;
int res = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(res > 0);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="record"></param>
/// <returns></returns>
public bool UpdateModel(M_LuckDrawRecord record)
{
return(dal.UpdateModel(record));
}
/// <summary>
/// 添加新数据
/// </summary>
/// <param name="record">新数据</param>
/// <returns></returns>
public bool AddNewRecord(M_LuckDrawRecord record)
{
return(dal.AddNewRecord(record));
}
