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>());
}
