public int UserAdd(WinEntity.Users.UserEntity UserEntity) { index = DB.cmd("INSERT INTO USERS (USERNAME,PASSWORD,EMAIL,AUTHORITYID) VALUES ('" + UserEntity.Username + "','" + UserEntity.Password + "','" + UserEntity.UserEmail + "',0)"); getValue = DB.cmdSingle("select top 1 ID from USERS order by ID desc"); if (index > 0) { index = DB.cmd("INSERT INTO AUTHORITY (USER_ID,FILE_OPERATIONS,STATIC_OPERATIONS,GRAPH_OPERATIONS,USER_OPERATIONS,NEW_WINDY_POWER,EMAIL_OPERATIONS,SYSTEM_FILES) VALUES (" + getValue + ",0,0,0,0,0,0,0)"); getValue = DB.cmdSingle("select top 1 ID from AUTHORITY order by ID desc"); index = DB.cmd("UPDATE USERS SET AUTHORITYID=" + getValue + " where EMAIL='" + UserEntity.UserEmail + "'"); } return(index); }
public DataRow getAuthority(WinEntity.Users.UserEntity UserEntity) { return(DB.getRowTable("select * from AUTHORITY WHERE USER_ID=" + UserEntity.UserID)); }
public int getUserID(WinEntity.Users.UserEntity UserEntity) { getValue = DB.cmdSingle("select * from USERS where USERNAME='******' AND PASSWORD='******'"); return(Convert.ToInt16(getValue)); }
public int UserLogin(WinEntity.Users.UserEntity UserEntity) { index = DB.UserLogin("select * from USERS where USERNAME='******' AND PASSWORD='******'"); return(index); }