public async Task <sysUserInfo> GetLists(string UserLog, string UserPwd)
{
sysUserInfo model = null;
var list = await Query(a => a.uLoginName == UserLog && a.uLoginPWD == UserPwd && a.tdIsDelete == false);
if (list.Count > 0)
{
model = list.FirstOrDefault();
var uselist = await _Db.Updateable <sysUserInfo>(it => it.uStatus == 1).Where(a => a.uID == model.uID).ExecuteCommandAsync();
}
return(model);
}
/// <summary>
/// 根据条件修改阅读状态
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public int MarkedRead(string keys)
{
var i = db.Updateable <Sys_Email>()
.UpdateColumns(it => new Sys_Email()
{
PF_IsRead = 1
})
.Where(it => keys.Contains(it.PF_ID.ToString())).ExecuteCommand();
return(i);
}
public bool Update(Advertisement model)
{
var i = db.Updateable(model).ExecuteCommand();
return(i > 0);
}