public static string getPassword(string uid) { if (isExistUser(uid) == true) { return(AccessDB.GetFieldValue("SELECT UserPWD FROM UserInfo WHERE UserID = '" + uid + "'")); } return(""); }
public static Boolean getBorrowAdmin(string uid) { if (isExistUser(uid) == true) { string qx = AccessDB.GetFieldValue("SELECT BorrowAdmin FROM UserInfo WHERE UserID = '" + uid + "'"); return(Convert.ToBoolean(qx)); } return(false); }
public static bool deleteUser(string uid) { if (isExistUser(uid) == true) { AccessDB.ExecSQL("DELETE FROM UserInfo WHERE UserID='" + uid + "'"); return(true); } return(false); }
public static bool isExistUser(string uid) { string cnt = AccessDB.GetFieldValue("SELECT count(*) FROM UserInfo WHERE UserID = '" + uid + "'"); if (cnt == "1") { return(true); } return(false); }
public static bool newUser(string uid, string pwd, string userAdmin, string readerAdmin, string bookAdmin, string borrowAdmin, string regTime) { if (isExistUser(uid) == false) { string sql; sql = "INSERT INTO UserInfo(UserID,UserPWD,UserAdmin,ReaderAdmin,BookAdmin,BorrowAdmin,RegisterTime)"; sql += "Values('" + uid + "','" + pwd + "','" + userAdmin + "','" + readerAdmin + "','" + bookAdmin + "','" + borrowAdmin + "','" + regTime + "')"; AccessDB.ExecSQL(sql); return(true); } return(false); }
public static bool modifyUser(string uid, string pwd, string userAdmin, string readerAdmin, string bookAdmin, string borrowAdmin) { if (isExistUser(uid) == true) { string sql; sql = "UPDATE UserInfo SET UserPWD='" + pwd + "',UserAdmin='" + userAdmin + "',ReaderAdmin='" + readerAdmin; sql += "',BookAdmin='" + bookAdmin + "',BorrowAdmin='" + borrowAdmin + "' WHERE UserID='" + uid + "'"; AccessDB.ExecSQL(sql); return(true); } return(false); }
public static Boolean IsBorrowAdmin; //是否拥有借阅权限 public static bool judgeUser(string uid, string pwd) { string sql; sql = "SELECT count(*) FROM UserInfo WHERE UserID='" + uid + "' and UserPWD='" + pwd + "'"; string cnt = AccessDB.GetFieldValue(sql); if (cnt == "1") { return(true); } return(false); }