public User GetUsers(string userName, string passWord) { User _user = null; string sqlCommand = "select * from User where Deleted=0 and LoginID=" + userName + " and Password="******"PhoneNumber"); _user.Password = DataReaderHelper.GetString(dr, "Password"); _user.LoginID = DataReaderHelper.GetString(dr, "LoginID"); _user.UserType = DataReaderHelper.GetInt16(dr, "UserType"); _user.Name = DataReaderHelper.GetString(dr, "Name"); _user.Deleted = DataReaderHelper.GetBoolean(dr, "Deleted"); _user.Notification = DataReaderHelper.GetBoolean(dr, "Notification"); _user.NotificationSound = DataReaderHelper.GetBoolean(dr, "NotificationSound"); _user.NotificationVibration = DataReaderHelper.GetBoolean(dr, "NotificationVibration"); _user.CreateTime = DataReaderHelper.GetDateTime(dr, "CreateTime"); _user.UpdateTime = DataReaderHelper.GetDateTime(dr, "UpdateTime"); } return(_user); }