public void SetSign(string pid, string gid)
{
using (var db = new SmartTSqlDB())
{
var res = db.TSigns.FirstOrDefault(p => p.Pid == pid);
if (res == null)
{
db.TSigns
.Value(p => p.Gid, gid)
.Value(p => p.Pid, pid)
.Value(p => p.SignGid, gid)
.Value(p => p.LastSign, DateTime.Now)
.Insert();
}
else
{
db.TSigns
.Where(p => p.Id == res.Id)
.Set(p => p.Pid, pid)
.Set(p => p.SignGid, gid)
.Set(p => p.LastSign, DateTime.Now)
.Update();
}
}
}
/// <summary>
/// 根据日期获取签到排名
/// </summary>
/// <param name="dt">日期</param>
/// <param name="count">数量</param>
/// <returns></returns>
public Dictionary <long, string> GetTopSignByDay(DateTime dt, int count = 3)
{
using (var db = new SmartTSqlDB())
{
var res = db.TSigns.Where(p => p.LastSign.Date == dt.Date).OrderBy(p => p.LastSign.Ticks).Take(count).ToDictionary(c => c.LastSign.ConvertToTimeStamp(), c => c.Pid);
return(res);
}
}
public TSign GetSign(string pid)
{
using (var db = new SmartTSqlDB())
{
var res = db.TSigns.FirstOrDefault(p => p.Pid == pid);
return(res);
}
}
public ConfigModel GetConfig()
{
ConfigModel ret = new ConfigModel();
using (var db = new SmartTSqlDB())
{
var res = db.TConfigs.ToList();
ret.Name = GetConfigStr(res, "TName");
ret.MenuStr = GetConfigStr(res, "MenuStr");
ret.PrivateMenuStr = GetConfigStr(res, "PMenuStr");
ret.MasterQQ = GetConfigStr(res, "MasterQQ");
var funcs = db.TFuncconfigs.ToList();
funcs.ForEach(p =>
{
ret.FunList.Add(MapperUtil.Map <FuncItem>(p));
});
return(ret);
}
}
