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