public static DataTable uLogin(Entity.UserInfo UserInfo)
{
string sql = string.Format("select UserID,permission from UserInfo where UserName='******' and UserPwd = '{1}'", UserInfo.UserName, UserInfo.UserPwd);
return(DBHelper.getTable(sql));
}
public static int uRegister(Entity.UserInfo userinfo)
{
string sql = string.Format("insert into UserInfo values('{0}','{1}','{2}','{3}','{4}')", userinfo.UserName, userinfo.UserPwd, userinfo.UserSex, userinfo.Birthday, userinfo.Email);
return(DBHelper.ExecuteNonQuery(sql));
}
public static int insertUserInfo(Entity.UserInfo UserInfo)
{
string sql = string.Format("insert into UserInfo(UserName,UserPwd,registerDay,Email,permission) values('{0}','{1}','{2}','{3}',3)", UserInfo.UserName, UserInfo.UserPwd, DateTime.Now.ToString(), UserInfo.Email);
return(DBHelper.ExecuteNonQuery(sql));
}
public bool JudgeUser(Entity.UserInfo user)
{
return(true);
}
