public int EditChannelRebateLog(ChannelRebateLog channelrebatelog)
{
using (var sql = new SqlHelper())
{
try
{
int result = new InternalChannelRebateLog(sql).EditChannelRebateLog(channelrebatelog);
return(result);
}
catch (Exception ex)
{
throw;
}
}
}
public static string EconfirmCard(int aid, int actid, int cardid, int comid, out Member_Activity actinfo, out string phone, out string name, out decimal idcard, out decimal agcardcode)
{
try
{
MemberCardData carddate = new MemberCardData();
var pro = carddate.EconfirmCard(aid, actid, cardid, comid, out actinfo, out phone, out name, out idcard, out agcardcode);
Member_Channel channel = new MemberChannelData().GetChannelDetailByCardNo(idcard.ToString());//根据卡号得到所属渠道的详细信息
if (channel != null)
{
//给渠道表中 开卡数量和总金额赋值
channel.Firstdealnum = channel.Firstdealnum + 1;
channel.Summoney = channel.Summoney + channel.RebateConsume;
var channeldata = new MemberChannelData().EditChannel(channel);
//把返佣日志录入渠道返佣日志表
ChannelRebateLog channelrebatelog = new ChannelRebateLog()
{
Id = 0,
Channelid = channel.Id,
Execdate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
Rebatemoney = channel.RebateConsume,
Type = (int)ChannelRebateType.FirstDeal,
Summoney = channel.Summoney,
Remark = "消费返佣" + channel.RebateConsume + "元"
};
var channelrebatelogret = new ChannelRebateLogData().EditChannelRebateLog(channelrebatelog);
}
return(JsonConvert.SerializeObject(new { type = 100, actinfo = actinfo, phone = phone, name = name, idcard = idcard, agcardcode = agcardcode, msg = pro }));
}
catch (Exception ex)
{
actinfo = null;
phone = "";
name = "";
idcard = 0;
agcardcode = 0;
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
internal int EditChannelRebateLog(ChannelRebateLog model)
{
var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate);
cmd.AddParam("@Id", model.Id);
cmd.AddParam("@Channelid", model.Channelid);
cmd.AddParam("@Type", model.Type);
cmd.AddParam("@Rebatemoney", model.Rebatemoney);
cmd.AddParam("@Summoney", model.Summoney);
cmd.AddParam("@Execdate", model.Execdate);
cmd.AddParam("@Remark", model.Remark);
var parm = cmd.AddReturnValueParameter("ReturnValue");
cmd.ExecuteNonQuery();
return((int)parm.Value);
}
