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