public void Delete(IDbSession sess, TextbookTdm textbook)
{
var ss = new SqlUpdate(sess);
ss.Sql = "atb_textbook_t";
ss.Where = "ng_id=@ng_id";
ss.Set("nt_r_state", 0)
.AddParam("ng_id", textbook.Id);
ss.ExecuteNonQuery();
}
public void SetLoginSuccess(IDbSession sess, long userId)
{
SqlUpdate su = new SqlUpdate(sess);
su.Sql = "sys_user_t";
su.Set("nt_fcnt", 0);
su.Set("bn_locked", "false", true);
su.Set("ts_locked", (DateTime?)null);
su.Set("nt_login_cnt", "nt_login_cnt+1", true);
su.Set("ts_last_login", DateTime.Now);
su.Set("nt_r_ver", "nt_r_ver+1", true);
su.Where = "ng_id=@ng_id";
su.AddParam("@ng_id", userId);
su.ExecuteNonQuery();
}
public void Update(IDbSession sess, TextbookTdm textbook)
{
var ss = new SqlUpdate(sess);
ss.Sql = "atb_textbook_t";
ss.Where = "ng_id=@ng_id";
ss.Set("ng_editor_id", textbook.EditorId)
.Set("nt_state", textbook.State)
.Set("sz_dst_store", textbook.DstStore)
.Set("sz_dst_md5", textbook.DstMd5)
.Set("ng_dst_size", textbook.DstSize)
.Set("ng_uper_id", textbook.UpdaterId)
.AddParam("ng_id", textbook.Id);
ss.ExecuteNonQuery();
}
public void SetLoginFailed(IDbSession sess, long userId, bool locked)
{
SqlUpdate su = new SqlUpdate(sess);
su.Sql = "sys_user_t";
su.Set("nt_fcnt", "nt_fcnt+1");
su.Set("bn_locked", locked?"true":"false", true);
if (locked)
{
su.Set("ts_locked", DateTime.Now.AddDays(1));
}
su.Set("nt_r_ver", "nt_r_ver+1", true);
su.Where = "ng_id=@ng_id";
su.AddParam("@ng_id", userId);
su.ExecuteNonQuery();
}
public void Update(IDbSession sess, UserTdm user)
{
var ss = new SqlUpdate(sess);
ss.Sql = "sys_user_t";
ss.Where = "ng_id=@ng_id";
ss.Set("sz_uname", user.UserName)
.Set("sz_nkname", user.NickName)
.Set("sz_email", user.Email)
.Set("sz_mobile", user.Mobile)
.Set("nt_kind", (int)user.Kind)
.Set("nt_gender", (int)user.Gender)
.Set("sz_slogan", user.Slogan)
.Set("sz_avatar", user.Avatar)
.Set("ng_uper_id", user.UpdaterId)
.AddParam("ng_id", user.Id);
ss.ExecuteNonQuery();
}
public int Update(IDbSession sess, OAuthTdm tdm)
{
var ss = new SqlUpdate(sess);
ss.Sql = "sys_oauth_t";
ss.Where = "ng_id=@ng_id";
//ss.ConflictTarget = "nt_kind,sz_open_id";
ss.Set("nt_kind", (int)tdm.Kind)
.Set("sz_open_id", tdm.OpenId)
.Set("ng_user_id", tdm.UserId)
.Set("sz_nick_name", tdm.NickName)
.Set("nt_gender", (int)tdm.Gender)
.Set("sz_country", tdm.Country)
.Set("sz_province", tdm.Province)
.Set("sz_city", tdm.City)
.Set("sz_language", tdm.Language)
.Set("sz_avatar_uri", tdm.AvatarUri)
.Set("sz_union_id", tdm.UnionId)
.AddParam("@ng_id", tdm.Id);
return(ss.ExecuteNonQuery());
}
