public static BaishiRewardInfo GetItemByGateAndTel(string Gate, string Tel)
{
if (Gate == null || Tel == null)
{
return(null);
}
if (itemCacheTimeout <= 0)
{
return(dal.GetItemByGateAndTel(Gate, Tel));
}
string key = string.Concat("DC2016_BLL_BaishiRewardByGateAndTel_", Gate, "_,_", Tel);
string value = RedisHelper.Get(key);
if (!string.IsNullOrEmpty(value))
{
try { return(new BaishiRewardInfo(value)); } catch { }
}
BaishiRewardInfo item = dal.GetItemByGateAndTel(Gate, Tel);
if (item == null)
{
return(null);
}
RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
return(item);
}
public static BaishiRewardInfo GetItem(uint?Id)
{
if (Id == null)
{
return(null);
}
if (itemCacheTimeout <= 0)
{
return(dal.GetItem(Id));
}
string key = string.Concat("DC2016_BLL_BaishiReward_", Id);
string value = RedisHelper.Get(key);
if (!string.IsNullOrEmpty(value))
{
try { return(new BaishiRewardInfo(value)); } catch { }
}
BaishiRewardInfo item = dal.GetItem(Id);
if (item == null)
{
return(null);
}
RedisHelper.Set(key, item.Stringify(), itemCacheTimeout);
return(item);
}
public static DC2016.DAL.BaishiReward.SqlUpdateBuild UpdateDiy(BaishiRewardInfo item, uint?Id)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item != null ? item : GetItem(Id));
}
return(new DC2016.DAL.BaishiReward.SqlUpdateBuild(item, Id));
}
public static int Update(BaishiRewardInfo item)
{
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(dal.Update(item));
}
private static void RemoveCache(BaishiRewardInfo item)
{
if (item == null)
{
return;
}
RedisHelper.Remove(string.Concat("DC2016_BLL_BaishiReward_", item.Id));
RedisHelper.Remove(string.Concat("DC2016_BLL_BaishiRewardByGateAndTel_", item.Gate, "_,_", item.Tel));
}
public static BaishiRewardInfo Insert(BaishiRewardInfo item)
{
item = dal.Insert(item);
if (itemCacheTimeout > 0)
{
RemoveCache(item);
}
return(item);
}
public int Update(BaishiRewardInfo item)
{
return(new SqlUpdateBuild(null, item.Id)
.SetActiveid(item.Activeid)
.SetGate(item.Gate)
.SetRewarditem(item.Rewarditem)
.SetState(item.State)
.SetTel(item.Tel)
.SetTime(item.Time).ExecuteNonQuery());
}
public BaishiRewardInfo Insert(BaishiRewardInfo item)
{
uint loc1;
if (uint.TryParse(string.Concat(SqlHelper.ExecuteScalar(TSQL.Insert, GetParameters(item))), out loc1))
{
item.Id = loc1;
}
return(item);
}
protected static MySqlParameter[] GetParameters(BaishiRewardInfo item)
{
return(new MySqlParameter[] {
GetParameter("?id", MySqlDbType.UInt32, 10, item.Id),
GetParameter("?activeid", MySqlDbType.VarChar, 32, item.Activeid),
GetParameter("?gate", MySqlDbType.VarChar, 8, item.Gate),
GetParameter("?rewarditem", MySqlDbType.Int32, 11, item.Rewarditem),
GetParameter("?state", MySqlDbType.Int32, 11, item.State),
GetParameter("?tel", MySqlDbType.VarChar, 18, item.Tel),
GetParameter("?time", MySqlDbType.DateTime, -1, item.Time)
});
}
public IActionResult func_record_raffleinfo(string tel, string gate, int rewarditem, string activeid)
{
if (tel.IsNullOrEmpty())
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确tel={tel}")));
}
if (gate.IsNullOrEmpty() || gate.Length > 8)
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确gate={gate}")));
}
if (rewarditem < 10000)
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确rewarditem={rewarditem}")));
}
if (activeid.IsNullOrEmpty())
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确activeid={activeid}")));
}
BaishiRewardInfo raffleinfo = BaishiReward.hareInfo(gate, tel, activeid);
if (raffleinfo == null)
{
raffleinfo = new BaishiRewardInfo();
raffleinfo.Activeid = activeid;
raffleinfo.Gate = gate;
raffleinfo.Tel = tel;
raffleinfo.Rewarditem = rewarditem;
raffleinfo.Time = DateTime.Now;
raffleinfo = BaishiReward.Insert(raffleinfo);
if (raffleinfo == null)
{
return(this.FuncResult(new APIReturn(19600, "记录数据失败")));
}
else
{
return(this.FuncResult(new APIReturn(0, "记录信息成功")));
}
}
else
{
Hashtable ht = new Hashtable();
ht["tel"] = raffleinfo.Tel;
ht["time"] = raffleinfo.Time;
ht["rewarditem"] = raffleinfo.Rewarditem;
return(this.FuncResult(new APIReturn(19601, "已有抽奖记录", ht)));
}
}
public IActionResult func_get_raffleinfo(string tel, string gate, string activeid)
{
if (tel.IsNullOrEmpty())
{
return(this.FuncResult(new APIReturn(10205, $"手机号格式错误tel={tel}")));
}
if (gate.IsNullOrEmpty() || gate.Length > 8)
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确gate={gate}")));
}
if (activeid.IsNullOrEmpty())
{
return(this.FuncResult(new APIReturn(10000, $"参数不正确activeid={activeid}")));
}
BaishiRewardInfo raffleinfo = BaishiReward.hareInfo(gate, tel, activeid);
if (raffleinfo == null)
{
return(this.FuncResult(new APIReturn(19602, "没有记录")));
}
else if (raffleinfo.State == 1)
{
return(this.FuncResult(new APIReturn(19603, "奖励已领取")));
}
else
{
raffleinfo.State = 1;
BaishiReward.Update(raffleinfo);
Hashtable ht = new Hashtable();
ht["tel"] = raffleinfo.Tel;
ht["time"] = raffleinfo.Time;
ht["rewarditem"] = raffleinfo.Rewarditem;
return(this.FuncResult(new APIReturn(0, "已有抽奖记录", ht))); //分享记录失败
}
}
public SqlUpdateBuild(BaishiRewardInfo item, uint?Id)
{
_item = item;
_where = SqlHelper.Addslashes("`id` = {0}", Id);
}
