using System;
namespace com.oztime.WorkShop.CodeBase.DB
{
/// <summary>
/// Summary description for DBGlobal.
/// </summary>
public class DBGlobal
{
public DBGlobal()
{
//
// TODO: Add constructor logic here
//
}
public static string DSN="DSN";
/*--------------以下内容与用户类相关----------*/
public static string SelectUserByID="select * from users where userid=@userid";
public static string SelectUserByName="select * from users where username=@username";
public static string AddNewUser="insert into users(username,password,usersex,useremail,usertitle) values(@username,@password,@usersex,@useremail,@usertitle)";
public static string SelectCurrentUserID="select max(userid) from users";
public static string SelectUserByNameAndPassword="select * from users where username=? and password=?";
/*-----------------End-----------------------*/
}
}