public static bool Insert(Model.bk m) { Gx.Sql sql = new Gx.Sql("(uid,sqly,name,zw,dw,jsxq,time,type) values(@uid,@sqly,@name,@zw,@dw,@jsxq,@time,@type)", "bk", "", m); if (sql.Insert() > 0) { return(true); } return(false); }
public static bool Delete(Model.bk m) { Gx.Sql sql = new Gx.Sql("", "bk", "where id=@id and uid=@uid", m); if (sql.Delete() > 0) { return(true); } return(false); }
public static bool Insert(Model.Userone m) { Gx.Sql s = new Gx.Sql("(name,pwd,role,time) values(@name,@pwd,@role,@time)", "Userone", "", m); if (s.Insert() > 0) { return(true); } return(false); }
public static bool Update(Model.bk m) { Gx.Sql sql = new Gx.Sql("type=@type", "bk", "where id=@id", m); if (sql.Update() > 0) { return(true); } return(false); }
public static bool Update(Model.user_login m) { Gx.Sql s = new Gx.Sql("login=@login,token=@token,time=@time", "user_login", "where name=@name", m); if (s.Update() > 0) { return(true); } return(false); }
public static bool Delete(Model.user_login m) { Gx.Sql s = new Gx.Sql("", "user_login", "where name=@name", m); if (s.Delete() > 0) { return(true); } return(false); }
public static bool Insert(Model.user_login m) { Delete(m); Gx.Sql s = new Gx.Sql("(name,login,token,time)values(@name,@login,@token,@time)", "user_login", "", m); if (s.Insert() > 0) { return(true); } return(false); }
public static bool Exists(Model.bk m) { Gx.Sql sql = new Gx.Sql("*", "bk", "where (type=1 or type=0) and uid=@uid", m); return(sql.Exists <Model.bk>()); }
public static List <Model.V_bk> SelectList(Model.V_bk m) { Gx.Sql s = new Gx.Sql("*", "v_bk", "where type=@type order by time desc", m); return(s.SelectList <Model.V_bk>()); }
public static List <Model.V_bk> UserList(Model.V_bk m) { Gx.Sql s = new Gx.Sql("*", "v_bk", "where uid=@uid order by time desc", m); return(s.SelectList <Model.V_bk>()); }
public static Model.Userone Get_User(Model.Userone m) { Gx.Sql s = new Gx.Sql("*", "Userone", "where name=@name", m); return(s.SelectFirst <Model.Userone>()); }
public static bool Exists(Model.Userone m) { Gx.Sql s = new Gx.Sql("*", "Userone", "where name=@name and pwd=@pwd", m); return(s.Exists <Model.Userone>()); }
public static bool Exists_Register(Model.Userone m) { Gx.Sql s = new Gx.Sql("*", "Userone", "where name=@name", m); return(s.Exists <Model.Userone>()); }
public static bool Exists(Model.user_login m) { Gx.Sql s = new Gx.Sql("*", "user_login", "where name=@name and login=@login and token=@token", m); return(s.Exists <Model.user_login>()); }